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)

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

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

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

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

jdavcs

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

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

history,pairs,ui click,ui screen done,ui total,request 1,request 2,request total
old,10,860,969,109,52,18,70
old,10,779,884,105,55,17,72
old,10,720,821,101,52,18,70
old,10,670,781,111,51,18,69
old,10,671,769,98,39,14,53
old,10,870,971,101,55,12,67
old,10,563,665,102,38,17,55
old,10,649,729,80,37,11,48
old,10,311,397,86,42,19,61

jdavcs

 1 ==================================================================================
  2 TESTING: new db/sqlite, pre-conflict dev (current dev minus 3a29, caa7)
  3 ==================================================================================
  4 - manage_db.sh init
  5 
  6 - manage_db.sh version
  7     9540a051226e (gxy) (head)
  8     d4a650f47a3c (tsi) (head)
  9 - manage_db.sh dbversion
 10     9540a051226e (head)