English-to-SQL / sample.py
billyeatcookies's picture
feat: Add sql generation
301bca1 verified
raw
history blame contribute delete
711 Bytes
import sqlite3 as sq
connection = sq.connect("student.db")
cursor = connection.cursor()
table_info="""
create table if not exists STUDENT(
NAME VARCHAR(25),
CLASS VARCHAR(25),
SECTION VARCHAR(25)
);
"""
cursor.execute(table_info)
cursor.executescript(
"""insert into STUDENT values('Paul','Data Science', 'A');
insert into STUDENT values('Alex','Data Science', 'B');
insert into STUDENT values('Joshua','Data Science', 'A');
insert into STUDENT values('Derik','History', 'A');
insert into STUDENT values('Jason','History', 'A');
insert into STUDENT values('Maya','History', 'A');"""
)
data = cursor.execute(
"""select * from STUDENT"""
)
for i in data:
print(i)