Index

_

__init__() (sqbooster.backends.DatabaseBackend method)

A

add() (sqbooster.simple.SimpleClient method)

all() (sqbooster.query.InMemoryQuery method) (sqbooster.query.Query method)

B

backend (sqbooster.simple.SimpleClient property) Blob (class in sqbooster.types)

Boolean (class in sqbooster.types) build() (sqbooster.query.Query method) build_count() (sqbooster.query.Query method)

C

clear() (sqbooster.backends.DatabaseBackend method) close() (sqbooster.backends.DatabaseBackend method) (sqbooster.backends.sqlite.SQLiteBackend method) (sqbooster.databases.jsonfile.JSONFileDatabase method) (sqbooster.databases.picklefile.PickleFileDatabase method) (sqbooster.simple.SimpleClient method) Column (class in sqbooster.schema) ColumnType (class in sqbooster.types) commit() (sqbooster.backends.sqlite.SQLiteBackend method) count() (sqbooster.backends.DatabaseBackend method) (sqbooster.backends.sqlite.SQLiteBackend method) (sqbooster.databases.jsonfile.JSONFileDatabase method) (sqbooster.databases.picklefile.PickleFileDatabase method) (sqbooster.query.InMemoryQuery method) (sqbooster.query.Query method) (sqbooster.simple.SimpleClient method)

create_table() (sqbooster.backends.DatabaseBackend method) (sqbooster.backends.sqlite.SQLiteBackend method) (sqbooster.databases.jsonfile.JSONFileDatabase method) (sqbooster.databases.picklefile.PickleFileDatabase method) (sqbooster.simple.SimpleClient method)

D

DatabaseBackend (class in sqbooster.backends) define() (sqbooster.simple.SimpleClient method) delete() (sqbooster.backends.DatabaseBackend method) (sqbooster.backends.sqlite.SQLiteBackend method) (sqbooster.databases.jsonfile.JSONFileDatabase method) (sqbooster.databases.picklefile.PickleFileDatabase method) (sqbooster.simple.SimpleClient method) delete_database() (sqbooster.backends.DatabaseBackend method) (sqbooster.backends.sqlite.SQLiteBackend method) (sqbooster.databases.jsonfile.JSONFileDatabase method) (sqbooster.databases.picklefile.PickleFileDatabase method)

delete_key() (sqbooster.backends.DatabaseBackend method) (sqbooster.backends.sqlite.SQLiteBackend method) (sqbooster.databases.jsonfile.JSONFileDatabase method) (sqbooster.databases.picklefile.PickleFileDatabase method) (sqbooster.simple.SimpleClient method) drop() (sqbooster.simple.SimpleClient method) drop_table() (sqbooster.backends.DatabaseBackend method) (sqbooster.backends.sqlite.SQLiteBackend method) (sqbooster.databases.jsonfile.JSONFileDatabase method) (sqbooster.databases.picklefile.PickleFileDatabase method)

E

execute() (sqbooster.backends.DatabaseBackend method) (sqbooster.backends.sqlite.SQLiteBackend method) (sqbooster.databases.jsonfile.JSONFileDatabase method) (sqbooster.databases.picklefile.PickleFileDatabase method) exists() (sqbooster.backends.DatabaseBackend method) (sqbooster.backends.sqlite.SQLiteBackend method) (sqbooster.databases.jsonfile.JSONFileDatabase method) (sqbooster.databases.picklefile.PickleFileDatabase method) (sqbooster.query.InMemoryQuery method) (sqbooster.query.Query method) (sqbooster.simple.SimpleClient method)

F

filter() (sqbooster.query.InMemoryQuery method) (sqbooster.query.Query method) find() (sqbooster.simple.SimpleClient method) first() (sqbooster.query.InMemoryQuery method) (sqbooster.query.Query method) Float (class in sqbooster.types) from_sql() (sqbooster.types.Blob method) (sqbooster.types.Boolean method) (sqbooster.types.ColumnType method) (sqbooster.types.Float method) (sqbooster.types.Integer method) (sqbooster.types.JSON method) (sqbooster.types.Pickle method) (sqbooster.types.Real method) (sqbooster.types.Text method) (sqbooster.types.Timestamp method) (sqbooster.types.VARCHAR method)

