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.5.tar.gz
(6.1 kB
view details)
Built Distribution
File details
Details for the file pddb-genwch-0.0.5.tar.gz
.
File metadata
- Download URL: pddb-genwch-0.0.5.tar.gz
- Upload date:
- Size: 6.1 kB
- Tags: Source
- Uploaded using Trusted Publishing? No
- Uploaded via: twine/3.4.1 importlib_metadata/3.10.0 pkginfo/1.7.0 requests/2.25.1 requests-toolbelt/0.9.1 tqdm/4.60.0 CPython/3.9.4
File hashes
Algorithm | Hash digest | |
---|---|---|
SHA256 | 72c1f92e96cf2038daa5e665f7ab3746bd46eb57572b5cac4053525b23d54de3 |
|
MD5 | 272ab83c0d280162b577f1a7c282d2be |
|
BLAKE2b-256 | aeed23724e4375a10e4f40007d2439c38d73773dd3e5fe3d07aeaa0cad5c1b4c |
File details
Details for the file pddb_genwch-0.0.5-py3-none-any.whl
.
File metadata
- Download URL: pddb_genwch-0.0.5-py3-none-any.whl
- Upload date:
- Size: 7.5 kB
- Tags: Python 3
- Uploaded using Trusted Publishing? No
- Uploaded via: twine/3.4.1 importlib_metadata/3.10.0 pkginfo/1.7.0 requests/2.25.1 requests-toolbelt/0.9.1 tqdm/4.60.0 CPython/3.9.4
File hashes
Algorithm | Hash digest | |
---|---|---|
SHA256 | 793d889739d2e161e2b5cd8b26c11a7ef1b7ca25b51b17b7255e9e488ade194b |
|
MD5 | 1aa7516d3b03d35eef703032048efd73 |
|
BLAKE2b-256 | 2778d4b7817b7843c6d81d79c032cb2776dda0faf35a42317482d74b48efa8a2 |