Using Pandas as database in python

Using Pandas (Parquet) as database in python

Method

• set_owner
• set_debug
• cols
• filter
• update
• insert
• upsert
• save
• load

Sample

Table

class User(pddb.pdtbl):
    def init_obj(self) -> dict:
        path = "./data/users.parquet"
        obj = {"uid": {"type": str, "uuid": True, "ignupd": True},
               "usr_cde": {"type": str, "key": True},
               "usr_name": {"type": str}}
        return (obj, path)

class Password(pddb.pdtbl):
    def init_obj(self) -> dict:
        path = "./data/passwords.parquet"
        obj = {"uid": {"type": str, "uuid": True, "key": True, "ignupd": True},
               "password": {"type": str, "require": True, "md5": True}}
        return (obj, path)

View

class VW_User_Password(pddb.pdvw):
    def init_obj(self) -> dict:
        usr = User()
        pwd = Password()
        cfg = {"source": [{"name": "usr", "tbl": usr}, {"name": "pwd", "tbl": pwd, "join": ["uid"]}],
               "cols": [{"tbl": "usr", "col": "uid"}, {"tbl": "usr", "col": "usr_cde"}, {"tbl": "pwd", "col": "password"}]}
        return cfg