Spaces:
Runtime error
Runtime error
File size: 2,001 Bytes
0ef555c |
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 |
import os
import pandas
import psycopg2
def connect():
if os.getenv('NEW_OJO_HOST') == '':
print("No configuration for the OJO database was found. Please create one now using `ojo_auth()`.")
return
else:
conn = psycopg2.connect(
host = os.getenv('NEW_OJO_HOST'),
database = "ojodb",
user = os.getenv('NEW_OJO_DEFAULT_USER'),
password = os.getenv('NEW_OJO_DEFAULT_PASS'),
port = os.getenv('NEW_OJO_PORT'),
sslmode = os.getenv('NEW_OJO_SSL_MODE'),
sslrootcert = os.getenv('NEW_OJO_SSL_ROOT_CERT'),
sslcert = os.getenv('NEW_OJO_SSL_CERT'),
sslkey = os.getenv('NEW_OJO_SSL_KEY')
)
return conn
# A function to get the list of plaintiffs; Takes a parameter n which is the number of plaintiffs to return;
# If n is None, all plaintiffs are returned
def plaintiffs(n=None):
conn = connect()
with conn:
if n is None:
sql = """select distinct(filed_by) from eviction_addresses.case c left join public.issue i on c.id = i.case_id;"""
else:
sql = """select distinct(filed_by) from eviction_addresses.case c left join public.issue i on c.id = i.case_id limit {};""".format(n)
data = pandas.read_sql_query(sql, conn)
conn.close()
return data
data = plaintiffs().dropna()
data.to_csv('data/plaintiffs.csv', index=False, header=True)
def minutes(n=None):
conn = connect()
with conn:
if n is None:
sql = """select distinct(description) from eviction_addresses.case c left join public.minute m on c.id = m.case_id;"""
else:
sql = """select distinct(description) from eviction_addresses.case c left join public.minute m on c.id = m.case_id limit {};""".format(n)
data = pandas.read_sql_query(sql, conn)
conn.close()
return data
data = minutes().dropna()
data.to_csv('data/minutes.csv', index=False, header=True)
|