sqlobject.tests.test_joins module

class sqlobject.tests.test_joins.AddressJoiner(**kw)[source]

Bases: sqlobject.main.SQLObject

addPersonJoiner(obj)
classmethod byZip(val, connection=None)
j = address_joiner
personJoiners
q = address_joiner
removePersonJoiner(obj)
class sqlmeta(instance)

Bases: sqlobject.main.sqlmeta

childName = None
columnDefinitions = {'zip': <StringCol b387252cL zip>}
columnList = [<SOStringCol zip alternate ID>]
columns = {'zip': <SOStringCol zip alternate ID>}
idName = 'id'
indexDefinitions = []
indexes = []
joinDefinitions = [<sqlobject.joins.RelatedJoin object>]
joins = [<sqlobject.joins.SORelatedJoin object>]
soClass

alias of AddressJoiner

style = <sqlobject.styles.MixedCaseUnderscoreStyle object>
table = 'address_joiner'
zip
class sqlobject.tests.test_joins.AddressJoiner2(**kw)[source]

Bases: sqlobject.main.SQLObject

j = address_joiner2
personJoiner2
personJoiner2ID
plus4
q = address_joiner2
class sqlmeta(instance)

Bases: sqlobject.main.sqlmeta

childName = None
columnDefinitions = {'personJoiner2ID': <ForeignKey b3dfe4acL personJoiner2>, 'plus4': <StringCol b3dfee4cL plus4>, 'zip': <StringCol b3dfedacL zip>}
columnList = [<SOStringCol zip>, <SOStringCol plus4 default=None>, <SOForeignKey personJoiner2ID connected to PersonJoiner2>]
columns = {'personJoiner2ID': <SOForeignKey personJoiner2ID connected to PersonJoiner2>, 'plus4': <SOStringCol plus4 default=None>, 'zip': <SOStringCol zip>}
defaultOrder = ['-zip', 'plus4']
idName = 'id'
indexDefinitions = []
indexes = []
joinDefinitions = []
joins = []
soClass

alias of AddressJoiner2

style = <sqlobject.styles.MixedCaseUnderscoreStyle object>
table = 'address_joiner2'
zip
class sqlobject.tests.test_joins.AddressJoiner3(**kw)[source]

Bases: sqlobject.main.SQLObject

j = address_joiner3
personJoiner3
personJoiner3ID
q = address_joiner3
class sqlmeta(instance)

Bases: sqlobject.main.sqlmeta

childName = None
columnDefinitions = {'personJoiner3ID': <ForeignKey b363b8ecL personJoiner3>, 'zip': <StringCol b42dceecL zip>}
columnList = [<SOStringCol zip>, <SOForeignKey personJoiner3ID connected to PersonJoiner3>]
columns = {'personJoiner3ID': <SOForeignKey personJoiner3ID connected to PersonJoiner3>, 'zip': <SOStringCol zip>}
idName = 'id'
indexDefinitions = []
indexes = []
joinDefinitions = []
joins = []
soClass

alias of AddressJoiner3

style = <sqlobject.styles.MixedCaseUnderscoreStyle object>
table = 'address_joiner3'
zip
class sqlobject.tests.test_joins.ExplicitJoiningSO(**kw)[source]

Bases: sqlobject.main.SQLObject

foo
j = explicit_joining_s_o
q = explicit_joining_s_o
class sqlmeta(instance)

Bases: sqlobject.main.sqlmeta

childName = None
columnDefinitions = {}
columnList = []
columns = {}
idName = 'id'
indexDefinitions = []
indexes = []
joinDefinitions = [<sqlobject.joins.MultipleJoin object>]
joins = [<sqlobject.joins.SOMultipleJoin object>]
soClass

alias of ExplicitJoiningSO

style = <sqlobject.styles.MixedCaseUnderscoreStyle object>
table = 'explicit_joining_s_o'
class sqlobject.tests.test_joins.ImplicitJoiningSO(**kw)[source]

