search

caciviclab / disclosure-backend-static

Campaign finance data powering Open Disclosure California
https://caciviclab.org/odca-jekyll/
15 stars 13 forks source link

Fix schema so all Filer_NamL have the same length. Remove Null constraint from Cmte_ID. #354

Closed mikeubell closed 2 months ago

mikeubell commented 2 months ago

The default schema created for some data tables that were previously empty is incorrect. I have updated all Filer_NamL VARCHAR lengths just in case.

mikeubell commented 2 months ago
Build diff from Commit f32856a03e92a7fd6bbc868a3ee0e5af24170ee4: ```diff diff --git a/build/_data/elections/oakland/2018-06-05.json b/build/_data/elections/oakland/2018-06-05.json index 140316d..b39b338 100644 --- a/build/_data/elections/oakland/2018-06-05.json +++ b/build/_data/elections/oakland/2018-06-05.json @@ -57,7 +57,7 @@ "total_contributions": 15000.0 }, { - "name": "Oakland Athletics Baseball Company", + "name": "Service Employees International Union Local 1021 Issues PAC", "type": "Measure", "election_name": "oakland-june-2018", "total_contributions": 10000.0 diff --git a/build/_data/elections/oakland/2023-11-07.json b/build/_data/elections/oakland/2023-11-07.json index 1e5045c..4e77c51 100644 --- a/build/_data/elections/oakland/2023-11-07.json +++ b/build/_data/elections/oakland/2023-11-07.json @@ -73,19 +73,19 @@ ], "top_contributors_for_offices": [ { - "name": "Service Employees International Union Local 1021 Candidate PAC", + "name": "UA Local 342", "type": "Office", "election_name": "oakland-2023", "total_contributions": 1200.0 }, { - "name": "Oakland Education Association PAC", + "name": "Service Employees International Union Local 1021 Candidate PAC", "type": "Office", "election_name": "oakland-2023", "total_contributions": 1200.0 }, { - "name": "Families in Action for Justice", + "name": "Peralta Federation of Teachers COPE", "type": "Office", "election_name": "oakland-2023", "total_contributions": 1200.0 diff --git a/build/_data/elections/oakland/2024-03-05.json b/build/_data/elections/oakland/2024-03-05.json index a6261f2..db9ca88 100644 --- a/build/_data/elections/oakland/2024-03-05.json +++ b/build/_data/elections/oakland/2024-03-05.json @@ -48,13 +48,13 @@ ], "top_contributors_for_offices": [ { - "name": "Monique C Houston", + "name": "Steven Von Stade", "type": "Office", "election_name": "oakland-march-2024", "total_contributions": 600.0 }, { - "name": "Steven Von Stade", + "name": "Monique C Houston", "type": "Office", "election_name": "oakland-march-2024", "total_contributions": 600.0 diff --git a/build/_data/elections/oakland/2024-11-05.json b/build/_data/elections/oakland/2024-11-05.json index 8bd5599..8440b5b 100644 --- a/build/_data/elections/oakland/2024-11-05.json +++ b/build/_data/elections/oakland/2024-11-05.json @@ -79,19 +79,19 @@ ], "top_contributors_for_offices": [ { - "name": "International Association of Firefighters Local 55", + "name": "International Federation of Professional and Technical Engineers-Local 21 TJ Anthony PAC Fund", "type": "Office", "election_name": "oakland-2024", "total_contributions": 2400.0 }, { - "name": "International Federation of Professional and Technical Engineers-Local 21 TJ Anthony PAC Fund", + "name": "International Association of Firefighters Local 55", "type": "Office", "election_name": "oakland-2024", "total_contributions": 2400.0 }, { - "name": "Todd Scanlin", + "name": "Weylin White", "type": "Office", "election_name": "oakland-2024", "total_contributions": 1800.0 diff --git a/build/_data/stats.json b/build/_data/stats.json index 09774be..eb365a2 100644 --- a/build/_data/stats.json +++ b/build/_data/stats.json @@ -1,3 +1,3 @@ { - "date_processed": "2024-07-01 00:08:53 -0700" + "date_processed": "2024-07-09 00:10:41 -0700" } diff --git a/build/_data/totals.json b/build/_data/totals.json index f82e1c3..f6a1f4e 100644 --- a/build/_data/totals.json +++ b/build/_data/totals.json @@ -1032,7 +1032,7 @@ "total_contributions": 15000.0 }, { - "name": "Oakland Athletics Baseball Company", + "name": "Service Employees International Union Local 1021 Issues PAC", "type": "Measure", "election_name": "oakland-june-2018", "total_contributions": 10000.0 @@ -1385,19 +1385,19 @@ ], "top_contributors_for_offices": [ { - "name": "Service Employees International Union Local 1021 Candidate PAC", + "name": "UA Local 342", "type": "Office", "election_name": "oakland-2023", "total_contributions": 1200.0 }, { - "name": "Oakland Education Association PAC", + "name": "Service Employees International Union Local 1021 Candidate PAC", "type": "Office", "election_name": "oakland-2023", "total_contributions": 1200.0 }, { - "name": "Families in Action for Justice", + "name": "Peralta Federation of Teachers COPE", "type": "Office", "election_name": "oakland-2023", "total_contributions": 1200.0 @@ -1500,13 +1500,13 @@ ], "top_contributors_for_offices": [ { - "name": "Monique C Houston", + "name": "Steven Von Stade", "type": "Office", "election_name": "oakland-march-2024", "total_contributions": 600.0 }, { - "name": "Steven Von Stade", + "name": "Monique C Houston", "type": "Office", "election_name": "oakland-march-2024", "total_contributions": 600.0 @@ -1646,19 +1646,19 @@ ], "top_contributors_for_offices": [ { - "name": "International Association of Firefighters Local 55", + "name": "International Federation of Professional and Technical Engineers-Local 21 TJ Anthony PAC Fund", "type": "Office", "election_name": "oakland-2024", "total_contributions": 2400.0 }, { - "name": "International Federation of Professional and Technical Engineers-Local 21 TJ Anthony PAC Fund", + "name": "International Association of Firefighters Local 55", "type": "Office", "election_name": "oakland-2024", "total_contributions": 2400.0 }, { - "name": "Todd Scanlin", + "name": "Weylin White", "type": "Office", "election_name": "oakland-2024", "total_contributions": 1800.0 diff --git a/build/schema.sql b/build/schema.sql index 0e830b9..437b823 100644 --- a/build/schema.sql +++ b/build/schema.sql @@ -221,7 +221,7 @@ ALTER TABLE public."A-Contributions" OWNER TO travis; CREATE TABLE public."B1-Loans" ( "Filer_ID" character varying(7) NOT NULL, - "Filer_NamL" character varying(104) NOT NULL, + "Filer_NamL" character varying(183) NOT NULL, "Report_Num" character varying(3) NOT NULL, "Committee_Type" character varying(3) NOT NULL, "Rpt_Date" date NOT NULL, @@ -292,7 +292,7 @@ ALTER TABLE public."B1-Loans" OWNER TO travis; CREATE TABLE public."B2-Loans" ( "Filer_ID" character varying(32) NOT NULL, - "Filer_NamL" character varying(32) NOT NULL, + "Filer_NamL" character varying(183) NOT NULL, "Report_Num" character varying(32) NOT NULL, "Committee_Type" character varying(32) NOT NULL, "Rpt_Date" character varying(32) NOT NULL, @@ -648,7 +648,7 @@ ALTER TABLE public."F-Expenses" OWNER TO travis; CREATE TABLE public."F461P5-Expenditure" ( "Filer_ID" character varying(9), - "Filer_NamL" character varying(60) NOT NULL, + "Filer_NamL" character varying(183) NOT NULL, "Report_Num" character varying(3) NOT NULL, "Committee_Type" character varying(3) NOT NULL, "Rpt_Date" date NOT NULL, @@ -808,7 +808,7 @@ ALTER TABLE public."F465P3-Expenditure" OWNER TO travis; CREATE TABLE public."F496P3-Contributions" ( "Filer_ID" character varying(7) NOT NULL, - "Filer_NamL" character varying(172) NOT NULL, + "Filer_NamL" character varying(183) NOT NULL, "Report_Num" character varying(3) NOT NULL, "Committee_Type" character varying(4), "Rpt_Date" date NOT NULL, @@ -966,7 +966,7 @@ ALTER TABLE public."G-Expenditure" OWNER TO travis; CREATE TABLE public."H-Loans" ( "Filer_ID" integer NOT NULL, - "Filer_NamL" character varying(47) NOT NULL, + "Filer_NamL" character varying(183) NOT NULL, "Report_Num" character varying(3) NOT NULL, "Committee_Type" character varying(3) NOT NULL, "Rpt_Date" date NOT NULL, @@ -998,7 +998,7 @@ CREATE TABLE public."H-Loans" ( "Loan_EMP" character varying(32), "Loan_OCC" character varying(32), "Loan_Self" boolean NOT NULL, - "Cmte_ID" integer NOT NULL, + "Cmte_ID" integer, "Tres_NamL" character varying(32), "Tres_NamF" character varying(32), "Tres_NamT" character varying(32), @@ -1037,7 +1037,7 @@ ALTER TABLE public."H-Loans" OWNER TO travis; CREATE TABLE public."I-Contributions" ( "Filer_ID" character varying(7) NOT NULL, - "Filer_NamL" character varying(144) NOT NULL, + "Filer_NamL" character varying(183) NOT NULL, "Report_Num" character varying(3) NOT NULL, "Committee_Type" character varying(3) NOT NULL, "Rpt_Date" date NOT NULL, ```