From 89643ba6fa98db82efd3246805ef801a8bfb5c81 Mon Sep 17 00:00:00 2001
From: Jeff Huth <jeff.huth@bytecode.io>
Date: Wed, 13 Nov 2019 17:03:56 -0800
Subject: Initial commit

Discovery mode works. Still working on normal sync.
---
 tap_google_sheets/schemas/file_metadata.json       | 44 +++++++++++
 tap_google_sheets/schemas/sheet_metadata.json      | 89 ++++++++++++++++++++++
 tap_google_sheets/schemas/sheets_loaded.json       | 22 ++++++
 .../schemas/spreadsheet_metadata.json              | 30 ++++++++
 4 files changed, 185 insertions(+)
 create mode 100644 tap_google_sheets/schemas/file_metadata.json
 create mode 100644 tap_google_sheets/schemas/sheet_metadata.json
 create mode 100644 tap_google_sheets/schemas/sheets_loaded.json
 create mode 100644 tap_google_sheets/schemas/spreadsheet_metadata.json

(limited to 'tap_google_sheets/schemas')

diff --git a/tap_google_sheets/schemas/file_metadata.json b/tap_google_sheets/schemas/file_metadata.json
new file mode 100644
index 0000000..25c19c4
--- /dev/null
+++ b/tap_google_sheets/schemas/file_metadata.json
@@ -0,0 +1,44 @@
+{
+  "type": "object",
+  "additionalProperties": false,
+  "properties": {
+    "id": {
+      "type": ["null", "string"]
+    },
+    "name": {
+      "type": ["null", "string"]
+    },
+    "version": {
+      "type": ["null", "integer"]
+    },
+    "createdTime": {
+      "type": ["null", "string"],
+      "format": "date-time"
+    },
+    "modifiedTime": {
+      "type": ["null", "string"],
+      "format": "date-time"
+    },
+    "teamDriveId": {
+      "type": ["null", "string"]
+    },
+    "driveId": {
+      "type": ["null", "string"]
+    },
+    "lastModifyingUser": {
+      "type": ["null", "object"],
+      "additionalProperties": false,
+      "properties": {
+        "kind": {
+          "type": ["null", "integer"]
+        },
+        "displayName": {
+          "type": ["null", "string"]
+        },
+        "emailAdress": {
+          "type": ["null", "string"]
+        }
+      }
+    }
+  }
+}
diff --git a/tap_google_sheets/schemas/sheet_metadata.json b/tap_google_sheets/schemas/sheet_metadata.json
new file mode 100644
index 0000000..c3f2ac2
--- /dev/null
+++ b/tap_google_sheets/schemas/sheet_metadata.json
@@ -0,0 +1,89 @@
+{
+  "type": "object",
+  "additionalProperties": false,
+  "properties": {
+    "spreadsheetId": {
+      "type": ["null", "string"]
+    },
+    "sheetId": {
+      "type": ["null", "integer"]
+    },
+    "title": {
+      "type": ["null", "string"]
+    },
+    "index": {
+      "type": ["null", "integer"]
+    },
+    "sheetType": {
+      "type": ["null", "string"]
+    },
+    "sheetUrl": {
+      "type": ["null", "string"]
+    },
+    "gridProperties": {
+      "type": ["null", "object"],
+      "additionalProperties": false,
+      "properties": {
+        "rowCount": {
+          "type": ["null", "integer"]
+        },
+        "columnCount": {
+          "type": ["null", "integer"]
+        },
+        "frozenRowCount": {
+          "type": ["null", "integer"]
+        },
+        "frozenColumnCount": {
+          "type": ["null", "integer"]
+        }
+      }
+    },
+    "columns": {
+      "anyOf": [
+        {
+          "type": "array",
+          "items": {
+            "type": ["null", "object"],
+            "additionalProperties": false,
+            "properties": {
+              "columnIndex": {
+                "type": ["null", "integer"]
+              },
+              "columnLetter": {
+                "type": ["null", "string"]
+              },
+              "columnName": {
+                "type": ["null", "string"]
+              },
+              "columnType": {
+                "type": ["null", "string"]
+              },
+              "columnSkipped": {
+                "type": ["null", "boolean"]
+              },
+              "type": {
+                "anyOf": [
+                  {
+                    "type": "array",
+                    "items": {
+                      "type": "string"
+                    }
+                  },
+                  {
+                    "type": "null"
+                  }
+                ]
+              },
+              "format": {
+                "type": ["null", "string"]
+              }
+            }
+          }
+        },
+        {
+          "type": "null"
+        }
+      ]
+    }
+  }
+}
diff --git a/tap_google_sheets/schemas/sheets_loaded.json b/tap_google_sheets/schemas/sheets_loaded.json
new file mode 100644
index 0000000..12f967a
--- /dev/null
+++ b/tap_google_sheets/schemas/sheets_loaded.json
@@ -0,0 +1,22 @@
+{
+  "type": "object",
+  "additionalProperties": false,
+  "properties": {
+    "spreadsheetId": {
+      "type": ["null", "string"]
+    },
+    "sheetId": {
+      "type": ["null", "integer"]
+    },
+    "sheetTitle": {
+      "type": ["null", "string"]
+    },
+    "loadDate": {
+      "type": ["null", "string"],
+      "format": "date-time"
+    },
+    "lastRowNumber": {
+      "type": ["null", "integer"]
+    }
+  }
+}
diff --git a/tap_google_sheets/schemas/spreadsheet_metadata.json b/tap_google_sheets/schemas/spreadsheet_metadata.json
new file mode 100644
index 0000000..852cb76
--- /dev/null
+++ b/tap_google_sheets/schemas/spreadsheet_metadata.json
@@ -0,0 +1,30 @@
+{
+  "type": "object",
+  "additionalProperties": false,
+  "properties": {
+    "spreadsheetId": {
+      "type": ["null", "string"]
+    },
+    "properties": {
+      "type": ["null", "object"],
+      "additionalProperties": false,
+      "properties": {
+        "title": {
+          "type": ["null", "string"]
+        },
+        "locale": {
+          "type": ["null", "string"]
+        },
+        "autoRecalc": {
+          "type": ["null", "string"]
+        },
+        "timeZone": {
+          "type": ["null", "string"]
+        }
+      }
+    },
+    "spreadsheetUrl": {
+      "type": ["null", "string"]
+    }
+  }
+}
-- 
cgit v1.2.3