Module Expr Str Import alias alias ImportFrom alias ImportFrom alias alias ImportFrom alias ImportFrom alias ImportFrom alias ImportFrom alias ImportFrom alias alias alias FunctionDef arguments args NameParam NameParam NameParam NameParam NameParam NameParam NameParam NameParam NameParam defaults NameLoad NameLoad NameLoad NameLoad NameLoad NameLoad Str NameLoad kwarg body Assign NameStore NameLoad TryExcept body Assign NameStore Call NameLoad NameLoad NameLoad NameLoad NameLoad NameLoad NameLoad NameLoad NameLoad Expr Call AttributeLoad NameLoad attr Expr Call AttributeLoad NameLoad attr keyword NameLoad Expr Call AttributeLoad NameLoad attr handlers ExceptHandler type NameLoad name NameStore body If CompareIsNot NameLoad NameLoad body TryExcept body Expr Call AttributeLoad NameLoad attr keyword NameLoad handlers ExceptHandler type NameLoad name NameStore body Pass Raise decorator_list FunctionDef arguments args NameParam NameParam NameParam defaults Num body Return Call NameLoad NameLoad NameLoad NameLoad keyword Str decorator_list Assign NameStore Set Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str ClassDef bases NameLoad body FunctionDef arguments args NameParam defaults body Assign NameStore BinOpSub NameLoad Call AttributeLoad NameLoad attr If CompareEq NameLoad NameLoad body Expr Call AttributeLoad NameLoad attr Str Expr Call AttributeLoad NameLoad attr Str Str TupleLoad Str TupleLoad Str TupleLoad TupleLoad Str TupleLoad Str TupleLoad Str Expr Call AttributeLoad NameLoad attr Str Str TupleLoad Str TupleLoad Str TupleLoad TupleLoad Str TupleLoad Str Expr Call AttributeLoad NameLoad attr Str Str TupleLoad Str TupleLoad Str TupleLoad TupleLoad Str TupleLoad Str TupleLoad Str Assign NameStore BinOpSub NameLoad Call AttributeLoad NameLoad attr If NameLoad body Raise Call NameLoad Str Call NameLoad Str keyword Call AttributeLoad Str attr GeneratorExp NameLoad comprehension NameStore Call NameLoad NameLoad decorator_list FunctionDef arguments args NameParam NameParam defaults body TryExcept body ImportFrom alias Expr Call AttributeLoad NameLoad attr AttributeLoad NameLoad attr Expr Call AttributeLoad NameLoad attr Expr Call AttributeLoad NameLoad attr Assign NameStore Call AttributeLoad NameLoad attr Expr Call AttributeLoad NameLoad attr NameLoad Expr Call AttributeLoad NameLoad attr Expr Call AttributeLoad NameLoad attr Expr Call AttributeLoad NameLoad attr Expr Call AttributeLoad NameLoad attr Expr Call AttributeLoad NameLoad attr Expr Call AttributeLoad NameLoad attr Expr Call AttributeLoad NameLoad attr Expr Call AttributeLoad NameLoad attr Expr Call AttributeLoad NameLoad attr Expr Call AttributeLoad AttributeLoad NameLoad attr attr Call NameLoad Str BinOpSub Call AttributeLoad NameLoad attr NameLoad Assign NameStore Call AttributeLoad NameLoad attr Expr Call AttributeLoad NameLoad attr Expr Call AttributeLoad AttributeLoad NameLoad attr attr Call NameLoad Str BinOpSub Call AttributeLoad NameLoad attr NameLoad Assign NameStore Call AttributeLoad NameLoad attr Expr Call AttributeLoad NameLoad attr Str Expr Call AttributeLoad NameLoad attr Expr Call AttributeLoad AttributeLoad NameLoad attr attr Call NameLoad Str BinOpSub Call AttributeLoad NameLoad attr NameLoad Expr Call AttributeLoad NameLoad attr Str keyword Num handlers ExceptHandler type NameLoad name NameStore body Expr Call AttributeLoad NameLoad attr Str keyword Num Raise decorator_list FunctionDef arguments args NameParam NameParam defaults body Assign AttributeStore NameLoad attr Str Expr Call AttributeLoad NameLoad attr Str If CompareIs NameLoad NameLoad body Assign NameStore Call AttributeLoad NameLoad attr Assign NameStore Call AttributeLoad AttributeLoad NameLoad attr attr NameLoad Assign NameStore Call AttributeLoad NameLoad attr AttributeLoad NameLoad attr AttributeLoad NameLoad attr AttributeLoad NameLoad attr Assign NameStore Call AttributeLoad NameLoad attr Str Str TupleLoad Str Str Str Str Str TupleLoad Str TupleLoad TupleLoad NameLoad Num AttributeLoad AttributeLoad AttributeLoad NameLoad attr attr attr AttributeLoad AttributeLoad NameLoad attr attr Call NameLoad Call NameLoad NameLoad keyword NameLoad keyword NameLoad orelse Assign NameStore Call AttributeLoad NameLoad attr Str Str TupleLoad Str Str Str Str Str Str Str Str Str Str TupleLoad Str TupleLoad TupleLoad AttributeLoad NameLoad attr NameLoad BoolOpOr AttributeLoad NameLoad attr AttributeLoad AttributeLoad NameLoad attr attr BoolOpOr AttributeLoad NameLoad attr Num AttributeLoad NameLoad attr AttributeLoad AttributeLoad AttributeLoad NameLoad attr attr attr BoolOpOr AttributeLoad NameLoad attr Num AttributeLoad NameLoad attr AttributeLoad NameLoad attr BoolOpOr AttributeLoad NameLoad attr Str keyword NameLoad keyword NameLoad For TupleStore NameStore NameStore NameStore NameLoad body Assign AttributeStore NameLoad attr NameLoad Assign AttributeStore NameLoad attr NameLoad Break decorator_list FunctionDef arguments args NameParam defaults body Assign NameStore BinOpBitOr BinOpBitOr BinOpBitOr BinOpBitOr Call NameLoad Call AttributeLoad AttributeLoad AttributeLoad NameLoad attr attr attr Call NameLoad Call AttributeLoad AttributeLoad AttributeLoad NameLoad attr attr attr Call NameLoad Call AttributeLoad AttributeLoad NameLoad attr attr Call NameLoad Call AttributeLoad AttributeLoad AttributeLoad NameLoad attr attr attr AttributeLoad NameLoad attr Expr Call AttributeLoad NameLoad attr Str Assign NameStore Call AttributeLoad NameLoad attr Str Str TupleLoad Str TupleLoad Str Call NameLoad GeneratorExp TupleLoad NameLoad comprehension NameStore NameLoad keyword NameLoad Assign AttributeStore NameLoad attr Call NameLoad GeneratorExp TupleLoad NameLoad NameLoad comprehension TupleStore NameStore NameStore NameLoad decorator_list FunctionDef arguments args NameParam defaults body Assign NameStore BinOpBitOr BinOpBitOr BinOpBitOr Call NameLoad Call AttributeLoad AttributeLoad AttributeLoad NameLoad attr attr attr Call NameLoad Call AttributeLoad AttributeLoad AttributeLoad NameLoad attr attr attr Call NameLoad Call AttributeLoad AttributeLoad AttributeLoad NameLoad attr attr attr Call NameLoad GeneratorExp NameLoad comprehension NameStore Call AttributeLoad AttributeLoad AttributeLoad NameLoad attr attr attr comprehension NameStore AttributeLoad NameLoad attr comprehension NameStore NameLoad Expr Call AttributeLoad NameLoad attr Str Assign NameStore Call AttributeLoad NameLoad attr Str Str TupleLoad Str Str TupleLoad Str Str Call NameLoad GeneratorExp TupleLoad AttributeLoad NameLoad attr AttributeLoad NameLoad attr comprehension NameStore NameLoad keyword NameLoad Assign AttributeStore NameLoad attr Call NameLoad GeneratorExp TupleLoad Call NameLoad NameLoad NameLoad NameLoad comprehension TupleStore NameStore NameStore NameStore NameLoad decorator_list FunctionDef arguments args NameParam defaults body Expr Call AttributeLoad NameLoad attr Str If AttributeLoad AttributeLoad NameLoad attr attr body Assign NameStore AttributeLoad AttributeLoad NameLoad attr attr orelse Assign NameStore Call AttributeLoad AttributeLoad AttributeLoad NameLoad attr attr attr Assign NameStore Call AttributeLoad NameLoad attr Str Str TupleLoad Str Str Str Str TupleLoad Str Call NameLoad GeneratorExp TupleLoad NameLoad NameLoad Num Call AttributeLoad AttributeLoad AttributeLoad NameLoad attr attr attr NameLoad NameLoad comprehension NameStore NameLoad keyword NameLoad Assign AttributeStore NameLoad attr Call NameLoad GeneratorExp TupleLoad NameLoad NameLoad comprehension TupleStore NameStore NameStore NameLoad decorator_list FunctionDef arguments args NameParam defaults body Assign AttributeStore NameLoad attr Dict Assign NameStore Call NameLoad For NameStore Call AttributeLoad AttributeLoad AttributeLoad NameLoad attr attr attr body If CompareEq AttributeLoad NameLoad attr AttributeLoad NameLoad attr body Expr Call AttributeLoad NameLoad attr Call AttributeLoad NameLoad attr AttributeLoad NameLoad attr If NameLoad body Assign NameStore Call AttributeLoad NameLoad attr BinOpAdd BinOpAdd Str Call AttributeLoad Str attr NameLoad Str Assign AttributeStore NameLoad attr Call NameLoad GeneratorExp TupleLoad NameLoad NameLoad comprehension TupleStore NameStore NameStore NameLoad decorator_list FunctionDef arguments args NameParam defaults body Assign AttributeStore NameLoad attr ListComp TupleLoad NameLoad NameLoad NameLoad NameLoad comprehension TupleStore NameStore NameStore NameStore NameStore Call AttributeLoad AttributeLoad AttributeLoad NameLoad attr attr attr BoolOpAnd NameLoad BoolOpOr Call AttributeLoad NameLoad attr Str BoolOpAnd NameLoad NameLoad Assign NameStore Call NameLoad GeneratorExp AttributeLoad NameLoad attr comprehension NameStore AttributeLoad AttributeLoad NameLoad attr attr For NameStore Call AttributeLoad AttributeLoad AttributeLoad NameLoad attr attr attr body For NameStore Call AttributeLoad AttributeLoad NameLoad attr attr body Expr Call AttributeLoad NameLoad attr AttributeLoad NameLoad attr If AttributeLoad NameLoad attr body Expr Call AttributeLoad NameLoad attr AttributeLoad NameLoad attr orelse Expr Call AttributeLoad NameLoad attr AttributeLoad AttributeLoad NameLoad attr attr For TupleStore NameStore NameStore Call AttributeLoad AttributeLoad AttributeLoad NameLoad attr attr attr body Expr Call AttributeLoad NameLoad attr NameLoad Expr Call AttributeLoad NameLoad attr NameLoad For NameStore AttributeLoad NameLoad attr body Assign NameStore Call AttributeLoad AttributeLoad NameLoad attr attr NameLoad For NameStore AttributeLoad NameLoad attr body If Call NameLoad AttributeLoad NameLoad attr NameLoad body Expr Call AttributeLoad NameLoad attr AttributeLoad NameLoad attr If Call NameLoad AttributeLoad NameLoad attr NameLoad body Expr Call AttributeLoad NameLoad attr AttributeLoad NameLoad attr For NameStore TupleLoad AttributeLoad NameLoad attr AttributeLoad NameLoad attr AttributeLoad NameLoad attr body Expr Call AttributeLoad NameLoad attr SubscriptLoad AttributeLoad AttributeLoad NameLoad attr attr Index NameLoad AugAssignSub NameStore Set NameLoad Assign AttributeStore NameLoad attr NameLoad decorator_list FunctionDef arguments args NameParam defaults body Expr Call AttributeLoad NameLoad attr Str Assign NameStore Call AttributeLoad NameLoad attr Str Str TupleLoad Str TupleLoad Str Call NameLoad GeneratorExp TupleLoad NameLoad comprehension NameStore Call AttributeLoad AttributeLoad AttributeLoad NameLoad attr attr attr CompareNotIn NameLoad AttributeLoad NameLoad attr keyword NameLoad Assign AttributeStore NameLoad attr Call NameLoad GeneratorExp TupleLoad NameLoad NameLoad comprehension TupleStore NameStore NameStore NameLoad Expr Call AttributeLoad AttributeLoad NameLoad attr attr AttributeLoad NameLoad attr Assign NameStore Call AttributeLoad NameLoad attr Str Str TupleLoad Str Str TupleLoad Str Call NameLoad GeneratorExp TupleLoad AttributeLoad NameLoad attr NameLoad comprehension NameStore Call AttributeLoad AttributeLoad NameLoad attr attr keyword NameLoad decorator_list FunctionDef arguments args NameParam defaults body Expr Call AttributeLoad NameLoad attr Str Assign NameStore Call NameLoad GeneratorExp TupleLoad TupleLoad SubscriptLoad AttributeLoad NameLoad attr Index AttributeLoad AttributeLoad NameLoad attr attr SubscriptLoad AttributeLoad NameLoad attr Index AttributeLoad NameLoad attr NameLoad comprehension NameStore Call AttributeLoad AttributeLoad AttributeLoad NameLoad attr attr attr comprehension NameStore NameLoad CompareNotIn AttributeLoad AttributeLoad NameLoad attr attr AttributeLoad NameLoad attr Assign NameStore Call AttributeLoad NameLoad attr Str Str TupleLoad Str Str Str Str TupleLoad Str Str Call NameLoad GeneratorExp TupleLoad SubscriptLoad NameLoad Index Num SubscriptLoad NameLoad Index Num AttributeLoad NameLoad attr SubscriptLoad Dict Str Str Str Num Num Num Index AttributeLoad NameLoad attr comprehension TupleStore NameStore NameStore Call AttributeLoad NameLoad attr Assign NameStore Call AttributeLoad NameLoad attr Str Str TupleLoad Str Str TupleLoad Str Str Call NameLoad GeneratorExp TupleLoad NameLoad SubscriptLoad AttributeLoad NameLoad attr Index NameLoad comprehension TupleStore NameStore NameStore NameStore NameLoad comprehension NameStore AttributeLoad SubscriptLoad NameLoad Index TupleLoad NameLoad NameLoad attr decorator_list FunctionDef arguments args NameParam defaults body Expr Call AttributeLoad NameLoad attr Str Assign NameStore Call NameLoad GeneratorExp TupleLoad TupleLoad SubscriptLoad AttributeLoad NameLoad attr Index AttributeLoad AttributeLoad NameLoad attr attr SubscriptLoad AttributeLoad NameLoad attr Index AttributeLoad NameLoad attr NameLoad comprehension NameStore Call AttributeLoad AttributeLoad AttributeLoad NameLoad attr attr attr comprehension NameStore NameLoad CompareNotIn AttributeLoad AttributeLoad NameLoad attr attr AttributeLoad NameLoad attr Assign NameStore Call AttributeLoad NameLoad attr Str Str TupleLoad Str Str Str TupleLoad Str Str Call NameLoad GeneratorExp TupleLoad SubscriptLoad NameLoad Index Num SubscriptLoad NameLoad Index Num AttributeLoad NameLoad attr comprehension TupleStore NameStore NameStore Call AttributeLoad NameLoad attr Assign NameStore Call AttributeLoad NameLoad attr Str Str TupleLoad Str Str TupleLoad Str Str Call NameLoad GeneratorExp TupleLoad NameLoad SubscriptLoad AttributeLoad NameLoad attr Index NameLoad comprehension TupleStore NameStore NameStore NameStore NameLoad comprehension NameStore AttributeLoad SubscriptLoad NameLoad Index TupleLoad NameLoad NameLoad attr decorator_list FunctionDef arguments args NameParam defaults body Expr Call AttributeLoad NameLoad attr Str Assign NameStore Call NameLoad Assign NameStore Call NameLoad For NameStore Call AttributeLoad AttributeLoad AttributeLoad NameLoad attr attr attr body If CompareNotIn AttributeLoad AttributeLoad NameLoad attr attr AttributeLoad NameLoad attr body Expr Call AttributeLoad NameLoad attr NameLoad orelse If CompareIn NameLoad AttributeLoad NameLoad attr body Expr Call AttributeLoad NameLoad attr NameLoad Assign NameStore Call AttributeLoad NameLoad attr Str Str TupleLoad Str Str Str Str Str Str Str Str Str Str Str TupleLoad Str Call NameLoad GeneratorExp TupleLoad SubscriptLoad AttributeLoad NameLoad attr Index AttributeLoad NameLoad attr Call AttributeLoad AttributeLoad NameLoad attr attr AttributeLoad NameLoad attr Call AttributeLoad AttributeLoad NameLoad attr attr IfExp UnaryOpNot Call NameLoad AttributeLoad NameLoad attr NameLoad AttributeLoad NameLoad attr SubscriptLoad AttributeLoad NameLoad attr Index Num SubscriptLoad Dict Str Str NameLoad Num Num NameLoad Index AttributeLoad NameLoad attr SubscriptLoad Dict Str Str Str NameLoad Num Num Num Num Index AttributeLoad NameLoad attr Call AttributeLoad AttributeLoad NameLoad attr attr AttributeLoad NameLoad attr AttributeLoad NameLoad attr AttributeLoad NameLoad attr SubscriptLoad AttributeLoad NameLoad attr Index AttributeLoad AttributeLoad NameLoad attr attr AttributeLoad NameLoad attr AttributeLoad NameLoad attr comprehension NameStore NameLoad Assign AttributeStore NameLoad attr Call NameLoad GeneratorExp TupleLoad NameLoad NameLoad comprehension TupleStore NameStore NameStore NameLoad Expr Call AttributeLoad NameLoad attr If NameLoad body Assign NameStore ListLoad For NameStore NameLoad body Expr Call AttributeLoad NameLoad attr Call NameLoad SubscriptLoad AttributeLoad NameLoad attr Index AttributeLoad NameLoad attr Assign NameStore Call AttributeLoad NameLoad attr BinOpAdd BinOpAdd Str Call AttributeLoad Str attr NameLoad Str For TupleStore NameStore NameStore NameLoad body Assign SubscriptStore AttributeLoad NameLoad attr Index NameLoad NameLoad Expr Call AttributeLoad NameLoad attr decorator_list FunctionDef arguments args NameParam NameParam defaults body If Call NameLoad NameLoad NameLoad body Return Call AttributeLoad AttributeLoad NameLoad attr attr Call AttributeLoad AttributeLoad NameLoad attr attr AttributeLoad NameLoad attr orelse Return NameLoad decorator_list FunctionDef arguments args NameParam defaults body Expr Call AttributeLoad NameLoad attr Str Assign NameStore Call NameLoad GeneratorExp TupleLoad TupleLoad SubscriptLoad AttributeLoad NameLoad attr Index AttributeLoad AttributeLoad NameLoad attr attr AttributeLoad NameLoad attr AttributeLoad NameLoad attr NameLoad comprehension NameStore TupleLoad AttributeLoad NameLoad attr AttributeLoad NameLoad attr AttributeLoad NameLoad attr AttributeLoad NameLoad attr comprehension NameStore AttributeLoad Call AttributeLoad AttributeLoad NameLoad attr attr NameLoad attr BoolOpAnd CompareIsNot AttributeLoad NameLoad attr NameLoad CompareIsNot AttributeLoad NameLoad attr NameLoad comprehension NameStore TupleLoad AttributeLoad NameLoad attr AttributeLoad NameLoad attr Call NameLoad NameLoad NameLoad Assign NameStore Call NameLoad GeneratorExp TupleLoad SubscriptLoad AttributeLoad NameLoad attr Index AttributeLoad NameLoad attr SubscriptLoad AttributeLoad NameLoad attr Index AttributeLoad NameLoad attr SubscriptLoad AttributeLoad NameLoad attr Index AttributeLoad AttributeLoad NameLoad attr attr AttributeLoad NameLoad attr AttributeLoad NameLoad attr comprehension NameStore Call AttributeLoad NameLoad attr Expr Call AttributeLoad NameLoad attr Assign NameStore Call AttributeLoad NameLoad attr Str Str TupleLoad Str Str Str Str Str TupleLoad Str Str Str NameLoad keyword NameLoad Assign AttributeStore NameLoad attr Call NameLoad GeneratorExp TupleLoad TupleLoad NameLoad NameLoad NameLoad NameLoad comprehension TupleStore NameStore NameStore NameStore NameStore NameLoad Expr Call AttributeLoad NameLoad attr Str Assign NameStore Call NameLoad GeneratorExp TupleLoad SubscriptLoad AttributeLoad NameLoad attr Index TupleLoad SubscriptLoad AttributeLoad NameLoad attr Index AttributeLoad AttributeLoad NameLoad attr attr AttributeLoad NameLoad attr AttributeLoad NameLoad attr NameLoad comprehension NameStore TupleLoad AttributeLoad NameLoad attr AttributeLoad NameLoad attr comprehension NameStore AttributeLoad Call AttributeLoad AttributeLoad NameLoad attr attr NameLoad attr BoolOpAnd CompareIsNot AttributeLoad NameLoad attr NameLoad CompareIsNot AttributeLoad NameLoad attr NameLoad comprehension NameStore TupleLoad AttributeLoad NameLoad attr AttributeLoad NameLoad attr Call NameLoad NameLoad NameLoad Assign NameStore Call AttributeLoad NameLoad attr Str Str TupleLoad Str Str Str TupleLoad Str Call NameLoad GeneratorExp TupleLoad NameLoad AttributeLoad NameLoad attr AttributeLoad NameLoad attr comprehension TupleStore NameStore NameStore Call AttributeLoad NameLoad attr keyword NameLoad Expr Call AttributeLoad NameLoad attr decorator_list FunctionDef arguments args NameParam defaults body Expr Call AttributeLoad NameLoad attr Str Assign NameStore Call AttributeLoad NameLoad attr Str Str TupleLoad Str Str Str Str Str Str TupleLoad Str Str Str Str Str Call NameLoad GeneratorExp TupleLoad AttributeLoad NameLoad attr SubscriptLoad AttributeLoad NameLoad attr Index NameLoad SubscriptLoad AttributeLoad NameLoad attr Index NameLoad SubscriptLoad AttributeLoad NameLoad attr Index NameLoad SubscriptLoad AttributeLoad NameLoad attr Index NameLoad IfExp CompareIn NameLoad AttributeLoad NameLoad attr NameLoad AttributeLoad SubscriptLoad SubscriptLoad AttributeLoad AttributeLoad NameLoad attr attr Index NameLoad Index Num attr comprehension TupleStore NameStore NameStore NameStore NameStore Call AttributeLoad AttributeLoad AttributeLoad NameLoad attr attr attr BoolOpAnd NameLoad NameLoad NameLoad UnaryOpNot Call AttributeLoad NameLoad attr Str Assign AttributeStore NameLoad attr Call NameLoad GeneratorExp TupleLoad TupleLoad NameLoad NameLoad NameLoad NameLoad NameLoad NameLoad comprehension TupleStore NameStore NameStore NameStore NameStore NameStore NameStore NameLoad Assign NameStore ListLoad FunctionDef arguments args NameParam NameParam NameParam NameParam NameParam NameParam NameParam defaults body For NameStore NameLoad body If BoolOpAnd CompareNotIn NameLoad NameLoad CompareIsNot AttributeLoad NameLoad attr NameLoad body Expr Call AttributeLoad NameLoad attr NameLoad Expr Call AttributeLoad NameLoad attr TupleLoad NameLoad NameLoad NameLoad NameLoad AugAssignAdd NameStore Num Assign NameStore Call NameLoad Call AttributeLoad NameLoad attr AttributeLoad NameLoad attr NameLoad BinOpAdd NameLoad Num NameLoad NameLoad NameLoad NameLoad Expr Call AttributeLoad NameLoad attr NameLoad Return NameLoad decorator_list For TupleStore NameStore NameStore NameStore NameStore Call AttributeLoad AttributeLoad AttributeLoad NameLoad attr attr attr body If BoolOpAnd NameLoad NameLoad NameLoad UnaryOpNot Call AttributeLoad NameLoad attr Str body Assign NameStore SubscriptLoad AttributeLoad NameLoad attr Index TupleLoad AttributeLoad NameLoad attr SubscriptLoad AttributeLoad NameLoad attr Index NameLoad SubscriptLoad AttributeLoad NameLoad attr Index NameLoad SubscriptLoad AttributeLoad NameLoad attr Index NameLoad SubscriptLoad AttributeLoad NameLoad attr Index NameLoad Assign NameStore Call AttributeLoad AttributeLoad NameLoad attr attr NameLoad NameLoad NameLoad NameLoad Assign NameStore Num For NameStore AttributeLoad NameLoad attr body Assign NameStore Call NameLoad Call AttributeLoad NameLoad attr NameLoad NameLoad Num NameLoad Call NameLoad NameLoad NameLoad FunctionDef arguments args NameParam defaults body If Call NameLoad NameLoad NameLoad body Return Call AttributeLoad AttributeLoad NameLoad attr attr TupleLoad SubscriptLoad AttributeLoad NameLoad attr Index AttributeLoad AttributeLoad NameLoad attr attr AttributeLoad NameLoad attr AttributeLoad NameLoad attr orelse Return NameLoad decorator_list Assign NameStore Call NameLoad GeneratorExp TupleLoad NameLoad Call AttributeLoad NameLoad attr AttributeLoad NameLoad attr Call AttributeLoad NameLoad attr AttributeLoad NameLoad attr Call AttributeLoad NameLoad attr AttributeLoad NameLoad attr Call NameLoad AttributeLoad NameLoad attr Call NameLoad AttributeLoad NameLoad attr Call AttributeLoad NameLoad attr AttributeLoad NameLoad attr NameLoad NameLoad IfExp AttributeLoad NameLoad attr Call AttributeLoad AttributeLoad NameLoad attr attr AttributeLoad NameLoad attr NameLoad comprehension TupleStore NameStore NameStore NameStore NameStore NameLoad BoolOpAnd CompareIsNot AttributeLoad NameLoad attr NameLoad CompareIsNot AttributeLoad NameLoad attr NameLoad Delete SubscriptDel NameLoad Slice Assign NameStore Call AttributeLoad NameLoad attr Str Str TupleLoad Str Str Str Str Str Str Str Str Str Str TupleLoad Str Str NameLoad decorator_list FunctionDef arguments args NameParam defaults body Assign NameStore AttributeLoad NameLoad attr If AttributeLoad NameLoad attr body Expr Call AttributeLoad NameLoad attr Str Expr Call AttributeLoad NameLoad attr Call AttributeLoad Str attr NameLoad keyword NameLoad keyword NameLoad Expr Call AttributeLoad NameLoad attr Call AttributeLoad Str attr NameLoad keyword NameLoad keyword NameLoad Expr Call AttributeLoad NameLoad attr Call AttributeLoad Str attr NameLoad keyword NameLoad keyword NameLoad Expr Call AttributeLoad NameLoad attr Call AttributeLoad Str attr NameLoad keyword NameLoad keyword NameLoad Expr Call AttributeLoad NameLoad attr Str Assign NameStore Call AttributeLoad NameLoad attr Str Str TupleLoad Str Str TupleLoad Str Str Call NameLoad GeneratorExp TupleLoad NameLoad NameLoad comprehension NameStore Call AttributeLoad AttributeLoad AttributeLoad NameLoad attr attr attr Assign AttributeStore NameLoad attr Call NameLoad GeneratorExp TupleLoad TupleLoad NameLoad NameLoad NameLoad comprehension TupleStore NameStore NameStore NameStore NameLoad Assign NameStore Call AttributeLoad NameLoad attr Str Str TupleLoad Str Str Str TupleLoad Str Str Call NameLoad GeneratorExp TupleLoad SubscriptLoad AttributeLoad NameLoad attr Index TupleLoad NameLoad AttributeLoad NameLoad attr SubscriptLoad AttributeLoad NameLoad attr Index NameLoad IfExp UnaryOpNot SubscriptLoad AttributeLoad NameLoad attr Index Num Num BinOpAdd NameLoad Num comprehension NameStore Call AttributeLoad AttributeLoad AttributeLoad NameLoad attr attr attr comprehension NameStore Call NameLoad Num comprehension NameStore SubscriptLoad AttributeLoad NameLoad attr Index NameLoad Assign NameStore Call AttributeLoad NameLoad attr Str Str TupleLoad Str Str Str Str Str Str Str Str TupleLoad Str Str Call NameLoad GeneratorExp TupleLoad NameLoad IfExp AttributeLoad NameLoad attr AttributeLoad NameLoad attr NameLoad IfExp AttributeLoad NameLoad attr AttributeLoad NameLoad attr NameLoad IfExp AttributeLoad NameLoad attr AttributeLoad NameLoad attr NameLoad Call NameLoad AttributeLoad NameLoad attr AttributeLoad NameLoad attr SubscriptLoad AttributeLoad NameLoad attr Index Num SubscriptLoad AttributeLoad NameLoad attr Index Num comprehension NameStore Call AttributeLoad AttributeLoad AttributeLoad NameLoad attr attr attr Assign AttributeStore NameLoad attr Call NameLoad GeneratorExp TupleLoad TupleLoad NameLoad NameLoad NameLoad comprehension TupleStore NameStore NameStore NameStore NameLoad Assign NameStore ListLoad For NameStore Call AttributeLoad AttributeLoad AttributeLoad NameLoad attr attr attr body For NameStore Call AttributeLoad AttributeLoad NameLoad attr attr body Expr Call AttributeLoad NameLoad attr TupleLoad SubscriptLoad AttributeLoad NameLoad attr Index TupleLoad NameLoad AttributeLoad NameLoad attr SubscriptLoad AttributeLoad NameLoad attr Index AttributeLoad NameLoad attr Call AttributeLoad AttributeLoad NameLoad attr attr AttributeLoad NameLoad attr IfExp AttributeLoad NameLoad attr Call AttributeLoad AttributeLoad NameLoad attr attr AttributeLoad AttributeLoad NameLoad attr attr NameLoad NameLoad CompareEq AttributeLoad NameLoad attr Str IfExp AttributeLoad NameLoad attr AttributeLoad AttributeLoad NameLoad attr attr NameLoad For TupleStore NameStore NameStore Call AttributeLoad AttributeLoad AttributeLoad NameLoad attr attr attr body If CompareNotIn NameLoad AttributeLoad NameLoad attr body Expr Call AttributeLoad NameLoad attr TupleLoad SubscriptLoad AttributeLoad NameLoad attr Index TupleLoad NameLoad AttributeLoad NameLoad attr SubscriptLoad AttributeLoad NameLoad attr Index NameLoad SubscriptLoad AttributeLoad NameLoad attr Index NameLoad NameLoad NameLoad NameLoad NameLoad Assign NameStore Call AttributeLoad NameLoad attr Str Str TupleLoad Str Str Str Str Str Str Str TupleLoad Str Str Str NameLoad FunctionDef arguments args NameParam NameParam defaults body Assign NameStore Call AttributeLoad NameLoad attr Str Str TupleLoad Str Str Str Str Str Str Str Str Str Str Str Str TupleLoad Str Str Call NameLoad GeneratorExp TupleLoad NameLoad NameLoad Call AttributeLoad AttributeLoad NameLoad attr attr TupleLoad NameLoad AttributeLoad NameLoad attr Call AttributeLoad AttributeLoad NameLoad attr attr TupleLoad NameLoad AttributeLoad NameLoad attr Call AttributeLoad NameLoad attr AttributeLoad NameLoad attr IfExp BoolOpAnd AttributeLoad NameLoad attr UnaryOpNot AttributeLoad NameLoad attr Call NameLoad AttributeLoad NameLoad attr AttributeLoad NameLoad attr AttributeLoad NameLoad attr NameLoad AttributeLoad NameLoad attr Call NameLoad NameLoad IfExp BoolOpAnd CompareIn Str AttributeLoad NameLoad attr Call NameLoad AttributeLoad SubscriptLoad AttributeLoad NameLoad attr Index Str attr NameLoad AttributeLoad SubscriptLoad AttributeLoad NameLoad attr Index Str attr NameLoad IfExp BoolOpAnd CompareIn Str AttributeLoad NameLoad attr Call NameLoad AttributeLoad SubscriptLoad AttributeLoad NameLoad attr Index Str attr NameLoad AttributeLoad SubscriptLoad AttributeLoad NameLoad attr Index Str attr NameLoad BoolOpAnd CompareIn Str AttributeLoad NameLoad attr CompareEq AttributeLoad SubscriptLoad AttributeLoad NameLoad attr Index Str attr Str BoolOpAnd CompareIn Str AttributeLoad NameLoad attr CompareEq AttributeLoad SubscriptLoad AttributeLoad NameLoad attr Index Str attr Str comprehension NameStore NameLoad Assign NameStore Call NameLoad GeneratorExp TupleLoad NameLoad NameLoad comprehension TupleStore NameStore NameStore NameStore NameLoad For NameStore NameLoad body If AttributeLoad NameLoad attr body Expr Call NameLoad AttributeLoad NameLoad attr SubscriptLoad NameLoad Index Call NameLoad NameLoad decorator_list Expr Call NameLoad AttributeLoad AttributeLoad NameLoad attr attr NameLoad decorator_list decorator_list
N/A N/A 
XbrlPublicPostgresDB.py implements a relational database interface for Arelle, based
on the XBRL US Public Database.  The database schema is described by "XBRL US Public Database",
published by XBRL US, 2011.  This is a syntactic representation of XBRL information. 

