def __getTables(): if (MANUAL_ENGINE_POSTGRES != None): sqlRequest = "SELECT table_schema, table_name FROM information_schema.tables where table_schema like '%%alesforce' ORDER BY table_schema,table_name" result = MANUAL_ENGINE_POSTGRES.execute(sqlRequest) return utils.__resultToDict(result) return {'data': [], "columns": []}
def __getObjects(tableName): if (MANUAL_ENGINE_POSTGRES != None): concat = SALESFORCE_SCHEMA + "." + tableName result = MANUAL_ENGINE_POSTGRES.execute( "select * from {}".format(concat)) return utils.__resultToDict(result) return {'data': [], "columns": []}
def __execRequest(strReq, Attributes): if (MANUAL_ENGINE_POSTGRES != None): result = MANUAL_ENGINE_POSTGRES.execute(strReq, Attributes) return utils.__resultToDict(result) return {'data': [], "columns": []}