Bull SQLite

Simple Helper Package for use with SQLite3 in Python. Handles connecting, comitting, and closing so you no longer have to bother; helping you write more concise code.

Basically takes in parameters for a given operation such as selecting, formats the query for you and executes it in only one line.

Example usage

import bull

# connect(db_name) returns an instance of the Database class
db = bull.Database.connect('example_database_name')

One way of creating a table using bull.Database.execute()

create_cats_table_query = 'CREATE TABLE cats(catId INTEGER PRIMARY KEY, catName TEXT NOT NULL);'
db.execute(create_cats_table_query)

Another way of creating the same table using bull.Database.create_table()

db.create_table(table_name='cats',
                fields=[
                    bull.Field('catId', bull.Type.INTEGER, bull.ColumnConstraint.PRIMARY_KEY),
                    bull.Field('catName', bull.Type.TEXT, bull.ColumnConstraint.NOT_NULL)
                ])