Skip to main content

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)

Uploaded Source

Built Distribution

pddb_genwch-0.0.5-py3-none-any.whl (7.5 kB view details)

Uploaded Python 3

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

Hashes for pddb-genwch-0.0.5.tar.gz
Algorithm Hash digest
SHA256 72c1f92e96cf2038daa5e665f7ab3746bd46eb57572b5cac4053525b23d54de3
MD5 272ab83c0d280162b577f1a7c282d2be
BLAKE2b-256 aeed23724e4375a10e4f40007d2439c38d73773dd3e5fe3d07aeaa0cad5c1b4c

See more details on using hashes here.

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

Hashes for pddb_genwch-0.0.5-py3-none-any.whl
Algorithm Hash digest
SHA256 793d889739d2e161e2b5cd8b26c11a7ef1b7ca25b51b17b7255e9e488ade194b
MD5 1aa7516d3b03d35eef703032048efd73
BLAKE2b-256 2778d4b7817b7843c6d81d79c032cb2776dda0faf35a42317482d74b48efa8a2

See more details on using hashes here.

Supported by

AWS AWS Cloud computing and Security Sponsor Datadog Datadog Monitoring Fastly Fastly CDN Google Google Download Analytics Microsoft Microsoft PSF Sponsor Pingdom Pingdom Monitoring Sentry Sentry Error logging StatusPage StatusPage Status page