Skip to main content

Python class helper for working with sqlite3 databases and Pandas dataframes.

Project description

Build Status Codecov GitHub

Python class helper for sqlite3 databases.

Example: Create, read and remove a table working with just dataframes.

from dbops.sqhelper import SQHelper
import pandas as pd

table_name = 'temperature'
df = pd.DataFrame({"timestamp": [1587222785, 1587222786], 'celsius': [23.3, 23.9]})

db = 'myDatabase.sql3'
database = SQHelper(db)

# The dataframe column names are used for the table's column names. 
# All dataframe entries are automatically inserted.

# Add some more entries to the database, in this case duplicates of the above entry are made.

# Read the content back into a dataframe
new_df = database.table_to_df(table_name)

# Remove the table from the database

Example: Create a table, add an entry and return it as a Pandas dataframe.

from dbops.sqhelper import SQHelper

db = 'myDatabase.sql3'
table_name = 'temperature'
columns = {'timestamp': 'NUMERIC', 'celsius': 'REAL'}

# Create a class instance for a single database
database = SQHelper(db)

# Add a table to the database

# Get all the tables in the database
all_tables = database.get_table_names()

# Add an entry to the database
new_entry = {'timestamp': 1587222785, 'celsius': 34.2}
database.insert(table_name, new_entry)

# Return the table as a Pandas Dataframe
df = database.table_to_df(table_name)

# Return all rows based on a column query, returns matching rows as dataframe
database.get_row(table_name, 'celsius', 34.2);

Use help(SQHelper) for more detailed information.

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

db-ops-0.0.2.tar.gz (6.3 kB view hashes)

Uploaded source

Built Distribution

db_ops-0.0.2-py3-none-any.whl (7.2 kB view hashes)

Uploaded py3

Supported by

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