Last active
April 17, 2019 05:48
-
-
Save wanghq/77cf14a907e4a328ed2d7937f10e2ae1 to your computer and use it in GitHub Desktop.
Use sqlite in Function Compute
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# -*- coding: utf-8 -*- | |
import logging | |
import os | |
import sqlite3 | |
os.chdir('/tmp') | |
# code is copied from https://www.tutorialspoint.com/sqlite/sqlite_python.htm | |
conn = sqlite3.connect('test.db') | |
print "Opened database successfully"; | |
conn.execute('''CREATE TABLE COMPANY | |
(ID INT PRIMARY KEY NOT NULL, | |
NAME TEXT NOT NULL, | |
AGE INT NOT NULL, | |
ADDRESS CHAR(50), | |
SALARY REAL);''') | |
print "Table created successfully"; | |
conn.execute("INSERT INTO COMPANY (ID,NAME,AGE,ADDRESS,SALARY) \ | |
VALUES (1, 'Paul', 32, 'California', 20000.00 )"); | |
conn.execute("INSERT INTO COMPANY (ID,NAME,AGE,ADDRESS,SALARY) \ | |
VALUES (2, 'Allen', 25, 'Texas', 15000.00 )"); | |
conn.execute("INSERT INTO COMPANY (ID,NAME,AGE,ADDRESS,SALARY) \ | |
VALUES (3, 'Teddy', 23, 'Norway', 20000.00 )"); | |
conn.execute("INSERT INTO COMPANY (ID,NAME,AGE,ADDRESS,SALARY) \ | |
VALUES (4, 'Mark', 25, 'Rich-Mond ', 65000.00 )"); | |
conn.commit() | |
print "Records created successfully"; | |
# if you open the initializer feature, please implement the initializer function, as below: | |
# def initializer(context): | |
# logger = logging.getLogger() | |
# logger.info('initializing') | |
def handler(event, context): | |
logger = logging.getLogger() | |
logger.info('hello world') | |
os.chdir('/tmp') | |
cursor = conn.execute("SELECT id, name, address, salary from COMPANY") | |
for row in cursor: | |
print "ID = ", row[0] | |
print "NAME = ", row[1] | |
print "ADDRESS = ", row[2] | |
print "SALARY = ", row[3], "\n" | |
print "Operation done successfully"; | |
return 'hello world' |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment