Python query Examples

Example #1

File: tipos_de_exame.py Project: mvsantos013/2020-1-banco-de-dados-trabalho-final

def handler(event, context):
  global data
  
  if(data is None or 'IS_LOCAL' in event):
    data = db.query(f'''SELECT * FROM `tipos_de_exame`;''')

  return {
    'statusCode': 200,
    'headers': { 'Access-Control-Allow-Origin': '*' },
    'body': data.to_json(orient='records')
  }

Example #2

def handler(event, context):
    global data

    if (data is None or 'IS_LOCAL' in event):
        data = db.query(query_string)

    return {
        'statusCode': 200,
        'headers': {
            'Access-Control-Allow-Origin': '*'
        },
        'body': data.to_json(orient='records')
    }