-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathtables and database.py
More file actions
107 lines (101 loc) · 13.7 KB
/
Copy pathtables and database.py
File metadata and controls
107 lines (101 loc) · 13.7 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
import mysql.connector as sql
import random
mycon=sql.connect(host='localhost',user='root',passwd='7654321')
cursor=mycon.cursor()
cursor.execute('create database kvsfee')
cursor.execute("use kvsfee")
print('done of database')
cursor.execute("create table CLASS_1(UNIQUE_ID BIGINT NOT NULL PRIMARY KEY, STUDENT_NAME VARCHAR(100), GENDER VARCHAR(50) NOT NULL, SGSC CHAR(50) DEFAULT 'NO', ADMISSION_NO INT NOT NULL, DOB DATE, CLASS INT DEFAULT 1, STREAM VARCHAR(100) DEFAULT 'NIL', FATHERS_NAME VARCHAR(100), MOTHERS_NAME VARCHAR(100), FEE_STATUS VARCHAR(100) DEFAULT 'PENDING');")
print('class_1 done')
cursor.execute("create table CLASS_2(UNIQUE_ID BIGINT NOT NULL PRIMARY KEY, STUDENT_NAME VARCHAR(100), GENDER VARCHAR(50) NOT NULL, SGSC CHAR(50) DEFAULT 'NO', ADMISSION_NO INT NOT NULL, DOB DATE, CLASS INT DEFAULT 2, STREAM VARCHAR(100) DEFAULT 'NIL', FATHERS_NAME VARCHAR(100), MOTHERS_NAME VARCHAR(100), FEE_STATUS VARCHAR(100) DEFAULT 'PENDING');")
print('class_2 done')
cursor.execute("create table CLASS_3(UNIQUE_ID BIGINT NOT NULL PRIMARY KEY, STUDENT_NAME VARCHAR(100), GENDER VARCHAR(50) NOT NULL, SGSC CHAR(50) DEFAULT 'NO', ADMISSION_NO INT NOT NULL, DOB DATE, CLASS INT DEFAULT 3, STREAM VARCHAR(100) DEFAULT 'NIL', FATHERS_NAME VARCHAR(100), MOTHERS_NAME VARCHAR(100), FEE_STATUS VARCHAR(100) DEFAULT 'PENDING');")
print('class_3 done')
cursor.execute("create table CLASS_4(UNIQUE_ID BIGINT NOT NULL PRIMARY KEY, STUDENT_NAME VARCHAR(100), GENDER VARCHAR(50) NOT NULL, SGSC CHAR(50) DEFAULT 'NO', ADMISSION_NO INT NOT NULL, DOB DATE, CLASS INT DEFAULT 4, STREAM VARCHAR(100) DEFAULT 'NIL', FATHERS_NAME VARCHAR(100), MOTHERS_NAME VARCHAR(100), FEE_STATUS VARCHAR(100) DEFAULT 'PENDING');")
print('class_4 done')
cursor.execute("create table CLASS_5(UNIQUE_ID BIGINT NOT NULL PRIMARY KEY, STUDENT_NAME VARCHAR(100), GENDER VARCHAR(50) NOT NULL, SGSC CHAR(50) DEFAULT 'NO', ADMISSION_NO INT NOT NULL, DOB DATE, CLASS INT DEFAULT 5, STREAM VARCHAR(100) DEFAULT 'NIL', FATHERS_NAME VARCHAR(100), MOTHERS_NAME VARCHAR(100), FEE_STATUS VARCHAR(100) DEFAULT 'PENDING');")
print('class_5 done')
cursor.execute("create table CLASS_6(UNIQUE_ID BIGINT NOT NULL PRIMARY KEY, STUDENT_NAME VARCHAR(100), GENDER VARCHAR(50) NOT NULL, SGSC CHAR(50) DEFAULT 'NO', ADMISSION_NO INT NOT NULL, DOB DATE, CLASS INT DEFAULT 6, STREAM VARCHAR(100) DEFAULT 'NIL', FATHERS_NAME VARCHAR(100), MOTHERS_NAME VARCHAR(100), FEE_STATUS VARCHAR(100) DEFAULT 'PENDING');")
print('class_6 done')
cursor.execute("create table CLASS_7(UNIQUE_ID BIGINT NOT NULL PRIMARY KEY, STUDENT_NAME VARCHAR(100), GENDER VARCHAR(50) NOT NULL, SGSC CHAR(50) DEFAULT 'NO', ADMISSION_NO INT NOT NULL, DOB DATE, CLASS INT DEFAULT 7, STREAM VARCHAR(100) DEFAULT 'NIL', FATHERS_NAME VARCHAR(100), MOTHERS_NAME VARCHAR(100), FEE_STATUS VARCHAR(100) DEFAULT 'PENDING');")
print('class_7 done')
cursor.execute("create table CLASS_8(UNIQUE_ID BIGINT NOT NULL PRIMARY KEY, STUDENT_NAME VARCHAR(100), GENDER VARCHAR(50) NOT NULL, SGSC CHAR(50) DEFAULT 'NO', ADMISSION_NO INT NOT NULL, DOB DATE, CLASS INT DEFAULT 8, STREAM VARCHAR(100) DEFAULT 'NIL', FATHERS_NAME VARCHAR(100), MOTHERS_NAME VARCHAR(100), FEE_STATUS VARCHAR(100) DEFAULT 'PENDING');")
print('class_8 done')
cursor.execute("create table CLASS_9(UNIQUE_ID BIGINT NOT NULL PRIMARY KEY, STUDENT_NAME VARCHAR(100), GENDER VARCHAR(50) NOT NULL, SGSC CHAR(50) DEFAULT 'NO', ADMISSION_NO INT NOT NULL, DOB DATE, CLASS INT DEFAULT 9, STREAM VARCHAR(100) DEFAULT 'NIL', FATHERS_NAME VARCHAR(100), MOTHERS_NAME VARCHAR(100), FEE_STATUS VARCHAR(100) DEFAULT 'PENDING');")
print('class_9 done')
cursor.execute("create table CLASS_10(UNIQUE_ID BIGINT NOT NULL PRIMARY KEY, STUDENT_NAME VARCHAR(100), GENDER VARCHAR(50) NOT NULL, SGSC CHAR(50) DEFAULT 'NO', ADMISSION_NO INT NOT NULL, DOB DATE, CLASS INT DEFAULT 10, STREAM VARCHAR(100) DEFAULT 'NIL', FATHERS_NAME VARCHAR(100), MOTHERS_NAME VARCHAR(100), FEE_STATUS VARCHAR(100) DEFAULT 'PENDING');")
print('class_10 done')
cursor.execute("create table CLASS_11(UNIQUE_ID BIGINT NOT NULL PRIMARY KEY, STUDENT_NAME VARCHAR(100), GENDER VARCHAR(50) NOT NULL, SGSC CHAR(50) DEFAULT 'NO', ADMISSION_NO INT NOT NULL, DOB DATE, CLASS INT DEFAULT 11, STREAM VARCHAR(100) DEFAULT 'NIL', FATHERS_NAME VARCHAR(100), MOTHERS_NAME VARCHAR(100), FEE_STATUS VARCHAR(100) DEFAULT 'PENDING');")
print('class_11 done')
cursor.execute("create table CLASS_12(UNIQUE_ID BIGINT NOT NULL PRIMARY KEY, STUDENT_NAME VARCHAR(100), GENDER VARCHAR(50) NOT NULL, SGSC CHAR(50) DEFAULT 'NO', ADMISSION_NO INT NOT NULL, DOB DATE, CLASS INT DEFAULT 12, STREAM VARCHAR(100) DEFAULT 'NIL', FATHERS_NAME VARCHAR(100), MOTHERS_NAME VARCHAR(100), FEE_STATUS VARCHAR(100) DEFAULT 'PENDING');")
print('class_12 done')
cursor.execute("create table LOGIN(USERNAME VARCHAR(100) NOT NULL, PASSWORD INT NOT NULL);")
print('login done')
print("successfully done")
UID=int(random.random()*(10**14))
adi=int(random.random()*(10**4))
cursor.execute("INSERT INTO class_1(UNIQUE_ID,STUDENT_NAME,GENDER,SGSC,ADMISSION_NO,DOB,FATHERS_NAME,MOTHERS_NAME) VALUES({},'RAJU KUMAR','MALE','NO',{},'2006/12/2','RAJESH KUMAR','MAHILA KUMAR')".format(UID,adi))
cursor.execute("INSERT INTO class_2(UNIQUE_ID,STUDENT_NAME,GENDER,SGSC,ADMISSION_NO,DOB,FATHERS_NAME,MOTHERS_NAME) VALUES({},'RAJU KUMAR','MALE','NO',{},'2006/12/2','RAJESH KUMAR','MAHILA KUMAR')".format(UID,adi))
cursor.execute("INSERT INTO class_3(UNIQUE_ID,STUDENT_NAME,GENDER,SGSC,ADMISSION_NO,DOB,FATHERS_NAME,MOTHERS_NAME) VALUES({},'RAJU KUMAR','MALE','NO',{},'2006/12/2','RAJESH KUMAR','MAHILA KUMAR')".format(UID,adi))
cursor.execute("INSERT INTO class_4(UNIQUE_ID,STUDENT_NAME,GENDER,SGSC,ADMISSION_NO,DOB,FATHERS_NAME,MOTHERS_NAME) VALUES({},'RAJU KUMAR','MALE','NO',{},'2006/12/2','RAJESH KUMAR','MAHILA KUMAR')".format(UID,adi))
cursor.execute("INSERT INTO class_5(UNIQUE_ID,STUDENT_NAME,GENDER,SGSC,ADMISSION_NO,DOB,FATHERS_NAME,MOTHERS_NAME) VALUES({},'RAJU KUMAR','MALE','NO',{},'2006/12/2','RAJESH KUMAR','MAHILA KUMAR')".format(UID,adi))
cursor.execute("INSERT INTO class_6(UNIQUE_ID,STUDENT_NAME,GENDER,SGSC,ADMISSION_NO,DOB,FATHERS_NAME,MOTHERS_NAME) VALUES({},'RAJU KUMAR','MALE','NO',{},'2006/12/2','RAJESH KUMAR','MAHILA KUMAR')".format(UID,adi))
cursor.execute("INSERT INTO class_7(UNIQUE_ID,STUDENT_NAME,GENDER,SGSC,ADMISSION_NO,DOB,FATHERS_NAME,MOTHERS_NAME) VALUES({},'RAJU KUMAR','MALE','NO',{},'2006/12/2','RAJESH KUMAR','MAHILA KUMAR')".format(UID,adi))
cursor.execute("INSERT INTO class_8(UNIQUE_ID,STUDENT_NAME,GENDER,SGSC,ADMISSION_NO,DOB,FATHERS_NAME,MOTHERS_NAME) VALUES({},'RAJU KUMAR','MALE','NO',{},'2006/12/2','RAJESH KUMAR','MAHILA KUMAR')".format(UID,adi))
cursor.execute("INSERT INTO class_9(UNIQUE_ID,STUDENT_NAME,GENDER,SGSC,ADMISSION_NO,DOB,FATHERS_NAME,MOTHERS_NAME) VALUES({},'RAJU KUMAR','MALE','NO',{},'2006/12/2','RAJESH KUMAR','MAHILA KUMAR')".format(UID,adi))
cursor.execute("INSERT INTO class_10(UNIQUE_ID,STUDENT_NAME,GENDER,SGSC,ADMISSION_NO,DOB,FATHERS_NAME,MOTHERS_NAME) VALUES({},'RAJU KUMAR','MALE','NO',{},'2006/12/2','RAJESH KUMAR','MAHILA KUMAR')".format(UID,adi))
print("the first record is sucessfull")
UID=int(random.random()*(10**14))
adi=int(random.random()*(10**4))
cursor.execute("INSERT INTO CLASS_1(UNIQUE_ID,STUDENT_NAME,GENDER,SGSC,ADMISSION_NO,DOB,FATHERS_NAME,MOTHERS_NAME) VALUES({},'RANI JAIN','FEMALE','NO',{},'2006/1/1','NEHRU JAIN','URMILA JAIN')".format(UID,adi))
cursor.execute("INSERT INTO CLASS_2(UNIQUE_ID,STUDENT_NAME,GENDER,SGSC,ADMISSION_NO,DOB,FATHERS_NAME,MOTHERS_NAME) VALUES({},'RANI JAIN','FEMALE','NO',{},'2006/1/1','NEHRU JAIN','URMILA JAIN')".format(UID,adi))
cursor.execute("INSERT INTO CLASS_3(UNIQUE_ID,STUDENT_NAME,GENDER,SGSC,ADMISSION_NO,DOB,FATHERS_NAME,MOTHERS_NAME) VALUES({},'RANI JAIN','FEMALE','NO',{},'2006/1/1','NEHRU JAIN','URMILA JAIN')".format(UID,adi))
cursor.execute("INSERT INTO CLASS_4(UNIQUE_ID,STUDENT_NAME,GENDER,SGSC,ADMISSION_NO,DOB,FATHERS_NAME,MOTHERS_NAME) VALUES({},'RANI JAIN','FEMALE','NO',{},'2006/1/1','NEHRU JAIN','URMILA JAIN')".format(UID,adi))
cursor.execute("INSERT INTO CLASS_5(UNIQUE_ID,STUDENT_NAME,GENDER,SGSC,ADMISSION_NO,DOB,FATHERS_NAME,MOTHERS_NAME) VALUES({},'RANI JAIN','FEMALE','NO',{},'2006/1/1','NEHRU JAIN','URMILA JAIN')".format(UID,adi))
cursor.execute("INSERT INTO CLASS_6(UNIQUE_ID,STUDENT_NAME,GENDER,SGSC,ADMISSION_NO,DOB,FATHERS_NAME,MOTHERS_NAME) VALUES({},'RANI JAIN','FEMALE','NO',{},'2006/1/1','NEHRU JAIN','URMILA JAIN')".format(UID,adi))
cursor.execute("INSERT INTO CLASS_7(UNIQUE_ID,STUDENT_NAME,GENDER,SGSC,ADMISSION_NO,DOB,FATHERS_NAME,MOTHERS_NAME) VALUES({},'RANI JAIN','FEMALE','NO',{},'2006/1/1','NEHRU JAIN','URMILA JAIN')".format(UID,adi))
cursor.execute("INSERT INTO CLASS_8(UNIQUE_ID,STUDENT_NAME,GENDER,SGSC,ADMISSION_NO,DOB,FATHERS_NAME,MOTHERS_NAME) VALUES({},'RANI JAIN','FEMALE','NO',{},'2006/1/1','NEHRU JAIN','URMILA JAIN')".format(UID,adi))
cursor.execute("INSERT INTO CLASS_9(UNIQUE_ID,STUDENT_NAME,GENDER,SGSC,ADMISSION_NO,DOB,FATHERS_NAME,MOTHERS_NAME) VALUES({},'RANI JAIN','FEMALE','NO',{},'2006/1/1','NEHRU JAIN','URMILA JAIN')".format(UID,adi))
cursor.execute("INSERT INTO CLASS_10(UNIQUE_ID,STUDENT_NAME,GENDER,SGSC,ADMISSION_NO,DOB,FATHERS_NAME,MOTHERS_NAME) VALUES({},'RANI JAIN','FEMALE','NO',{},'2006/1/1','NEHRU JAIN','URMILA JAIN')".format(UID,adi))
print('second is sucessfull')
UID=int(random.random()*(10**14))
adi=int(random.random()*(10**4))
cursor.execute("INSERT INTO class_1(UNIQUE_ID,STUDENT_NAME,GENDER,SGSC,ADMISSION_NO,DOB,FATHERS_NAME,MOTHERS_NAME) VALUES({},'JIYA RATHOD','FEMALE','YES',{},'2006/3/12','RAJ RATHOD','DIYA RATHOD')".format(UID,adi))
cursor.execute("INSERT INTO class_2(UNIQUE_ID,STUDENT_NAME,GENDER,SGSC,ADMISSION_NO,DOB,FATHERS_NAME,MOTHERS_NAME) VALUES({},'JIYA RATHOD','FEMALE','YES',{},'2006/3/12','RAJ RATHOD','DIYA RATHOD')".format(UID,adi))
cursor.execute("INSERT INTO class_3(UNIQUE_ID,STUDENT_NAME,GENDER,SGSC,ADMISSION_NO,DOB,FATHERS_NAME,MOTHERS_NAME) VALUES({},'JIYA RATHOD','FEMALE','YES',{},'2006/3/12','RAJ RATHOD','DIYA RATHOD')".format(UID,adi))
cursor.execute("INSERT INTO class_4(UNIQUE_ID,STUDENT_NAME,GENDER,SGSC,ADMISSION_NO,DOB,FATHERS_NAME,MOTHERS_NAME) VALUES({},'JIYA RATHOD','FEMALE','YES',{},'2006/3/12','RAJ RATHOD','DIYA RATHOD')".format(UID,adi))
cursor.execute("INSERT INTO class_5(UNIQUE_ID,STUDENT_NAME,GENDER,SGSC,ADMISSION_NO,DOB,FATHERS_NAME,MOTHERS_NAME) VALUES({},'JIYA RATHOD','FEMALE','YES',{},'2006/3/12','RAJ RATHOD','DIYA RATHOD')".format(UID,adi))
cursor.execute("INSERT INTO class_6(UNIQUE_ID,STUDENT_NAME,GENDER,SGSC,ADMISSION_NO,DOB,FATHERS_NAME,MOTHERS_NAME) VALUES({},'JIYA RATHOD','FEMALE','YES',{},'2006/3/12','RAJ RATHOD','DIYA RATHOD')".format(UID,adi))
cursor.execute("INSERT INTO class_7(UNIQUE_ID,STUDENT_NAME,GENDER,SGSC,ADMISSION_NO,DOB,FATHERS_NAME,MOTHERS_NAME) VALUES({},'JIYA RATHOD','FEMALE','YES',{},'2006/3/12','RAJ RATHOD','DIYA RATHOD')".format(UID,adi))
cursor.execute("INSERT INTO class_8(UNIQUE_ID,STUDENT_NAME,GENDER,SGSC,ADMISSION_NO,DOB,FATHERS_NAME,MOTHERS_NAME) VALUES({},'JIYA RATHOD','FEMALE','YES',{},'2006/3/12','RAJ RATHOD','DIYA RATHOD')".format(UID,adi))
cursor.execute("INSERT INTO class_9(UNIQUE_ID,STUDENT_NAME,GENDER,SGSC,ADMISSION_NO,DOB,FATHERS_NAME,MOTHERS_NAME) VALUES({},'JIYA RATHOD','FEMALE','YES',{},'2006/3/12','RAJ RATHOD','DIYA RATHOD')".format(UID,adi))
cursor.execute("INSERT INTO class_10(UNIQUE_ID,STUDENT_NAME,GENDER,SGSC,ADMISSION_NO,DOB,FATHERS_NAME,MOTHERS_NAME) VALUES({},'JIYA RATHOD','FEMALE','YES',{},'2006/3/12','RAJ RATHOD','DIYA RATHOD')".format(UID,adi))
print("the 3nd is sucessfull'")
UID=int(random.random()*(10**14))
adi=int(random.random()*(10**4))
cursor.execute("INSERT INTO class_11(UNIQUE_ID,STUDENT_NAME,GENDER,SGSC,ADMISSION_NO,DOB,STREAM,FATHERS_NAME,MOTHERS_NAME) VALUES({},'RAJU KUMAR','MALE','NO',{},'2006/12/2','CS','RAJESH KUMAR','MAHILA KUMAR')".format(UID,adi))
cursor.execute("INSERT INTO class_12(UNIQUE_ID,STUDENT_NAME,GENDER,SGSC,ADMISSION_NO,DOB,STREAM,FATHERS_NAME,MOTHERS_NAME) VALUES({},'RAJU KUMAR','MALE','NO',{},'2006/12/2','CS','RAJESH KUMAR','MAHILA KUMAR')".format(UID,adi))
UID=int(random.random()*(10**14))
adi=int(random.random()*(10**4))
cursor.execute("INSERT INTO CLASS_11(UNIQUE_ID,STUDENT_NAME,GENDER,SGSC,ADMISSION_NO,DOB,STREAM,FATHERS_NAME,MOTHERS_NAME) VALUES({},'RANI JAIN','FEMALE','NO',{},'2006/1/1','BIO','NEHRU JAIN','URMILA JAIN')".format(UID,adi))
cursor.execute("INSERT INTO CLASS_12(UNIQUE_ID,STUDENT_NAME,GENDER,SGSC,ADMISSION_NO,DOB,STREAM,FATHERS_NAME,MOTHERS_NAME) VALUES({},'RANI JAIN','FEMALE','NO',{},'2006/1/1','BIO','NEHRU JAIN','URMILA JAIN')".format(UID,adi))
UID=int(random.random()*(10**14))
adi=int(random.random()*(10**4))
cursor.execute("INSERT INTO class_11(UNIQUE_ID,STUDENT_NAME,GENDER,SGSC,ADMISSION_NO,DOB,STREAM,FATHERS_NAME,MOTHERS_NAME) VALUES({},'JIYA RATHOD','FEMALE','YES',{},'2006/3/12','BIO','RAJ RATHOD','DIYA RATHOD')".format(UID,adi))
cursor.execute("INSERT INTO class_12(UNIQUE_ID,STUDENT_NAME,GENDER,SGSC,ADMISSION_NO,DOB,STREAM,FATHERS_NAME,MOTHERS_NAME) VALUES({},'JIYA RATHOD','FEMALE','YES',{},'2006/3/12','CS','RAJ RATHOD','DIYA RATHOD')".format(UID,adi))
print('11 and 12 is done')
cursor.execute("INSERT INTO LOGIN VALUES('SUNIL KUMAR T','1111')")
cursor.execute("INSERT INTO LOGIN VALUES('VINOD KUMAR MAHAWAR','1000')")
cursor.execute("INSERT INTO LOGIN VALUES('RINKA A P','3333')")
cursor.execute("INSERT INTO LOGIN VALUES('AISHWARYA V S','4444')")
cursor.execute("INSERT INTO LOGIN VALUES('PRIYANKA GUMBAR','2222')")
cursor.execute("INSERT INTO LOGIN VALUES('RANI','7777')")
cursor.execute("INSERT INTO LOGIN VALUES('RAJA','8888')")
cursor.execute("INSERT INTO LOGIN VALUES('RAHUL','1234')")
cursor.execute("INSERT INTO LOGIN VALUES('SHUBHAM','2345')")
cursor.execute("INSERT INTO LOGIN VALUES('PRANAM','4321')")
cursor.execute("INSERT INTO LOGIN VALUES('VISHAL','5555')")
cursor.execute("INSERT INTO LOGIN VALUES('SHAILESH','6666')")
print('login records is done')
mycon.commit()
mycon.close()