lx160cm/text-to-sql-generativeai

1import sqlite3
2## COnnect to SQlite
3
4connection=sqlite3.connect("student.db")
5
6# Create a cursor object to insert record, create table
7cursor=connection.cursor()
8
9## create the table
10table_info="""
11Create table STUDENT(NAME VARCHAR(25),CLASS VARCHAR(25), SECTION VARCHAR(25));
12"""
13cursor.execute(table_info)
14##Insert Some Records
15cursor.execute("""Insert into STUDENT values('Ramu','Data Science','A')""")
16cursor.execute("""Insert into STUDENT values('Alex','GenAI','B')""")
17cursor.execute("""Insert into STUDENT values('Shaan','NASA','A')""")
18cursor.execute("""Insert into STUDENT values('Tanvika','DevOps','A')""")
19cursor.execute("""Insert into STUDENT values('Teja','NASA','B')""")
20cursor.execute("""Insert into STUDENT values('Kishore','CIVIL','B')""")
21
22## Display Records
23connection.commit()
24print("The Inserted records are")
25data = cursor.execute('''select *from STUDENT''')
26for row in data:
27    print(row)