DBSheet

Using google spreadsheets as database.

This package helps you make use of google sheets as databases. What all it supports

Creating Tables
Inserting Rows
Get all records
Search for One Row
Search for particular number of Rows

How to initialize

from db_sheet.db_sheet import DbSheet
from db_sheet.sheet_table import WorkingTable, CreateTable, Table
db = DbSheet(db_name = "SHEETBACKEND", api_creds = "client_secret.json", scope = ['https://spreadsheets.google.com/feeds'])
sheet = db.get_db_conn()

Sheet is like database.

Creating tables

from db_sheet.db_sheet import DbSheet
from db_sheet.sheet_table import WorkingTable, CreateTable, Table
db = DbSheet(db_name = "SHEETBACKEND", api_creds = "client_secret.json", scope = ['https://spreadsheets.google.com/feeds'])
sheet = db.get_db_conn()
table = Table({"Col1","col2"},"name_of_table")
creator = CreateTable(table, sheet)
creator.create_table()

Inserting Rows

from db_sheet.sheet_table import WorkingTable, CreateTable, Table
working_table = WorkingTable("tablename",sheet)
working_table.insert({"value1","value2"}

Get all records

from db_sheet.sheet_table import WorkingTable, CreateTable, Table
working_table = WorkingTable("tablename",sheet)
working_table.get_all()

Search for One Row

from db_sheet.sheet_table import WorkingTable, CreateTable, Table
working_table = WorkingTable("tablename",sheet)
working_table.get_one("column_name",value)

Search for particular number of Rows

from db_sheet.sheet_table import WorkingTable, CreateTable, Table
working_table = WorkingTable("tablename",sheet)
working_table.find("column_name",value,total_count_u_need)

Contribution:

You can contibute by following below simple steps.

Make sure your build is passing
Keep your code clean and proper commenting with pep8.

Thats it for now. Will add more since its just a begginging. Suggestions are welcome. Please create an issue if you think this is **** and you can make it better :D

@ Author: chowmean

chowmean/DBSheet