This code in model:
db.prescription.patient.requires=IS_IN_DB(db
(db.auth_user.is_patient==True),
db.auth_user.id,'%(first_name)s %(last_name)s')
makes sure that a reference is always represened by the name of a
patient. You could make a search action like this:
def search_prescriptions():
form=SQLFORM(db.presction,fields=['patient'])
if FORM.accepts(form,request.vars,keepvalues=True):
doctor=db.auth_user.with_alias('doctor')
prescriptions=db
(db.prescription.patient==request.vars.patient).select(
db.prescription.ALL,db.doctor.ALL,
left=doctor.on
(db.prescription.doctor==doctor.id))
else:
prescriptions=None
return dict(form=form, prescriptions=prescriptions)
It will make a Dropbox with names of patients, you select one and you
get a list of his prescriptions and doctor info.
Massimo
On Jun 28, 8:38 am, jayvandal <[email protected]> wrote:
> Thanks for showing me how the db would be constructed in web2py.
> My big question is how do I code to display the patient in dropdown
> menu on a web page.
> The user would select a patient and then all the prescriptions for the
> patient would be displayed on the web page.
> I could code in Django the view and the template.I could get it to
> display the dropdown list of patients, but when I clicked the patient
> I could see the correct id value although I crashed the program,
> Of course I am not a Django expert, nor a Grails expert
>
> Is there a place where I could access the source code for the
> tutorials such as Cookbook. I am running into a lot of syntax errors
> with keying in the examples. I get bogged down debugging errors. Is
> there a book, ebook?
> Thanks for the time you have spent with me!
> Jim
>
> On Jun 27, 11:03 pm, mdipierro <[email protected]> wrote:
>
> > Short answer:
> > yes it is possible to read that Django model and read those data
> > directly from the existing sqlite database.
> > If you really want to I can send you instructions on how to do it
> > or can arrange to do the conversion from you.
>
> > Long answer:
> > Don't. Export the data for example in CSV and re import them in
> > web2py in a better model.
> > Example:
> > 1) Why patients have web pages and not email but doctors have emails
> > but not web pages not middle names?
> > 2) What if two doctors have the same name?
> > 3) What if a Doctor is also a Patient of another doctor?
> > 4) Doctors and Patients should be derived from the same class
> > (auth_user) and belong to groups with different permissions (Patients,
> > Doctors).
> > 5) Pills (prescriptions) should not be associated to multiple doctors
> > (Many2Many) but always by a single doctor (One2Many)
> > 6) The reason for the Pills (prescription) should probably be a text
> > field and perhaps should allow attachments (like lab reports etc.).
>
> > I would personally do something like this:
>
> > db.define_table('specialty',SQLField('name'))
>
> > from gluon.tools import *
> > auth=Auth(globals(),db) # authentication/authorization
> > # the fields below are requires you can add more
> > auth.settings.table_user = db.define_table("auth_user",
> > db.Field("first_name", length=128,default=""),
> > db.Field("middle_name", length=128,default=""),
> > db.Field("last_name", length=128,default=""),
> > db.Field("email", length=128,default=""),
> > db.Field("web_page", length=128,default=""),
> > db.Field("is_patient", 'boolean', default=True),
> > db.Field("is_doctor", 'boolean', default=True),
> > db.Field("is_administrator", 'boolean', default=True),
> > db.Field("password", "password",readable=False,
> > label="Password"),
> > db.Field("registration_key", length=128,
> > writable=False, readable=False, default=""))
> > t = auth.settings.table_user
> > t.first_name.requires = IS_NOT_EMPTY()
> > t.last_name.requires = IS_NOT_EMPTY()
> > t.password.requires = CRYPT() # password will be stored hashed
> > t.email.requires = [IS_EMAIL(), IS_NOT_IN_DB(db, db.auth_user.email)]
> > t.web_page.requires=IS_URL()
> > auth.define_tables() ### auth_user will not be redefined!
>
> > db.define_table('doctor_speciatly',
> > SQLField('doctor',db.auth_user),
> > SQLField('specialty',db.specialty))
>
> > db.doctor_specialty.doctor.requires=IS_IN_DB(db
> > (db.auth_user.is_doctor==True),
> > db.auth_user.id,'%(first_name)s %(last_name)s')
>
> > db.doctor_specialty.specialty.requires=IS_IN_DB(db,
> > db.specialty.id,'%(name)s')
>
> > db.define_table('prescription',
> > SQLField('doctor',db.auth_user),
> > SQLField('patient',db.auth_user),
> > SQLField('drug_name',length=128),
> > SQLField('prognosis','text'))
>
> > db.prescription.doctor.requires=IS_IN_DB(db
> > (db.auth_user.is_doctor==True),
> > db.auth_user.id,'%(first_name)s %(last_name)s')
>
> > db.prescription.patient.requires=IS_IN_DB(db
> > (db.auth_user.is_patient==True),
> > db.auth_user.id,'%(first_name)s %(last_name)s')
>
> > Massimo
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"web2py Web Framework" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/web2py?hl=en
-~----------~----~----~----~------~----~------~--~---
