A tiny library for one-way syncing the Google spreadsheet to database
Project description
Sheet2db
Sheet2db is a tiny python library for one-way syncing the Google spreadsheet to database. (Currently, it supports only MySQL)
It is useful for managing some static data on Google spreadsheet, but also want to sync the sheet data to database.
Sheet2db DOES NOT collect any your secret values!
Installation
pip install sheet2db
Usage
You must have API key which is accessible to Google Spreadsheet API
Example sheet format (items tab):
===========================
| A | B | C | D |
===========================
| id | name | count | ver |
|----|------|-------|-----|
| .. | .... | ..... | ... |
===========================
Following example will sync items tab of 1U3un2ZJPRhLrWzc2DMXq8VI7Nqf9pYlajfO4mQVCZpE spreadsheet to database:
"AIzaSyC6pabjqmaPiguYoHbq4W7a0DV0wQg5JGk" is a fake api key
from sheet2db import Sheet2db
# Pass API key
syncer = Sheet2db(api_key='AIzaSyC6pabjqmaPiguYoHbq4W7a0DV0wQg5JGk')
# If you need to access to private spreadsheet, you can't use API key. Use oauth credentials instead.
syncer = Sheet2db(
creds_path='credentials.json',
token_path='token.json')
# Fetch data from spreadsheet
syncer.fetch(
sheet='1U3un2ZJPRhLrWzc2DMXq8VI7Nqf9pYlajfO4mQVCZpE',
tab='items',
range='A1:D')
# Sync fetched data to database (mysql)
syncer.sync(
host='192.168.168.10',
port=3306,
user='mingrammer',
password='p@ssw0rd',
db='static',
table='items')
You can also use ssh tunneling to access to remote database with sshtunnel
with sshtunnel.SSHTunnelForwarder(
('db.service.io', 22),
ssh_username='ssh_user'
ssh_pkey='~/.ssh/id_rsa'
ssh_private_key_password='ssh_pk_password',
remote_bind_address=('localhost', 3306),
) as tunnel:
syncer.sync(
host = tunnel.local_bind_host,
port = tunnel.local_bind_host,
user = 'mingrammer',
password = 'p@ssw0rd',
db = 'static',
table = 'items')
License
MIT
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
Built Distribution
Hashes for sheet2db-1.0.0-py2.py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 3afa32698f651e8dae5459757ea0c58d9689d7ff94267f527aade0caf29ace7e |
|
MD5 | 09c2597776a7daf31e796cd0b4117436 |
|
BLAKE2b-256 | 997719beeb17953bea1644483ce84125596caa5c56cda171eb45811af67d0228 |