Skip to main content
Join the official 2019 Python Developers SurveyStart the survey!

Data loader for SQLAlchemy

Project description

Overview

clue_sqlaloader provides a mechanism for populating a sql database using SQLAlchemy and YAML.

Usage

clue_sqlaloader was primarily meant to run from inside other applications as a framework piece but can be run from the command-line as follows:

$ python -m clue_sqlaloader.__init__ sqlite:///somefile.db data.yaml

The typical way to use the loader from within Python is as follows:

from clue_sqlaloader import Loader
loader = Loader(sqlalchemy_session)
loader.load_from_yamlf('somefile.yaml')

The format of the YAML should be similar to the following:

- model: mymodule.Group
  refname: !!refname "admingroup"
  fields:
    name: admin
- model: mymodule.User
  fields:
    username: testuser1
    email: user@hisplace.com
    groups: [!!ref "admingroup"]
  execute:
    set_password: testuser1

The model and fields arguments are straightforward. The execute argument will call the given function name on the newly created object with the given value.

Credits

Written and maintained by Rocky Burt <rocky AT serverzen DOT com>

Changes

0.1.1 (Apr-21-2011)

  • Made Reference lookup a little more robust
  • Added missing dep for zope.dottedname

0.1 (Apr-12-2011)

  • first release

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 clue_sqlaloader, version 0.1.1
Filename, size File type Python version Upload date Hashes
Filename, size clue_sqlaloader-0.1.1.tar.gz (4.1 kB) File type Source Python version None Upload date Hashes View hashes

Supported by

Elastic Elastic Search Pingdom Pingdom Monitoring Google Google BigQuery Sentry Sentry Error logging AWS AWS Cloud computing DataDog DataDog Monitoring Fastly Fastly CDN SignalFx SignalFx Supporter DigiCert DigiCert EV certificate StatusPage StatusPage Status page