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
