Hello,
I have a database design dilema. I want to do a e-learning system for a
course. The course soould have severeal lessons, each lesson can be of
different type.
Let's say we have following model:
#for definiton of each course
db.define_table('course',
Field('title', 'string'))
#for the video lesson
db.define_table('video',
Field('title', 'string'),
Field('video_url', 'string'),
Field('course_id', db.course),
Field('weight', 'integer'))
#for the tekst lesson
db.define_table('text',
Field('title', 'string'),
Field('content', 'text'),
Field('course_id', db.course),
Field('weight', 'integer'))
I know how to do this with a raw sql using UNION, like:
db.executesql('SELECT title, course_id, weight FROM video UNION SELECT
title, course_id, weight FROM text WHERE course_id = *some_value* ORDER BY
weight')
But i wondering if there is any way I can achieve that with DAL? Maybe I
should design the database model in a different way?
Thank you for your replies, ideas, thoughts..
Kristjan
