I'm also here.
I offer you an italian pizza for another suggestion. Please, you are
free to tell me if I disturb you.
The database works fine, I'm able to transfer the old planning table
data in the new plan table.
I'd modified my program to read data from this new table and to display
its in a web form like a spreadsheet:
-------------------------------
| Month | instr1 | instr2 | etc.
-------------------------------
| 1 Sun | user | user |
-------------------------------
| 2 Mon | | | user
The administrator can insert the user that he wants in the input fields.
Now, when the admin press Save button the program receive a
dictionary (**kw) in the form:
{'day' : ['user','user','','','user',......],
'day' : ['user','user','','','user',......],
..}
Where day is 1 to how many days has the month, and the array for
each day contains the values for the instruments (the username if there
is an user or an empty string) in the instrument table order.
I'm in trouble to save or update the plan table with the data coming
from the form.
At the first time I'd tried:
for k,v in kw.items():
for instr in self.instruments:
newdata=self.mysession.query(PlanEntry).selectfirst(and_(self.plan.c.year==year,
self.plan.c.month==month, self.plan.c.day==k,
self.plan.c.instrument_id==instr.instrument_id))
to associate to each newdata the new entries and save its.
But I think that this is a bad approach. In your opinion there are some
other ways to do this?
Thanks again for your help.
--
-------------------------------------------------------------------
(o_
(o_ //\ Coltivate Linux che tanto Windows si pianta da solo.
(/)_ V_/_
+------------------------------------------------------------------+
| ENRICO MORELLI | email: [EMAIL PROTECTED] |
| * * * * | phone: +39 055 4574269 |
| University of Florence | fax : +39 055 4574253 |
| CERM - via Sacconi, 6 - 50019 Sesto Fiorentino (FI) - ITALY |
+------------------------------------------------------------------+
-------------------------------------------------------------------------
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________
Sqlalchemy-users mailing list
Sqlalchemy-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users
