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 is 0
• float: prefix f_. default value is 0.0
• string: prefix s_. default value is ''
• boolean: prefix b_. default value is false
• date: prefix d_. default value is null

service account key

1. make service account key from google api console
2. get client_email from service account key
3. add read permission to client_email