- Coraline Database Manager Package
Now, only MSSQL and MySQL DB are supported
-How to use-
Initial database object by specify host, username and password
from coralinedb import MySQLDB
sql_db = MySQLDB(host, username, password)
Load a table or multiple tables
new_table = sql_db.load_table(“database_name”, “table_name”)
or
table1, table2 = sql_db.load_tables(“database_name”, [“table_name1”, “table_name2”])
Save a dataframe to a table
sql_db.save_table(df, “database_name”, “table_name”)
Get number of rows of a table
n_rows = sql_db.get_count(“database_name”, “table_name”)
Run other SQL statement on host (with or without database name)
table = sql_db.query(“show databases;”)
table = sql_db.query(“SELECT * FROM …”, “database_name”)
Run store procedure on host (with or without database name)
affected_row = db.call_procedure(“CALL store_procedure”) dataframe = db.call_procedure(“CALL store_procedure”, return_df=True)
2 maintainers
Metadata
2 maintainers
Release files for coralinedb 2.10.1
For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.
Source distribution (sdist)
| File | Size | Uploaded | |
|---|---|---|---|
| coralinedb-2.10.1.tar.gz | 7.4 kB | Details |
Release files / coralinedb-2.10.1.tar.gz
| Download URL | coralinedb-2.10.1.tar.gz |
|---|---|
| Size | 7.4 kB |
| Tags | Source |
|
SHA-256 checksum How to use checksums |
e25641ca239a83ddc58c96bf524a14d850ddde745dbfa0c9db10002d74bd083e
|
|
BLAKE2b-256 checksum How to use checksums |
66aefdee8d3daed6a02b0b976ec0fcebb9552ca78d7be2fafe3301a625e4afa0
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/2.0.0 pkginfo/1.5.0.1 requests/2.22.0 setuptools/40.8.0 requests-toolbelt/0.9.1 tqdm/4.36.1 CPython/3.7.4
|
