Source code for sqlobject.tests.test_sqlbuilder_importproxy

fromsqlobjectimport SQLObject, StringCol
fromsqlobject.sqlbuilderimport Alias, ImportProxy, tablesUsedSet
fromsqlobject.viewsimport ViewSQLObject

[docs]
deftestSimple():
 nyi = ImportProxy('NotYetImported')
 x = nyi.q.name
 classNotYetImported(SQLObject):
 name = StringCol(dbName='a_name')
 y = nyi.q.name
 assert str(x) == 'not_yet_imported.a_name'
 assert str(y) == 'not_yet_imported.a_name'

[docs]
deftestAddition():
 nyi = ImportProxy('NotYetImported2')
 x = nyi.q.name + nyi.q.name
 classNotYetImported2(SQLObject):
 name = StringCol(dbName='a_name')
 assert str(x) == \
 '((not_yet_imported2.a_name) + (not_yet_imported2.a_name))'

[docs]
deftestOnView():
 nyi = ImportProxy('NotYetImportedV')
 x = nyi.q.name
 classNotYetImported3(SQLObject):
 name = StringCol(dbName='a_name')
 classNotYetImportedV(ViewSQLObject):
 classsqlmeta:
 idName = NotYetImported3.q.id
 name = StringCol(dbName=NotYetImported3.q.name)
 assert str(x) == 'not_yet_imported_v.name'

[docs]
deftestAlias():
 nyi = ImportProxy('NotYetImported4')
 y = Alias(nyi, 'y')
 x = y.q.name
 classNotYetImported4(SQLObject):
 name = StringCol(dbName='a_name')
 assert str(y) == 'not_yet_imported4 y'
 assert tablesUsedSet(x, None) == set(['not_yet_imported4 y'])
 assert str(x) == 'y.a_name'