def init_db():
# Create all tables
models.db.create_all()
bank = [('Beijing Bank', 'Beijing', 0.0),
('Shanghai Bank', 'Shanghai', 0.0), ('Hefei Bank', 'Hefei', 0.0),
('Nanjing Bank', 'Nanjing', 0.0)]
staff = [
('staff_1', '大司马', '13312312345', '芜湖市起飞区', '2012-08-17', 'depart_1'),
('staff_2', '李姐', '13323323333', '理解市李姐万岁', '2019-08-31', 'depart_3'),
('staff_3', '韩金龙', '13323311451', '这波市肉弹冲击', '2020-01-31', 'depart_5'),
('staff_4', '神魔恋', '17344455555', '李在赣神魔市', '2020-01-01', 'depart_2'),
('staff_5', '小王', '18912345678', '北京市海淀区', '2018-01-31', 'depart_4'),
('staff_6', '小李', '13012345678', '合肥市包河区', '2018-02-28', 'depart_2'),
('staff_7', '小郭', '18900011100', '合肥市蜀山区', '2018-10-31', 'depart_3'),
('staff_8', '小史', '18912321232', '广东省深圳市', '2000-01-31', 'depart_3')
]
department = [('depart_1', '市场部', '普通', 'staff_1', 'Beijing Bank'),
('depart_2', '市场部', '普通', 'staff_2', 'Beijing Bank'),
('depart_3', '市场部', '特殊', 'staff_3', 'Shanghai Bank'),
('depart_4', '人事部', '普通', 'staff_4', 'Nanjing Bank'),
('depart_5', '人事部', '普通', 'staff_5', 'Hefei Bank')]
manager = [
('staff_1', 'depart_1'),
('staff_2', 'depart_2'),
('staff_3', 'depart_3'),
('staff_4', 'depart_4'),
('staff_5', 'depart_5'),
]
# add Banks
for item in bank:
models.db.session.add(models.SubBank(*item))
# add Staffs without foreign key
for item in staff:
models.db.session.add(models.Staff(*item[:-1]))
# add department without foreign key
for item in department:
models.db.session.add(models.Department(*item[:-2]))
models.db.session.commit()
# add foreign key
for item in manager:
models.db.session.add(models.Manager(*item))
models.db.session.commit()
for item in staff:
result = models.Staff.query.filter(
models.Staff.s_identity_code == item[0]).first()
result.s_d_code = item[-1]
models.db.session.commit()
for item in department:
result = models.Department.query.filter(
models.Department.d_code == item[0]).first()
result.d_m_identity_code = item[-2]
result.d_sb_name = item[-1]
models.db.session.commit()
def create_db():
db.create_all()
depts = [
'CSE', 'EEE', 'ECE', 'MECH', 'PROD', 'ICE', 'META', 'CIVIL', 'ARCHI',
'CHEM'
]
for dept in depts:
entry = models.Department(department=dept)
db.session.add(entry)
db.session.commit()
def gen_depts():
print('generating departments')
for key in DEPARTMENTS.keys():
dept = models.Department(name=key)
dept.save()
print('Dept', dept.name, 'saved')
description='Address many department level '
'technology issues')
committee_2 = models.Committee(name='Technology',
category='university',
description='Address many university level '
'technology issues')
committee_member_1 = models.CommitteeMembers(role='Chair',
faculty=faculty,
committee=committee_1)
committee_member_2 = models.CommitteeMembers(faculty=faculty,
committee=committee_2)
dept = models.Department(name='Computing Sciences')
course_1 = models.Course(title='Software Engineering',
credits=3,
level='UG',
description='See website',
prerequisites='None',
term=term_fall,
department=dept)
course_time_1 = models.CourseTimes(days='MWF',
start_time=datetime.datetime(
2014, 9, 1, 11, 30),
end_time=datetime.datetime(2014, 9, 1, 14))
course_time_2 = models.CourseTimes(days='TTR',
def add_department(*,
db: Session = Depends(deps.get_db),
department: schemas.DepartmentCreate) -> Any:
"""部门管理-新增"""
db.add(models.Department(**department.dict()))
return {"code": 20000, "data": "", "message": "新增部门成功"}
import csv from app import app, create_app, db from app import models hr = models.Department(name='HR') sales = models.Department(name='Sales') legal = models.Department(name='Legal') engineering = models.Department(name='Engineering') db.add(hr) db.add(sales) db.add(legal) db.add(engineering) admin = models.User(username="******", email="*****@*****.**") guest = models.User(username="******", email="*****@*****.**") jan = models.User(username="******", email="*****@*****.**") hein = models.User(username="******", email="*****@*****.**") klaas = models.User(username="******", email="*****@*****.**") pit = models.User(username="******", email="*****@*****.**") db.add(admin) db.add(guest) db.add(jan) db.add(hein) db.add(klaas) db.add(pit) hr.users.append(admin) sales.users.append(jan) legal.users.append(hein) engineering.users.append(klaas)
def seed():
# db.drop_all()
level1 = models.Level(id=1)
level1.save()
level2 = models.Level(id=2)
level2.save()
level3 = models.Level(id=3)
level3.save()
level4 = models.Level(id=4)
level4.save()
sessiona = models.Session(id=1, name="2011/2012", current=False)
sessiona.save()
sessionb = models.Session(id=2, name="2012/2013", current=False)
sessionb.save()
sessionc = models.Session(id=3, name="2013/2014", current=False)
sessionc.save()
sessiond = models.Session(id=4, name="2014/2015", current=False)
sessiond.save()
sessione = models.Session(id=5, name="2015/2016", current=False)
sessione.save()
sessiona = models.Session(id=6, name="2016/2017", current=True)
sessiona.save()
usera = models.User(id=178646,
email="*****@*****.**",
password="******")
usera.save()
userb = models.User(id=186674, email="*****@*****.**", password="******")
userb.save()
userc = models.User(id=255001,
email="*****@*****.**",
password="******")
userc.save()
userd = models.User(id=255002, email="*****@*****.**", password="******")
userd.save()
facultya = models.Faculty(name="Social Science")
facultya.save()
facultyb = models.Faculty(name="Science")
facultyb.save()
departmenta = models.Department(code="CSC",
name="Customer Science",
fac_name="Science")
departmenta.save()
departmentb = models.Department(code="GEO",
name="Geophraphy",
fac_name="Social Science")
departmentb.save()
studenta = models.Student(firstname="Mofope",
lastname="Ojosh",
department_code="CSC",
student_id=178646,
level=4,
phone_no="08116631381",
sex="F")
studenta.save()
studentb = models.Student(firstname="Omolola",
lastname="Okunubi",
department_code="GEO",
student_id=186674,
level=4,
phone_no="08124456789",
sex="F")
studentb.save()
staffa = models.Staff(firstname="Francis",
lastname="Akomolafe",
staff_id=255001,
phone_no="0812345679",
sex="M")
staffa.save()
staffb = models.Staff(firstname="Tolu",
lastname="Osa",
staff_id=255002,
phone_no="0812345678",
sex="M")
staffb.save()
coursea = models.Course(code=101,
title="Introduction",
unit=4,
level=1,
department_code="CSC")
coursea.save()
coursef = models.Course(code=401,
title="Nigeria",
unit=4,
level=4,
department_code="GEO")
coursef.save()
courseb = models.Course(code=401,
title="Systems Programming",
unit=4,
level=4,
department_code="CSC")
courseb.save()
coursec = models.Course(code=433,
title="Database Systems",
unit=3,
level=4,
department_code="CSC")
courseb.save()
coursed = models.Course(code=402,
title="Operating Systems",
unit=3,
level=4,
department_code="CSC")
coursed.save()
coursee = models.Course(code=422,
title="Computer Organizations",
unit=3,
level=4,
department_code="CSC")
coursee.save()
courseforma = models.Courseform(student_id=178646,
level=4,
session_id=6,
total_units=4)
courseforma.save()
courseformb = models.Courseform(student_id=186674,
level=4,
session_id=6,
total_units=4)
courseformb.save()
offeringa = models.Offering(courseform_id=1, course_id=3)
offeringa.save()
offeringb = models.Offering(courseform_id=2, course_id=2)
offeringb.save()
advisera = models.Adviser(staff_id=255001, department_code="CSC", level=4)
advisera.save()
adviserb = models.Adviser(staff_id=255002, department_code="GEO", level=1)
adviserb.save()