sqlobject.tests.test_ForeignKey module

class sqlobject.tests.test_ForeignKey.SOTestComposerKey(**kw)[source]

Bases: sqlobject.main.SQLObject

classmethod byId2(val, connection=None)
property id2
j = so_test_composer_key
property name
q = so_test_composer_key
class sqlmeta(instance)

Bases: sqlobject.main.sqlmeta

childName = None
columnDefinitions = {'id2': <IntCol b4da52ac id2>, 'name': <StringCol b557af0c name>}
columnList = [<SOStringCol name>, <SOIntCol id2 default=None>]
columns = {'id2': <SOIntCol id2 default=None>, 'name': <SOStringCol name>}
idName = 'id'
indexDefinitions = []
indexes = []
joinDefinitions = []
joins = []
soClass

alias of sqlobject.tests.test_ForeignKey.SOTestComposerKey

style = <sqlobject.styles.MixedCaseUnderscoreStyle object>
table = 'so_test_composer_key'
class sqlobject.tests.test_ForeignKey.SOTestFKValidationA(**kw)[source]

Bases: sqlobject.main.SQLObject

property bfk
property bfkID
property cfk
property cfkID
j = so_test_fk_validation_a
property name
q = so_test_fk_validation_a
class sqlmeta(instance)

Bases: sqlobject.main.sqlmeta

childName = None
columnDefinitions = {'bfkID': <ForeignKey b4e723ec bfk>, 'cfkID': <ForeignKey b4e7236c cfk>, 'name': <StringCol b4e7240c name>}
columnList = [<SOStringCol name>, <SOForeignKey bfkID connected to SOTestFKValidationB>, <SOForeignKey cfkID default=None connected to SOTestFKValidationC>]
columns = {'bfkID': <SOForeignKey bfkID connected to SOTestFKValidationB>, 'cfkID': <SOForeignKey cfkID default=None connected to SOTestFKValidationC>, 'name': <SOStringCol name>}
idName = 'id'
indexDefinitions = []
indexes = []
joinDefinitions = []
joins = []
soClass

alias of sqlobject.tests.test_ForeignKey.SOTestFKValidationA

style = <sqlobject.styles.MixedCaseUnderscoreStyle object>
table = 'so_test_fk_validation_a'
class sqlobject.tests.test_ForeignKey.SOTestFKValidationB(**kw)[source]

Bases: sqlobject.main.SQLObject

property afk
property afkID
j = so_test_fk_validation_b
property name
q = so_test_fk_validation_b
class sqlmeta(instance)

Bases: sqlobject.main.sqlmeta

childName = None
columnDefinitions = {'afkID': <ForeignKey b4e72a8c afk>, 'name': <StringCol b4e72c4c name>}
columnList = [<SOStringCol name>, <SOForeignKey afkID connected to SOTestFKValidationA>]
columns = {'afkID': <SOForeignKey afkID connected to SOTestFKValidationA>, 'name': <SOStringCol name>}
idName = 'id'
indexDefinitions = []
indexes = []
joinDefinitions = []
joins = []
soClass

alias of sqlobject.tests.test_ForeignKey.SOTestFKValidationB

style = <sqlobject.styles.MixedCaseUnderscoreStyle object>
table = 'so_test_fk_validation_b'
class sqlobject.tests.test_ForeignKey.SOTestFKValidationC(**kw)[source]

Bases: sqlobject.main.SQLObject

j = so_test_fk_validation_c
property name
q = so_test_fk_validation_c
class sqlmeta(instance)

Bases: sqlobject.main.sqlmeta

childName = None
columnDefinitions = {'name': <StringCol b54cb8ec name>}
columnList = [<SOStringCol name>]
columns = {'name': <SOStringCol name>}
idName = 'id'
idType

alias of builtins.str

indexDefinitions = []
indexes = []
joinDefinitions = []
joins = []
soClass

alias of sqlobject.tests.test_ForeignKey.SOTestFKValidationC

style = <sqlobject.styles.MixedCaseUnderscoreStyle object>
table = 'so_test_fk_validation_c'
class sqlobject.tests.test_ForeignKey.SOTestOtherColumn(**kw)[source]

Bases: sqlobject.main.SQLObject

j = so_test_other_column
property key1
property key1ID
property key2
property key2ID
q = so_test_other_column
class sqlmeta(instance)

Bases: sqlobject.main.sqlmeta

childName = None
columnDefinitions = {'key1ID': <ForeignKey b5579a2c key1>, 'key2ID': <ForeignKey b5579b2c key2>}
columnList = [<SOForeignKey key1ID default=None connected to SOTestComposerKey>, <SOForeignKey key2ID default=None connected to SOTestComposerKey>]
columns = {'key1ID': <SOForeignKey key1ID default=None connected to SOTestComposerKey>, 'key2ID': <SOForeignKey key2ID default=None connected to SOTestComposerKey>}
idName = 'id'
indexDefinitions = []
indexes = []
joinDefinitions = []
joins = []
soClass

alias of sqlobject.tests.test_ForeignKey.SOTestOtherColumn

style = <sqlobject.styles.MixedCaseUnderscoreStyle object>
table = 'so_test_other_column'
class sqlobject.tests.test_ForeignKey.SOTestWorkKey(**kw)[source]

Bases: sqlobject.main.SQLObject

property composer
property composerID
j = so_test_work_key
q = so_test_work_key
class sqlmeta(instance)

Bases: sqlobject.main.sqlmeta

childName = None
columnDefinitions = {'composerID': <ForeignKey b4de8ecc composer>, 'title': <StringCol b4de898c title>}
columnList = [<SOForeignKey composerID connected to SOTestComposerKey>, <SOStringCol title>]
columns = {'composerID': <SOForeignKey composerID connected to SOTestComposerKey>, 'title': <SOStringCol title>}
idName = 'work_id'
indexDefinitions = []
indexes = []
joinDefinitions = []
joins = []
soClass

alias of sqlobject.tests.test_ForeignKey.SOTestWorkKey

style = <sqlobject.styles.MixedCaseUnderscoreStyle object>
table = 'so_test_work_key'
property title
class sqlobject.tests.test_ForeignKey.SOTestWorkKey2(**kw)[source]

Bases: sqlobject.main.SQLObject

j = so_test_work_key2
q = so_test_work_key2
class sqlmeta(instance)

Bases: sqlobject.main.sqlmeta

childName = None
columnDefinitions = {'title': <StringCol b557938c title>}
columnList = [<SOStringCol title>]
columns = {'title': <SOStringCol title>}
idName = 'id'
indexDefinitions = []
indexes = []
joinDefinitions = []
joins = []
soClass

alias of sqlobject.tests.test_ForeignKey.SOTestWorkKey2

style = <sqlobject.styles.MixedCaseUnderscoreStyle object>
table = 'so_test_work_key2'
property title
sqlobject.tests.test_ForeignKey.test1()[source]
sqlobject.tests.test_ForeignKey.test2()[source]
sqlobject.tests.test_ForeignKey.test_foreignkey_validation()[source]
sqlobject.tests.test_ForeignKey.test_otherColumn()[source]