def to_sql(self):
return 'INSERT INTO Conferences VALUES ({}, {}, {}, {})'.format(
stringify(self.name),
self.number_of_seats,
stringify(self.start_date.strftime(settings.DATE_FORMAT)),
stringify(self.end_date.strftime(settings.DATE_FORMAT)),
)
def to_sql(self):
return 'INSERT INTO Participants VALUES ({}, {}, {}, {}, {})'.format(
self.client.id,
stringify(self.first_name) if self.first_name else 'NULL',
stringify(self.last_name) if self.last_name else 'NULL',
stringify(self.email) if self.email else 'NULL',
stringify(self.student_id) if self.student_id else 'NULL',
)
def to_sql(self):
return 'INSERT INTO Workshops VALUES ({}, {}, {}, {}, {}, {}, {})'.format(
stringify(self.name),
self.conference.id,
self.number_of_seats,
stringify(self.start_datetime.strftime(settings.DATETIME_FORMAT)),
stringify(self.end_datetime.strftime(settings.DATETIME_FORMAT)),
self.price,
self.lecturer.id,
)
def to_sql(self):
return 'INSERT INTO ConferencePriceThresholds VALUES ({}, {}, {}, {})'.format(
self.conference.id,
stringify(self.end_date.strftime(settings.DATE_FORMAT)),
self.price,
self.student_discount,
)
def to_sql(self):
return 'INSERT INTO RegistrationsForWorkshops VALUES ({}, {}, {})'.format(
self.workshop.id,
self.participant.id,
stringify(self.paid_at.strftime(settings.DATETIME_FORMAT))
if self.paid_at else 'NULL',
)
def to_sql(self):
return 'INSERT INTO Lecturers VALUES ({}, {})'.format(
stringify(self.first_name),
stringify(self.last_name),
)
def to_sql(self):
return 'INSERT INTO Clients VALUES ({}, {}, {})'.format(
stringify(self.client_name) if self.client_name else 'NULL',
stringify(self.email) if self.email else 'NULL',
1 if self.is_company else 0,
)
def to_sql(self):
return 'INSERT INTO RegistrationDateRanges VALUES ({}, {}, {})'.format(
self.registration_for_conference.id,
stringify(self.start_date.strftime(settings.DATE_FORMAT)),
stringify(self.end_date.strftime(settings.DATE_FORMAT)),
)