MTabishS/text2sql_

1import sqlite3
2
3# connecting to sqllite
4connection=sqlite3.connect(r'F:\netsol_project\text_2_sql_llm\schema\apartment_rentals.sqlite') 
5
6# creating cursor object to insert record, create tables, and retrieve
7cursor=connection.cursor()
8
9# Displaying all the records
10print('The inserted records are as give:')
11data = cursor.execute('SELECT * FROM Apartment_Bookings')
12
13for row in data:
14    print(row)
15
16# close the connection
17connection.commit()
18connection.close()
19