Coraline Database Manager Package
Project description
- 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)
Project details
Release history Release notifications | RSS feed
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 |