質問編集履歴

2019/09/27 01:20

投稿

kotaro_nagano

スコア11

test CHANGED Viewed

File without changes

test CHANGED Viewed

@@ -88,8 +88,12 @@
 86:  }
 ・・・中略
   function setAuthAndDependencies(auth) {
     google_auth = auth;
@@ -108,6 +112,308 @@
   }
+・・・中略
+  // public API methods
+  this.getInfo = function(cb) {
+    self.makeFeedRequest(["worksheets", ss_key], "GET", null, function(
+      err,
+      data
+    ) {
+      if (err) return cb(err);
+      if (data === true) {
+        return cb(new Error("No response to getInfo call"));
+      }
+      var ss_data = {
+        id: data.id,
+        title: data.title,
+        updated: data.updated,
+        author: data.author,
+        worksheets: []
+      };
+      var worksheets = forceArray(data.entry);
+      worksheets.forEach(function(ws_data) {
+        ss_data.worksheets.push(new SpreadsheetWorksheet(self, ws_data));
+      });
+      self.info = ss_data;
+      self.worksheets = ss_data.worksheets;
+      cb(null, ss_data);
+    });
+  };
+・・・中略
+  // This method is used internally to make all requests
+  this.makeFeedRequest = function(url_params, method, query_or_data, cb) {
+    var url;
+    var headers = {};
+    if (!cb) cb = function() {};
+    if (typeof url_params == "string") {
+      // used for edit / delete requests
+      url = url_params;
+    } else if (Array.isArray(url_params)) {
+      //used for get and post requets
+      url_params.push(visibility, projection);
+      url = GOOGLE_FEED_URL + url_params.join("/");
+    }
+    async.series({
+      auth: function(step) {
+        if (auth_mode != "jwt") return step();
+        // check if jwt token is expired
+        if (google_auth && google_auth.expires > +new Date()) return step();
+        renewJwtAuth(step);
+      },
+      request: function(result, step) {
+        if (google_auth) {
+          if (google_auth.type === "Bearer") {
+            headers["Authorization"] = "Bearer " + google_auth.value;
+          } else {
+            headers["Authorization"] = "GoogleLogin auth=" + google_auth;
+          }
+        }
+        headers["Gdata-Version"] = "3.0";
+        if (method == "POST" || method == "PUT") {
+          headers["content-type"] = "application/atom+xml";
+        }
+        if (
+          method == "PUT" ||
+          (method == "POST" && url.indexOf("/batch") != -1)
+        ) {
+          headers["If-Match"] = "*";
+        }
+        if (method == "GET" && query_or_data) {
+          var query = "?" + querystring.stringify(query_or_data);
+          // replacements are needed for using structured queries on getRows
+          query = query.replace(/%3E/g, ">");
+          query = query.replace(/%3D/g, "=");
+          query = query.replace(/%3C/g, "<");
+          url += query;
+        }
+        request(
+          {
+            url: url,
+            method: method,
+            headers: headers,
+            gzip: options.gzip !== undefined ? options.gzip : true,
+            body: method == "POST" || method == "PUT" ? query_or_data : null
+          },
+          function(err, response, body) {
+            if (err) {
+              return cb(err);
+            } else if (response.statusCode === 401) {
+              return cb(new Error("Invalid authorization key."));
+            } else if (response.statusCode >= 400) {
+              var message = _.isObject(body)
+                ? JSON.stringify(body)
+                : body.replace(/&quot;/g, '"');
+              return cb(
+                new Error(
+                  "HTTP error " +
+                    response.statusCode +
+                    " (" +
+                    http.STATUS_CODES[response.statusCode]
+                ) +
+                  ") - " +
+                  message
+              );
+            } else if (
+              response.statusCode === 200 &&
+              response.headers["content-type"].indexOf("text/html") >= 0
+            ) {
+              return cb(
+                new Error(
+                  "Sheet is private. Use authentication or make public. (see https://github.com/theoephraim/node-google-spreadsheet#a-note-on-authentication for details)"
+                )
+              );
+            }
+            if (body) {
+              var xml_parser = new xml2js.Parser({
+                // options carried over from older version of xml2js
+                // might want to update how the code works, but for now this is fine
+                explicitArray: false,
+                explicitRoot: false
+              });
+              xml_parser.parseString(body, function(err, result) {
+                if (err) {
+                  xml_parser = null;
+                  body = null;
+                  return cb(err);
+                }
+                if (cb.length == 3) {
+                  cb(null, result, body);
+                } else {
+                  body = null;
+                  cb(null, result);
+                }
+              });
+            } else {
+              if (err) cb(err);
+              else cb(null, true);
+            }
+          }
+        );
+      }
+    });
+  };
 ```

2019/09/27 01:20

投稿

kotaro_nagano

スコア11

test CHANGED Viewed

File without changes

test CHANGED Viewed

@@ -50,72 +50,194 @@
+  this.setAuthToken = function(auth_id) {
+    if (auth_mode == "anonymous") auth_mode = "token";
+    setAuthAndDependencies(auth_id);
+  };
+...中略
-  function renewJwtAuth(cb) {
+75:  function renewJwtAuth(cb) {
-    auth_mode = "jwt";
+76:    auth_mode = "jwt";
-    jwt_client.authorize(function(err, token) {
+77:    jwt_client.authorize(function(err, token) {
-      if (err) return cb(err);
+78:      if (err) return cb(err);
-      self.setAuthToken({
+79:      self.setAuthToken({
-        type: token.token_type,
+80:        type: token.token_type,
-        value: token.access_token,
+81:        value: token.access_token,
-        expires: token.expiry_date
+82:        expires: token.expiry_date
+83:      });
+84:      cb();
+85:    });
+86:  }
+・・・中略
+  function setAuthAndDependencies(auth) {
+    google_auth = auth;
+    if (!options.visibility) {
+      visibility = google_auth ? "private" : "public";
+    }
+    if (!options.projection) {
+      projection = google_auth ? "full" : "values";
+    }
+  }
+```
+### 該当のソースコード
+```js
+"use strict";
+const googleSpreadSheet = require("google-spreadsheet");
+const doc = new googleSpreadSheet(
+  "1X98eannyhE"
+);
+let sheet;
+const setAuth = () =>
+  new Promise((resolve, reject) => {
+    const creds = require("./903c28f.json");
+    doc.useServiceAccountAuth(creds, getInfoAndSheets());
-      });
+  });
+const getInfoAndSheets = () =>
+  new Promise((resolve, reject) => {
-      cb();
+    doc.getInfo((err, info) => {
+      sheet = info.worksheets[0];
     });
+    resolve();
+  });
+const workingWithCells = () => {
+  const COLUMS = {
+    name: 1,
+    price: 2
+  };
+  sheet.getCells(
+    {
+      "min-row": 2,
+      "max-row": 5,
+      "return-empty": true
+    },
+    (err, cells) => {
+      for (let i = 0; i < cells.length / sheet.colCount; i += 1) {
+        const name = cells[i * sheet.colCount + COLUMS.name].value;
+        const price = cells[i * sheet.colCount + COLUMS.price].value;
-  }
+      }
+    }
+  );
+};
+const a = async () => {
+  await setAuth();
+  await workingWithCells();
+};
+const main = () => {
+  a();
+};
+main();
-```
+```
-### 該当のソースコード
+### 試したこと
 ```js
