dbhydra
Data science friendly ORM (Object Relational Mapping) library combining Python, Pandas, and various SQL dialects For full documentation see official documentation - currently unavailable but we're working on it!
Installation
Use the package manager pip to install dbhydra.
pip install dbhydra
Usage
import dbhydra.dbhydra_core as dh
db1=dh.db()
table1 = dh.Table(db1,"test",["test1","test2","test3","test4"],["int","int","int","int"])
#table1.drop()
#table1.create()
#rows=[[1,2,3,4],[5,4,7,9]]
#table1.insert(rows)
list1=table1.select("SELECT * FROM test")
print(list1)
#list2=table1.select_all()
#print(list2)
#table1.drop()
table1.export_to_xlsx()
tables=db1.get_all_tables()
table_dict=db1.generate_table_dict()
print(tables)
columns=table_dict['test'].get_all_columns()
types=table_dict['test'].get_all_types()
print(columns,types)
table_test=dh.Table.init_all_columns(db1,"test")
print(table_test.columns)
table2 = dh.Table(db1,"test_new",["id","test2"],["int","nvarchar(20)"])
#table2.create()
#table2.drop()
Current scope
Aims: Easy integration with Pandas, SQL SERVER/MySQL database, and exports/imports to/from excel/CSV format
Done: Table functions (Create, Drop, Select, Update, Insert, and Delete) should be working fine
Todo: Group by, Order by, Where, Linking of FK, Customizable PK,...
Contributing
Pull requests are welcome. For major changes, please open an issue first to discuss what you would like to change.
License
1 maintainer
Metadata
1 maintainer
Release files for dbhydra 2.3.9
For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.
Source distribution (sdist)
| File | Size | Uploaded | |
|---|---|---|---|
| dbhydra-2.3.9.tar.gz | 30.7 kB | Details |
Built distribution (wheel)
| File | Interpreter | ABI | Platform | Reset |
|---|---|---|---|---|
| dbhydra-2.3.9-py3-none-any.whl | Python 3 | none | any | Details |
Total release size: 67.2 kB
Release files / dbhydra-2.3.9.tar.gz
| Download URL | dbhydra-2.3.9.tar.gz |
|---|---|
| Size | 30.7 kB |
| Tags | Source |
|
SHA-256 checksum How to use checksums |
3d1ad79c02851876db5fa41c5bd93bdcf79f7c453ebcc653ebab852a21d0749e
|
|
BLAKE2b-256 checksum How to use checksums |
9173c859aa1d7dc1206e5f87fb0cd7826352bad00514c08b90fa9f7ca1a89dcd
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/6.1.0 CPython/3.12.7
|
Release files / dbhydra-2.3.9-py3-none-any.whl
| Download URL | dbhydra-2.3.9-py3-none-any.whl |
|---|---|
| Size | 36.5 kB |
| Tags | Python 3 |
|
SHA-256 checksum How to use checksums |
86e67eb0e173e06d3bbe06e9f3d62843fb0a67a2f1483fedfd8306f54867526e
|
|
BLAKE2b-256 checksum How to use checksums |
b90e475afa4de049b484bef0719dfaa07b3dca9cb7bfd385a96de4c3b68097da
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/6.1.0 CPython/3.12.7
|
