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 b3ab648cL id2>, 'name': <StringCol b3ab684cL 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'¶
-
-
classmethod
-
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 b579ee6cL cfk>, 'bfkID': <ForeignKey b579e20cL bfk>, 'name': <StringCol b41061ccL 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 b44254acL name>, 'afkID': <ForeignKey b566d84cL 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 b555098cL 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 b57643ccL key2>, 'key1ID': <ForeignKey b576412cL 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 b397dfecL title>, 'composerID': <ForeignKey b3bf7c4cL 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 b5764cecL 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
¶
-