def migrate_company():
try:
cnx = mysql.connector.connect(
host=self.host,
user=self.username,
password=self.password,
database=self.database,
)
cursor = cnx.cursor()
query = "SELECT * FROM company"
cursor.execute(query)
for (id, name, city, timezone, alarm_email, address, tel, logo,
manager, extra, creator, createdat) in cursor:
u = Company()
u.id = id
u.name = name
u.city = city
u.timezone = timezone
u.alarm_email = alarm_email
u.address = address
u.telephone = tel
u.logo = logo
if manager in [0, -1]:
manager = 10
u.manager = manager
u.extra = extra
u.created_by = 10
u.created_on = createdat
db.session.add(u)
db.session.commit()
cursor.close()
cnx.close()
return "done"
except Exception as e:
return str(e), 500
from model.internship import Internship
from model.open_internship import OpenInternship
from model.program import Program
from model.student import Student
from model.university import University
from model.university_program import university_program # Dont remove
db.create_all()
address1 = Address("Distelstraat 6", "Schaerbeek", "Brussels", "Brussels", "Belgium", "1030")
address2 = Address("Hemeryckxlaan 10", "Kontich", "Antwerp", "Antwerp", "Belgium", "2660")
address3 = Address("Uitbreidingstraat 8", "Berchem", "Antwerp", "Antwerp", "Belgium", "2600")
address4 = Address("Celestijnenlaan 69", "", "Leuven", "Vlaams-Brabant", "Belgium", "3000")
company = Company("uza", "password", "+3212345678", "*****@*****.**", "UZA", "CPY1")
company.address = address1
program = Program("Masters in Applied Computer Science", "MACS")
student1 = Student("student1", "password1", "+3245678910", "*****@*****.**", "Jeff", "Ronald", "Bezos", "STU1")
student1.address = address2
student1.program = program
student2 = Student("student2", "password2", "+3244557766", "*****@*****.**", "John", "Bill", "Gates", "STU2")
student2.address = address4
student2.program = program
student3 = Student("student3", "password3", "+3244557786", "*****@*****.**", "Shawn", "James", "Hill", "STU3")
student3.address = address4
student3.program = program