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 b43907ec id2>, 'name': <StringCol b43906cc 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 = {'bfkID': <ForeignKey b439744c bfk>, 'cfkID': <ForeignKey b439752c cfk>, 'name': <StringCol b439746c 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 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 b439764c name>, 'afkID': <ForeignKey b4397c8c 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 b439c3ac 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 b4394e2c key2>, 'key1ID': <ForeignKey b4394e0c 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 = {'composerID': <ForeignKey b439452c composer>, 'title': <StringCol b439454c 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 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 b4394a4c 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]