coralinedb 2.9.1

Coraline Database Manager Package

Coraline Database Manager Package

Now, only MSSQL and MySQL DB are supported

-How to use-

1. Initial database object by specify host, username and password

   from coralinedb import MySQLDB

   sql_db = MySQLDB(host, username, password)

2. 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”])

3. Save a dataframe to a table

   sql_db.save_table(df, “database_name”, “table_name”)

4. Get number of rows of a table

   n_rows = sql_db.get_count(“database_name”, “table_name”)

5. 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”)

6. 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)