Unhammer: sql

2014-01-24T14:58:26Z

sql

New page

Some tips for hacking around with the MediaGoblin databases and SQLAlchemy.

First off, read all of http://docs.sqlalchemy.org/en/latest/orm/tutorial.html – great tutorial.

Then, to use MediaGoblin database classes/tables from your python interpreter, you can start up <tt>bin/python2 -i</tt> (if you use Emacs, you can hand it <tt>/path/to/mediagoblin/bin/python2 -i</tt> when it asks which python to start) and begin with this boilerplate:
<pre>
from sqlalchemy import create_engine
engine = create_engine('sqlite:///:memory:', echo=True)
# Use an in-memory table, and have all SQL statements echoed back in
# the interpreter for debuggability

from mediagoblin.db.base import Session
Session.configure(bind=engine)
session=Session()

# Some of the tables need to have some entries in order for the rest
# to be usable:
from mediagoblin.db.models import FOUNDATIONS as MAIN_FOUNDATIONS
for Model,rows in MAIN_FOUNDATIONS.items():
for parameters in rows:
new_row = Model(**parameters)
session.add(new_row)

from mediagoblin.db.base import Base
from mediagoblin.db.models import * # User, MediaEntry, etc
Base.metadata.create_all(engine) # creates all tables
</pre>

Now try it out:
<pre>
session.query(User).all() # An empty list

goblinda=User(username='goblinda',email='gob@lin.da')
session.add(goblinda)
session.query(User).all() # Now has an entry =D
</pre>

SQLAlchemy Tips - Revision history

Unhammer: sql