-
Notifications
You must be signed in to change notification settings - Fork 0
/
initialize.py
10 lines (9 loc) · 2 KB
/
initialize.py
1
2
3
4
5
6
7
8
9
10
from tkinter import *
from tkinter import messagebox
root = Tk()
import sqlite3
conn = sqlite3.connect("bus_database.db")
c=conn.cursor()
c.execute('''insert into running_details values ('MP1B1','2022-11-30',40),( 'MP1B1','2022-12-01',40),( 'MP1B1','2022-12-02',40),( 'MP1B1','2022-12-03',40),( 'MP1B1','2022-12-04',40),( 'MP1B1','2022-12-05',40),( 'MP1B2','2022-12-01',40),( 'MP1B2','2022-12-02',40),( 'MP1B2','2022-12-04',40),( 'MP1B2','2022-12-05',40),('GJ1B1','2022-11-30',38),('GJ1B1','2022-12-02',38),('GJ1B1','2022-12-04',38),('GJ1B1','2022-12-05',38),('MP2B1','2022-11-30',36),('MP2B1','2022-12-01',36),('MP2B1','2022-12-03',36),('MP2B1','2022-12-04',36),('GJ1B2','2022-11-30',38),('GJ1B2','2022-12-01',38),('GJ1B2','2022-12-02',38),('GJ1B2','2022-12-03',38),('GJ1B2','2022-12-05',38),('MP1B3','2022-12-01',40),('MP1B3','2022-12-02',40),('MP1B3','2022-12-03',40),('MP1B3','2022-12-4',40),('MP1B3','2022-12-05',40),('GJ1B3','2022-11-30',38),('GJ1B3','2022-12-02',38),('GJ1B3','2022-12-04',38),('GJ1B3','2022-12-05',38),('MP3B1','2022-12-01',30),('MP3B1','2022-12-02',30),('MP3B1','2022-12-03',30),('MP3B1','2022-12-4',30),('MP3B1','2022-12-05',30),('GJ1B4','2022-11-30',40),('GJ1B4','2022-12-01',40),('GJ1B4','2022-12-02',40),('GJ1B4','2022-12-03',40),('GJ1B4','2022-12-05',40),('MP2B3','2022-11-30',40),('MP2B3','2022-12-01',40),('MP2B3','2022-12-03',40),('MP2B3','2022-12-04',40),( 'RJ1B1','2022-11-30',30),( 'RJ1B1','2022-12-01',30),( 'RJ1B1','2022-12-02',30),( 'RJ1B1','2022-12-03',30),( 'RJ1B1','2022-12-04',30),( 'RJ1B1','2022-12-05',30),( 'UP1B1','2022-11-30',38),( 'UP1B1','2022-12-01',38),( 'UP1B1','2022-12-02',38),( 'UP1B1','2022-12-03',38),( 'UP1B1','2022-12-04',38),( 'UP1B1','2022-12-05',38),( 'MP4B1','2022-11-30',36),( 'MP4B1','2022-12-01',36),( 'MP4B1','2022-12-02',36),( 'MP4B1','2022-12-03',36),( 'MP4B1','2022-12-04',36),( 'MP4B1','2022-12-05',36),('MP3B2','2022-12-01',30),('MP3B2','2022-12-02',30),('MP3B2','2022-12-03',30),('MP3B2','2022-12-4',30),('MP3B2','2022-12-05',30)''')
conn.commit()
conn.close()