def setUp(self):
from sqlalchemy.ext.declarative import declarative_base
Base = declarative_base(metadata=sa.MetaData('sqlite:///:memory:'))
Base.query = tws.transactional_session().query_property()
class DBTestCls1(Base):
__tablename__ = 'Test'
id = sa.Column(sa.Integer, primary_key=True)
name = sa.Column(sa.String(50))
class DBTestCls2(Base):
__tablename__ = 'Test2'
id = sa.Column(sa.String, primary_key=True)
class DBTestCls3(Base):
__tablename__ = 'Test3'
id1 = sa.Column(sa.Integer, primary_key=True)
id2 = sa.Column(sa.Integer, primary_key=True)
self.DBTestCls1 = DBTestCls1
self.DBTestCls2 = DBTestCls2
self.DBTestCls3 = DBTestCls3
Base.metadata.create_all()
session = sa.orm.sessionmaker()()
self.session = session
session.add(self.DBTestCls1(id=1))
session.add(self.DBTestCls2(id='bob'))
session.commit()
testapi.setup()
def setUp(self):
import elixir as el
self.session = el.session = tws.transactional_session()
el.metadata = sa.MetaData('sqlite:///:memory:')
class DBTestCls1(el.Entity):
name = el.Field(el.String)
some_number = el.Field(el.Integer, default=2)
class DBTestCls2(el.Entity):
nick = el.Field(el.String)
other_id = el.Field(el.Integer, colname='other')
other = el.ManyToOne(DBTestCls1,
field=other_id,
backref='others')
self.DBTestCls1 = DBTestCls1
self.DBTestCls2 = DBTestCls2
el.setup_all()
el.metadata.create_all()
foo = self.DBTestCls1(id=1, name='foo')
bob = self.DBTestCls2(id=1, nick='bob', other=foo)
george = self.DBTestCls2(id=2, nick='george')
testapi.setup()
def setUp(self):
from sqlalchemy.ext.declarative import declarative_base
Base = declarative_base(metadata=sa.MetaData('sqlite:///:memory:'))
Base.query = tws.transactional_session().query_property()
class DBTestCls1(Base):
__tablename__ = 'Test'
id = sa.Column(sa.Integer, primary_key=True)
name = sa.Column(sa.String(50))
class DBTestCls2(Base):
__tablename__ = 'Test2'
id = sa.Column(sa.String, primary_key=True)
class DBTestCls3(Base):
__tablename__ = 'Test3'
id1 = sa.Column(sa.Integer, primary_key=True)
id2 = sa.Column(sa.Integer, primary_key=True)
self.DBTestCls1 = DBTestCls1
self.DBTestCls2 = DBTestCls2
self.DBTestCls3 = DBTestCls3
Base.metadata.create_all()
session = sa.orm.sessionmaker()()
self.session = session
session.add(self.DBTestCls1(id=1))
session.add(self.DBTestCls2(id='bob'))
session.commit()
testapi.setup()
def setUp(self):
from sqlalchemy.ext.declarative import declarative_base
self.session = tws.transactional_session()
Base = declarative_base(metadata=sa.MetaData('sqlite:///:memory:'))
Base.query = self.session.query_property()
class DBTestCls1(Base):
__tablename__ = 'Test'
id = sa.Column(sa.Integer, primary_key=True)
name = sa.Column(sa.String(50))
class DBTestCls2(Base):
__tablename__ = 'Test2'
id = sa.Column(sa.Integer, primary_key=True)
nick = sa.Column(sa.String)
other_id = sa.Column(sa.Integer, sa.ForeignKey('Test.id'))
other = sa.orm.relation(DBTestCls1, backref=sa.orm.backref('others'))
Base.metadata.create_all()
self.DBTestCls1 = DBTestCls1
self.DBTestCls2 = DBTestCls2
foo = self.DBTestCls1(id=1, name='foo')
self.session.add(foo)
bob = self.DBTestCls2(id=1, nick='bob')
bob.other = foo
self.session.add(bob)
george = self.DBTestCls2(id=2, nick='george')
self.session.add(george)
transaction.commit()
testapi.setup()
def setUp(self):
self.session = el.session = tws.transactional_session()
el.metadata = sa.MetaData('sqlite:///:memory:')
class DBTestCls1(el.Entity):
name = el.Field(el.String)
some_number = el.Field(el.Integer, default=2)
class DBTestCls2(el.Entity):
nick = el.Field(el.String)
other_id = el.Field(el.Integer, colname='other')
other = el.ManyToOne(DBTestCls1, field=other_id, backref='others')
class DBTestCls3(el.Entity):
surname = el.Field(el.String)
roles = el.ManyToMany('DBTestCls4')
class DBTestCls4(el.Entity):
rolename = el.Field(el.String)
users = el.ManyToMany('DBTestCls3')
class DBTestCls5(el.Entity):
account_name = el.Field(el.String, required=True)
user = el.OneToOne('DBTestCls6', inverse='account')
class DBTestCls6(el.Entity):
name = el.Field(el.String)
account_id = el.Field(el.Integer, required=False)
account = el.ManyToOne(DBTestCls5,
field=account_id,
inverse='user',
uselist=False)
self.DBTestCls1 = DBTestCls1
self.DBTestCls2 = DBTestCls2
self.DBTestCls3 = DBTestCls3
self.DBTestCls4 = DBTestCls4
self.DBTestCls5 = DBTestCls5
self.DBTestCls6 = DBTestCls6
el.setup_all()
el.metadata.create_all()
foo = self.DBTestCls1(id=1, name='foo')
bob = self.DBTestCls2(id=1, nick='bob', other=foo)
george = self.DBTestCls2(id=2, nick='george')
fred = self.DBTestCls3(id=1, surname='fred')
admin = self.DBTestCls4(id=1, rolename='admin')
fred.roles.append(admin)
account1 = self.DbTestCls5(id=1, account_name='account1')
bob1 = self.DbTestCls6(id=1, name='bob1', account_id=1)
testapi.setup()
self.admin_role = admin
def setUp(self):
self.session = el.session = tws.transactional_session()
el.metadata = sa.MetaData('sqlite:///:memory:')
class DBTestCls1(el.Entity):
name = el.Field(el.String)
some_number = el.Field(el.Integer, default=2)
class DBTestCls2(el.Entity):
nick = el.Field(el.String)
other_id = el.Field(el.Integer, colname='other')
other = el.ManyToOne(DBTestCls1,
field=other_id,
backref='others')
class DBTestCls3(el.Entity):
surname = el.Field(el.String)
roles = el.ManyToMany('DBTestCls4')
class DBTestCls4(el.Entity):
rolename = el.Field(el.String)
users = el.ManyToMany('DBTestCls3')
class DBTestCls5(el.Entity):
account_name = el.Field(el.String, required=True)
user = el.OneToOne('DBTestCls6', inverse='account')
class DBTestCls6(el.Entity):
name = el.Field(el.String)
account_id = el.Field(el.Integer, required=False)
account = el.ManyToOne(DBTestCls5, field=account_id, inverse='user', uselist=False)
self.DBTestCls1 = DBTestCls1
self.DBTestCls2 = DBTestCls2
self.DBTestCls3 = DBTestCls3
self.DBTestCls4 = DBTestCls4
self.DBTestCls5 = DBTestCls5
self.DBTestCls6 = DBTestCls6
el.setup_all()
el.metadata.create_all()
foo = self.DBTestCls1(id=1, name='foo')
bob = self.DBTestCls2(id=1, nick='bob', other=foo)
george = self.DBTestCls2(id=2, nick='george')
fred = self.DBTestCls3(id=1, surname='fred')
admin = self.DBTestCls4(id=1, rolename='admin')
fred.roles.append(admin)
account1 = self.DbTestCls5(id=1, account_name='account1')
bob1 = self.DbTestCls6(id=1, name='bob1', account_id=1)
testapi.setup()
self.admin_role = admin
def setUp(self):
from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy.orm import mapper
from sqlalchemy.sql import join
from sqlalchemy import Table, Column, Integer, String, ForeignKey
self.session = tws.transactional_session()
Base = declarative_base(metadata=sa.MetaData('sqlite:///:memory:'))
Base.query = self.session.query_property()
users_table = Table(
'users',
Base.metadata,
Column('user_id', Integer, primary_key=True),
Column('name', String(40)),
)
addresses_table = Table(
'addresses',
Base.metadata,
Column('address_id', Integer, primary_key=True),
Column('user_id', Integer, ForeignKey('users.user_id')),
Column('place', String(40)),
)
class DBTestCls1(object):
pass
j = join(users_table, addresses_table)
mapper(DBTestCls1,
j,
properties={
'user_id':
[users_table.c.user_id, addresses_table.c.user_id]
})
Base.metadata.create_all()
self.DBTestCls1 = DBTestCls1
transaction.commit()
testapi.setup()
def setup(self):
self.session = tws.transactional_session()
Base = declarative_base(metadata=sa.MetaData('sqlite:///:memory:'))
Base.query = self.session.query_property()
class DbTestCls1(Base):
__tablename__ = 'Test'
id = sa.Column(sa.Integer, primary_key=True)
name = sa.Column(sa.String(50))
def __unicode__(self):
return self.name
class DbTestCls2(Base):
__tablename__ = 'Test2'
id = sa.Column(sa.Integer, primary_key=True)
nick = sa.Column(sa.String(50))
other_id = sa.Column(sa.Integer, sa.ForeignKey('Test.id'))
other = sa.orm.relation(DbTestCls1, backref=sa.orm.backref('others'))
def __unicode__(self):
return self.nick
class DbTestCls3(Base):
__tablename__ = 'Test3'
id1 = sa.Column(sa.Integer, primary_key=True)
id2 = sa.Column(sa.Integer, primary_key=True)
self.DbTestCls1 = DbTestCls1
self.DbTestCls2 = DbTestCls2
self.DbTestCls3 = DbTestCls3
Base.metadata.create_all()
foo1 = self.DbTestCls1(id=1, name='foo1')
self.session.add(foo1)
self.session.add(self.DbTestCls1(id=2, name='foo2'))
self.session.add(self.DbTestCls2(id=1, nick='bob1'))
self.session.add(self.DbTestCls2(id=2, nick='bob2'))
bob3 = self.DbTestCls2(id=3, nick='bob3')
foo1.others.append(bob3)
self.session.add(bob3)
assert(self.DbTestCls1.query.first().others[0] == bob3)
transaction.commit()
return super(SQLABase, self).setup()
def setUp(self):
from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy.orm import mapper
from sqlalchemy.sql import join
from sqlalchemy import Table, Column, Integer, String, ForeignKey
self.session = tws.transactional_session()
Base = declarative_base(metadata=sa.MetaData('sqlite:///:memory:'))
Base.query = self.session.query_property()
users_table = Table('users', Base.metadata,
Column('user_id', Integer, primary_key=True),
Column('name', String(40)),
)
addresses_table = Table('addresses', Base.metadata,
Column('address_id', Integer, primary_key=True),
Column('user_id', Integer, ForeignKey('users.user_id')),
Column('place', String(40)),
)
class DBTestCls1(object):
pass
j = join(users_table, addresses_table)
mapper(DBTestCls1, j, properties={
'user_id': [users_table.c.user_id, addresses_table.c.user_id]
})
Base.metadata.create_all()
self.DBTestCls1 = DBTestCls1
transaction.commit()
testapi.setup()
def setup(self):
el.metadata = sa.MetaData('sqlite:///:memory:')
el.session = tws.transactional_session()
class DbTestCls1(el.Entity):
name = el.Field(el.String)
def __unicode__(self):
return self.name
class DbTestCls2(el.Entity):
nick = el.Field(el.String)
other_id = el.Field(el.Integer)
other = el.ManyToOne(DbTestCls1, field=other_id, backref='others')
def __unicode__(self):
return self.nick
class DbTestCls3(el.Entity):
id1 = el.Field(el.Integer, primary_key=True)
id2 = el.Field(el.Integer, primary_key=True)
self.DbTestCls1 = DbTestCls1
self.DbTestCls2 = DbTestCls2
self.DbTestCls3 = DbTestCls3
el.setup_all()
el.metadata.create_all()
foo1 = self.DbTestCls1(id=1, name='foo1')
self.DbTestCls1(id=2, name='foo2')
self.DbTestCls2(id=1, nick='bob1')
self.DbTestCls2(id=2, nick='bob2')
bob3 = self.DbTestCls2(id=3, nick='bob3')
foo1.others.append(bob3)
assert(self.DbTestCls1.query.first().others[0] == bob3)
transaction.commit()
return super(ElixirBase, self).setup()
Unicode,
DateTime,
MetaData,
Table,
ForeignKey,
)
from sqlalchemy.orm import relation, backref
from sqlalchemy.ext.declarative import declarative_base
import tw2.sqla as tws
import random
from random import randint
from datetime import datetime, timedelta
session = tws.transactional_session()
Base = declarative_base(metadata=MetaData('sqlite:///%s.db' % __name__))
Base.query = session.query_property()
friends_mapping = Table(
'persons_friends_mapping', Base.metadata,
Column('friender_id', Integer, ForeignKey('persons.id'), primary_key=True),
Column('friendee_id', Integer, ForeignKey('persons.id'), primary_key=True))
class Person(Base):
__tablename__ = 'persons'
id = Column(Integer, primary_key=True)
first_name = Column(Unicode(255), nullable=False)
last_name = Column(Unicode(255), nullable=False)
some_attribute = Column(Unicode(255), nullable=False)
"""
from tw2.core.resources import JSSymbol
from tw2.jit.widgets import SQLARadialGraph
import transaction
from sqlalchemy import (
Column, Integer, Unicode,
MetaData, Table, ForeignKey,
)
from sqlalchemy.orm import relation, backref
from sqlalchemy.ext.declarative import declarative_base
import tw2.sqla as tws
session = tws.transactional_session()
Base = declarative_base(metadata=MetaData('sqlite:///%s.db' % __name__))
Base.query = session.query_property()
friends_mapping = Table(
'persons_friends_mapping', Base.metadata,
Column('friender_id', Integer,
ForeignKey('persons.id'), primary_key=True),
Column('friendee_id', Integer,
ForeignKey('persons.id'), primary_key=True))
class Person(Base):
__tablename__ = 'persons'
id = Column(Integer, primary_key=True)
first_name = Column(Unicode(255), nullable=False)
last_name = Column(Unicode(255), nullable=False)
def setUp(self):
from sqlalchemy.ext.declarative import declarative_base
self.session = tws.transactional_session()
Base = declarative_base(metadata=sa.MetaData('sqlite:///:memory:'))
Base.query = self.session.query_property()
class DBTestCls1(Base):
__tablename__ = 'Test'
id = sa.Column(sa.Integer, primary_key=True)
name = sa.Column(sa.String(50))
some_number = sa.Column(sa.Integer, default=2)
class DBTestCls2(Base):
__tablename__ = 'Test2'
id = sa.Column(sa.Integer, primary_key=True)
nick = sa.Column(sa.String)
other_id = sa.Column(sa.Integer, sa.ForeignKey('Test.id'))
other = sa.orm.relation(DBTestCls1,
backref=sa.orm.backref('others'))
join_table = sa.Table('Test3_Test4', Base.metadata,
sa.Column('Test3', sa.Integer, sa.ForeignKey('Test3.id'), primary_key=True),
sa.Column('Test4', sa.Integer, sa.ForeignKey('Test4.id'), primary_key=True)
)
class DBTestCls3(Base):
__tablename__ = 'Test3'
id = sa.Column(sa.Integer, primary_key=True)
surname = sa.Column(sa.String(50))
def __unicode__(self):
return self.surname
class DBTestCls4(Base):
__tablename__ = 'Test4'
id = sa.Column(sa.Integer, primary_key=True)
rolename = sa.Column(sa.String(50))
users = sa.orm.relationship('DBTestCls3', secondary=join_table, backref='roles')
def __unicode__(self):
return self.rolename
class DBTestCls5(Base):
__tablename__ = 'Test5'
id = sa.Column(sa.Integer, primary_key=True)
account_name = sa.Column(sa.String(50), nullable=False)
class DBTestCls6(Base):
__tablename__ = 'Test6'
id = sa.Column(sa.Integer, primary_key=True)
name = sa.Column(sa.String(50))
account_id = sa.Column(sa.Integer, sa.ForeignKey('Test5.id'), nullable=True)
account = sa.orm.relation(DBTestCls5, backref=sa.orm.backref('user', uselist=False))
Base.metadata.create_all()
self.DBTestCls1 = DBTestCls1
self.DBTestCls2 = DBTestCls2
self.DBTestCls3 = DBTestCls3
self.DBTestCls4 = DBTestCls4
self.DBTestCls5 = DBTestCls5
self.DBTestCls6 = DBTestCls6
foo = self.DBTestCls1(id=1, name='foo')
self.session.add(foo)
bob = self.DBTestCls2(id=1, nick='bob')
bob.other = foo
self.session.add(bob)
george = self.DBTestCls2(id=2, nick='george')
self.session.add(george)
fred = self.DBTestCls3(id=1, surname='fred')
admin = self.DBTestCls4(id=1, rolename='admin')
fred.roles.append(admin)
self.session.add(fred)
self.admin_role = admin
account1 = self.DBTestCls5(id=1, account_name='account1')
self.session.add(account1)
bob1 = self.DBTestCls6(id=1, name='bob1', account_id=1)
self.session.add(bob1)
transaction.commit()
testapi.setup()
def setUp(self):
from sqlalchemy.ext.declarative import declarative_base
self.session = tws.transactional_session()
Base = declarative_base(metadata=sa.MetaData('sqlite:///:memory:'))
Base.query = self.session.query_property()
class DBTestCls1(Base):
__tablename__ = 'Test'
id = sa.Column(sa.Integer, primary_key=True)
name = sa.Column(sa.String(50))
some_number = sa.Column(sa.Integer, default=2)
class DBTestCls2(Base):
__tablename__ = 'Test2'
id = sa.Column(sa.Integer, primary_key=True)
nick = sa.Column(sa.String)
other_id = sa.Column(sa.Integer, sa.ForeignKey('Test.id'))
other = sa.orm.relation(DBTestCls1,
backref=sa.orm.backref('others'))
join_table = sa.Table(
'Test3_Test4', Base.metadata,
sa.Column('Test3',
sa.Integer,
sa.ForeignKey('Test3.id'),
primary_key=True),
sa.Column('Test4',
sa.Integer,
sa.ForeignKey('Test4.id'),
primary_key=True))
class DBTestCls3(Base):
__tablename__ = 'Test3'
id = sa.Column(sa.Integer, primary_key=True)
surname = sa.Column(sa.String(50))
def __unicode__(self):
return self.surname
class DBTestCls4(Base):
__tablename__ = 'Test4'
id = sa.Column(sa.Integer, primary_key=True)
rolename = sa.Column(sa.String(50))
users = sa.orm.relationship('DBTestCls3',
secondary=join_table,
backref='roles')
def __unicode__(self):
return self.rolename
class DBTestCls5(Base):
__tablename__ = 'Test5'
id = sa.Column(sa.Integer, primary_key=True)
account_name = sa.Column(sa.String(50), nullable=False)
class DBTestCls6(Base):
__tablename__ = 'Test6'
id = sa.Column(sa.Integer, primary_key=True)
name = sa.Column(sa.String(50))
account_id = sa.Column(sa.Integer,
sa.ForeignKey('Test5.id'),
nullable=True)
account = sa.orm.relation(DBTestCls5,
backref=sa.orm.backref('user',
uselist=False))
Base.metadata.create_all()
self.DBTestCls1 = DBTestCls1
self.DBTestCls2 = DBTestCls2
self.DBTestCls3 = DBTestCls3
self.DBTestCls4 = DBTestCls4
self.DBTestCls5 = DBTestCls5
self.DBTestCls6 = DBTestCls6
foo = self.DBTestCls1(id=1, name='foo')
self.session.add(foo)
bob = self.DBTestCls2(id=1, nick='bob')
bob.other = foo
self.session.add(bob)
george = self.DBTestCls2(id=2, nick='george')
self.session.add(george)
fred = self.DBTestCls3(id=1, surname='fred')
admin = self.DBTestCls4(id=1, rolename='admin')
fred.roles.append(admin)
self.session.add(fred)
self.admin_role = admin
account1 = self.DBTestCls5(id=1, account_name='account1')
self.session.add(account1)
bob1 = self.DBTestCls6(id=1, name='bob1', account_id=1)
self.session.add(bob1)
transaction.commit()
testapi.setup()
