Skip to main content

Coraline Database Manager Package

Project description

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)

Project details


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

coralinedb-2.10.1.tar.gz (7.4 kB view details)

Uploaded Source

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

Hashes for coralinedb-2.10.1.tar.gz
Algorithm Hash digest
SHA256 e25641ca239a83ddc58c96bf524a14d850ddde745dbfa0c9db10002d74bd083e
MD5 8ab5dfdefcbe669c7a943ca32b6300c9
BLAKE2b-256 66aefdee8d3daed6a02b0b976ec0fcebb9552ca78d7be2fafe3301a625e4afa0

See more details on using hashes here.

Supported by

AWS AWS Cloud computing and Security Sponsor Datadog Datadog Monitoring Fastly Fastly CDN Google Google Download Analytics Microsoft Microsoft PSF Sponsor Pingdom Pingdom Monitoring Sentry Sentry Error logging StatusPage StatusPage Status page