- 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
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
File details
Details for the file coralinedb-2.10.1.tar.gz.
File metadata
- Download URL: coralinedb-2.10.1.tar.gz
- Upload date:
- Size: 7.4 kB
- Tags: Source
- Uploaded using 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
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 |
e25641ca239a83ddc58c96bf524a14d850ddde745dbfa0c9db10002d74bd083e
|
|
| MD5 |
8ab5dfdefcbe669c7a943ca32b6300c9
|
|
| BLAKE2b-256 |
66aefdee8d3daed6a02b0b976ec0fcebb9552ca78d7be2fafe3301a625e4afa0
|
