Skip to main content
This is a pre-production deployment of Warehouse. Changes made here affect the production instance of PyPI (
Help us improve Python packaging - Donate today!

Data loader for SQLAlchemy

Project Description


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


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)

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

- model: mymodule.Group
  refname: !!refname "admingroup"
    name: admin
- model: mymodule.User
    username: testuser1
    groups: [!!ref "admingroup"]
    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.


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


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
Release History

Release History

This version
History Node


History Node


Download Files

Download Files

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

File Name & Checksum SHA256 Checksum Help Version File Type Upload Date
clue_sqlaloader-0.1.1.tar.gz (4.1 kB) Copy SHA256 Checksum SHA256 Source Apr 22, 2011

Supported By

WebFaction WebFaction Technical Writing Elastic Elastic Search Pingdom Pingdom Monitoring Dyn Dyn DNS Sentry Sentry Error Logging CloudAMQP CloudAMQP RabbitMQ Heroku Heroku PaaS Kabu Creative Kabu Creative UX & Design Fastly Fastly CDN DigiCert DigiCert EV Certificate Rackspace Rackspace Cloud Servers DreamHost DreamHost Log Hosting