sqlobject.tests.test_new_joins module

class sqlobject.tests.test_new_joins.AddressJNew(**kw)[source]

Bases: sqlobject.main.SQLObject

classmethod byZip(val, connection=None)
j = address_j_new
personJs
q = address_j_new
class sqlmeta(instance)

Bases: sqlobject.main.sqlmeta

childName = None
columnDefinitions = {'zip': <StringCol b405b98c zip>}
columnList = [<SOStringCol zip alternate ID>]
columns = {'zip': <SOStringCol zip alternate ID>}
idName = 'id'
indexDefinitions = []
indexes = []
joinDefinitions = []
joins = []
soClass

alias of AddressJNew

style = <sqlobject.styles.MixedCaseUnderscoreStyle object>
table = 'address_j_new'
zip
class sqlobject.tests.test_new_joins.AddressJNew2(**kw)[source]

Bases: sqlobject.main.SQLObject

j = address_j_new2
personJNew2
personJNew2ID
plus4
q = address_j_new2
class sqlmeta(instance)

Bases: sqlobject.main.sqlmeta

childName = None
columnDefinitions = {'personJNew2ID': <ForeignKey b40eda8c personJNew2>, 'plus4': <StringCol b40ed84c plus4>, 'zip': <StringCol b40edb2c zip>}
columnList = [<SOStringCol zip>, <SOStringCol plus4 default=None>, <SOForeignKey personJNew2ID connected to PersonJNew2>]
columns = {'personJNew2ID': <SOForeignKey personJNew2ID connected to PersonJNew2>, 'plus4': <SOStringCol plus4 default=None>, 'zip': <SOStringCol zip>}
defaultOrder = ['-zip', 'plus4']
idName = 'id'
indexDefinitions = []
indexes = []
joinDefinitions = []
joins = []
soClass

alias of AddressJNew2

style = <sqlobject.styles.MixedCaseUnderscoreStyle object>
table = 'address_j_new2'
zip
class sqlobject.tests.test_new_joins.AddressJNew3(**kw)[source]

Bases: sqlobject.main.SQLObject

j = address_j_new3
personJNew3
personJNew3ID
q = address_j_new3
class sqlmeta(instance)

Bases: sqlobject.main.sqlmeta

childName = None
columnDefinitions = {'zip': <StringCol b41f450c zip>, 'personJNew3ID': <ForeignKey b41f44cc personJNew3>}
columnList = [<SOStringCol zip>, <SOForeignKey personJNew3ID connected to PersonJNew3>]
columns = {'zip': <SOStringCol zip>, 'personJNew3ID': <SOForeignKey personJNew3ID connected to PersonJNew3>}
idName = 'id'
indexDefinitions = []
indexes = []
joinDefinitions = []
joins = []
soClass

alias of AddressJNew3

style = <sqlobject.styles.MixedCaseUnderscoreStyle object>
table = 'address_j_new3'
zip
class sqlobject.tests.test_new_joins.ExplicitJoiningSONew(**kw)[source]

Bases: sqlobject.main.SQLObject

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

Bases: sqlobject.main.sqlmeta

childName = None
columnDefinitions = {}
columnList = []
columns = {}
idName = 'id'
indexDefinitions = []
indexes = []
joinDefinitions = []
joins = []
soClass

alias of ExplicitJoiningSONew

style = <sqlobject.styles.MixedCaseUnderscoreStyle object>
table = 'explicit_joining_so_new'
class sqlobject.tests.test_new_joins.ImplicitJoiningSONew(**kw)[source]

Bases: sqlobject.main.SQLObject

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

Bases: sqlobject.main.sqlmeta

childName = None
columnDefinitions = {}
columnList = []
columns = {}
idName = 'id'
indexDefinitions = []
indexes = []
joinDefinitions = []
joins = []
soClass

alias of ImplicitJoiningSONew

style = <sqlobject.styles.MixedCaseUnderscoreStyle object>
table = 'implicit_joining_so_new'
class sqlobject.tests.test_new_joins.PersonJNew(**kw)[source]

Bases: sqlobject.main.SQLObject

addressJs
classmethod byName(val, connection=None)
j = person_j_new
name
q = person_j_new
class sqlmeta(instance)

Bases: sqlobject.main.sqlmeta

childName = None
columnDefinitions = {'name': <StringCol b490370c name>}
columnList = [<SOStringCol name alternate ID>]
columns = {'name': <SOStringCol name alternate ID>}
idName = 'id'
indexDefinitions = []
indexes = []
joinDefinitions = []
joins = []
soClass

alias of PersonJNew

style = <sqlobject.styles.MixedCaseUnderscoreStyle object>
table = 'person_j_new'
class sqlobject.tests.test_new_joins.PersonJNew2(**kw)[source]

Bases: sqlobject.main.SQLObject

addressJ2s
classmethod byName(val, connection=None)
j = person_j_new2
name
q = person_j_new2
class sqlmeta(instance)

Bases: sqlobject.main.sqlmeta

childName = None
columnDefinitions = {'name': <StringCol b426af4c name>}
columnList = [<SOStringCol name alternate ID>]
columns = {'name': <SOStringCol name alternate ID>}
idName = 'id'
indexDefinitions = []
indexes = []
joinDefinitions = []
joins = []
soClass

alias of PersonJNew2

style = <sqlobject.styles.MixedCaseUnderscoreStyle object>
table = 'person_j_new2'
class sqlobject.tests.test_new_joins.PersonJNew3(**kw)[source]

Bases: sqlobject.main.SQLObject

addressJNew3s
classmethod byName(val, connection=None)
j = person_j_new3
name
q = person_j_new3
class sqlmeta(instance)

Bases: sqlobject.main.sqlmeta

childName = None
columnDefinitions = {'name': <StringCol b41115ac name>}
columnList = [<SOStringCol name alternate ID>]
columns = {'name': <SOStringCol name alternate ID>}
idName = 'id'
indexDefinitions = []
indexes = []
joinDefinitions = []
joins = []
soClass

alias of PersonJNew3

style = <sqlobject.styles.MixedCaseUnderscoreStyle object>
table = 'person_j_new3'
class sqlobject.tests.test_new_joins.TestJoin[source]

Bases: object

assertNamesEqual(people, dest)[source]
assertZipsEqual(zips, dest)[source]
setup_method(meth)[source]
test_join()[source]
test_joinAttributeWithUnderscores()[source]
class sqlobject.tests.test_new_joins.TestJoin2[source]

Bases: object

setup_method(meth)[source]
test_basic()[source]
test_defaultOrder()[source]
class sqlobject.tests.test_new_joins.TestJoin3[source]

Bases: object

setup_method(meth)[source]
test_accessors()[source]