-"use strict";
-const googleSpreadSheet = require("google-spreadsheet");
-const doc = new googleSpreadSheet(
-  "1X98eannyhE"
-);
-let sheet;
-const setAuth = () =>
-  new Promise((resolve, reject) => {
-    const creds = require("./903c28f.json");
-    doc.useServiceAccountAuth(creds, getInfoAndSheets());
-  });
 const getInfoAndSheets = () =>
   new Promise((resolve, reject) => {
@@ -130,79 +252,13 @@
   });
-const workingWithCells = () => {
-  const COLUMS = {
-    name: 1,
-    price: 2
-  };
-  sheet.getCells(
-    {
-      "min-row": 2,
-      "max-row": 5,
-      "return-empty": true
-    },
-    (err, cells) => {
-      for (let i = 0; i < cells.length / sheet.colCount; i += 1) {
-        const name = cells[i * sheet.colCount + COLUMS.name].value;
-        const price = cells[i * sheet.colCount + COLUMS.price].value;
-      }
-    }
-  );
-};
-const a = async () => {
-  await setAuth();
-  await workingWithCells();
-};
-const main = () => {
-  a();
-};
-main();
-```
+```
-### 試したこと
+上記の関数を下記に変更
-```js
+```
 const getInfoAndSheets = () =>
@@ -210,6 +266,8 @@
     doc.getInfo((err, info) => {
+      if(!info) info = function(){}
       sheet = info.worksheets[0];
     });
@@ -218,30 +276,6 @@
   });
-```
-上記の関数を下記に変更
-```
-const getInfoAndSheets = () =>
-  new Promise((resolve, reject) => {
-    doc.getInfo((err, info) => {
-      if(!info) info = function(){}
-      sheet = info.worksheets[0];
-    });
-    resolve();
-  });

2019/09/27 01:17

投稿

kotaro_nagano

スコア11

test CHANGED Viewed

File without changes

test CHANGED Viewed

@@ -44,6 +44,40 @@
+```js
+  /Users/user/dev/atom-tools/node_modules/google-spreadsheet/index.js
+  function renewJwtAuth(cb) {
+    auth_mode = "jwt";
+    jwt_client.authorize(function(err, token) {
+      if (err) return cb(err);
+      self.setAuthToken({
+        type: token.token_type,
+        value: token.access_token,
+        expires: token.expiry_date
+      });
+      cb();
+    });
+  }
+```
 ### 該当のソースコード