cursor

Lambda 上　モデルが作れない場合　直接クエリーで接続

>>> cursor.execute("SELECT id, parent_id FROM test LIMIT 2");

>>> cursor.fetchall()

((54360982, None), (54360880, None))

>>> cursor.execute("SELECT id, parent_id FROM test LIMIT 2");

>>> dictfetchall(cursor)

[{'parent_id': None, 'id': 54360982}, {'parent_id': None, 'id': 54360880}]

>>> cursor.execute("SELECT id, parent_id FROM test LIMIT 2");

>>> results = namedtuplefetchall(cursor)

>>> results

[Result(id=54360982, parent_id=None), Result(id=54360880, parent_id=None)]

>>> results[0].id

54360982

>>> results[0][0]

54360982