Skip to main content

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.

Source Distribution

clue_sqlaloader-0.1.1.tar.gz (4.1 kB view details)

Uploaded Source

File details

Details for the file clue_sqlaloader-0.1.1.tar.gz.

File metadata

File hashes

Hashes for clue_sqlaloader-0.1.1.tar.gz
Algorithm Hash digest
SHA256 168379eac9b3f7b9d08f334c76d004653f81ff70130e72e62676c3b680654c11
MD5 26f6ec440de13c4b2613c9354da3a077
BLAKE2b-256 2df525c1d5dda601095c52b6c8e68ad6bb3eaca6470660f9d7b13b66a6c43208

See more details on using hashes here.

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