Hello,
I've three models called project, project_type and steps.
A project belongs to a certain project_type and depending on what kind of
project it is, includes different steps. For example "writing a book" is a
new project and belongs to the project_type "hobby project".
"making a plan" and "get feedback" are steps for a "hobby project". So the
project "writing a book" should contain this steps.
*My question:*
After creating a second project and saying it's also a "hobby project" the
new project is connected to the same steps like my first project. And if I
modify anything in a step, like mark "making a plan" as completed, it's
also completed for any other project. You can imagine that this is not what
I want to do.
How can I create several steps for a new project, based on which
project_type it is?
I thought about creating a new table "project-with-steps" and insert the
project_id and each project_steps for the project_type into it, but maybe
there is a smarter solution?
This is my current database definition:
db.define_table('project_type',
Field('title', notnull=True, unique=True),
Field('description', 'text', notnull=True),
format='%(title)s')
db.define_table('project',
Field('name', notnull=True),
Field('description', 'text', notnull=True),
Field('project_type', db.project_type, notnull=True),
format='%(name)s')
db.define_table('step',
Field('title', notnull=True, unique=True),
Field('description', 'text', notnull=True),
Field('project_id', db.project),
format='%(title)s')
db.define_table('project_type_with_steps',
Field('type_id', db.project_type),
Field('step_id', db.step))
Thanks for your help!
Andreas
--
---
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/groups/opt_out.
