def upgrade_310(conn): conn.execute("CREATE TABLE failed_url ( url_id INTEGER PRIMARY KEY, url TEXT, file_id INTEGER)") conn.execute("CREATE UNIQUE INDEX idx_failed_url_1 ON failed_url (url)") conn.execute("ALTER TABLE file ADD COLUMN searchapi_host VARCHAR") conn.commit() sddbversionutils.update_db_version(conn,'3.10')
def upgrade_35(conn): sddbnormalize.normalize_checksum_type(conn) conn.execute("alter table history add column selection_file_checksum TEXT") conn.execute("alter table history add column selection_file TEXT") conn.execute("update file set duration=cast(((julianday(end_date) - julianday(start_date)) * 86400.0) as integer) where status = 'done'") conn.execute("update file set duration=1 where duration=0 and status='done'") conn.execute("update file set rate=size/duration where status='done'") conn.commit() sddbversionutils.update_db_version(conn,'3.5')
def upgrade_30(conn): # put schema upgrade code if any sddbversionutils.update_db_version(conn,'3.0')
def upgrade_36(conn): # put schema upgrade code here if any sddbversionutils.update_db_version(conn, '3.6')