G

get() (sqbooster.simple.SimpleClient method) get_column() (sqbooster.schema.TableSchema method) get_schema() (sqbooster.backends.DatabaseBackend method) (sqbooster.backends.sqlite.SQLiteBackend method) (sqbooster.databases.jsonfile.JSONFileDatabase method) (sqbooster.databases.picklefile.PickleFileDatabase method) (sqbooster.simple.SimpleClient method) get_size() (sqbooster.backends.DatabaseBackend method) (sqbooster.backends.sqlite.SQLiteBackend method) (sqbooster.databases.jsonfile.JSONFileDatabase method) (sqbooster.databases.picklefile.PickleFileDatabase method)

get_tables() (sqbooster.backends.DatabaseBackend method) (sqbooster.backends.sqlite.SQLiteBackend method) (sqbooster.databases.jsonfile.JSONFileDatabase method) (sqbooster.databases.picklefile.PickleFileDatabase method) (sqbooster.simple.SimpleClient method)

H

has() (sqbooster.simple.SimpleClient method)

has_column() (sqbooster.schema.TableSchema method)

I

InMemoryQuery (class in sqbooster.query) insert() (sqbooster.backends.DatabaseBackend method) (sqbooster.backends.sqlite.SQLiteBackend method) (sqbooster.databases.jsonfile.JSONFileDatabase method) (sqbooster.databases.picklefile.PickleFileDatabase method)

insert_many() (sqbooster.backends.DatabaseBackend method) (sqbooster.backends.sqlite.SQLiteBackend method) (sqbooster.databases.jsonfile.JSONFileDatabase method) (sqbooster.databases.picklefile.PickleFileDatabase method) (sqbooster.simple.SimpleClient method) Integer (class in sqbooster.types)

J

JSON (class in sqbooster.types) json() (in module sqbooster) (sqbooster.simple.SimpleClient class method)

JSONFileDatabase (class in sqbooster.databases.jsonfile)

K

keys() (sqbooster.backends.DatabaseBackend method) (sqbooster.backends.sqlite.SQLiteBackend method) (sqbooster.databases.jsonfile.JSONFileDatabase method) (sqbooster.databases.picklefile.PickleFileDatabase method) (sqbooster.simple.SimpleClient method)

L

limit() (sqbooster.query.InMemoryQuery method) (sqbooster.query.Query method)

M

module sqbooster sqbooster.backends sqbooster.backends.postgresql sqbooster.backends.sqlite sqbooster.databases.jsonfile sqbooster.databases.mongo sqbooster.databases.picklefile sqbooster.databases.redis sqbooster.query sqbooster.schema sqbooster.simple sqbooster.types

mongo() (in module sqbooster) (sqbooster.simple.SimpleClient class method) MongoDatabase (class in sqbooster.databases.mongo)

O

offset() (sqbooster.query.InMemoryQuery method) (sqbooster.query.Query method) one() (sqbooster.query.InMemoryQuery method) (sqbooster.query.Query method)

order_by() (sqbooster.query.InMemoryQuery method) (sqbooster.query.Query method)

P

Pickle (class in sqbooster.types) pickle() (in module sqbooster) (sqbooster.simple.SimpleClient class method) PickleFileDatabase (class in sqbooster.databases.picklefile) placeholder (sqbooster.backends.DatabaseBackend property) (sqbooster.backends.sqlite.SQLiteBackend attribute) (sqbooster.databases.jsonfile.JSONFileDatabase attribute) (sqbooster.databases.picklefile.PickleFileDatabase attribute) (sqbooster.query.Query property) postgresql() (in module sqbooster) (sqbooster.simple.SimpleClient class method) PostgreSQLBackend (class in sqbooster.backends.postgresql)

prepare_insert() (sqbooster.schema.TableSchema method) primary_key (sqbooster.schema.TableSchema property) python_type (sqbooster.types.Blob attribute) (sqbooster.types.Boolean attribute) (sqbooster.types.ColumnType attribute) (sqbooster.types.Float attribute) (sqbooster.types.Integer attribute) (sqbooster.types.JSON attribute) (sqbooster.types.Pickle attribute) (sqbooster.types.Real attribute) (sqbooster.types.Text attribute) (sqbooster.types.Timestamp attribute) (sqbooster.types.VARCHAR attribute)