This module provides the execution context for saving a dts and assession in 
XBRL Public Database Tables.  It may be loaded by Arelle'sRSS feed, or by individual
DTS and instances opened by interactive or command line/web service mode.

(c) Copyright 2013 Mark V Systems Limited, California US, All rights reserved.  
Mark V copyright applies to this software, which is licensed according to the terms of Arelle(r).
and does not apply to the XBRL US Database schema and description.

The XBRL US Database schema and description is (c) Copyright XBRL US 2011, The 
resulting database may contain data from SEC interactive data filings (or any other XBRL
instance documents and DTS) in a relational model. Mark V Systems conveys neither 
rights nor license for the database schema.
 
The XBRL US Database and this code is intended for Postgres.  XBRL-US uses Postgres 8.4, 
Arelle uses 9.1, via Python DB API 2.0 interface, using the pg8000 library.

Information for the 'official' XBRL US-maintained database (this schema, containing SEC filings):
    Database Name: edgar_db 
    Database engine: Postgres version 8.4 
    \Host: public.xbrl.us 
    Port: 5432

to use from command line:

linux
   # be sure plugin is installed
   arelleCmdLine --plugin '+xbrlDB|show'
   arelleCmdLine -f http://sec.org/somewhere/some.rss -v --store-to-XBRL-DB 'myserver.com,portnumber,pguser,pgpasswd,database,timeoutseconds'
   
