jdavcs

PRE-FLUSH:

(Pdb) pp items
<galaxy.model.MetadataFile(None) at 0x7fb433652b20>,
<galaxy.model.Job(1) at 0x7fb4336496a0>,
<galaxy.model.User(1) at 0x7fb4336432e0>,
<galaxy.model.JobToOutputDatasetAssociation(1) at 0x7fb4336a5cd0>,
<galaxy.model.HistoryDatasetAssociation(1) at 0x7fb4336a5880>,
<galaxy.model.Dataset(1) at 0x7fb4336a5d00>

jdavcs

from sqlalchemy import (
    create_engine,
    inspect,
    Column,
    ForeignKey,
    Integer,
    MetaData,
    String,
    Table,
)

jdavcs

from sqlalchemy import (
    create_engine,
    inspect,
    Column,
    ForeignKey,
    Integer
)
from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy.orm import (
    defer,

jdavcs

Using virtualenv: /home/sergey/0dev/galaxy/_galaxy/dev-deps-nosqlalchemyutils/.venv
Updating dependencies
Resolving dependencies...
   1: fact: galaxy is 21.01
   1: derived: galaxy
   1: fact: galaxy depends on aiofiles (*)
   1: fact: galaxy depends on async-generator (*)
   1: fact: galaxy depends on async-exit-stack (*)
   1: fact: galaxy depends on Babel (*)
   1: fact: galaxy depends on bdbag (*)

jdavcs

import os
import sys

sys.path.insert(1, os.path.abspath(os.path.join(os.path.dirname(__file__), os.pardir, 'lib')))

from sqlalchemy import create_engine, MetaData

from galaxy.model import mapping
from galaxy.model.orm.scripts import get_config

jdavcs

def test_indexes(self):
    
    from sqlalchemy import create_engine, MetaData
    from galaxy.model import mapping

    # metadata loaded from mapping.py
    md1 = mapping.metadata
    ix1 = set()
    for t in md1.tables.values():
        ix1 |= t.indexes  # mapping only: 422

jdavcs

from scripts.db_shell import *


def create_jobs_with_datasets(n, datasets_per_job):
    jobs = []
    for i in range(n):
        job = Job()
        jobs.append(job)
        for j in range(datasets_per_job):
            ds = Dataset(state=Dataset.states.NEW)