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')