# sqlobject.tests.test_new_joins module

class `sqlobject.tests.test_new_joins.``AddressJNew`(**kw)

  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 b35404ecL 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)

  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 b360c34cL personJNew2>, 'zip': <StringCol b3728dacL zip>, 'plus4': <StringCol b360c28cL plus4>}
    `columnList` = [<SOStringCol zip>, <SOStringCol plus4 default=None>, <SOForeignKey personJNew2ID connected to PersonJNew2>]
    `columns` = {'personJNew2ID': <SOForeignKey personJNew2ID connected to PersonJNew2>, 'zip': <SOStringCol zip>, 'plus4': <SOStringCol plus4 default=None>}
    `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)

  Bases: `sqlobject.main.SQLObject`

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

    Bases: `sqlobject.main.sqlmeta`

    `childName` = None
    `columnDefinitions` = {'personJNew3ID': <ForeignKey b34fee6cL personJNew3>, 'zip': <StringCol b34fe80cL zip>}
    `columnList` = [<SOStringCol zip>, <SOForeignKey personJNew3ID connected to PersonJNew3>]
    `columns` = {'personJNew3ID': <SOForeignKey personJNew3ID connected to PersonJNew3>, 'zip': <SOStringCol zip>}
    `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)

  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)

  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)

  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 b351f42cL 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)

  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 b350ac6cL 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)

  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 b353f30cL 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`
  `assertNamesEqual`(people, dest)
  `assertZipsEqual`(zips, dest)
  `setup_method`(meth)
  `test_join`()
  `test_joinAttributeWithUnderscores`()

class `sqlobject.tests.test_new_joins.``TestJoin2`
  `setup_method`(meth)
  `test_basic`()
  `test_defaultOrder`()

class `sqlobject.tests.test_new_joins.``TestJoin3`
  `setup_method`(meth)
  `test_accessors`()