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 b58ba4ccL id2>, 'name': <StringCol b58ba20cL 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 b580e82cL cfk>, 'bfkID': <ForeignKey b577d86cL bfk>, 'name': <StringCol b58258ccL 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 b3b64f4cL name>, 'afkID': <ForeignKey b581822cL 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 b586a06cL 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 b3c75bccL key2>, 'key1ID': <ForeignKey b4b1bc0cL 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 b58315ccL title>, 'composerID': <ForeignKey b5528fecL 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'
SOTestWorkKey.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 b3c7532cL 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'
SOTestWorkKey2.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]