Warning

This document is for an old release of Galaxy. You can alternatively view this page in the latest release if it exists or view the top of the latest release's documentation.

galaxy.model.orm package

galaxy.model.orm - ORM-related functionality

Submodules

galaxy.model.orm.engine_factory module

galaxy.model.orm.engine_factory.build_engine(url, engine_options, database_query_profiling_proxy=False, trace_logger=None, slow_query_log_threshold=0)[source]

galaxy.model.orm.logging_connection_proxy module

galaxy.model.orm.logging_connection_proxy.stripwd(s)[source]
galaxy.model.orm.logging_connection_proxy.pretty_stack()[source]
class galaxy.model.orm.logging_connection_proxy.LoggingProxy[source]

Bases: sqlalchemy.interfaces.ConnectionProxy

Logs SQL statements using standard logging module

begin(conn, begin)[source]
commit(conn, commit)[source]
rollback(conn, rollback)[source]
cursor_execute(execute, cursor, statement, parameters, context, executemany)[source]
class galaxy.model.orm.logging_connection_proxy.TraceLoggerProxy(trace_logger)[source]

Bases: sqlalchemy.interfaces.ConnectionProxy

Logs SQL statements using a metlog client

__init__(trace_logger)[source]
cursor_execute(execute, cursor, statement, parameters, context, executemany)[source]

galaxy.model.orm.now module

galaxy.model.orm.now.now()

Return a new datetime representing UTC day and time.

galaxy.model.orm.scripts module

Code to support database helper scripts (create_db.py, manage_db.py, etc…).

galaxy.model.orm.scripts.get_config(argv, use_argparse=True, cwd=None)[source]

Read sys.argv and parse out repository of migrations and database url.

>>> import os
>>> from ConfigParser import SafeConfigParser
>>> from shutil import rmtree
>>> from tempfile import mkdtemp
>>> config_dir = mkdtemp()
>>> os.makedirs(os.path.join(config_dir, 'config'))
>>> def write_ini(path, property, value):
...     p = SafeConfigParser()
...     p.add_section('app:main')
...     p.set('app:main', property, value)
...     with open(os.path.join(config_dir, 'config', path), 'w') as f: p.write(f)
>>> write_ini('tool_shed.ini', 'database_connection', 'sqlite:///pg/testdb1')
>>> config = get_config(['manage_db.py', 'tool_shed'], cwd=config_dir)
>>> config['repo']
'lib/galaxy/webapps/tool_shed/model/migrate'
>>> config['db_url']
'sqlite:///pg/testdb1'
>>> write_ini('galaxy.ini', 'database_file', 'moo.sqlite')
>>> config = get_config(['manage_db.py'], cwd=config_dir)
>>> config['db_url']
'sqlite:///moo.sqlite?isolation_level=IMMEDIATE'
>>> config['repo']
'lib/galaxy/model/migrate'
>>> rmtree(config_dir)