sqlobject package¶
SQLObject
Subpackages¶
- sqlobject.firebird package
builder()- Submodules
- sqlobject.firebird.firebirdconnection module
FirebirdConnectionFirebirdConnection.addColumn()FirebirdConnection.columnsFromSchema()FirebirdConnection.createColumn()FirebirdConnection.createEmptyDatabase()FirebirdConnection.createIDColumn()FirebirdConnection.createIndexSQL()FirebirdConnection.createReferenceConstraint()FirebirdConnection.createTable()FirebirdConnection.dbNameFirebirdConnection.delColumn()FirebirdConnection.dropDatabase()FirebirdConnection.dropTable()FirebirdConnection.guessClass()FirebirdConnection.joinSQLType()FirebirdConnection.limit_reFirebirdConnection.makeConnection()FirebirdConnection.readDefaultEncodingFromDB()FirebirdConnection.schemesFirebirdConnection.supportTransactionsFirebirdConnection.tableExists()
- sqlobject.firebird.firebirdconnection module
- sqlobject.include package
- sqlobject.inheritance package
InheritableSQLObject- Subpackages
- sqlobject.inheritance.tests package
- Submodules
- sqlobject.inheritance.tests.test_aggregates module
SOTestAggregate1SOTestAggregate2test_aggregates()
- sqlobject.inheritance.tests.test_asdict module
EmployeeADInheritablePersonADInheritablePersonAD.byLastName()InheritablePersonAD.childNameInheritablePersonAD.firstNameInheritablePersonAD.jInheritablePersonAD.lastNameInheritablePersonAD.qInheritablePersonAD.sqlmetaInheritablePersonAD.sqlmeta.childClassesInheritablePersonAD.sqlmeta.childNameInheritablePersonAD.sqlmeta.indexesInheritablePersonAD.sqlmeta.joinDefinitionsInheritablePersonAD.sqlmeta.joinsInheritablePersonAD.sqlmeta.parentClassInheritablePersonAD.sqlmeta.soClassInheritablePersonAD.sqlmeta.table
ManagerADtest_asDict()test_getColumns()
- sqlobject.inheritance.tests.test_deep_inheritance module
DIEmployeeDIManagerDIPersontest_creation_fail()test_creation_fail2()test_deep_inheritance()
- sqlobject.inheritance.tests.test_destroy_cascade module
SOTestCascade1SOTestCascade2SOTestCascade3test_destroySelf()
- sqlobject.inheritance.tests.test_foreignKey module
EmployeeWithNotesNotePaperPersonWithNotesSOTestInhBaseSOTestInhFKeytest_foreignKey()test_foreignKey2()
- sqlobject.inheritance.tests.test_indexes module
InhEmployeeIdxGetInhPersonIdxGetInhSalesManIdxGettest_index_get_1()
- sqlobject.inheritance.tests.test_inheritance module
EmployeeInheritablePersonsetup()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
CommandCommand.aliasesCommand.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.descriptionCommand.helpCommand.ini_config()Command.load_options_from_egg()Command.max_argsCommand.max_args_errorCommand.min_argsCommand.min_args_errorCommand.open_editor()Command.orderClassesByDependencyLevel()Command.prog_nameCommand.required_argsCommand.run()Command.shorten_filename()
CommandCreateCommandDropCommandExecuteCommandHelpCommandListCommandRecordCommandRecord.base_dir()CommandRecord.command()CommandRecord.command_force_db_version()CommandRecord.find_last_version()CommandRecord.find_output_dir()CommandRecord.helpCommandRecord.nameCommandRecord.parserCommandRecord.strip_comments()CommandRecord.summaryCommandRecord.update_db()CommandRecord.version_regex
CommandRunnerCommandSQLCommandStatusCommandUpgradeSQLObjectVersionTableSQLObjectVersionTable.jSQLObjectVersionTable.qSQLObjectVersionTable.sqlmetaSQLObjectVersionTable.sqlmeta.childNameSQLObjectVersionTable.sqlmeta.idNameSQLObjectVersionTable.sqlmeta.indexesSQLObjectVersionTable.sqlmeta.joinDefinitionsSQLObjectVersionTable.sqlmeta.joinsSQLObjectVersionTable.sqlmeta.soClassSQLObjectVersionTable.sqlmeta.styleSQLObjectVersionTable.sqlmeta.table
SQLObjectVersionTable.updatedSQLObjectVersionTable.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
IncorrectIDStyleErrorLowerBoundOfSliceIsNotSupportedMaxdbConnectionMaxdbConnection.GET_COLUMNSMaxdbConnection.GET_PK_AND_FKMaxdbConnection.addColumn()MaxdbConnection.columnsFromSchema()MaxdbConnection.createColumn()MaxdbConnection.createIDColumn()MaxdbConnection.createIndexSQL()MaxdbConnection.createReferenceConstraint()MaxdbConnection.createSequenceName()MaxdbConnection.createTable()MaxdbConnection.dbNameMaxdbConnection.delColumn()MaxdbConnection.dropTable()MaxdbConnection.guessClass()MaxdbConnection.joinSQLType()MaxdbConnection.makeConnection()MaxdbConnection.schemesMaxdbConnection.sqlAddLimit()MaxdbConnection.supportTransactionsMaxdbConnection.tableExists()
PrimaryKeyNotFoundedStyleMismatchErrormaxdbException
- sqlobject.maxdb.maxdbconnection module
- sqlobject.mssql package
builder()- Submodules
- sqlobject.mssql.mssqlconnection module
MSSQLConnectionMSSQLConnection.HAS_IDENTITYMSSQLConnection.SHOW_COLUMNSMSSQLConnection.SHOW_TABLESMSSQLConnection.addColumn()MSSQLConnection.can_use_max_types()MSSQLConnection.can_use_microseconds()MSSQLConnection.columnsFromSchema()MSSQLConnection.createColumn()MSSQLConnection.createIDColumn()MSSQLConnection.createIndexSQL()MSSQLConnection.createReferenceConstraint()MSSQLConnection.dbNameMSSQLConnection.delColumn()MSSQLConnection.guessClass()MSSQLConnection.insert_id()MSSQLConnection.joinSQLType()MSSQLConnection.limit_reMSSQLConnection.makeConnection()MSSQLConnection.odbc_keywordsMSSQLConnection.schemesMSSQLConnection.server_version()MSSQLConnection.supportTransactionsMSSQLConnection.tableExists()
- sqlobject.mssql.mssqlconnection module
- sqlobject.mysql package
builder()- Submodules
- sqlobject.mysql.mysqlconnection module
ConnectorBytesConverter()ErrorMessageMySQLConnectionMySQLConnection.addColumn()MySQLConnection.can_use_json_funcs()MySQLConnection.can_use_microseconds()MySQLConnection.columnsFromSchema()MySQLConnection.createColumn()MySQLConnection.createEmptyDatabase()MySQLConnection.createIDColumn()MySQLConnection.createIndexSQL()MySQLConnection.createReferenceConstraint()MySQLConnection.dbNameMySQLConnection.delColumn()MySQLConnection.dropDatabase()MySQLConnection.guessClass()MySQLConnection.joinSQLType()MySQLConnection.listDatabases()MySQLConnection.listTables()MySQLConnection.makeConnection()MySQLConnection.odbc_keywordsMySQLConnection.schemesMySQLConnection.server_version()MySQLConnection.supportTransactionsMySQLConnection.tableExists()
- sqlobject.mysql.mysqlconnection module
- sqlobject.postgres package
builder()- Submodules
- sqlobject.postgres.pgconnection module
ErrorMessageOdbcBinaryConverter()PostgresBinaryConverter()PostgresConnectionPostgresConnection.addColumn()PostgresConnection.columnsFromSchema()PostgresConnection.createColumn()PostgresConnection.createEmptyDatabase()PostgresConnection.createIDColumn()PostgresConnection.createIndexSQL()PostgresConnection.createReferenceConstraint()PostgresConnection.dbNamePostgresConnection.defaultFromSchema()PostgresConnection.delColumn()PostgresConnection.dropDatabase()PostgresConnection.dropTable()PostgresConnection.guessClass()PostgresConnection.joinSQLType()PostgresConnection.listDatabases()PostgresConnection.listTables()PostgresConnection.makeConnection()PostgresConnection.odbc_keywordsPostgresConnection.schemesPostgresConnection.supportTransactionsPostgresConnection.tableExists()
Psyco2BinaryConverter()PsycoBinaryConverter()escape_bytea()
- sqlobject.postgres.pgconnection module
- sqlobject.sqlite package
builder()- Submodules
- sqlobject.sqlite.sqliteconnection module
ErrorMessageSQLiteConnectionSQLiteConnection.addColumn()SQLiteConnection.close()SQLiteConnection.columnsFromSchema()SQLiteConnection.createColumn()SQLiteConnection.createEmptyDatabase()SQLiteConnection.createIDColumn()SQLiteConnection.createIndexSQL()SQLiteConnection.createReferenceConstraint()SQLiteConnection.dbNameSQLiteConnection.delColumn()SQLiteConnection.dropDatabase()SQLiteConnection.getConnection()SQLiteConnection.guessClass()SQLiteConnection.joinSQLType()SQLiteConnection.listDatabases()SQLiteConnection.listTables()SQLiteConnection.makeConnection()SQLiteConnection.makeMemoryConnection()SQLiteConnection.oldUri()SQLiteConnection.recreateTableWithoutColumn()SQLiteConnection.releaseConnection()SQLiteConnection.schemesSQLiteConnection.supportTransactionsSQLiteConnection.tableExists()SQLiteConnection.uri()
- sqlobject.sqlite.sqliteconnection module
- sqlobject.sybase package
builder()- Submodules
- sqlobject.sybase.sybaseconnection module
SybaseConnectionSybaseConnection.HAS_IDENTITYSybaseConnection.NumericTypeSybaseConnection.SHOW_COLUMNSSybaseConnection.SHOW_TABLESSybaseConnection.addColumn()SybaseConnection.columnsFromSchema()SybaseConnection.createColumn()SybaseConnection.createIDColumn()SybaseConnection.createIndexSQL()SybaseConnection.createReferenceConstraint()SybaseConnection.dbNameSybaseConnection.delColumn()SybaseConnection.guessClass()SybaseConnection.insert_id()SybaseConnection.joinSQLType()SybaseConnection.makeConnection()SybaseConnection.schemesSybaseConnection.supportTransactionsSybaseConnection.tableExists()
- sqlobject.sybase.sybaseconnection module
- sqlobject.tests package
- Submodules
- sqlobject.tests.dbtest module
- sqlobject.tests.test_ForeignKey module
SOTestComposerKeySOTestFKValidationASOTestFKValidationBSOTestFKValidationCSOTestFKValidationC.jSOTestFKValidationC.nameSOTestFKValidationC.qSOTestFKValidationC.sqlmetaSOTestFKValidationC.sqlmeta.childNameSOTestFKValidationC.sqlmeta.idNameSOTestFKValidationC.sqlmeta.idTypeSOTestFKValidationC.sqlmeta.indexesSOTestFKValidationC.sqlmeta.joinDefinitionsSOTestFKValidationC.sqlmeta.joinsSOTestFKValidationC.sqlmeta.soClassSOTestFKValidationC.sqlmeta.styleSOTestFKValidationC.sqlmeta.table
SOTestOtherColumnSOTestWorkKeySOTestWorkKey2test1()test2()test_foreignkey_validation()test_otherColumn()
- sqlobject.tests.test_ForeignKey_cascade module
SOTestMessageCascadeFalseSOTestMessageCascadeFalse.bodySOTestMessageCascadeFalse.jSOTestMessageCascadeFalse.qSOTestMessageCascadeFalse.recipientSOTestMessageCascadeFalse.recipientIDSOTestMessageCascadeFalse.senderSOTestMessageCascadeFalse.senderIDSOTestMessageCascadeFalse.sqlmetaSOTestMessageCascadeFalse.sqlmeta.childNameSOTestMessageCascadeFalse.sqlmeta.idNameSOTestMessageCascadeFalse.sqlmeta.indexesSOTestMessageCascadeFalse.sqlmeta.joinDefinitionsSOTestMessageCascadeFalse.sqlmeta.joinsSOTestMessageCascadeFalse.sqlmeta.soClassSOTestMessageCascadeFalse.sqlmeta.styleSOTestMessageCascadeFalse.sqlmeta.table
SOTestMessageCascadeMixedSOTestMessageCascadeMixed.bodySOTestMessageCascadeMixed.jSOTestMessageCascadeMixed.qSOTestMessageCascadeMixed.recipientSOTestMessageCascadeMixed.recipientIDSOTestMessageCascadeMixed.senderSOTestMessageCascadeMixed.senderIDSOTestMessageCascadeMixed.sqlmetaSOTestMessageCascadeMixed.sqlmeta.childNameSOTestMessageCascadeMixed.sqlmeta.idNameSOTestMessageCascadeMixed.sqlmeta.indexesSOTestMessageCascadeMixed.sqlmeta.joinDefinitionsSOTestMessageCascadeMixed.sqlmeta.joinsSOTestMessageCascadeMixed.sqlmeta.soClassSOTestMessageCascadeMixed.sqlmeta.styleSOTestMessageCascadeMixed.sqlmeta.table
SOTestMessageCascadeNullSOTestMessageCascadeNull.bodySOTestMessageCascadeNull.jSOTestMessageCascadeNull.qSOTestMessageCascadeNull.recipientSOTestMessageCascadeNull.recipientIDSOTestMessageCascadeNull.senderSOTestMessageCascadeNull.senderIDSOTestMessageCascadeNull.sqlmetaSOTestMessageCascadeNull.sqlmeta.childNameSOTestMessageCascadeNull.sqlmeta.idNameSOTestMessageCascadeNull.sqlmeta.indexesSOTestMessageCascadeNull.sqlmeta.joinDefinitionsSOTestMessageCascadeNull.sqlmeta.joinsSOTestMessageCascadeNull.sqlmeta.soClassSOTestMessageCascadeNull.sqlmeta.styleSOTestMessageCascadeNull.sqlmeta.table
SOTestMessageCascadeTrueSOTestMessageCascadeTrue.bodySOTestMessageCascadeTrue.jSOTestMessageCascadeTrue.qSOTestMessageCascadeTrue.recipientSOTestMessageCascadeTrue.recipientIDSOTestMessageCascadeTrue.senderSOTestMessageCascadeTrue.senderIDSOTestMessageCascadeTrue.sqlmetaSOTestMessageCascadeTrue.sqlmeta.childNameSOTestMessageCascadeTrue.sqlmeta.idNameSOTestMessageCascadeTrue.sqlmeta.indexesSOTestMessageCascadeTrue.sqlmeta.joinDefinitionsSOTestMessageCascadeTrue.sqlmeta.joinsSOTestMessageCascadeTrue.sqlmeta.soClassSOTestMessageCascadeTrue.sqlmeta.styleSOTestMessageCascadeTrue.sqlmeta.table
SOTestPerson1SOTestPerson2SOTestPerson3SOTestPerson4test1()test2()test3()test4()test5()
- sqlobject.tests.test_NoneValuedResultItem module
- sqlobject.tests.test_SQLMultipleJoin module
- sqlobject.tests.test_SQLRelatedJoin module
FighterRecGroupMapRecursiveGroupTourtmentcreateAllTables()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
SOTestSO1SOTestSO10SOTestSO11SOTestSO12SOTestSO2SOTestSO3SOTestSO4SOTestSO5SOTestSO6SOTestSO7SOTestSO8SOTestSO9StudentsetupGetters()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
ComplexComplexGroupUnitModeltest_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
NewSOTestClassNewSOTestClassConverter()SOTestClassSOTestClassConverter()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
ComplexCSVSimpleCSVassert_export()test_complex()test_simple()test_zip()
- sqlobject.tests.test_csvimport module
- sqlobject.tests.test_cyclic_reference module
SOTestCyclicRefASOTestCyclicRefBtest_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
NoCacheServiceServiceGrouptestDeleteBy()testDeleteMany()testDeleteRelatedJoins()testDestroySelf()testSelect()
- sqlobject.tests.test_distinct module
- sqlobject.tests.test_empty module
- sqlobject.tests.test_enum module
Enum1EnumUnicodeEnumWithDefaultNoneEnumWithDefaultOtherEnumWithNonetestBad()testDefaultNone()testDefaultOther()testNone()testUnicode()
- sqlobject.tests.test_events module
EventTesterInheritableEventTestAInheritableEventTestA.aInheritableEventTestA.childNameInheritableEventTestA.jInheritableEventTestA.qInheritableEventTestA.sqlmetaInheritableEventTestA.sqlmeta.childClassesInheritableEventTestA.sqlmeta.childNameInheritableEventTestA.sqlmeta.indexesInheritableEventTestA.sqlmeta.joinDefinitionsInheritableEventTestA.sqlmeta.joinsInheritableEventTestA.sqlmeta.parentClassInheritableEventTestA.sqlmeta.soClassInheritableEventTestA.sqlmeta.table
InheritableEventTestBInheritableEventTestB.aInheritableEventTestB.bInheritableEventTestB.childNameInheritableEventTestB.jInheritableEventTestB.qInheritableEventTestB.sqlmetaInheritableEventTestB.sqlmeta.childClassesInheritableEventTestB.sqlmeta.childNameInheritableEventTestB.sqlmeta.indexesInheritableEventTestB.sqlmeta.joinDefinitionsInheritableEventTestB.sqlmeta.joinsInheritableEventTestB.sqlmeta.parentClassInheritableEventTestB.sqlmeta.soClassInheritableEventTestB.sqlmeta.table
InheritableEventTestCInheritableEventTestC.bInheritableEventTestC.cInheritableEventTestC.childNameInheritableEventTestC.jInheritableEventTestC.qInheritableEventTestC.sqlmetaInheritableEventTestC.sqlmeta.childClassesInheritableEventTestC.sqlmeta.childNameInheritableEventTestC.sqlmeta.indexesInheritableEventTestC.sqlmeta.joinDefinitionsInheritableEventTestC.sqlmeta.joinsInheritableEventTestC.sqlmeta.parentClassInheritableEventTestC.sqlmeta.soClassInheritableEventTestC.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
SOTestExceptionSOTestExceptionWithNonexistingTableSOTestExceptionWithNonexistingTable.jSOTestExceptionWithNonexistingTable.qSOTestExceptionWithNonexistingTable.sqlmetaSOTestExceptionWithNonexistingTable.sqlmeta.childNameSOTestExceptionWithNonexistingTable.sqlmeta.idNameSOTestExceptionWithNonexistingTable.sqlmeta.indexesSOTestExceptionWithNonexistingTable.sqlmeta.joinDefinitionsSOTestExceptionWithNonexistingTable.sqlmeta.joinsSOTestExceptionWithNonexistingTable.sqlmeta.soClassSOTestExceptionWithNonexistingTable.sqlmeta.styleSOTestExceptionWithNonexistingTable.sqlmeta.table
test_exceptions()
- sqlobject.tests.test_expire module
- sqlobject.tests.test_groupBy module
- sqlobject.tests.test_identity module
- sqlobject.tests.test_indexes module
AddressIndexGet2PersonIndexGetPersonIndexGet2SOIndex1SOIndex2test_index_get_1()test_index_get_2()test_indexes_1()test_indexes_2()
- sqlobject.tests.test_inheritance module
- sqlobject.tests.test_joins module
AddressJoinerAddressJoiner2AddressJoiner3ExplicitJoiningSOImplicitJoiningSOPersonJoinerPersonJoiner2PersonJoiner3TestJoinTestJoin2TestJoin3
- 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
SOTestANYSOTestMySQLidSizeSOTestMySQLidSize.jSOTestMySQLidSize.qSOTestMySQLidSize.sqlmetaSOTestMySQLidSize.sqlmeta.childNameSOTestMySQLidSize.sqlmeta.idNameSOTestMySQLidSize.sqlmeta.idSizeSOTestMySQLidSize.sqlmeta.indexesSOTestMySQLidSize.sqlmeta.joinDefinitionsSOTestMySQLidSize.sqlmeta.joinsSOTestMySQLidSize.sqlmeta.soClassSOTestMySQLidSize.sqlmeta.styleSOTestMySQLidSize.sqlmeta.table
SOTestSOListMySQLtest_ANY()test_idSize()test_list_databases()test_list_tables()
- sqlobject.tests.test_new_joins module
AddressJNewAddressJNew2AddressJNew3ExplicitJoiningSONewImplicitJoiningSONewPersonJNewPersonJNew2PersonJNew3TestJoinTestJoin2TestJoin3
- 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
Counter2IterTestTestSelectUniqTestsetupIter()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
SRThrough1SRThrough2SRThrough3setup_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
SBAddressSBPersonsetup_module()testFK()testFK2()testInstance()testJoin()testJoin2()testRelatedJoin()testRelatedJoin2()
- sqlobject.tests.test_sqlite module
SQLiteFactoryTestSQLiteTruedivTestdo_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
SOStringIDSOStringID.byVal()SOStringID.firebirdCreateSOStringID.firebirdDropSOStringID.jSOStringID.mssqlCreateSOStringID.mssqlDropSOStringID.mysqlCreateSOStringID.mysqlDropSOStringID.postgresCreateSOStringID.postgresDropSOStringID.qSOStringID.sqliteCreateSOStringID.sqliteDropSOStringID.sqlmetaSOStringID.sybaseCreateSOStringID.val
test_stringID()
- sqlobject.tests.test_style module
- sqlobject.tests.test_subqueries module
SOTestIn1SOTestIn2SOTestOuterinsert()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
SOTestValidatorSOValidationSOValidationTestSOValidationTestBoolSOValidationTestFloatSOValidationTestIntTestValidation
- sqlobject.tests.test_views module
PhoneCallPhoneNumberViewPhoneViewPhoneCallViewPhoneInnerAggregateViewPhoneMoreViewPhoneMore2checkAttr()setup_module()testAliasOverride()testColumnSQLVPC()testDistinctCount()testGetVP()testGetVPC()testGetVPM()testInnerAggregate()testJoinView()testSelect()testSelect2()testSimpleVPC()
- Submodules
- sqlobject.util package
- sqlobject.versioning package
VersionVersioninggetColumns()- Subpackages
- sqlobject.versioning.test package
- Submodules
- sqlobject.versioning.test.test_version module
BaseChildExtraGovernmentHasAltIdHasForeignMonarchyMyClassVChildsetup()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
BLOBColBigIntColBoolColColCurrencyColDateColDateTimeColDecimalColDecimalStringColEnumColFloatColForeignKeyIntColJSONColJsonbColKeyColMediumIntColPickleColSOBLOBColSOBigIntColSOBoolColSOColSOCol.autoConstraints()SOCol.createSQL()SOCol.createValidators()SOCol.defaultSOCol.firebirdCreateSQL()SOCol.getDbEncoding()SOCol.joinNameSOCol.maxdbCreateSQL()SOCol.mssqlCreateSQL()SOCol.mysqlCreateSQL()SOCol.postgresCreateSQL()SOCol.sqliteCreateSQL()SOCol.sybaseCreateSQL()SOCol.validator
SOCurrencyColSODateColSODateTimeColSODecimalColSODecimalStringColSOEnumColSOFloatColSOForeignKeySOForeignKey.createValidators()SOForeignKey.maxdbCreateReferenceConstraint()SOForeignKey.maxdbCreateSQL()SOForeignKey.mssqlCreateReferenceConstraint()SOForeignKey.mssqlCreateSQL()SOForeignKey.mysqlCreateReferenceConstraint()SOForeignKey.mysqlCreateSQL()SOForeignKey.postgresCreateReferenceConstraint()SOForeignKey.postgresCreateSQL()SOForeignKey.sqliteCreateSQL()SOForeignKey.sybaseCreateReferenceConstraint()SOForeignKey.sybaseCreateSQL()
SOIntColSOJSONColSOJsonbColSOKeyColSOMediumIntColSOPickleColSOSetColSOSmallIntColSOStringColSOStringLikeColSOTimeColSOTimedeltaColSOTimestampColSOTinyIntColSOUnicodeColSOUuidColSetColSmallIntColStringColTimeColTimedeltaColTimestampColTinyIntColUnicodeColUuidColuse_microseconds()
- sqlobject.compat module
- sqlobject.conftest module
- sqlobject.constraints module
- sqlobject.converters module
BoolConverter()ConverterRegistryDateConverter()DateTimeConverter()DateTimeConverterMS()DecimalConverter()FloatConverter()IntConverter()LongConverter()NoneConverter()SequenceConverter()StringLikeConverter()StructTimeConverter()TimeConverter()TimeConverterMS()TimedeltaConverter()lookupConverter()quote_str()registerConverter()sqlrepr()unquote_str()
- sqlobject.dbconnection module
BooleanConnMethodWrapperConnWrapperConnectionHubConnectionURIOpenerConsoleWriterDBAPIDBAPI.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.dbNameDBAPI.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()
DBConnectionIterationLogWriterTransactionconnectionForURI()dbConnectionForScheme()makeDebugWriter()registerConnection()registerConnectionInstance()
- sqlobject.dberrors module
- sqlobject.declarative module
- sqlobject.events module
- sqlobject.index module
- sqlobject.joins module
- sqlobject.main module
- SQLObject
NoDefaultSQLObjectSQLObject.SelectResultsClassSQLObject.childNameSQLObject.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.sqlmetaSQLObject.sqlmeta.addColumn()SQLObject.sqlmeta.addColumnsFromDatabase()SQLObject.sqlmeta.addIndex()SQLObject.sqlmeta.addJoin()SQLObject.sqlmeta.asDict()SQLObject.sqlmeta.cacheValuesSQLObject.sqlmeta.childClassesSQLObject.sqlmeta.childNameSQLObject.sqlmeta.dbEncodingSQLObject.sqlmeta.defaultOrderSQLObject.sqlmeta.delColumn()SQLObject.sqlmeta.delJoin()SQLObject.sqlmeta.dirtySQLObject.sqlmeta.expireAll()SQLObject.sqlmeta.expiredSQLObject.sqlmeta.fromDatabaseSQLObject.sqlmeta.getColumns()SQLObject.sqlmeta.idNameSQLObject.sqlmeta.idSequenceSQLObject.sqlmeta.idSizeSQLObject.sqlmeta.idTypeSQLObject.sqlmeta.indexesSQLObject.sqlmeta.joinDefinitionsSQLObject.sqlmeta.joinsSQLObject.sqlmeta.lazyUpdateSQLObject.sqlmeta.parentClassSQLObject.sqlmeta.registrySQLObject.sqlmeta.send()SQLObject.sqlmeta.setClass()SQLObject.sqlmeta.styleSQLObject.sqlmeta.table
SQLObject.sqlrepr()SQLObject.sync()SQLObject.syncUpdate()SQLObject.tableExists()SQLObject.tablesUsedImmediate()
SQLObjectIntegrityErrorSQLObjectNotFoundgetID()getObject()sqlmetasqlmeta.addColumn()sqlmeta.addColumnsFromDatabase()sqlmeta.addIndex()sqlmeta.addJoin()sqlmeta.asDict()sqlmeta.cacheValuessqlmeta.childClassessqlmeta.childNamesqlmeta.dbEncodingsqlmeta.defaultOrdersqlmeta.delColumn()sqlmeta.delJoin()sqlmeta.dirtysqlmeta.expireAll()sqlmeta.expiredsqlmeta.fromDatabasesqlmeta.getColumns()sqlmeta.idNamesqlmeta.idSequencesqlmeta.idSizesqlmeta.idTypesqlmeta.indexessqlmeta.joinDefinitionssqlmeta.joinssqlmeta.lazyUpdatesqlmeta.parentClasssqlmeta.registrysqlmeta.send()sqlmeta.setClass()sqlmeta.stylesqlmeta.table
- sqlobject.sqlbuilder module
- sqlobject.sqlbuilder
- Disclaimer
- Instructions
ALL()AND()ANY()AliasAliasFieldAliasSQLMetaAliasTableCONCATCONTAINSSTRING()CROSSJOIN()ColumnASConstantSpaceDESCDeleteENDSWITH()EXISTS()FULLJOIN()FULLJOINConditional()FULLJOINOn()FULLJOINUsing()FULLOUTERJOIN()FULLOUTERJOINConditional()FULLOUTERJOINOn()FULLOUTERJOINUsing()FieldIN()INNERJOIN()INNERJOINConditional()INNERJOINOn()INNERJOINUsing()INSubqueryISNOTNULL()ISNULL()ImportProxyImportProxyFieldInsertJOIN()LEFTJOIN()LEFTJOINConditional()LEFTJOINOn()LEFTJOINUsing()LEFTOUTERJOIN()LEFTOUTERJOINConditional()LEFTOUTERJOINOn()LEFTOUTERJOINUsing()LIKENATURALFULLJOIN()NATURALFULLOUTERJOIN()NATURALJOIN()NATURALLEFTJOIN()NATURALLEFTOUTERJOIN()NATURALRIGHTJOIN()NATURALRIGHTOUTERJOIN()NOT()NOTEXISTS()NOTIN()NOTINSubqueryNoDefaultOR()OuterOuterFieldOuterTableRIGHTJOIN()RIGHTJOINConditional()RIGHTJOINOn()RIGHTJOINUsing()RIGHTOUTERJOIN()RIGHTOUTERJOINConditional()RIGHTOUTERJOINOn()RIGHTOUTERJOINUsing()RLIKEReplaceSOME()SQLCallSQLConstantSQLExprConverter()SQLExpressionSQLJoinSQLJoinConditionalSQLJoinOnSQLJoinUsingSQLModuloSQLObjectFieldSQLObjectStateSQLObjectTableSQLObjectTableWithJoinsSQLOpSQLPrefixSQLTrueClauseClassSTARTSWITH()STRAIGHTJOIN()SelectSubqueryTableTableSpaceUnionUpdateVersionErrordictToList()execute()sqlIdentifier()tablesUsedSet()
- sqlobject.sresults module
SelectResultsSelectResults.IterationClassSelectResults.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