Q

Query (class in sqbooster.query) query() (sqbooster.backends.DatabaseBackend method) (sqbooster.backends.sqlite.SQLiteBackend method) (sqbooster.databases.jsonfile.JSONFileDatabase method) (sqbooster.databases.picklefile.PickleFileDatabase method) (sqbooster.simple.SimpleClient method)

R

read() (sqbooster.backends.DatabaseBackend method) (sqbooster.backends.sqlite.SQLiteBackend method) (sqbooster.databases.jsonfile.JSONFileDatabase method) (sqbooster.databases.picklefile.PickleFileDatabase method) (sqbooster.simple.SimpleClient method) Real (class in sqbooster.types) redis() (in module sqbooster) (sqbooster.simple.SimpleClient class method)

RedisDatabase (class in sqbooster.databases.redis) remove() (sqbooster.simple.SimpleClient method) remove_database() (sqbooster.backends.sqlite.SQLiteBackend method) (sqbooster.databases.jsonfile.JSONFileDatabase method) (sqbooster.databases.picklefile.PickleFileDatabase method) rollback() (sqbooster.backends.sqlite.SQLiteBackend method) row_to_dict() (sqbooster.schema.TableSchema method)

S

select() (sqbooster.query.InMemoryQuery method) (sqbooster.query.Query method) SimpleClient (class in sqbooster.simple) sqbooster module sqbooster.backends module sqbooster.backends.postgresql module sqbooster.backends.sqlite module sqbooster.databases.jsonfile module sqbooster.databases.mongo module sqbooster.databases.picklefile module sqbooster.databases.redis module sqbooster.query module

sqbooster.schema module sqbooster.simple module sqbooster.types module sql_type (sqbooster.schema.Column property) (sqbooster.types.Blob attribute) (sqbooster.types.Boolean attribute) (sqbooster.types.ColumnType attribute) (sqbooster.types.Float attribute) (sqbooster.types.Integer attribute) (sqbooster.types.JSON attribute) (sqbooster.types.Pickle attribute) (sqbooster.types.Real attribute) (sqbooster.types.Text attribute) (sqbooster.types.Timestamp attribute) (sqbooster.types.VARCHAR attribute) sql_type_with_length (sqbooster.types.VARCHAR property) sqlite() (in module sqbooster) (sqbooster.simple.SimpleClient class method) SQLiteBackend (class in sqbooster.backends.sqlite)

T

table_exists() (sqbooster.backends.DatabaseBackend method) (sqbooster.backends.sqlite.SQLiteBackend method) (sqbooster.databases.jsonfile.JSONFileDatabase method) (sqbooster.databases.picklefile.PickleFileDatabase method) tables() (sqbooster.simple.SimpleClient method) TableSchema (class in sqbooster.schema) Text (class in sqbooster.types) Timestamp (class in sqbooster.types) to_python() (sqbooster.schema.Column method) to_sql() (sqbooster.schema.Column method) (sqbooster.types.Blob method) (sqbooster.types.Boolean method) (sqbooster.types.ColumnType method) (sqbooster.types.Float method) (sqbooster.types.Integer method) (sqbooster.types.JSON method) (sqbooster.types.Pickle method) (sqbooster.types.Real method) (sqbooster.types.Text method) (sqbooster.types.Timestamp method) (sqbooster.types.VARCHAR method)

to_sql_create() (sqbooster.schema.TableSchema method) to_sql_definition() (sqbooster.schema.Column method)

U

update() (sqbooster.backends.DatabaseBackend method) (sqbooster.backends.sqlite.SQLiteBackend method) (sqbooster.databases.jsonfile.JSONFileDatabase method) (sqbooster.databases.picklefile.PickleFileDatabase method) (sqbooster.simple.SimpleClient method)

V

validate_row() (sqbooster.schema.TableSchema method)

VARCHAR (class in sqbooster.types)

W

write() (sqbooster.backends.DatabaseBackend method) (sqbooster.backends.sqlite.SQLiteBackend method) (sqbooster.databases.jsonfile.JSONFileDatabase method) (sqbooster.databases.picklefile.PickleFileDatabase method) (sqbooster.simple.SimpleClient method)