windows
   rem be sure plugin is installed
   arelleCmdLine --plugin "+xbrlDB|show"
   arelleCmdLine -f http://sec.org/somewhere/some.rss -v --store-to-XBRL-DB "myserver.com,portnumber,pguser,pgpasswd,database,timeoutseconds"

 N/A time datetime arelle.ModelDocument Type arelle.ModelDtsObject ModelConcept ModelResource arelle.ModelValue qname arelle.ValidateXbrlCalcs roundValue arelle.XmlUtil elementFragmentIdentifier arelle XbrlConst SqlDb XPDBException isSqlConnection SqlDbConnection insertIntoDB N/A N/A modelXbrl user password host port database timeout product rssItem N/A None None None None None None postgres None kwargs N/A N/A xpgdb None N/A N/A N/A xpgdb N/A XbrlPostgresDatabaseConnection modelXbrl user password host port database timeout product N/A N/A N/A xpgdb verifyTables N/A N/A N/A xpgdb insertXbrl rssItem rssItem N/A N/A N/A xpgdb close N/A N/A N/A Exception N/A ex N/A N/A N/A xpgdb None N/A N/A N/A N/A N/A N/A xpgdb close rollback True N/A N/A N/A Exception N/A ex2 N/A N/A N/A N/A isDBPort N/A N/A host port timeout N/A 10 N/A N/A N/A isSqlConnection host port timeout product postgres N/A N/A XBRLDBTABLES N/A fact fact_aug entity entity_name_history unit unit_measure context context_aug context_dimension accession accession_document_association accession_element accession_timestamp attribute_value custom_role_type uri document qname taxonomy taxonomy_version namespace element element_attribute element_attribute_value_association network relationship custom_arcrole_type custom_arcrole_used_on custom_role_used_on label_resource reference_part reference_part_type reference_resource resource enumeration_arcrole_cycles_allowed enumeration_element_balance enumeration_element_period_type enumeration_unit_measure_location industry industry_level industry_structure query_log sic_code XbrlPostgresDatabaseConnection N/A SqlDbConnection N/A verifyTables N/A N/A self N/A N/A N/A missingTables N/A XBRLDBTABLES N/A N/A self tablesInDB N/A N/A missingTables XBRLDBTABLES N/A N/A N/A N/A self create xbrlPublicPostgresDB.ddl N/A N/A N/A self getTable enumeration_arcrole_cycles_allowed enumeration_arcrole_cycles_allowed_id N/A description N/A description N/A N/A any N/A undirected N/A none N/A N/A N/A self getTable enumeration_element_balance enumeration_element_balance_id N/A description N/A description N/A N/A credit N/A debit N/A N/A N/A self getTable enumeration_element_period_type enumeration_element_period_type_id N/A description N/A description N/A N/A instant N/A duration N/A forever N/A missingTables N/A XBRLDBTABLES N/A N/A self tablesInDB N/A missingTables N/A N/A N/A XPDBException xpgDB:MissingTables N/A _ The following tables are missing, suggest reinitializing database schema: %(missingTableNames)s missingTableNames N/A N/A ,  join N/A t N/A t N/A sorted missingTables N/A insertXbrl N/A N/A self rssItem N/A N/A N/A N/A arelle ValidateXbrlDimensions N/A N/A N/A ValidateXbrlDimensions loadDimensionDefaults N/A self modelXbrl N/A N/A N/A self identifyPreexistingDocuments N/A N/A N/A self identifyConceptsUsed N/A startedAt N/A N/A time time N/A N/A N/A self insertAccession rssItem N/A N/A N/A self insertUris N/A N/A N/A self insertQnames N/A N/A N/A self insertNamespaces N/A N/A N/A self insertDocuments N/A N/A N/A self insertCustomArcroles N/A N/A N/A self insertCustomRoles N/A N/A N/A self insertElements N/A N/A N/A self insertResources N/A N/A N/A self insertNetworks N/A N/A N/A N/A self modelXbrl profileStat N/A _ XbrlPublicDB: DTS insertion N/A N/A N/A time time startedAt N/A startedAt N/A N/A time time N/A N/A N/A self insertFacts N/A N/A N/A N/A self modelXbrl profileStat N/A _ XbrlPublicDB: instance insertion N/A N/A N/A time time startedAt N/A startedAt N/A N/A time time N/A N/A N/A self showStatus Committing entries N/A N/A N/A self commit N/A N/A N/A N/A self modelXbrl profileStat N/A _ XbrlPublicDB: insertion committed N/A N/A N/A time time startedAt N/A N/A N/A self showStatus DB insertion completed clearAfter 5000 N/A N/A N/A Exception N/A ex N/A N/A N/A N/A self showStatus DB insertion failed due to exception clearAfter 5000 N/A N/A insertAccession N/A N/A self rssItem N/A N/A N/A N/A self accessionId (TBD) N/A N/A N/A self showStatus insert accession N/A N/A rssItem None N/A N/A _time N/A N/A time time N/A now N/A N/A N/A datetime datetime fromtimestamp _time N/A today N/A N/A datetime date N/A now year N/A now month N/A now day N/A table N/A N/A self getTable accession accession_id N/A filing_date entity_id creation_software entry_url filing_accession_number N/A filing_accession_number N/A N/A today 0 N/A N/A N/A self modelXbrl modelDocument creationSoftwareComment N/A N/A self modelXbrl uri N/A str N/A int _time checkIfExisting True returnExistenceStatus True N/A N/A table N/A N/A self getTable accession accession_id N/A accepted_timestamp is_most_current filing_date entity_id entity_name creation_software standard_industrial_classification sec_html_url entry_url filing_accession_number N/A filing_accession_number N/A N/A N/A rssItem acceptanceDatetime True N/A N/A rssItem filingDate N/A N/A datetime datetime min N/A N/A rssItem cikNumber 0 N/A rssItem companyName N/A N/A N/A self modelXbrl modelDocument creationSoftwareComment N/A N/A rssItem assignedSic -1 N/A rssItem htmlUrl N/A rssItem url N/A N/A rssItem accessionNumber UNKNOWN checkIfExisting True returnExistenceStatus True N/A N/A id filing_accession_number existenceStatus table N/A N/A N/A self accessionId id N/A N/A self accessionPreviouslyInDB existenceStatus N/A N/A insertUris N/A N/A self N/A N/A N/A uris N/A N/A N/A N/A N/A _DICT_SET N/A N/A N/A N/A self modelXbrl namespaceDocs keys N/A _DICT_SET N/A N/A N/A N/A self modelXbrl arcroleTypes keys N/A _DICT_SET N/A N/A N/A XbrlConst standardArcroleCyclesAllowed keys N/A _DICT_SET N/A N/A N/A N/A self modelXbrl roleTypes keys N/A XbrlConst standardRoles N/A N/A N/A self showStatus insert uris N/A table N/A N/A self getTable uri uri_id N/A uri N/A uri N/A tuple N/A N/A uri N/A uri uris checkIfExisting True N/A N/A self uriId N/A dict N/A N/A uri id N/A N/A id uri table N/A insertQnames N/A N/A self N/A N/A N/A qnames N/A N/A N/A N/A _DICT_SET N/A N/A N/A N/A self modelXbrl qnameConcepts keys N/A _DICT_SET N/A N/A N/A N/A self modelXbrl qnameAttributes keys N/A _DICT_SET N/A N/A N/A N/A self modelXbrl qnameTypes keys N/A set N/A measure N/A unit N/A N/A N/A N/A self modelXbrl units values N/A measures N/A unit measures N/A measure measures N/A N/A N/A self showStatus insert qnames N/A table N/A N/A self getTable qname qname_id N/A namespace local_name N/A namespace local_name N/A tuple N/A N/A N/A qn namespaceURI N/A qn localName N/A qn qnames checkIfExisting True N/A N/A self qnameId N/A dict N/A N/A N/A qname ns ln id N/A N/A id ns ln table N/A insertNamespaces N/A N/A self N/A N/A N/A N/A N/A self showStatus insert namespaces N/A N/A N/A self disclosureSystem baseTaxonomyNamespaces N/A N/A namespaceUris N/A N/A self disclosureSystem baseTaxonomyNamespaces N/A N/A namespaceUris N/A N/A N/A N/A self modelXbrl namespaceDocs keys N/A table N/A N/A self getTable namespace namespace_id N/A uri is_base taxonomy_version_id prefix N/A uri N/A tuple N/A N/A uri True 0 N/A N/A N/A N/A self disclosureSystem standardPrefixes get uri None N/A uri namespaceUris checkIfExisting True N/A N/A self namespaceId N/A dict N/A N/A uri id N/A N/A id uri table N/A identifyPreexistingDocuments N/A N/A self N/A N/A N/A N/A self existingDocumentIds N/A N/A docUris N/A set N/A modelDocument N/A N/A N/A N/A self modelXbrl urlDocs values N/A N/A N/A N/A modelDocument type N/A Type SCHEMA N/A N/A N/A N/A docUris add N/A N/A self dbStr N/A modelDocument uri N/A docUris N/A N/A results N/A N/A self execute N/A N/A SELECT document_id, document_uri FROM document WHERE document_uri IN ( N/A N/A ,  join docUris ); N/A N/A self existingDocumentIds N/A dict N/A N/A docUri docId N/A N/A docId docUri results N/A identifyConceptsUsed N/A N/A self N/A N/A N/A N/A self relationshipSets N/A N/A arcrole ELR linkqname arcqname N/A N/A arcrole ELR linkqname arcqname N/A N/A N/A N/A self modelXbrl baseSets keys N/A ELR N/A N/A N/A arcrole startswith XBRL- N/A linkqname arcqname N/A conceptsUsed N/A set N/A N/A f qname N/A f N/A N/A self modelXbrl factsInInstance N/A cntx N/A N/A N/A N/A self modelXbrl contexts values N/A N/A dim N/A N/A N/A cntx qnameDims values N/A N/A N/A N/A conceptsUsed add N/A dim dimensionQname N/A N/A dim isExplicit N/A N/A N/A N/A conceptsUsed add N/A dim memberQname N/A N/A N/A N/A conceptsUsed add N/A N/A dim typedMember qname N/A N/A defaultDim defaultDimMember N/A N/A N/A N/A self modelXbrl qnameDimensionDefaults items N/A N/A N/A N/A conceptsUsed add defaultDim N/A N/A N/A conceptsUsed add defaultDimMember N/A relationshipSetKey N/A self relationshipSets N/A N/A relationshipSet N/A N/A N/A self modelXbrl relationshipSet relationshipSetKey N/A rel N/A relationshipSet modelRelationships N/A N/A N/A isinstance N/A rel fromModelObject ModelConcept N/A N/A N/A N/A conceptsUsed add N/A rel fromModelObject N/A N/A isinstance N/A rel toModelObject ModelConcept N/A N/A N/A N/A conceptsUsed add N/A rel toModelObject N/A qn N/A N/A XbrlConst qnXbrliIdentifier N/A XbrlConst qnXbrliPeriod N/A XbrlConst qnXbrliUnit N/A N/A N/A N/A conceptsUsed add N/A N/A N/A self modelXbrl qnameConcepts N/A qn N/A conceptsUsed N/A None N/A N/A self conceptsUsed conceptsUsed N/A insertDocuments N/A N/A self N/A N/A N/A N/A N/A self showStatus insert documents N/A table N/A N/A self getTable document document_id N/A document_uri N/A document_uri N/A set N/A N/A docUri N/A docUri N/A N/A N/A N/A self modelXbrl urlDocs keys N/A docUri N/A self existingDocumentIds checkIfExisting True N/A N/A self documentIds N/A dict N/A N/A uri id N/A N/A id uri table N/A N/A N/A N/A self documentIds update N/A self existingDocumentIds N/A table N/A N/A self getTable accession_document_association accession_document_association_id N/A accession_id document_id N/A document_id N/A tuple N/A N/A N/A self accessionId docId N/A docId N/A N/A N/A self documentIds values checkIfExisting True N/A insertCustomArcroles N/A N/A self N/A N/A N/A N/A N/A self showStatus insert arcrole types N/A arcroleTypesByIds N/A dict N/A N/A N/A N/A N/A self documentIds N/A N/A N/A arcroleType modelDocument uri N/A N/A self uriId N/A N/A arcroleType arcroleURI arcroleType N/A arcroleTypes N/A N/A N/A N/A self modelXbrl arcroleTypes values N/A arcroleType arcroleTypes N/A N/A N/A arcroleType modelDocument uri N/A self existingDocumentIds N/A table N/A N/A self getTable custom_arcrole_type custom_arcrole_type_id N/A document_id uri_id definition cycles_allowed N/A document_id uri_id N/A tuple N/A N/A N/A arcroleTypeIDs N/A 0 N/A arcroleTypeIDs N/A 1 N/A arcroleType definition N/A N/A any undirected none 1 2 3 N/A N/A arcroleType cyclesAllowed N/A N/A arcroleTypeIDs arcroleType N/A N/A arcroleTypesByIds items N/A table N/A N/A self getTable custom_arcrole_used_on custom_arcrole_used_on_id N/A custom_arcrole_type_id qname_id N/A custom_arcrole_type_id qname_id N/A tuple N/A N/A id N/A N/A self qnameId N/A usedOn N/A N/A id docid uriid table N/A usedOn N/A N/A arcroleTypesByIds N/A N/A docid uriid usedOns N/A insertCustomRoles N/A N/A self N/A N/A N/A N/A N/A self showStatus insert role types N/A roleTypesByIds N/A dict N/A N/A N/A N/A N/A self documentIds N/A N/A N/A roleType modelDocument uri N/A N/A self uriId N/A N/A roleType roleURI roleType N/A roleTypes N/A N/A N/A N/A self modelXbrl roleTypes values N/A roleType roleTypes N/A N/A N/A roleType modelDocument uri N/A self existingDocumentIds N/A table N/A N/A self getTable custom_role_type custom_role_type_id N/A document_id uri_id definition N/A document_id uri_id N/A tuple N/A N/A N/A roleTypeIDs N/A 0 N/A roleTypeIDs N/A 1 N/A roleType definition N/A N/A roleTypeIDs roleType N/A N/A roleTypesByIds items N/A table N/A N/A self getTable custom_role_used_on custom_role_used_on_id N/A custom_role_type_id qname_id N/A custom_role_type_id qname_id N/A tuple N/A N/A id N/A N/A self qnameId N/A usedOn N/A N/A id docid uriid table N/A usedOn N/A N/A roleTypesByIds N/A N/A docid uriid usedOns N/A insertElements N/A N/A self N/A N/A N/A N/A N/A self showStatus insert elements N/A filingDocumentConcepts N/A set N/A existingDocumentUsedConcepts N/A set N/A concept N/A N/A N/A N/A self modelXbrl qnameConcepts values N/A N/A N/A N/A N/A concept modelDocument uri N/A self existingDocumentIds N/A N/A N/A N/A filingDocumentConcepts add concept N/A N/A N/A concept N/A self conceptsUsed N/A N/A N/A N/A existingDocumentUsedConcepts add concept N/A table N/A N/A self getTable element element_id N/A qname_id datatype_qname_id xbrl_base_datatype_qname_id balance_id period_type_id substitution_group_qname_id abstract nillable document_id is_numeric is_monetary N/A qname_id N/A tuple N/A N/A N/A N/A self qnameId N/A N/A concept qname N/A N/A N/A self qnameId get N/A concept typeQname N/A N/A N/A self qnameId get N/A N/A N/A isinstance N/A concept baseXbrliTypeQname list N/A concept baseXbrliTypeQname N/A N/A concept baseXbrliTypeQname N/A 0 N/A N/A debit credit None 1 2 None N/A N/A concept balance N/A N/A instant duration forever None 1 2 3 0 N/A N/A concept periodType N/A N/A N/A self qnameId get N/A concept substitutionGroupQname N/A concept isAbstract N/A concept isNillable N/A N/A self documentIds N/A N/A N/A concept modelDocument uri N/A concept isNumeric N/A concept isMonetary N/A concept filingDocumentConcepts N/A N/A self elementId N/A dict N/A N/A qnameId elementId N/A N/A elementId qnameId table N/A N/A N/A filingDocumentConcepts clear N/A existingDocumentUsedConcepts N/A N/A conceptQnameIds N/A N/A concept existingDocumentUsedConcepts N/A N/A N/A N/A conceptQnameIds append N/A str N/A N/A self qnameId N/A N/A concept qname N/A results N/A N/A self execute N/A N/A SELECT element_id, qname_id FROM element WHERE qname_id IN ( N/A N/A ,  join conceptQnameIds ); N/A N/A elementId qnameId results N/A N/A N/A N/A self elementId N/A qnameId elementId N/A N/A N/A existingDocumentUsedConcepts clear N/A conceptElementId N/A N/A self concept N/A N/A N/A N/A isinstance concept ModelConcept N/A N/A N/A N/A N/A self elementId get N/A N/A N/A self qnameId get N/A concept qname N/A N/A None N/A insertResources N/A N/A self N/A N/A N/A N/A N/A self showStatus insert resources N/A uniqueResources N/A dict N/A N/A N/A N/A N/A self documentIds N/A N/A N/A resource modelDocument uri N/A resource sourceline N/A resource objectIndex resource N/A arcrole N/A N/A XbrlConst conceptLabel N/A XbrlConst conceptReference N/A XbrlConst elementLabel N/A XbrlConst elementReference N/A rel N/A N/A N/A N/A self modelXbrl relationshipSet arcrole modelRelationships N/A N/A N/A rel fromModelObject None N/A N/A rel toModelObject None N/A resource N/A N/A rel fromModelObject N/A rel toModelObject N/A isinstance resource ModelResource N/A resourceData N/A tuple N/A N/A N/A N/A self uriId N/A N/A resource role N/A N/A self qnameId N/A N/A resource qname N/A N/A self documentIds N/A N/A N/A resource modelDocument uri N/A resource sourceline N/A resource objectIndex N/A resource N/A N/A uniqueResources values N/A N/A N/A uniqueResources clear N/A table N/A N/A self getTable resource resource_id N/A role_uri_id qname_id document_id document_line_number document_column_number N/A document_id document_line_number document_column_number resourceData checkIfExisting True N/A N/A self resourceId N/A dict N/A N/A N/A docId line offset id N/A N/A id docId line offset table N/A N/A N/A self showStatus insert labels N/A uniqueResources N/A dict N/A N/A N/A N/A self resourceId N/A N/A N/A N/A self documentIds N/A N/A N/A resource modelDocument uri N/A resource sourceline N/A resource objectIndex resource N/A arcrole N/A N/A XbrlConst conceptLabel N/A XbrlConst elementLabel N/A rel N/A N/A N/A N/A self modelXbrl relationshipSet arcrole modelRelationships N/A N/A N/A rel fromModelObject None N/A N/A rel toModelObject None N/A resource N/A N/A rel fromModelObject N/A rel toModelObject N/A isinstance resource ModelResource N/A table N/A N/A self getTable label_resource resource_id N/A resource_id label xml_lang N/A resource_id N/A tuple N/A N/A resourceId N/A resource textValue N/A resource xmlLang N/A N/A resourceId resource N/A N/A uniqueResources items checkIfExisting True N/A N/A N/A uniqueResources clear N/A insertNetworks N/A N/A self N/A N/A N/A N/A N/A self showStatus insert networks N/A table N/A N/A self getTable network network_id N/A accession_id extended_link_qname_id extended_link_role_uri_id arc_qname_id arcrole_uri_id description N/A accession_id extended_link_qname_id extended_link_role_uri_id arc_qname_id arcrole_uri_id N/A tuple N/A N/A N/A self accessionId N/A N/A self qnameId N/A linkqname N/A N/A self uriId N/A ELR N/A N/A self qnameId N/A arcqname N/A N/A self uriId N/A arcrole N/A N/A ELR N/A XbrlConst standardRoles None N/A N/A N/A N/A N/A self modelXbrl roleTypes N/A ELR N/A 0 definition N/A N/A arcrole ELR linkqname arcqname N/A N/A N/A N/A self modelXbrl baseSets keys N/A ELR linkqname arcqname N/A N/A N/A arcrole startswith XBRL- N/A N/A self networkId N/A dict N/A N/A N/A accId linkQnId linkRoleId arcQnId arcRoleId id N/A N/A id accId linkQnId linkRoleId arcQnId arcRoleId table N/A dbRels N/A walkTree N/A N/A rels seq depth relationshipSet visited dbRels networkId N/A N/A N/A rel rels N/A N/A N/A N/A rel visited N/A N/A rel toModelObject None N/A N/A N/A N/A visited add rel N/A N/A N/A dbRels append N/A rel seq depth networkId N/A seq 1 N/A seq N/A walkTree N/A N/A relationshipSet fromModelObject N/A rel toModelObject seq N/A depth 1 relationshipSet visited dbRels networkId N/A N/A N/A visited remove rel N/A seq N/A N/A N/A arcrole ELR linkqname arcqname N/A N/A N/A N/A self modelXbrl baseSets keys N/A N/A N/A ELR linkqname arcqname N/A N/A N/A arcrole startswith XBRL- N/A N/A networkId N/A N/A self networkId N/A N/A N/A self accessionId N/A N/A self qnameId N/A linkqname N/A N/A self uriId N/A ELR N/A N/A self qnameId N/A arcqname N/A N/A self uriId N/A arcrole N/A relationshipSet N/A N/A N/A self modelXbrl relationshipSet arcrole ELR linkqname arcqname N/A seq 1 N/A rootConcept N/A relationshipSet rootConcepts N/A N/A seq N/A walkTree N/A N/A relationshipSet fromModelObject rootConcept seq 1 relationshipSet N/A set dbRels networkId resourceResourceId N/A N/A resource N/A N/A N/A N/A isinstance resource ModelResource N/A N/A N/A N/A N/A self resourceId get N/A N/A N/A self documentIds N/A N/A N/A resource modelDocument uri N/A resource sourceline N/A resource objectIndex N/A N/A None N/A N/A relsData N/A tuple N/A N/A networkId N/A N/A self conceptElementId N/A rel fromModelObject N/A N/A self conceptElementId N/A rel toModelObject N/A N/A self dbNum N/A rel order N/A resourceResourceId N/A rel fromModelObject N/A resourceResourceId N/A rel toModelObject N/A N/A self dbNum N/A rel weight sequence depth N/A N/A rel preferredLabel N/A N/A N/A self qnameId get N/A rel preferredLabel None N/A N/A rel sequence depth networkId dbRels N/A N/A N/A rel fromModelObject None N/A N/A rel toModelObject None N/A N/A dbRels N/A N/A table N/A N/A self getTable relationship relationship_id N/A network_id from_element_id to_element_id reln_order from_resource_id to_resource_id calculation_weight tree_sequence tree_depth preferred_label_role_uri_id N/A network_id tree_sequence relsData N/A insertFacts N/A N/A self N/A N/A N/A accsId N/A self accessionId N/A N/A self accessionPreviouslyInDB N/A N/A N/A N/A self showStatus deleting prior facts of this accession N/A N/A N/A self execute N/A N/A DELETE FROM fact WHERE fact.accession_id = {}; format accsId close False fetch False N/A N/A N/A self execute N/A N/A DELETE from unit_measure USING unit WHERE unit.accession_id = {0} AND unit_measure.unit_id = unit.unit_id; format accsId close False fetch False N/A N/A N/A self execute N/A N/A DELETE from unit WHERE unit.accession_id = {0}; format accsId close False fetch False N/A N/A N/A self execute N/A N/A DELETE from context WHERE context.accession_id = {0}; format accsId close False fetch False N/A N/A N/A self showStatus insert facts N/A table N/A N/A self getTable unit unit_id N/A accession_id unit_xml_id N/A accession_id unit_xml_id N/A tuple N/A N/A accsId unitId N/A unitId N/A N/A N/A N/A self modelXbrl units keys N/A N/A self unitId N/A dict N/A N/A N/A _accsId xmlId id N/A N/A id _accsId xmlId table N/A table N/A N/A self getTable unit_measure unit_measure_id N/A unit_id qname_id location_id N/A qname_id location_id N/A tuple N/A N/A N/A N/A self unitId N/A N/A accsId N/A unit id N/A N/A self qnameId N/A measure N/A N/A N/A N/A unit measures N/A 1 1 N/A i 1 N/A unit N/A N/A N/A N/A self modelXbrl units values N/A i N/A range 2 N/A measure N/A N/A unit measures N/A i N/A table N/A N/A self getTable context context_id N/A accession_id period_start period_end period_instant specifies_dimensions context_xml_id entity_scheme entity_identifier N/A accession_id context_xml_id N/A tuple N/A N/A accsId N/A N/A cntx isStartEndPeriod N/A cntx startDatetime None N/A N/A cntx isStartEndPeriod N/A cntx endDatetime None N/A N/A cntx isInstantPeriod N/A cntx instantDatetime None N/A bool N/A cntx qnameDims N/A cntx id N/A N/A cntx entityIdentifier N/A 0 N/A N/A cntx entityIdentifier N/A 1 N/A cntx N/A N/A N/A N/A self modelXbrl contexts values N/A N/A self cntxId N/A dict N/A N/A N/A _accsId xmlId id N/A N/A id _accsId xmlId table N/A values N/A N/A cntx N/A N/A N/A N/A self modelXbrl contexts values N/A N/A dim N/A N/A N/A cntx qnameDims values N/A N/A N/A N/A values append N/A N/A N/A self cntxId N/A N/A accsId N/A cntx id N/A N/A self qnameId N/A N/A dim dimensionQname N/A N/A N/A self qnameId get N/A dim memberQname N/A N/A dim isTyped N/A N/A N/A self qnameId get N/A N/A dim typedMember qname None False N/A N/A dim contextElement segment N/A N/A dim isTyped N/A N/A dim typedMember stringValue None N/A N/A dimQname memQname N/A N/A N/A N/A self modelXbrl qnameDimensionDefaults items N/A N/A N/A dimQname N/A cntx qnameDims N/A N/A N/A N/A values append N/A N/A N/A self cntxId N/A N/A accsId N/A cntx id N/A N/A self qnameId N/A dimQname N/A N/A self qnameId N/A memQname None True True None N/A table N/A N/A self getTable context_dimension context_dimension_id N/A context_id dimension_qname_id member_qname_id typed_qname_id is_default is_segment typed_text_content N/A context_id dimension_qname_id member_qname_id values insertFactSet N/A N/A modelFacts tupleFactId N/A N/A N/A table N/A N/A self getTable fact fact_id N/A accession_id tuple_fact_id context_id unit_id element_id effective_value fact_value xml_id precision_value decimals_value is_precision_infinity is_decimals_infinity N/A accession_id xml_id N/A tuple N/A N/A accsId tupleFactId N/A N/A N/A self cntxId get N/A accsId N/A fact contextID N/A N/A N/A self unitId get N/A accsId N/A fact unitID N/A N/A self conceptElementId N/A fact concept N/A N/A N/A fact isNumeric N/A N/A fact isNil N/A roundValue N/A fact value N/A fact precision N/A fact decimals None N/A fact value N/A elementFragmentIdentifier fact N/A N/A N/A precision N/A fact xAttributes N/A isinstance N/A N/A N/A fact xAttributes N/A precision xValue int N/A N/A N/A fact xAttributes N/A precision xValue None N/A N/A N/A decimals N/A fact xAttributes N/A isinstance N/A N/A N/A fact xAttributes N/A decimals xValue int N/A N/A N/A fact xAttributes N/A decimals xValue None N/A N/A precision N/A fact xAttributes N/A N/A N/A N/A fact xAttributes N/A precision xValue INF N/A N/A decimals N/A fact xAttributes N/A N/A N/A N/A fact xAttributes N/A decimals xValue INF N/A fact modelFacts N/A factId N/A dict N/A N/A xmlId id N/A N/A id _accsId xmlId table N/A fact modelFacts N/A N/A N/A fact isTuple N/A N/A N/A insertFactSet N/A fact modelTupleFacts N/A factId N/A N/A elementFragmentIdentifier fact N/A N/A N/A insertFactSet N/A N/A self modelXbrl facts None N/A N/A