Database interaction utilities for the SPARC platform
Project description
sparc.db
========
Database interaction utilities for the SPARC platform.
SQL Databases
-------------
Interactions to SQL databases are provided via SQLAlchemy (http://www.sqlalchemy.org/).
In addition, z3c.saconfig (https://pypi.python.org/pypi/z3c.saconfig) is
provided to allow connection configuration andintegration of SQLAlchemy in ZCA.
### Usage - SQLite memory DB connection
These steps will give you access to a SQLAlchemy session, see the SQLAlchemy
docs to understand how to interact with this object.
>>> import sparc.db
>>> from sparc.common import Configure
>>> from zope.component import getUtility
>>> from z3c.saconfig.interfaces import IEngineFactory, IScopedSession
>>> Configure((sparc.db, 'memory.zcml',))
>>> myEngine = getUtility(IEngineFactory, name="memory_engine")
>>> mySession = getUtility(IScopedSession, name="memory_session")
The above example gives access to a in-memoery SQLite instance. In practice,
you would create your own db.zcml with the appropriate connection information.
See SAConfig documentation on how to create the ZCML configu file.
sparc.db
==========
0.0.3
++++++++++++++++++
* pypi packaging update
0.0.2
++++++++++++++++++
* include zcml configuration files in packaging
0.0.1
++++++++++++++++++
* initial release
========
Database interaction utilities for the SPARC platform.
SQL Databases
-------------
Interactions to SQL databases are provided via SQLAlchemy (http://www.sqlalchemy.org/).
In addition, z3c.saconfig (https://pypi.python.org/pypi/z3c.saconfig) is
provided to allow connection configuration andintegration of SQLAlchemy in ZCA.
### Usage - SQLite memory DB connection
These steps will give you access to a SQLAlchemy session, see the SQLAlchemy
docs to understand how to interact with this object.
>>> import sparc.db
>>> from sparc.common import Configure
>>> from zope.component import getUtility
>>> from z3c.saconfig.interfaces import IEngineFactory, IScopedSession
>>> Configure((sparc.db, 'memory.zcml',))
>>> myEngine = getUtility(IEngineFactory, name="memory_engine")
>>> mySession = getUtility(IScopedSession, name="memory_session")
The above example gives access to a in-memoery SQLite instance. In practice,
you would create your own db.zcml with the appropriate connection information.
See SAConfig documentation on how to create the ZCML configu file.
sparc.db
==========
0.0.3
++++++++++++++++++
* pypi packaging update
0.0.2
++++++++++++++++++
* include zcml configuration files in packaging
0.0.1
++++++++++++++++++
* initial 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.
Source Distribution
sparc.db-0.0.3.tar.gz
(9.1 kB
view details)
File details
Details for the file sparc.db-0.0.3.tar.gz
.
File metadata
- Download URL: sparc.db-0.0.3.tar.gz
- Upload date:
- Size: 9.1 kB
- Tags: Source
- Uploaded using Trusted Publishing? No
File hashes
Algorithm | Hash digest | |
---|---|---|
SHA256 | 00ac41b7e1129984e257e94df99c7e841f9977f51fc1c47b84ecb984528d8468 |
|
MD5 | 9179306c2d232834ff115cd7761e8aac |
|
BLAKE2b-256 | f9f2bc3e1eff665c10c0d03d15c2caf89576286d909d92420237d37807d3741c |