Bases: sqlobject.main.SQLObject

addBar(obj)
foo
j = implicit_joining_s_o
q = implicit_joining_s_o
removeBar(obj)
class sqlmeta(instance)

Bases: sqlobject.main.sqlmeta

childName = None
columnDefinitions = {}
columnList = []
columns = {}
idName = 'id'
indexDefinitions = []
indexes = []
joinDefinitions = [<sqlobject.joins.RelatedJoin object>]
joins = [<sqlobject.joins.SORelatedJoin object>]
soClass

alias of ImplicitJoiningSO

style = <sqlobject.styles.MixedCaseUnderscoreStyle object>
table = 'implicit_joining_s_o'
class sqlobject.tests.test_joins.PersonJoiner(**kw)[source]

Bases: sqlobject.main.SQLObject

addAddressJoiner(obj)
addressJoiners
classmethod byName(val, connection=None)
j = person_joiner
name
q = person_joiner
removeAddressJoiner(obj)
class sqlmeta(instance)

Bases: sqlobject.main.sqlmeta

childName = None
columnDefinitions = {'name': <StringCol b42dc92cL name>}
columnList = [<SOStringCol name alternate ID>]
columns = {'name': <SOStringCol name alternate ID>}
idName = 'id'
indexDefinitions = []
indexes = []
joinDefinitions = [<sqlobject.joins.RelatedJoin object>]
joins = [<sqlobject.joins.SORelatedJoin object>]
soClass

alias of PersonJoiner

style = <sqlobject.styles.MixedCaseUnderscoreStyle object>
table = 'person_joiner'
class sqlobject.tests.test_joins.PersonJoiner2(**kw)[source]

Bases: sqlobject.main.SQLObject

addressJoiner2s
classmethod byName(val, connection=None)
j = person_joiner2
name
q = person_joiner2
class sqlmeta(instance)

Bases: sqlobject.main.sqlmeta

childName = None
columnDefinitions = {'name': <StringCol b4069d6cL name>}
columnList = [<SOStringCol name alternate ID>]
columns = {'name': <SOStringCol name alternate ID>}
idName = 'id'
indexDefinitions = []
indexes = []
joinDefinitions = [<sqlobject.joins.MultipleJoin object>]
joins = [<sqlobject.joins.SOMultipleJoin object>]
soClass

alias of PersonJoiner2

style = <sqlobject.styles.MixedCaseUnderscoreStyle object>
table = 'person_joiner2'
class sqlobject.tests.test_joins.PersonJoiner3(**kw)[source]

Bases: sqlobject.main.SQLObject

addressJoiner3s
classmethod byName(val, connection=None)
j = person_joiner3
name
q = person_joiner3
class sqlmeta(instance)

Bases: sqlobject.main.sqlmeta

childName = None
columnDefinitions = {'name': <StringCol b42ea96cL name>}
columnList = [<SOStringCol name alternate ID>]
columns = {'name': <SOStringCol name alternate ID>}
idName = 'id'
indexDefinitions = []
indexes = []
joinDefinitions = [<sqlobject.joins.MultipleJoin object>]
joins = [<sqlobject.joins.SOMultipleJoin object>]
soClass

alias of PersonJoiner3

style = <sqlobject.styles.MixedCaseUnderscoreStyle object>
table = 'person_joiner3'
class sqlobject.tests.test_joins.TestJoin[source]
assertNamesEqual(people, dest)[source]
assertZipsEqual(zips, dest)[source]
setup_method(meth)[source]
test_join()[source]
test_joinAttributeWithUnderscores()[source]
class sqlobject.tests.test_joins.TestJoin2[source]
setup_method(meth)[source]
test_basic()[source]
test_defaultOrder()[source]
class sqlobject.tests.test_joins.TestJoin3[source]
setup_method(meth)[source]
test_accessors()[source]