Skip to main content

Stores configurations in a database instead of a file

Project description

Allows you to store configuration in an SQLAlchemy database instead of configuration files. The API is close, but not exactly like configparser and it plugs right into any application that is already using a declarative SQLAlchemy model:

# create a new model to hold the configuration items
class ConfigSetting(Base, ConfigSettingMixin):
    __tablename__ = 'configuration'

# instantiate the model with your session
config = Config(ConfigSetting, session)

# now config sections will work like a regular dict
config['section_foo']['bar'] = 123

# values will be json-encoded before being stored (this can be changed)
# to persist changes, simply commit the session

A full, minimal example is a bit more verbose due to the required initial setup:

from sqlacfg import ConfigSettingMixin, Config
from sqlalchemy import create_engine
from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy.orm import sessionmaker

Base = declarative_base()
Session = sessionmaker()

class ConfigSetting(Base, ConfigSettingMixin):
    __tablename__ = 'configuration'

# for this demonstration, we just create the db in memory
eng = create_engine('sqlite:///:memory:', echo=True)

session = sessionmaker(bind=eng)()

config = Config(ConfigSetting, session)

config['base']['foo'] = 'bar'
config['base']['baz'] = 'baz'

print dict(config['base'].iteritems())

Project details

Download files

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

Files for sqlacfg, version 0.3
Filename, size File type Python version Upload date Hashes
Filename, size sqlacfg-0.3.tar.gz (3.0 kB) File type Source Python version None Upload date Hashes View

Supported by

Pingdom Pingdom Monitoring Google Google Object Storage and Download Analytics Sentry Sentry Error logging AWS AWS Cloud computing DataDog DataDog Monitoring Fastly Fastly CDN DigiCert DigiCert EV certificate StatusPage StatusPage Status page