def create_record_table(table): create_sql = '''CREATE TABLE IF NOT EXISTS `%s` ( `%s` int(11) NOT NULL AUTO_INCREMENT, `%s` varchar(255) NOT NULL, `%s` int(11) NOT NULL, `%s` varchar(255) NOT NULL, `%s` varchar(255) NOT NULL, PRIMARY KEY (`%s`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;''' % \ (table, record.KEY_RECORD_ID, record.KEY_RECORD_URL, record.KEY_STATUS, record.KEY_STORE_PATH, record.KEY_EXTRA, record.KEY_RECORD_ID) _pool.execute(create_sql)
def delete(table, where_clause = ''): sql = '''DELETE FROM %s %s;''' % (table, where_clause) return _pool.execute(sql)
def update(table, record): sql = '''UPDATE %s SET %s='%s', %s=%s, %s='%s', %s='%s' WHERE %s=%s;''' % ( table, KEY_RECORD_URL, record.record_url, KEY_STATUS, record.status, KEY_STORE_PATH, record.store_path, KEY_EXTRA, record.extra, KEY_RECORD_ID, record.record_id) return _pool.execute(sql)
def insert(table, record): sql = '''INSERT INTO %s(%s, %s, %s, %s) VALUES('%s', %s, '%s', '%s');''' % (table, KEY_RECORD_URL, KEY_STATUS, KEY_STORE_PATH, KEY_EXTRA, record.record_url, record.status, record.store_path, record.extra) return _pool.execute(sql)