def loadstates(self):
copy_command = '''copy dbapp.ustates
from 's3://crimeanalysisyk/ustates.csv'
iam_role 'arn:aws:iam::234001707946:role/RedshiftLab'
delimiter ',';'''
#script = ScriptReader.get_script(SCRIPT_PATH)
result = RedshiftDataManager.run_update(copy_command, DB_CONNECTION)
def loadhatecrimes(self):
copy_command = '''copy
dbapp.hatecrimes
from
's3://crimeanalysisyk/hate_crime.csv'
iam_role
'arn:aws:iam::234001707946:role/RedshiftLab'
csv;'''
result = RedshiftDataManager.run_update(copy_command, DB_CONNECTION)
def loadgunviolence(self):
copy_command = '''copy
dbapp.gun_violence
from
's3://crimeanalysisyk/gun-violence.csv'
iam_role
'arn:aws:iam::234001707946:role/RedshiftLab'
delimiter
','
ACCEPTANYDATE
dateformat
'MM/DD/YYYY';'''
result = RedshiftDataManager.run_update(copy_command, DB_CONNECTION)
def redshift_update(event, context, script_path):
logger.info(event)
logger.info(context)
DB_CONNECTION = get_creds()
script = ScriptReader.get_script(script_path)
#print(script)
result = RedshiftDataManager.run_update(script, DB_CONNECTION)
event = {
"ExecutionState": result['ExecutionState'],
"ExecutionMessage": result['ExecutionMessage']
}
return event