knoxdb 0.5.0

Quickly create a PostgresSQL DB without the hassle.

KnoxDB Python Library

Table of contents

• Install
• Usage
• Feedback

Install

This library only supports python3

$ pip install knoxdb

Usage

import knoxdb
from knoxdb import knox

Create a new DB with a custom name. This returns back information about the DB you can store to easily access it again.

new_db = knox.create(db_name="test_db")

Get a DB Instance from the ID returned after creating an instance

db = knox.get_from_id(id="test_db_id")

Connect to DB Instance

conn = knox.connect(id="test_db_id")

Close connection to DB

knox.close_db_connection(conn=conn)

Query the DB Instance by passing in a SQL Command

conn = knox.connect(id="test_db_id")
sql_string = "CREATE TABLE \"User\" (id serial PRIMARY KEY, name VARCHAR(255) NOT NULL, email VARCHAR(255) NOT NULL)"
db_query = knox.query(conn=conn, sql_string=sql_string, close_conn=True)

Feedback

Feel free to send me feedback or feature requests on my Website. Feature requests are always welcome.

If there's anything you'd like to chat about, please feel free to email me at [e-mail]!