Module Import alias Import alias Import alias Import alias ImportFrom alias ImportFrom alias ImportFrom alias ImportFrom alias ImportFrom alias ClassDef bases NameLoad body Assign NameStore Str FunctionDef arguments args NameParam defaults vararg kwarg body Expr Call AttributeLoad NameLoad attr Str Assign AttributeStore NameLoad attr Call NameLoad Assign AttributeStore NameLoad attr Call AttributeLoad AttributeLoad NameLoad attr attr AttributeLoad NameLoad attr Str Str Assign AttributeStore NameLoad attr Call AttributeLoad AttributeLoad NameLoad attr attr AttributeLoad NameLoad attr Str Str Expr Call AttributeLoad NameLoad attr Expr Call AttributeLoad NameLoad attr decorator_list FunctionDef arguments args NameParam defaults body Expr Call AttributeLoad NameLoad attr Str Expr Call AttributeLoad NameLoad attr Str keyword AttributeLoad NameLoad attr Assign NameStore Call AttributeLoad NameLoad attr Assign NameStore BinOpMod Str TupleLoad AttributeLoad NameLoad attr AttributeLoad AttributeLoad NameLoad attr attr Expr Call AttributeLoad NameLoad attr NameLoad decorator_list FunctionDef arguments args NameParam defaults body Expr Call AttributeLoad NameLoad attr Str Assign NameStore Dict Assign NameStore Dict 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 Expr Call AttributeLoad NameLoad attr Str For NameStore Call AttributeLoad NameLoad attr Call NameLoad AttributeLoad NameLoad attr Str body Assign NameStore BinOpMod Str TupleLoad SubscriptLoad NameLoad Index Str SubscriptLoad NameLoad Index Str Assign NameStore BinOpMod Str TupleLoad SubscriptLoad NameLoad Index Str SubscriptLoad NameLoad Index Str TryExcept body Assign NameStore SubscriptLoad NameLoad Index NameLoad handlers ExceptHandler type NameLoad body Continue TryExcept body Assign SubscriptStore SubscriptLoad NameLoad Index NameLoad Index NameLoad Call AttributeLoad NameLoad attr SubscriptLoad NameLoad Index Str handlers ExceptHandler type NameLoad body Assign SubscriptStore NameLoad Index NameLoad Call NameLoad TupleLoad TupleLoad Str Str TupleLoad Str Str TupleLoad Str Str TupleLoad Str Str TupleLoad Str Str TupleLoad Str Str TupleLoad Str Str TupleLoad Str Str TupleLoad Str Str TupleLoad Str Str Assign SubscriptStore SubscriptLoad NameLoad Index NameLoad Index NameLoad Call AttributeLoad NameLoad attr SubscriptLoad NameLoad Index Str Expr Call AttributeLoad NameLoad attr Str Assign NameStore Call AttributeLoad NameLoad attr Call NameLoad AttributeLoad NameLoad attr Str Assign NameStore TupleLoad Str Str Str Str Str Str Str Str Str Str Str Str Expr Call AttributeLoad NameLoad attr NameLoad For TupleStore NameStore NameStore Call AttributeLoad NameLoad attr body Assign NameStore BinOpAdd Call AttributeLoad NameLoad attr Str Call AttributeLoad NameLoad attr Expr Call AttributeLoad NameLoad attr NameLoad decorator_list FunctionDef arguments args NameParam NameParam defaults body If UnaryOpNot NameLoad body Return Str Return NameLoad decorator_list decorator_list
N/A N/A os N/A csv N/A MySQLdb N/A warnings django.db connection calaccess_raw get_download_directory django.utils.datastructures SortedDict calaccess_campaign_browser.models Summary calaccess_campaign_browser.management.commands CalAccessCommand Command N/A CalAccessCommand N/A N/A help Load refined CAL-ACCESS campaign filing summaries handle N/A N/A self N/A args options N/A N/A N/A N/A self header Loading summary totals N/A N/A self data_dir N/A get_download_directory N/A N/A self source_csv N/A N/A N/A os path join N/A self data_dir csv smry_cd.csv N/A N/A self target_csv N/A N/A N/A os path join N/A self data_dir csv smry_cd_transformed.csv N/A N/A N/A self transform_csv N/A N/A N/A self load_csv N/A load_csv N/A N/A self N/A N/A N/A N/A N/A self log  Loading transformed CSV N/A N/A N/A warnings filterwarnings ignore category N/A MySQLdb Warning N/A c N/A N/A connection cursor N/A sql N/A 
            LOAD DATA LOCAL INFILE '%s'
            INTO TABLE %s
            FIELDS TERMINATED BY ','
            OPTIONALLY ENCLOSED BY '"'
            LINES TERMINATED BY '\r\n'
            IGNORE 1 LINES (
                filing_id_raw,
                amend_id,
                itemized_monetary_contributions,
                unitemized_monetary_contributions,
                total_monetary_contributions,
                non_monetary_contributions,
                total_contributions,
                itemized_expenditures,
                unitemized_expenditures,
                total_expenditures,
                ending_cash_balance,
                outstanding_debts
            )
         N/A N/A self target_csv N/A N/A Summary _meta db_table N/A N/A N/A c execute sql N/A transform_csv N/A N/A self N/A N/A N/A N/A N/A self log  Transforming source CSV N/A grouped N/A N/A form2field N/A A-1 A-2 A-3 F460-4 F460-5 E-1 E-2 E-4 F460-16 F460-19 F450-7 F450-8 F450-10 F450-1 F450-2 E-6 itemized_monetary_contributions unitemized_monetary_contributions total_monetary_contributions non_monetary_contributions total_contributions itemized_expenditures unitemized_expenditures total_expenditures ending_cash_balance outstanding_debts total_monetary_contributions non_monetary_contributions total_contributions itemized_expenditures unitemized_expenditures total_expenditures N/A N/A N/A self log   Regrouping N/A r N/A N/A csv DictReader N/A open N/A self source_csv rb N/A N/A uid N/A %s-%s N/A N/A r N/A FILING_ID N/A r N/A AMEND_ID N/A formkey N/A %s-%s N/A N/A r N/A FORM_TYPE N/A r N/A LINE_ITEM N/A N/A N/A field N/A form2field N/A formkey N/A N/A N/A KeyError N/A N/A N/A N/A N/A N/A N/A grouped N/A uid N/A field N/A N/A self safeamt N/A r N/A AMOUNT_A N/A N/A N/A KeyError N/A N/A N/A grouped N/A uid N/A SortedDict N/A N/A itemized_monetary_contributions \N N/A unitemized_monetary_contributions \N N/A total_monetary_contributions \N N/A non_monetary_contributions \N N/A total_contributions \N N/A itemized_expenditures \N N/A unitemized_expenditures \N N/A total_expenditures \N N/A ending_cash_balance \N N/A outstanding_debts \N N/A N/A N/A grouped N/A uid N/A field N/A N/A self safeamt N/A r N/A AMOUNT_A N/A N/A N/A self log   Writing to filesystem N/A out N/A N/A csv writer N/A open N/A self target_csv wb N/A outheaders N/A filing_id_raw amend_id itemized_monetary_contributions unitemized_monetary_contributions total_monetary_contributions non_monetary_contributions total_contributions itemized_expenditures unitemized_expenditures total_expenditures ending_cash_balance outstanding_debts N/A N/A N/A out writerow outheaders N/A N/A uid data N/A N/A grouped items N/A N/A outrow N/A N/A N/A uid split - N/A N/A data values N/A N/A N/A out writerow outrow N/A safeamt N/A N/A self num N/A N/A N/A N/A num N/A N/A \N N/A num N/A N/A