Skip to main content

Make changes to sql tables using SqlAlchmey sessions

Project description

Sessionize Logo

Sessionize: intutive Python SQL table manipulation toolkit

PyPI Latest Release

What is it?

Sessionize is a Python package that has an intuitive API that utilizes SqlAlchemy to connect to and manipulate records in SQL tables.

Main Features

Here are just a few of the things that Sessionize does well:

  • Quickly and easily start a SQL session to insert, delete, and update records in SQL tables.
  • Roll back any changes durring SQL session inside a context manager.
  • Additional SQL migration functions for changing or adding primary keys, adding or dropping columns, renaming column and more.

Where to get it

The source code is currently hosted on GitHub at: https://github.com/eddiethedean/sessionize

# PyPI
pip install sessionize

Dependencies

Example

import sqlalchemy as sa
from sessionize import SessionTable 

# Create SqlAlchemy engine to connect to database.
engine = sa.create_engine('sqlite:///foo.db')

# Create SessionTable to start session of table changes.
st = SessionTable('people', engine)

# Make changes to SessionTable:
# Add 1 to each value in the age column.
st['age'] + 1
# Update the first record with new values.
st[0] = {'id': 1, 'name': 'Olive', 'age': 18}
# Delete the last record.
del st[-1]

# Commit SessionTable to push changes to SQL table.
st.commit()

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

sessionize-0.0.18.tar.gz (19.1 kB view hashes)

Uploaded Source

Built Distribution

sessionize-0.0.18-py3-none-any.whl (29.3 kB view hashes)

Uploaded Python 3

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