Using pandas as db in python
Project description
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
Project details
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
pddb-genwch-0.0.1.tar.gz
(5.4 kB
view hashes)
Built Distribution
Close
Hashes for pddb_genwch-0.0.1-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 764cf6de85af2d444143b9e80031b69a39ef402b2b96218fcd9bbed13837c362 |
|
MD5 | 5489e6c3e75968c064705687f2fb3796 |
|
BLAKE2b-256 | cf564592d6ff8e902e6e58ac15f4161b392f9e60e3f90ba44b0ff172a78895f0 |