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