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
-~----------~----~----~----~------~----~------~--~---
