pythonjit._database

Provides a Object oriented interface for working with sqlite3 databases.

pythonjit uses a database to keep track of when source code changes, so that it knows when to recompile the static libraries.

This is a stripped down copy of pride.components.database. There are features present that are not used in pythonjit.

This module is a utility used by the library, and is not intended to be used in any other capacity.

Cache_Database

Database with the table structure expected by Import_Hook.

Instance defaults:

{'auto_commit': True,
 'connection': None,
 'cursor': None,
 'database_name': '',
 'detect_types_flags': 1,
 'return_cursor': False,
 'text_factory': <type 'str'>}

Method resolution order:

(<class 'pythonjit._database.Cache_Database'>,
 <class 'pythonjit._database.Database'>,
 <type 'object'>)

Database

An object with methods for dispatching sqlite3 commands.
Database objects may be simpler and safer then directly working with sqlite3 queries.
Note that database methods commit automatically when the auto_commit attribute is set to True (defaults to True).

Instance defaults:

{'auto_commit': True,
 'connection': None,
 'cursor': None,
 'database_name': '',
 'detect_types_flags': 1,
 'return_cursor': False,
 'text_factory': <type 'str'>}

Method resolution order:

(<class 'pythonjit._database.Database'>, <type 'object'>)

• update_table(self, table_name, where, arguments):

  No documentation available

Method resolution order:

(<class 'sqlite3.IntegrityError'>,
 <class 'sqlite3.DatabaseError'>,
 <class 'sqlite3.Error'>,
 <type 'exceptions.StandardError'>,
 <type 'exceptions.Exception'>,
 <type 'exceptions.BaseException'>,
 <type 'object'>)

• drop_table(self, table_name):

  Removes a table from the underlying sqlite3 database. Note that this will remove all entries in the specified table, and the data cannot be recovered.

• insert_or_replace(self, table_name, new_values):

  No documentation available

• delete_from(self, table_name, where):

  Removes an entry from the specified table. The where argument is a dictionary containing field name:value pairs.

• query(self, table_name, retrieve_fields, where, group_by, having, order_by, distinct):

  Retrieves information from the named database table. retrieve_fileds is an iterable containing string names of the fields that should be returned. The where argument is a dictionary of field name:value pairs.

• get_last_auto_increment_value(self, table_name):

  No documentation available

• alter_table(self, table_name, mode, argument):

  Alters the specified table. Available modes are "ADD" and "RENAME" argument should be an additional field definition or new name. Added columns are appended.

• open_database(self, database_name, text_factory):

  Opens database_name and obtain a sqlite3 connection and cursor. Database objects call this implicitly when initializing. Database objects wrap the connection and store the cursor as Database.cursor.

• table_info(self, table_name):

  Returns a generator which yields field information for the specified table. Entries consist of the field index, field name, field type, and more.

• create_table(self, table_name, fields, if_not_exists):

  Creates a table in the underlying sqlite3 database. fields is an iterable containing field names. The if_not_exists flag, which defaults to True, will only create the table if it does not exist already.

• insert_into(self, table_name, values, columns, batch):

  Inserts values into the specified table. The values must be the correct type and the correct amount. Value types and quantity can be introspected via the table_info method.

• delete(self):

  No documentation available

create_assignment_string

create_assignment_string(items):

Helper function used by Database objects

create_where_string

create_where_string(where):

Helper function used by Database objects

test_db

test_db():

Unit test for Database objects