Module Import alias Import alias ImportFrom alias ImportFrom alias Expr Str Assign NameStore ListLoad Str Str Assign NameStore ListLoad Str Str FunctionDef arguments args NameParam defaults body For NameStore NameLoad body Expr Yield Call AttributeLoad NameLoad attr NameLoad Assign NameStore Yield Call AttributeLoad NameLoad attr Str Assign NameStore ListLoad For NameStore NameLoad body Assign NameStore SubscriptLoad NameLoad Index Num If SubscriptLoad NameLoad Index Num body Assign NameStore Call AttributeLoad AttributeLoad NameLoad attr attr SubscriptLoad NameLoad Index Num Str Assign NameStore Call AttributeLoad NameLoad attr Call AttributeLoad NameLoad attr orelse Assign NameStore NameLoad If SubscriptLoad NameLoad Index Num body Assign NameStore Call AttributeLoad AttributeLoad NameLoad attr attr SubscriptLoad NameLoad Index Num Str Assign NameStore Call AttributeLoad NameLoad attr Call AttributeLoad NameLoad attr orelse Assign NameStore NameLoad Expr Call AttributeLoad NameLoad attr TupleLoad NameLoad NameLoad NameLoad For TupleStore NameStore NameStore NameStore NameLoad body Expr Yield Call AttributeLoad NameLoad attr Str TupleLoad NameLoad NameLoad NameLoad For NameStore NameLoad body Expr Yield Call AttributeLoad NameLoad attr NameLoad Expr Yield Call AttributeLoad NameLoad attr Str decorator_list AttributeLoad NameLoad attr
N/A N/A time N/A datetime pappyproxy http twisted.internet defer N/A 
Schema v6

Description:
Replaces the string representation of times with unix times so that we can select
by most recent first. Also deletes old tag column.
 N/A update_queries N/A 
    CREATE TABLE requests_new (
        id                INTEGER   PRIMARY KEY  AUTOINCREMENT,
        full_request      BLOB      NOT NULL,
        submitted         INTEGER   NOT NULL,
        response_id       INTEGER   REFERENCES responses(id),
        unmangled_id      INTEGER   REFERENCES requests(id),
        port              INTEGER,
        is_ssl            INTEGER,
        host              TEXT,
        plugin_data       TEXT,
        start_datetime    REAL,
        end_datetime      REAL
    );
     
    INSERT INTO requests_new (id, full_request, submitted, response_id, unmangled_id, port, is_ssl, host, plugin_data) SELECT id, full_request, submitted, response_id, unmangled_id, port, is_ssl, host, plugin_data FROM requests;
     N/A drop_queries N/A 
    DROP TABLE requests;
     
    ALTER TABLE requests_new RENAME TO requests;
     update N/A N/A dbpool N/A N/A N/A query update_queries N/A N/A N/A N/A N/A dbpool runQuery query N/A reqrows N/A N/A N/A dbpool runQuery 
        SELECT id, start_datetime, end_datetime
        FROM requests;
         N/A new_times N/A N/A row reqrows N/A N/A reqid N/A row N/A 0 N/A N/A row N/A 1 N/A N/A start_datetime N/A N/A N/A datetime datetime strptime N/A row N/A 1 %Y-%m-%dT%H:%M:%S.%f N/A start_unix_time N/A N/A time mktime N/A N/A start_datetime timetuple N/A N/A start_unix_time None N/A N/A row N/A 2 N/A N/A end_datetime N/A N/A N/A datetime datetime strptime N/A row N/A 2 %Y-%m-%dT%H:%M:%S.%f N/A end_unix_time N/A N/A time mktime N/A N/A end_datetime timetuple N/A N/A end_unix_time None N/A N/A N/A new_times append N/A reqid start_unix_time end_unix_time N/A N/A reqid start_unix_time end_unix_time new_times N/A N/A N/A N/A N/A dbpool runQuery 
            UPDATE requests_new SET start_datetime=?, end_datetime=? WHERE id=?;
             N/A start_unix_time end_unix_time reqid N/A query drop_queries N/A N/A N/A N/A N/A dbpool runQuery query N/A N/A N/A N/A dbpool runQuery 
        UPDATE schema_meta SET version=6;
         N/A N/A defer inlineCallbacks