r****m 发帖数: 1 | 1 从google sheet读取资料的代码示范
把试你们代码的可疑的人的名单放到一个公用的google sheet里
然后你的脚本就可以读取这个名单进行操作
这个名单是小将名单还是老将名单,你们自己决定
const fs = require('fs');
const readline = require('readline');
const {google} = require('googleapis');
// If modifying these scopes, delete token.json.
const SCOPES = ['https://www.googleapis.com/auth/spreadsheets.readonly'];
// The file token.json stores the user's access and refresh tokens, and is
// created automatically when the authorization flow completes for the first
// time.
const TOKEN_PATH = 'token.json';
// Load client secrets from a local file.
fs.readFile('credentials.json', (err, content) => {
if (err) return console.log('Error loading client secret file:', err);
// Authorize a client with credentials, then call the Google Sheets API.
authorize(JSON.parse(content), listMajors);
});
/**
* Create an OAuth2 client with the given credentials, and then execute the
* given callback function.
* @param {Object} credentials The authorization client credentials.
* @param {function} callback The callback to call with the authorized
client.
*/
function authorize(credentials, callback) {
const {client_secret, client_id, redirect_uris} = credentials.installed;
const oAuth2Client = new google.auth.OAuth2(
client_id, client_secret, redirect_uris[0]);
// Check if we have previously stored a token.
fs.readFile(TOKEN_PATH, (err, token) => {
if (err) return getNewToken(oAuth2Client, callback);
oAuth2Client.setCredentials(JSON.parse(token));
callback(oAuth2Client);
});
}
/**
* Get and store new token after prompting for user authorization, and then
* execute the given callback with the authorized OAuth2 client.
* @param {google.auth.OAuth2} oAuth2Client The OAuth2 client to get token
for.
* @param {getEventsCallback} callback The callback for the authorized
client.
*/
function getNewToken(oAuth2Client, callback) {
const authUrl = oAuth2Client.generateAuthUrl({
access_type: 'offline',
scope: SCOPES,
});
console.log('Authorize this app by visiting this url:', authUrl);
const rl = readline.createInterface({
input: process.stdin,
output: process.stdout,
});
rl.question('Enter the code from that page here: ', (code) => {
rl.close();
oAuth2Client.getToken(code, (err, token) => {
if (err) return console.error('Error while trying to retrieve access
token', err);
oAuth2Client.setCredentials(token);
// Store the token to disk for later program executions
fs.writeFile(TOKEN_PATH, JSON.stringify(token), (err) => {
if (err) return console.error(err);
console.log('Token stored to', TOKEN_PATH);
});
callback(oAuth2Client);
});
});
}
/**
* Prints the names and majors of students in a sample spreadsheet:
* @see https://docs.google.com/spreadsheets/d/
1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgvE2upms/edit
* @param {google.auth.OAuth2} auth The authenticated Google OAuth client.
*/
function listMajors(auth) {
const sheets = google.sheets({version: 'v4', auth});
sheets.spreadsheets.values.get({
spreadsheetId: '1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgvE2upms',
range: 'Class Data!A2:E',
}, (err, res) => {
if (err) return console.log('The API returned an error: ' + err);
const rows = res.data.values;
if (rows.length) {
console.log('Name, Major:');
// Print columns A and E, which correspond to indices 0 and 4.
rows.map((row) => {
console.log(`${row[0]}, ${row[4]}`);
});
} else {
console.log('No data found.');
}
});
} | l*******k 发帖数: 922 | 2 费那么大劲。只要把5次错误后的lock out时间从24小时减到5分钟或者10分钟就行了。 | r****m 发帖数: 1 | 3 你没看懂,进攻是防守的最好手段
【在 l*******k 的大作中提到】 : 费那么大劲。只要把5次错误后的lock out时间从24小时减到5分钟或者10分钟就行了。
| z*****n 发帖数: 36 | | u*****s 发帖数: 1 | 5 你这一段里再加个病毒就更完美了,lol
[在 reklam (ciel) 的大作中提到:]
:从google sheet读取资料的代码示范
:把试你们代码的可疑的人的名单放到一个公用的google sheet里
:然后你的脚本就可以读取这个名单进行操作
:这个名单是小将名单还是老将名单,你们自己决定
:const fs = require('fs');
:const readline = require('readline');
:const {google} = require('googleapis');
:// If modifying these scopes, delete token.json.
:const SCOPES = ['https://www.googleapis.com/auth/spreadsheets.readonly&
#39;];
:// The file token.json stores the user's access and refresh tokens, and
is
:.......... | k*******p 发帖数: 8821 | 6 怎么调成5分种或者10分钟?
【在 l*******k 的大作中提到】 : 费那么大劲。只要把5次错误后的lock out时间从24小时减到5分钟或者10分钟就行了。
| f****i 发帖数: 1 | 7 这智商
那如果公用的google sheet被人攻击了,怎么办?
【在 r****m 的大作中提到】 : 从google sheet读取资料的代码示范 : 把试你们代码的可疑的人的名单放到一个公用的google sheet里 : 然后你的脚本就可以读取这个名单进行操作 : 这个名单是小将名单还是老将名单,你们自己决定 : const fs = require('fs'); : const readline = require('readline'); : const {google} = require('googleapis'); : // If modifying these scopes, delete token.json. : const SCOPES = ['https://www.googleapis.com/auth/spreadsheets.readonly']; : // The file token.json stores the user's access and refresh tokens, and is
| g***n 发帖数: 14250 | 8 最牛逼的是盯着版面看谁发帖就试睡密码。
搞得都不能发帖了,老邢活剥了你 |
|