Package biana :: Package BianaDB :: Module database :: Class TableDB

Class TableDB

This object will implement a database table

Instance Methods

__init__(self, table_name, table_fields, primary_key=(), indices=[], fulltext_indices=[])
Intializes the object source code

__str__(self)
str(x)

source code

set_primary_key(self, primary_key)

source code

has_optimized_fields(self)

source code

_has_optimized_fields(self)

source code

get_temp_table_name(self)

source code

add_field(self, new_field)

source code

has_field(self, field_name)

source code

get_fields(self)

source code

get_table_name(self)

source code

set_table_name(self, new_name)

source code

get_field(self, field_name)

source code

add_indice(self, indice)

source code

has_indice(self, indice)
Checks if the table contains an indice with those fields

source code

get_optimize_queries(self)

source code

get_analyze_query(self)

source code

get_SQLSearchStatement(self, field, value_list)

source code

get_SQLSelectStatement(self, field_list)

source code

create_mysql_query(self, created_unique_tables={}, ignore_primary_key=False) source code

get_temp_table(self)

source code

get_drop_query(self)

source code

empty_temporal_table_sql_query(self, _skip_first=None)

source code

Inherited from object: __delattr__, __getattribute__, __hash__, __new__, __reduce__, __reduce_ex__, __repr__, __setattr__

Properties

[hide private]

Inherited from object: __class__

Method Details

[hide private]

init(self, table_name, table_fields, primary_key=`()`, indices=`[]`, fulltext_indices=`[]`)
(Constructor)

source code

Intializes the object

"table_name" will be the table name in the database "table_fields" will be a list of fieldDB Objects "primary_key" A tuple or list of the name of the fields that form the primary_key "indices": a list of tuples with the name of the fields that form the indices

Overrides: object.__init__

str(self)
(Informal representation operator)

source code

str(x)

Overrides: object.__str__: (inherited documentation)

Class TableDB

__init__(self, table_name, table_fields, primary_key=(), indices=[], fulltext_indices=[]) (Constructor)

__str__(self) (Informal representation operator)

init(self, table_name, table_fields, primary_key=`()`, indices=`[]`, fulltext_indices=`[]`)
(Constructor)

str(self)
(Informal representation operator)