1.0.4 • Published 6 years ago
nadeshiko v1.0.4
nadeshiko
Cache layer for Google Sheet
usage
make sheet
make metadata sheet.
metadata-references and metadata-constraints
reference table is ...
| s_table | s_range | s_sheet |
|---|---|---|
| testdata-foo | A1:E | spreadsheet-id |
| testdata-bar | A1:B | spreadsheet-id |
constraint table is...
| type | first table | first attribute | second table | second attribute |
|---|---|---|---|---|
| fk | testdata-bar | parent_id | testdata-foo | id |
make data sheet. referenced by reference table. sample sheet is ... (sheet name = testdata-foo)
| i_id | f_rate | s_name | b_is_default | d_deleted_at |
|---|---|---|---|---|
| 1 | 1.5 | testdb | TRUE | |
| 2 | 2.5 | bar | FALSE | |
| 3 | 4.125 | spam | FALSE | 1995. 9. 7 오전 10:40:52 |
supported type
- integer: prefix
i_. default value is0 - float: prefix
f_. default value is0.0 - string: prefix
s_. default value is'' - boolean: prefix
b_. default value isfalse - date: prefix
d_. default value isnull
service account key
- make service account key from google api console
- get
client_emailfrom service account key - add read permission to
client_email