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
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.