def create_table (self):
"""
Creates the table in the database for the entity if and only if the
table does not already exist.
NOTE: This method is used by the tools script for creating the
entity tables.
"""
if table_exists(self):
logging.warning('Entity Table %s already exists in database' % (
self.table
))
return
logging.info('Creating Entity Table %s' % (self.table))
sql = """CREATE TABLE IF NOT EXISTS %s (
added_id int auto_increment not null,
id binary(16) not null,
data mediumblob not null,
create_date int not null,
update_date int not null,
PRIMARY KEY(added_id),
UNIQUE(id)
) CHARSET=utf8 COLLATE=utf8_unicode_ci ENGINE=InnoDB""" % (
self.table
)
self.db.execute(sql)
def create_table (self):
"""
Creates the table in the database for this index if and only if the
table does not already exist.
NOTE: This method is used by the tools script for creating the
tables for indexes.
"""
if table_exists(self):
logging.warning('Index Table %s already exists in database' % (
self.table
))
return
logging.info('Creating Index Table %s' % (self.table))
property_type = 'varchar(255)'
if self.relationship:
property_type = 'binary(16)'
sql = """CREATE TABLE IF NOT EXISTS %s (
%s binary(16) not null,
%s %s not null,
datetime int not null,
PRIMARY KEY (%s,%s)
) CHARSET=utf8 COLLATE=utf8_unicode_ci ENGINE=InnoDB""" % (
self.table,
self.entity_key_id,
self.property,
property_type,
self.entity_key_id,
self.property
)
self.db.execute(sql)
