sqlobject.tests.test_ForeignKey module

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

Bases: sqlobject.main.SQLObject

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

Bases: sqlobject.main.sqlmeta

childName = None
columnDefinitions = {'id2': <IntCol b3959e0cL id2>, 'name': <StringCol b3959dccL 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 SOTestComposerKey

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

Bases: sqlobject.main.SQLObject

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

Bases: sqlobject.main.sqlmeta

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

alias of SOTestFKValidationA

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

Bases: sqlobject.main.SQLObject

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

Bases: sqlobject.main.sqlmeta

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

alias of 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
name
q = so_test_fk_validation_c
class sqlmeta(instance)

Bases: sqlobject.main.sqlmeta

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

alias of str

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

alias of 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
key1
key1ID
key2
key2ID
q = so_test_other_column
class sqlmeta(instance)

Bases: sqlobject.main.sqlmeta

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

alias of SOTestOtherColumn

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

Bases: sqlobject.main.SQLObject

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

Bases: sqlobject.main.sqlmeta

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

alias of SOTestWorkKey

style = <sqlobject.styles.MixedCaseUnderscoreStyle object>
table = 'so_test_work_key'
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 b3958fccL title>}
columnList = [<SOStringCol title>]
columns = {'title': <SOStringCol title>}
idName = 'id'
indexDefinitions = []
indexes = []
joinDefinitions = []
joins = []
soClass

alias of SOTestWorkKey2

style = <sqlobject.styles.MixedCaseUnderscoreStyle object>
table = 'so_test_work_key2'
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]