sqlobject package¶
SQLObject
Subpackages¶
- sqlobject.firebird package
builder()
- Submodules
- sqlobject.firebird.firebirdconnection module
FirebirdConnection
FirebirdConnection.addColumn()
FirebirdConnection.columnsFromSchema()
FirebirdConnection.createColumn()
FirebirdConnection.createEmptyDatabase()
FirebirdConnection.createIDColumn()
FirebirdConnection.createIndexSQL()
FirebirdConnection.createReferenceConstraint()
FirebirdConnection.createTable()
FirebirdConnection.dbName
FirebirdConnection.delColumn()
FirebirdConnection.dropDatabase()
FirebirdConnection.dropTable()
FirebirdConnection.guessClass()
FirebirdConnection.joinSQLType()
FirebirdConnection.limit_re
FirebirdConnection.makeConnection()
FirebirdConnection.readDefaultEncodingFromDB()
FirebirdConnection.schemes
FirebirdConnection.supportTransactions
FirebirdConnection.tableExists()
- sqlobject.firebird.firebirdconnection module
- sqlobject.include package
- sqlobject.inheritance package
InheritableSQLObject
- Subpackages
- sqlobject.inheritance.tests package
- Submodules
- sqlobject.inheritance.tests.test_aggregates module
SOTestAggregate1
SOTestAggregate2
test_aggregates()
- sqlobject.inheritance.tests.test_asdict module
EmployeeAD
InheritablePersonAD
InheritablePersonAD.byLastName()
InheritablePersonAD.childName
InheritablePersonAD.firstName
InheritablePersonAD.j
InheritablePersonAD.lastName
InheritablePersonAD.q
InheritablePersonAD.sqlmeta
InheritablePersonAD.sqlmeta.childClasses
InheritablePersonAD.sqlmeta.childName
InheritablePersonAD.sqlmeta.indexes
InheritablePersonAD.sqlmeta.joinDefinitions
InheritablePersonAD.sqlmeta.joins
InheritablePersonAD.sqlmeta.parentClass
InheritablePersonAD.sqlmeta.soClass
InheritablePersonAD.sqlmeta.table
ManagerAD
test_asDict()
test_getColumns()
- sqlobject.inheritance.tests.test_deep_inheritance module
DIEmployee
DIManager
DIPerson
test_creation_fail()
test_creation_fail2()
test_deep_inheritance()
- sqlobject.inheritance.tests.test_destroy_cascade module
SOTestCascade1
SOTestCascade2
SOTestCascade3
test_destroySelf()
- sqlobject.inheritance.tests.test_foreignKey module
EmployeeWithNotes
Note
Paper
PersonWithNotes
SOTestInhBase
SOTestInhFKey
test_foreignKey()
test_foreignKey2()
- sqlobject.inheritance.tests.test_indexes module
InhEmployeeIdxGet
InhPersonIdxGet
InhSalesManIdxGet
test_index_get_1()
- sqlobject.inheritance.tests.test_inheritance module
Employee
InheritablePerson
setup()
test_addDelColumn()
test_creation_fail()
test_inheritance()
test_inheritance_select()
- sqlobject.inheritance.tests.test_inheritance_tree module
- sqlobject.inheritance.tests.test_aggregates module
- Submodules
- sqlobject.inheritance.tests package
- Submodules
- sqlobject.manager package
- Submodules
- sqlobject.manager.command module
Command
Command.aliases
Command.ask()
Command.classes()
Command.classes_from_egg()
Command.classes_from_module()
Command.classes_from_package()
Command.command()
Command.config()
Command.config_from_egg()
Command.connection()
Command.description
Command.help
Command.ini_config()
Command.load_options_from_egg()
Command.max_args
Command.max_args_error
Command.min_args
Command.min_args_error
Command.open_editor()
Command.orderClassesByDependencyLevel()
Command.prog_name
Command.required_args
Command.run()
Command.shorten_filename()
CommandCreate
CommandDrop
CommandExecute
CommandHelp
CommandList
CommandRecord
CommandRecord.base_dir()
CommandRecord.command()
CommandRecord.command_force_db_version()
CommandRecord.find_last_version()
CommandRecord.find_output_dir()
CommandRecord.help
CommandRecord.name
CommandRecord.parser
CommandRecord.strip_comments()
CommandRecord.summary
CommandRecord.update_db()
CommandRecord.version_regex
CommandRunner
CommandSQL
CommandStatus
CommandUpgrade
SQLObjectVersionTable
SQLObjectVersionTable.j
SQLObjectVersionTable.q
SQLObjectVersionTable.sqlmeta
SQLObjectVersionTable.sqlmeta.childName
SQLObjectVersionTable.sqlmeta.idName
SQLObjectVersionTable.sqlmeta.indexes
SQLObjectVersionTable.sqlmeta.joinDefinitions
SQLObjectVersionTable.sqlmeta.joins
SQLObjectVersionTable.sqlmeta.soClass
SQLObjectVersionTable.sqlmeta.style
SQLObjectVersionTable.sqlmeta.table
SQLObjectVersionTable.updated
SQLObjectVersionTable.version
db_differences()
nowarning_tempnam()
register()
standard_parser()
update_sys_path()
- sqlobject.manager.command module
- Submodules
- sqlobject.maxdb package
builder()
- Submodules
- sqlobject.maxdb.maxdbconnection module
IncorrectIDStyleError
LowerBoundOfSliceIsNotSupported
MaxdbConnection
MaxdbConnection.GET_COLUMNS
MaxdbConnection.GET_PK_AND_FK
MaxdbConnection.addColumn()
MaxdbConnection.columnsFromSchema()
MaxdbConnection.createColumn()
MaxdbConnection.createIDColumn()
MaxdbConnection.createIndexSQL()
MaxdbConnection.createReferenceConstraint()
MaxdbConnection.createSequenceName()
MaxdbConnection.createTable()
MaxdbConnection.dbName
MaxdbConnection.delColumn()
MaxdbConnection.dropTable()
MaxdbConnection.guessClass()
MaxdbConnection.joinSQLType()
MaxdbConnection.makeConnection()
MaxdbConnection.schemes
MaxdbConnection.sqlAddLimit()
MaxdbConnection.supportTransactions
MaxdbConnection.tableExists()
PrimaryKeyNotFounded
StyleMismatchError
maxdbException
- sqlobject.maxdb.maxdbconnection module
- sqlobject.mssql package
builder()
- Submodules
- sqlobject.mssql.mssqlconnection module
MSSQLConnection
MSSQLConnection.HAS_IDENTITY
MSSQLConnection.SHOW_COLUMNS
MSSQLConnection.SHOW_TABLES
MSSQLConnection.addColumn()
MSSQLConnection.can_use_max_types()
MSSQLConnection.can_use_microseconds()
MSSQLConnection.columnsFromSchema()
MSSQLConnection.createColumn()
MSSQLConnection.createIDColumn()
MSSQLConnection.createIndexSQL()
MSSQLConnection.createReferenceConstraint()
MSSQLConnection.dbName
MSSQLConnection.delColumn()
MSSQLConnection.guessClass()
MSSQLConnection.insert_id()
MSSQLConnection.joinSQLType()
MSSQLConnection.limit_re
MSSQLConnection.makeConnection()
MSSQLConnection.odbc_keywords
MSSQLConnection.schemes
MSSQLConnection.server_version()
MSSQLConnection.supportTransactions
MSSQLConnection.tableExists()
- sqlobject.mssql.mssqlconnection module
- sqlobject.mysql package
builder()
- Submodules
- sqlobject.mysql.mysqlconnection module
ConnectorBytesConverter()
ErrorMessage
MySQLConnection
MySQLConnection.addColumn()
MySQLConnection.can_use_json_funcs()
MySQLConnection.can_use_microseconds()
MySQLConnection.columnsFromSchema()
MySQLConnection.createColumn()
MySQLConnection.createEmptyDatabase()
MySQLConnection.createIDColumn()
MySQLConnection.createIndexSQL()
MySQLConnection.createReferenceConstraint()
MySQLConnection.dbName
MySQLConnection.delColumn()
MySQLConnection.dropDatabase()
MySQLConnection.guessClass()
MySQLConnection.joinSQLType()
MySQLConnection.listDatabases()
MySQLConnection.listTables()
MySQLConnection.makeConnection()
MySQLConnection.odbc_keywords
MySQLConnection.schemes
MySQLConnection.server_version()
MySQLConnection.supportTransactions
MySQLConnection.tableExists()
- sqlobject.mysql.mysqlconnection module
- sqlobject.postgres package
builder()
- Submodules
- sqlobject.postgres.pgconnection module
ErrorMessage
OdbcBinaryConverter()
PostgresBinaryConverter()
PostgresConnection
PostgresConnection.addColumn()
PostgresConnection.columnsFromSchema()
PostgresConnection.createColumn()
PostgresConnection.createEmptyDatabase()
PostgresConnection.createIDColumn()
PostgresConnection.createIndexSQL()
PostgresConnection.createReferenceConstraint()
PostgresConnection.dbName
PostgresConnection.defaultFromSchema()
PostgresConnection.delColumn()
PostgresConnection.dropDatabase()
PostgresConnection.dropTable()
PostgresConnection.guessClass()
PostgresConnection.joinSQLType()
PostgresConnection.listDatabases()
PostgresConnection.listTables()
PostgresConnection.makeConnection()
PostgresConnection.odbc_keywords
PostgresConnection.schemes
PostgresConnection.supportTransactions
PostgresConnection.tableExists()
PsycoBinaryConverter()
escape_bytea()
- sqlobject.postgres.pgconnection module
- sqlobject.sqlite package
builder()
- Submodules
- sqlobject.sqlite.sqliteconnection module
ErrorMessage
SQLiteConnection
SQLiteConnection.addColumn()
SQLiteConnection.close()
SQLiteConnection.columnsFromSchema()
SQLiteConnection.createColumn()
SQLiteConnection.createEmptyDatabase()
SQLiteConnection.createIDColumn()
SQLiteConnection.createIndexSQL()
SQLiteConnection.createReferenceConstraint()
SQLiteConnection.dbName
SQLiteConnection.delColumn()
SQLiteConnection.dropDatabase()
SQLiteConnection.getConnection()
SQLiteConnection.guessClass()
SQLiteConnection.joinSQLType()
SQLiteConnection.listDatabases()
SQLiteConnection.listTables()
SQLiteConnection.makeConnection()
SQLiteConnection.makeMemoryConnection()
SQLiteConnection.oldUri()
SQLiteConnection.recreateTableWithoutColumn()
SQLiteConnection.releaseConnection()
SQLiteConnection.schemes
SQLiteConnection.supportTransactions
SQLiteConnection.tableExists()
SQLiteConnection.uri()
- sqlobject.sqlite.sqliteconnection module
- sqlobject.sybase package
builder()
- Submodules
- sqlobject.sybase.sybaseconnection module
SybaseConnection
SybaseConnection.HAS_IDENTITY
SybaseConnection.NumericType
SybaseConnection.SHOW_COLUMNS
SybaseConnection.SHOW_TABLES
SybaseConnection.addColumn()
SybaseConnection.columnsFromSchema()
SybaseConnection.createColumn()
SybaseConnection.createIDColumn()
SybaseConnection.createIndexSQL()
SybaseConnection.createReferenceConstraint()
SybaseConnection.dbName
SybaseConnection.delColumn()
SybaseConnection.guessClass()
SybaseConnection.insert_id()
SybaseConnection.joinSQLType()
SybaseConnection.makeConnection()
SybaseConnection.schemes
SybaseConnection.supportTransactions
SybaseConnection.tableExists()
- sqlobject.sybase.sybaseconnection module
- sqlobject.tests package
- Submodules
- sqlobject.tests.dbtest module
- sqlobject.tests.test_ForeignKey module
SOTestComposerKey
SOTestFKValidationA
SOTestFKValidationB
SOTestFKValidationC
SOTestFKValidationC.j
SOTestFKValidationC.name
SOTestFKValidationC.q
SOTestFKValidationC.sqlmeta
SOTestFKValidationC.sqlmeta.childName
SOTestFKValidationC.sqlmeta.idName
SOTestFKValidationC.sqlmeta.idType
SOTestFKValidationC.sqlmeta.indexes
SOTestFKValidationC.sqlmeta.joinDefinitions
SOTestFKValidationC.sqlmeta.joins
SOTestFKValidationC.sqlmeta.soClass
SOTestFKValidationC.sqlmeta.style
SOTestFKValidationC.sqlmeta.table
SOTestOtherColumn
SOTestWorkKey
SOTestWorkKey2
test1()
test2()
test_foreignkey_validation()
test_otherColumn()
- sqlobject.tests.test_ForeignKey_cascade module
SOTestMessageCascadeFalse
SOTestMessageCascadeFalse.body
SOTestMessageCascadeFalse.j
SOTestMessageCascadeFalse.q
SOTestMessageCascadeFalse.recipient
SOTestMessageCascadeFalse.recipientID
SOTestMessageCascadeFalse.sender
SOTestMessageCascadeFalse.senderID
SOTestMessageCascadeFalse.sqlmeta
SOTestMessageCascadeFalse.sqlmeta.childName
SOTestMessageCascadeFalse.sqlmeta.idName
SOTestMessageCascadeFalse.sqlmeta.indexes
SOTestMessageCascadeFalse.sqlmeta.joinDefinitions
SOTestMessageCascadeFalse.sqlmeta.joins
SOTestMessageCascadeFalse.sqlmeta.soClass
SOTestMessageCascadeFalse.sqlmeta.style
SOTestMessageCascadeFalse.sqlmeta.table
SOTestMessageCascadeMixed
SOTestMessageCascadeMixed.body
SOTestMessageCascadeMixed.j
SOTestMessageCascadeMixed.q
SOTestMessageCascadeMixed.recipient
SOTestMessageCascadeMixed.recipientID
SOTestMessageCascadeMixed.sender
SOTestMessageCascadeMixed.senderID
SOTestMessageCascadeMixed.sqlmeta
SOTestMessageCascadeMixed.sqlmeta.childName
SOTestMessageCascadeMixed.sqlmeta.idName
SOTestMessageCascadeMixed.sqlmeta.indexes
SOTestMessageCascadeMixed.sqlmeta.joinDefinitions
SOTestMessageCascadeMixed.sqlmeta.joins
SOTestMessageCascadeMixed.sqlmeta.soClass
SOTestMessageCascadeMixed.sqlmeta.style
SOTestMessageCascadeMixed.sqlmeta.table
SOTestMessageCascadeNull
SOTestMessageCascadeNull.body
SOTestMessageCascadeNull.j
SOTestMessageCascadeNull.q
SOTestMessageCascadeNull.recipient
SOTestMessageCascadeNull.recipientID
SOTestMessageCascadeNull.sender
SOTestMessageCascadeNull.senderID
SOTestMessageCascadeNull.sqlmeta
SOTestMessageCascadeNull.sqlmeta.childName
SOTestMessageCascadeNull.sqlmeta.idName
SOTestMessageCascadeNull.sqlmeta.indexes
SOTestMessageCascadeNull.sqlmeta.joinDefinitions
SOTestMessageCascadeNull.sqlmeta.joins
SOTestMessageCascadeNull.sqlmeta.soClass
SOTestMessageCascadeNull.sqlmeta.style
SOTestMessageCascadeNull.sqlmeta.table
SOTestMessageCascadeTrue
SOTestMessageCascadeTrue.body
SOTestMessageCascadeTrue.j
SOTestMessageCascadeTrue.q
SOTestMessageCascadeTrue.recipient
SOTestMessageCascadeTrue.recipientID
SOTestMessageCascadeTrue.sender
SOTestMessageCascadeTrue.senderID
SOTestMessageCascadeTrue.sqlmeta
SOTestMessageCascadeTrue.sqlmeta.childName
SOTestMessageCascadeTrue.sqlmeta.idName
SOTestMessageCascadeTrue.sqlmeta.indexes
SOTestMessageCascadeTrue.sqlmeta.joinDefinitions
SOTestMessageCascadeTrue.sqlmeta.joins
SOTestMessageCascadeTrue.sqlmeta.soClass
SOTestMessageCascadeTrue.sqlmeta.style
SOTestMessageCascadeTrue.sqlmeta.table
SOTestPerson1
SOTestPerson2
SOTestPerson3
SOTestPerson4
test1()
test2()
test3()
test4()
test5()
- sqlobject.tests.test_NoneValuedResultItem module
- sqlobject.tests.test_SQLMultipleJoin module
- sqlobject.tests.test_SQLRelatedJoin module
Fighter
RecGroupMap
RecursiveGroup
Tourtment
createAllTables()
createData()
test_1()
test_rec_group()
test_related_join_filter()
test_related_join_transaction()
- sqlobject.tests.test_SingleJoin module
- sqlobject.tests.test_aggregates module
- sqlobject.tests.test_aliases module
- sqlobject.tests.test_asdict module
- sqlobject.tests.test_auto module
- sqlobject.tests.test_basic module
SOTestSO1
SOTestSO10
SOTestSO11
SOTestSO12
SOTestSO2
SOTestSO3
SOTestSO4
SOTestSO5
SOTestSO6
SOTestSO7
SOTestSO8
SOTestSO9
Student
setupGetters()
testAsDict()
testForeignKeyDestroySelfRestrict()
testForeignKeyDropTableCascade()
testForeignKeySetNull()
test_boolCol()
test_case1()
test_case2()
test_connection_override()
test_count()
test_defaultSQL()
test_extra_vars()
test_foreignKey()
test_foreignKeyDestroySelfCascade()
test_getset()
test_newline()
test_nonexisting_attr()
test_selectBy()
test_wrong_sqlmeta_idSize()
test_wrong_sqlmeta_idType()
- sqlobject.tests.test_blob module
- sqlobject.tests.test_boundattributes module
- sqlobject.tests.test_cache module
- sqlobject.tests.test_class_hash module
- sqlobject.tests.test_columns_order module
- sqlobject.tests.test_combining_joins module
Complex
ComplexGroup
UnitModel
test_join_sqlrepr()
- sqlobject.tests.test_comparison module
- sqlobject.tests.test_compat module
- sqlobject.tests.test_complex_sorting module
- sqlobject.tests.test_constraints module
- sqlobject.tests.test_converters module
NewSOTestClass
NewSOTestClassConverter()
SOTestClass
SOTestClassConverter()
test_bool()
test_call()
test_constant()
test_datetime()
test_delete()
test_dict()
test_float()
test_insert()
test_instance()
test_integer()
test_like_quoted()
test_list()
test_newstyle()
test_none()
test_op()
test_prefix()
test_quote_unquote_str()
test_replace()
test_select()
test_sets()
test_simple_string()
test_simple_unicode()
test_sqlexpr()
test_sqlobjectfield()
test_string_()
test_string_000()
test_string_b()
test_string_newline()
test_string_r()
test_string_tab()
test_timedelta()
test_trueclause()
test_tuple()
test_update()
- sqlobject.tests.test_create_drop module
- sqlobject.tests.test_csvexport module
ComplexCSV
SimpleCSV
assert_export()
test_complex()
test_simple()
test_zip()
- sqlobject.tests.test_csvimport module
- sqlobject.tests.test_cyclic_reference module
SOTestCyclicRefA
SOTestCyclicRefB
test_cyclic_reference()
- sqlobject.tests.test_datetime module
- sqlobject.tests.test_decimal module
- sqlobject.tests.test_declarative module
- sqlobject.tests.test_default_style module
- sqlobject.tests.test_delete module
NoCache
Service
ServiceGroup
testDeleteBy()
testDeleteMany()
testDeleteRelatedJoins()
testDestroySelf()
testSelect()
- sqlobject.tests.test_distinct module
- sqlobject.tests.test_empty module
- sqlobject.tests.test_enum module
Enum1
EnumUnicode
EnumWithDefaultNone
EnumWithDefaultOther
EnumWithNone
testBad()
testDefaultNone()
testDefaultOther()
testNone()
testUnicode()
- sqlobject.tests.test_events module
EventTester
InheritableEventTestA
InheritableEventTestA.a
InheritableEventTestA.childName
InheritableEventTestA.j
InheritableEventTestA.q
InheritableEventTestA.sqlmeta
InheritableEventTestA.sqlmeta.childClasses
InheritableEventTestA.sqlmeta.childName
InheritableEventTestA.sqlmeta.indexes
InheritableEventTestA.sqlmeta.joinDefinitions
InheritableEventTestA.sqlmeta.joins
InheritableEventTestA.sqlmeta.parentClass
InheritableEventTestA.sqlmeta.soClass
InheritableEventTestA.sqlmeta.table
InheritableEventTestB
InheritableEventTestB.a
InheritableEventTestB.b
InheritableEventTestB.childName
InheritableEventTestB.j
InheritableEventTestB.q
InheritableEventTestB.sqlmeta
InheritableEventTestB.sqlmeta.childClasses
InheritableEventTestB.sqlmeta.childName
InheritableEventTestB.sqlmeta.indexes
InheritableEventTestB.sqlmeta.joinDefinitions
InheritableEventTestB.sqlmeta.joins
InheritableEventTestB.sqlmeta.parentClass
InheritableEventTestB.sqlmeta.soClass
InheritableEventTestB.sqlmeta.table
InheritableEventTestC
InheritableEventTestC.b
InheritableEventTestC.c
InheritableEventTestC.childName
InheritableEventTestC.j
InheritableEventTestC.q
InheritableEventTestC.sqlmeta
InheritableEventTestC.sqlmeta.childClasses
InheritableEventTestC.sqlmeta.childName
InheritableEventTestC.sqlmeta.indexes
InheritableEventTestC.sqlmeta.joinDefinitions
InheritableEventTestC.sqlmeta.joins
InheritableEventTestC.sqlmeta.parentClass
InheritableEventTestC.sqlmeta.soClass
InheritableEventTestC.sqlmeta.table
make_listen()
make_watcher()
test_add_column()
test_create()
test_inheritance_row_created()
test_row_create()
test_row_destroy()
test_row_destroyed()
test_row_update()
test_row_updated()
- sqlobject.tests.test_exceptions module
SOTestException
SOTestExceptionWithNonexistingTable
SOTestExceptionWithNonexistingTable.j
SOTestExceptionWithNonexistingTable.q
SOTestExceptionWithNonexistingTable.sqlmeta
SOTestExceptionWithNonexistingTable.sqlmeta.childName
SOTestExceptionWithNonexistingTable.sqlmeta.idName
SOTestExceptionWithNonexistingTable.sqlmeta.indexes
SOTestExceptionWithNonexistingTable.sqlmeta.joinDefinitions
SOTestExceptionWithNonexistingTable.sqlmeta.joins
SOTestExceptionWithNonexistingTable.sqlmeta.soClass
SOTestExceptionWithNonexistingTable.sqlmeta.style
SOTestExceptionWithNonexistingTable.sqlmeta.table
test_exceptions()
- sqlobject.tests.test_expire module
- sqlobject.tests.test_groupBy module
- sqlobject.tests.test_identity module
- sqlobject.tests.test_indexes module
AddressIndexGet2
PersonIndexGet
PersonIndexGet2
SOIndex1
SOIndex2
test_index_get_1()
test_index_get_2()
test_indexes_1()
test_indexes_2()
- sqlobject.tests.test_inheritance module
- sqlobject.tests.test_joins module
AddressJoiner
AddressJoiner2
AddressJoiner3
ExplicitJoiningSO
ImplicitJoiningSO
PersonJoiner
PersonJoiner2
PersonJoiner3
TestJoin
TestJoin2
TestJoin3
- sqlobject.tests.test_joins_conditional module
- sqlobject.tests.test_jsonbcol module
- sqlobject.tests.test_jsoncol module
- sqlobject.tests.test_lazy module
- sqlobject.tests.test_md5 module
- sqlobject.tests.test_mysql module
SOTestANY
SOTestMySQLidSize
SOTestMySQLidSize.j
SOTestMySQLidSize.q
SOTestMySQLidSize.sqlmeta
SOTestMySQLidSize.sqlmeta.childName
SOTestMySQLidSize.sqlmeta.idName
SOTestMySQLidSize.sqlmeta.idSize
SOTestMySQLidSize.sqlmeta.indexes
SOTestMySQLidSize.sqlmeta.joinDefinitions
SOTestMySQLidSize.sqlmeta.joins
SOTestMySQLidSize.sqlmeta.soClass
SOTestMySQLidSize.sqlmeta.style
SOTestMySQLidSize.sqlmeta.table
SOTestSOListMySQL
test_ANY()
test_idSize()
test_list_databases()
test_list_tables()
- sqlobject.tests.test_new_joins module
AddressJNew
AddressJNew2
AddressJNew3
ExplicitJoiningSONew
ImplicitJoiningSONew
PersonJNew
PersonJNew2
PersonJNew3
TestJoin
TestJoin2
TestJoin3
- sqlobject.tests.test_parse_uri module
- sqlobject.tests.test_paste module
- sqlobject.tests.test_perConnection module
- sqlobject.tests.test_pickle module
- sqlobject.tests.test_picklecol module
- sqlobject.tests.test_postgres module
- sqlobject.tests.test_reparent_sqlmeta module
- sqlobject.tests.test_schema module
- sqlobject.tests.test_select module
Counter2
IterTest
TestSelect
UniqTest
setupIter()
test_00_normal()
test_00b_lazy()
test_01_turn_to_list()
test_02_generator()
test_03_ranged_indexed()
test_04_indexed_ended_by_exception()
test_05_select_limit()
test_06_contains()
test_07_contains_special()
test_by_uniq()
test_selectBy()
test_selectBy_kwargs()
test_select_LIKE()
test_select_RLIKE()
test_select_getOne()
test_select_perConnection()
test_select_sqlbuilder()
- sqlobject.tests.test_select_through module
SRThrough1
SRThrough2
SRThrough3
setup_module()
testBadRef()
testThroughFK()
testThroughFKAndJoin()
testThroughMultipleJoin()
testThroughRelatedJoin()
- sqlobject.tests.test_setters module
- sqlobject.tests.test_slice module
- sqlobject.tests.test_sorting module
- sqlobject.tests.test_sqlbuilder module
- sqlobject.tests.test_sqlbuilder_dbspecific module
- sqlobject.tests.test_sqlbuilder_importproxy module
- sqlobject.tests.test_sqlbuilder_joins_instances module
SBAddress
SBPerson
setup_module()
testFK()
testFK2()
testInstance()
testJoin()
testJoin2()
testRelatedJoin()
testRelatedJoin2()
- sqlobject.tests.test_sqlite module
SQLiteFactoryTest
SQLiteTruedivTest
do_select()
test_empty_string()
test_list_databases()
test_list_tables()
test_memorydb()
test_sqlite_aggregate()
test_sqlite_factory()
test_sqlite_factory_str()
test_sqlite_threaded()
test_truediv()
- sqlobject.tests.test_sqlmeta_idName module
- sqlobject.tests.test_sqlobject_admin module
- sqlobject.tests.test_string_id module
SOStringID
SOStringID.byVal()
SOStringID.firebirdCreate
SOStringID.firebirdDrop
SOStringID.j
SOStringID.mssqlCreate
SOStringID.mssqlDrop
SOStringID.mysqlCreate
SOStringID.mysqlDrop
SOStringID.postgresCreate
SOStringID.postgresDrop
SOStringID.q
SOStringID.sqliteCreate
SOStringID.sqliteDrop
SOStringID.sqlmeta
SOStringID.sybaseCreate
SOStringID.val
test_stringID()
- sqlobject.tests.test_style module
- sqlobject.tests.test_subqueries module
SOTestIn1
SOTestIn2
SOTestOuter
insert()
setup()
test_1syntax_in()
test_2perform_in()
test_3syntax_exists()
test_4perform_direct()
test_4perform_exists()
test_4syntax_direct()
test_5perform_direct()
test_6perform_join()
test_6syntax_join()
- sqlobject.tests.test_transactions module
- sqlobject.tests.test_unicode module
- sqlobject.tests.test_uuidcol module
- sqlobject.tests.test_validation module
SOTestValidator
SOValidation
SOValidationTest
SOValidationTestBool
SOValidationTestFloat
SOValidationTestInt
TestValidation
- sqlobject.tests.test_views module
PhoneCall
PhoneNumber
ViewPhone
ViewPhoneCall
ViewPhoneInnerAggregate
ViewPhoneMore
ViewPhoneMore2
checkAttr()
setup_module()
testAliasOverride()
testColumnSQLVPC()
testDistinctCount()
testGetVP()
testGetVPC()
testGetVPM()
testInnerAggregate()
testJoinView()
testSelect()
testSelect2()
testSimpleVPC()
- Submodules
- sqlobject.util package
- sqlobject.versioning package
Version
Versioning
getColumns()
- Subpackages
- sqlobject.versioning.test package
- Submodules
- sqlobject.versioning.test.test_version module
Base
Child
Extra
Government
HasAltId
HasForeign
Monarchy
MyClass
VChild
setup()
test_altid()
test_extra()
test_foreign_keys()
test_get_changed()
test_inheritable_versioning()
test_next()
test_restore()
test_versioning()
- sqlobject.versioning.test.test_version module
- Submodules
- sqlobject.versioning.test package
Submodules¶
- sqlobject.boundattributes module
- sqlobject.cache module
- sqlobject.classregistry module
- sqlobject.col module
BLOBCol
BigIntCol
BoolCol
Col
CurrencyCol
DateCol
DateTimeCol
DecimalCol
DecimalStringCol
EnumCol
FloatCol
ForeignKey
IntCol
JSONCol
JsonbCol
KeyCol
MediumIntCol
PickleCol
SOBLOBCol
SOBigIntCol
SOBoolCol
SOCol
SOCol.autoConstraints()
SOCol.createSQL()
SOCol.createValidators()
SOCol.default
SOCol.firebirdCreateSQL()
SOCol.getDbEncoding()
SOCol.joinName
SOCol.maxdbCreateSQL()
SOCol.mssqlCreateSQL()
SOCol.mysqlCreateSQL()
SOCol.postgresCreateSQL()
SOCol.sqliteCreateSQL()
SOCol.sybaseCreateSQL()
SOCol.validator
SOCurrencyCol
SODateCol
SODateTimeCol
SODecimalCol
SODecimalStringCol
SOEnumCol
SOFloatCol
SOForeignKey
SOForeignKey.createValidators()
SOForeignKey.maxdbCreateReferenceConstraint()
SOForeignKey.maxdbCreateSQL()
SOForeignKey.mssqlCreateReferenceConstraint()
SOForeignKey.mssqlCreateSQL()
SOForeignKey.mysqlCreateReferenceConstraint()
SOForeignKey.mysqlCreateSQL()
SOForeignKey.postgresCreateReferenceConstraint()
SOForeignKey.postgresCreateSQL()
SOForeignKey.sqliteCreateSQL()
SOForeignKey.sybaseCreateReferenceConstraint()
SOForeignKey.sybaseCreateSQL()
SOIntCol
SOJSONCol
SOJsonbCol
SOKeyCol
SOMediumIntCol
SOPickleCol
SOSetCol
SOSmallIntCol
SOStringCol
SOStringLikeCol
SOTimeCol
SOTimedeltaCol
SOTimestampCol
SOTinyIntCol
SOUnicodeCol
SOUuidCol
SetCol
SmallIntCol
StringCol
TimeCol
TimedeltaCol
TimestampCol
TinyIntCol
UnicodeCol
UuidCol
use_microseconds()
- sqlobject.compat module
- sqlobject.conftest module
- sqlobject.constraints module
- sqlobject.converters module
BoolConverter()
ConverterRegistry
DateConverter()
DateTimeConverter()
DateTimeConverterMS()
DecimalConverter()
FloatConverter()
IntConverter()
LongConverter()
NoneConverter()
SequenceConverter()
StringLikeConverter()
StructTimeConverter()
TimeConverter()
TimeConverterMS()
TimedeltaConverter()
lookupConverter()
quote_str()
registerConverter()
sqlrepr()
unquote_str()
- sqlobject.dbconnection module
Boolean
ConnMethodWrapper
ConnWrapper
ConnectionHub
ConnectionURIOpener
ConsoleWriter
DBAPI
DBAPI.accumulateSelect()
DBAPI.clearTable()
DBAPI.close()
DBAPI.createBinary()
DBAPI.createColumn()
DBAPI.createColumns()
DBAPI.createEmptyDatabase()
DBAPI.createIndexSQL()
DBAPI.createReferenceConstraint()
DBAPI.createReferenceConstraints()
DBAPI.createSQL()
DBAPI.createTable()
DBAPI.createTableSQL()
DBAPI.dbName
DBAPI.dropTable()
DBAPI.getConnection()
DBAPI.iterSelect()
DBAPI.make_odbc_conn_str()
DBAPI.printDebug()
DBAPI.query()
DBAPI.queryAll()
DBAPI.queryAllDescription()
DBAPI.queryForSelect()
DBAPI.queryInsertID()
DBAPI.queryOne()
DBAPI.releaseConnection()
DBAPI.sqlrepr()
DBAPI.transaction()
DBConnection
Iteration
LogWriter
Transaction
connectionForURI()
dbConnectionForScheme()
makeDebugWriter()
registerConnection()
registerConnectionInstance()
- sqlobject.dberrors module
- sqlobject.declarative module
- sqlobject.events module
- sqlobject.index module
- sqlobject.joins module
- sqlobject.main module
- SQLObject
NoDefault
SQLObject
SQLObject.SelectResultsClass
SQLObject.childName
SQLObject.clearTable()
SQLObject.coerceID()
SQLObject.createIndexes()
SQLObject.createIndexesSQL()
SQLObject.createJoinTables()
SQLObject.createJoinTablesSQL()
SQLObject.createTable()
SQLObject.createTableSQL()
SQLObject.delete()
SQLObject.deleteBy()
SQLObject.deleteMany()
SQLObject.destroySelf()
SQLObject.dropJoinTables()
SQLObject.dropTable()
SQLObject.expire()
SQLObject.get()
SQLObject.select()
SQLObject.selectBy()
SQLObject.set()
SQLObject.setConnection()
SQLObject.sqlmeta
SQLObject.sqlmeta.addColumn()
SQLObject.sqlmeta.addColumnsFromDatabase()
SQLObject.sqlmeta.addIndex()
SQLObject.sqlmeta.addJoin()
SQLObject.sqlmeta.asDict()
SQLObject.sqlmeta.cacheValues
SQLObject.sqlmeta.childClasses
SQLObject.sqlmeta.childName
SQLObject.sqlmeta.dbEncoding
SQLObject.sqlmeta.defaultOrder
SQLObject.sqlmeta.delColumn()
SQLObject.sqlmeta.delJoin()
SQLObject.sqlmeta.dirty
SQLObject.sqlmeta.expireAll()
SQLObject.sqlmeta.expired
SQLObject.sqlmeta.fromDatabase
SQLObject.sqlmeta.getColumns()
SQLObject.sqlmeta.idName
SQLObject.sqlmeta.idSequence
SQLObject.sqlmeta.idSize
SQLObject.sqlmeta.idType
SQLObject.sqlmeta.indexes
SQLObject.sqlmeta.joinDefinitions
SQLObject.sqlmeta.joins
SQLObject.sqlmeta.lazyUpdate
SQLObject.sqlmeta.parentClass
SQLObject.sqlmeta.registry
SQLObject.sqlmeta.send()
SQLObject.sqlmeta.setClass()
SQLObject.sqlmeta.style
SQLObject.sqlmeta.table
SQLObject.sqlrepr()
SQLObject.sync()
SQLObject.syncUpdate()
SQLObject.tableExists()
SQLObject.tablesUsedImmediate()
SQLObjectIntegrityError
SQLObjectNotFound
getID()
getObject()
sqlmeta
sqlmeta.addColumn()
sqlmeta.addColumnsFromDatabase()
sqlmeta.addIndex()
sqlmeta.addJoin()
sqlmeta.asDict()
sqlmeta.cacheValues
sqlmeta.childClasses
sqlmeta.childName
sqlmeta.dbEncoding
sqlmeta.defaultOrder
sqlmeta.delColumn()
sqlmeta.delJoin()
sqlmeta.dirty
sqlmeta.expireAll()
sqlmeta.expired
sqlmeta.fromDatabase
sqlmeta.getColumns()
sqlmeta.idName
sqlmeta.idSequence
sqlmeta.idSize
sqlmeta.idType
sqlmeta.indexes
sqlmeta.joinDefinitions
sqlmeta.joins
sqlmeta.lazyUpdate
sqlmeta.parentClass
sqlmeta.registry
sqlmeta.send()
sqlmeta.setClass()
sqlmeta.style
sqlmeta.table
- sqlobject.sqlbuilder module
- sqlobject.sqlbuilder
- Disclaimer
- Instructions
ALL()
AND()
ANY()
Alias
AliasField
AliasSQLMeta
AliasTable
CONCAT
CONTAINSSTRING()
CROSSJOIN()
ColumnAS
ConstantSpace
DESC
Delete
ENDSWITH()
EXISTS()
FULLJOIN()
FULLJOINConditional()
FULLJOINOn()
FULLJOINUsing()
FULLOUTERJOIN()
FULLOUTERJOINConditional()
FULLOUTERJOINOn()
FULLOUTERJOINUsing()
Field
IN()
INNERJOIN()
INNERJOINConditional()
INNERJOINOn()
INNERJOINUsing()
INSubquery
ISNOTNULL()
ISNULL()
ImportProxy
ImportProxyField
Insert
JOIN()
LEFTJOIN()
LEFTJOINConditional()
LEFTJOINOn()
LEFTJOINUsing()
LEFTOUTERJOIN()
LEFTOUTERJOINConditional()
LEFTOUTERJOINOn()
LEFTOUTERJOINUsing()
LIKE
NATURALFULLJOIN()
NATURALFULLOUTERJOIN()
NATURALJOIN()
NATURALLEFTJOIN()
NATURALLEFTOUTERJOIN()
NATURALRIGHTJOIN()
NATURALRIGHTOUTERJOIN()
NOT()
NOTEXISTS()
NOTIN()
NOTINSubquery
NoDefault
OR()
Outer
OuterField
OuterTable
RIGHTJOIN()
RIGHTJOINConditional()
RIGHTJOINOn()
RIGHTJOINUsing()
RIGHTOUTERJOIN()
RIGHTOUTERJOINConditional()
RIGHTOUTERJOINOn()
RIGHTOUTERJOINUsing()
RLIKE
Replace
SOME()
SQLCall
SQLConstant
SQLExprConverter()
SQLExpression
SQLJoin
SQLJoinConditional
SQLJoinOn
SQLJoinUsing
SQLModulo
SQLObjectField
SQLObjectState
SQLObjectTable
SQLObjectTableWithJoins
SQLOp
SQLPrefix
SQLTrueClauseClass
STARTSWITH()
STRAIGHTJOIN()
Select
Subquery
Table
TableSpace
Union
Update
VersionError
dictToList()
execute()
sqlIdentifier()
tablesUsedSet()
- sqlobject.sresults module
SelectResults
SelectResults.IterationClass
SelectResults.accumulate()
SelectResults.accumulateMany()
SelectResults.accumulateOne()
SelectResults.avg()
SelectResults.clone()
SelectResults.connection()
SelectResults.count()
SelectResults.distinct()
SelectResults.filter()
SelectResults.getOne()
SelectResults.lazyColumns()
SelectResults.lazyIter()
SelectResults.limit()
SelectResults.max()
SelectResults.min()
SelectResults.newClause()
SelectResults.orderBy()
SelectResults.queryForSelect()
SelectResults.reversed()
SelectResults.sum()
SelectResults.throughTo
- sqlobject.styles module
- sqlobject.views module
- sqlobject.wsgi_middleware module