# sqlobject.tests.test_indexes module

class `sqlobject.tests.test_indexes.``AddressIndexGet2`(**kw)

  Bases: `sqlobject.main.SQLObject`

  `j` = address_index_get2
  `person`
  `personID`
  `pk` = <sqlobject.index.SODatabaseIndex object>
  `q` = address_index_get2
  class `sqlmeta`(instance)

    Bases: `sqlobject.main.sqlmeta`

    `childName` = None
    `columnDefinitions` = {'personID': <ForeignKey b389de8cL person>, 'street': <StringCol b389d26cL street>, 'type': <StringCol b389da6cL type>}
    `columnList` = [<SOForeignKey personID connected to PersonIndexGet2 not null>, <SOStringCol type not null>, <SOStringCol street not null>]
    `columns` = {'personID': <SOForeignKey personID connected to PersonIndexGet2 not null>, 'street': <SOStringCol street not null>, 'type': <SOStringCol type not null>}
    `idName` = 'id'
    `indexDefinitions` = [<DatabaseIndex b389d8ccL {'unique': True, 'name': 'pk', 'columns': (<ForeignKey b389de8cL person>, <StringCol b389da6cL type>)}>]
    `indexes` = [<sqlobject.index.SODatabaseIndex object>]
    `joinDefinitions` = []
    `joins` = []
    `soClass`

      alias of `AddressIndexGet2`

    `style` = <sqlobject.styles.MixedCaseUnderscoreStyle object>
    `table` = 'address_index_get2'
  `AddressIndexGet2.``street`
  `AddressIndexGet2.``type`

class `sqlobject.tests.test_indexes.``PersonIndexGet`(**kw)

  Bases: `sqlobject.main.SQLObject`

  `age`
  classmethod `byAge`(val, connection=None)
  `firstName`
  `j` = person_index_get
  `lastName`
  `nameIndex` = <sqlobject.index.SODatabaseIndex object>
  `q` = person_index_get
  class `sqlmeta`(instance)

    Bases: `sqlobject.main.sqlmeta`

    `childName` = None
    `columnDefinitions` = {'lastName': <StringCol b3bb8a8cL lastName>, 'age': <IntCol b3bb808cL age>, 'firstName': <StringCol b3bb810cL firstName>}
    `columnList` = [<SOStringCol firstName>, <SOStringCol lastName>, <SOIntCol age alternate ID>]
    `columns` = {'lastName': <SOStringCol lastName>, 'age': <SOIntCol age alternate ID>, 'firstName': <SOStringCol firstName>}
    `idName` = 'id'
    `indexDefinitions` = [<DatabaseIndex b3bb848cL {'unique': True, 'name': 'nameIndex', 'columns': (<StringCol b3bb810cL firstName>, <StringCol b3bb8a8cL lastName>)}>]
    `indexes` = [<sqlobject.index.SODatabaseIndex object>]
    `joinDefinitions` = []
    `joins` = []
    `soClass`

      alias of `PersonIndexGet`

    `style` = <sqlobject.styles.MixedCaseUnderscoreStyle object>
    `table` = 'person_index_get'

class `sqlobject.tests.test_indexes.``PersonIndexGet2`(**kw)

  Bases: `sqlobject.main.SQLObject`

  `addresses`
  `age`
  classmethod `byName`(val, connection=None)
  `j` = person_index_get2
  `name`
  `q` = person_index_get2
  class `sqlmeta`(instance)

    Bases: `sqlobject.main.sqlmeta`

    `childName` = None
    `columnDefinitions` = {'age': <IntCol b3b5734cL age>, 'name': <StringCol b3b57bacL name>}
    `columnList` = [<SOStringCol name alternate ID>, <SOIntCol age>]
    `columns` = {'age': <SOIntCol age>, 'name': <SOStringCol name alternate ID>}
    `idName` = 'id'
    `indexDefinitions` = []
    `indexes` = []
    `joinDefinitions` = [<sqlobject.joins.MultipleJoin object>]
    `joins` = [<sqlobject.joins.SOMultipleJoin object>]
    `soClass`

      alias of `PersonIndexGet2`

    `style` = <sqlobject.styles.MixedCaseUnderscoreStyle object>
    `table` = 'person_index_get2'

class `sqlobject.tests.test_indexes.``SOIndex1`(**kw)

  Bases: `sqlobject.main.SQLObject`

  `j` = so_index1
  `name`
  `nameIndex` = <sqlobject.index.SODatabaseIndex object>
  `nameIndex2` = <sqlobject.index.SODatabaseIndex object>
  `nameIndex3` = <sqlobject.index.SODatabaseIndex object>
  `number`
  `q` = so_index1
  class `sqlmeta`(instance)

    Bases: `sqlobject.main.sqlmeta`

    `childName` = None
    `columnDefinitions` = {'name': <StringCol b3ac21ccL name>, 'number': <IntCol b3ac2eccL number>}
    `columnList` = [<SOStringCol name>, <SOIntCol number>]
    `columns` = {'name': <SOStringCol name>, 'number': <SOIntCol number>}
    `idName` = 'id'
    `indexDefinitions` = [<DatabaseIndex b3ac288cL {'unique': True, 'name': 'nameIndex', 'columns': ('name',)}>, <DatabaseIndex b3ac2f6cL {'name': 'nameIndex2', 'columns': (<StringCol b3ac21ccL name>, <IntCol b3ac2eccL number>)}>, <DatabaseIndex b3ac2e0cL {'name': 'nameIndex3', 'columns': ({'column': <SOStringCol name>, 'length': 3},)}>]
    `indexes` = [<sqlobject.index.SODatabaseIndex object>, <sqlobject.index.SODatabaseIndex object>, <sqlobject.index.SODatabaseIndex object>]
    `joinDefinitions` = []
    `joins` = []
    `soClass`

      alias of `SOIndex1`

    `style` = <sqlobject.styles.MixedCaseUnderscoreStyle object>
    `table` = 'so_index1'

class `sqlobject.tests.test_indexes.``SOIndex2`(**kw)

  Bases: `sqlobject.main.SQLObject`

  `j` = so_index2
  `name`
  `nameIndex` = <sqlobject.index.SODatabaseIndex object>
  `q` = so_index2
  class `sqlmeta`(instance)

    Bases: `sqlobject.main.sqlmeta`

    `childName` = None
    `columnDefinitions` = {'name': <StringCol b3c1efccL name>}
    `columnList` = [<SOStringCol name>]
    `columns` = {'name': <SOStringCol name>}
    `idName` = 'id'
    `indexDefinitions` = [<DatabaseIndex b388c90cL {'name': 'nameIndex', 'columns': ({'expression': 'lower(name)'},)}>]
    `indexes` = [<sqlobject.index.SODatabaseIndex object>]
    `joinDefinitions` = []
    `joins` = []
    `soClass`

      alias of `SOIndex2`

    `style` = <sqlobject.styles.MixedCaseUnderscoreStyle object>
    `table` = 'so_index2'

`sqlobject.tests.test_indexes.``test_index_get_1`()

`sqlobject.tests.test_indexes.``test_index_get_2`()

`sqlobject.tests.test_indexes.``test_indexes_1`()

`sqlobject.tests.test_indexes.``test_indexes_2`()