Dear,
I have a little problem using CherryPy and SQLAlchemy.
I'm writing a program to manage the planning usage of our
instrumentation.
In a method I can add a new instrument and the procedure ALTER a
planning table adding the new instrument. With a psql I see that the
alteration is correct, the planning table has the new field.
But when I display the planning table, the field there isn't.
Eg. I added av1300 instrument and in the planning table appears:
psql> \d planning_set_2006
gg | integer | not null
day | character varying(3) |
av1000 | character varying(50) |
av200 | character varying(50) |
av400 | character varying(50) |
av500 | character varying(50) |
av600 | character varying(50) |
av700 | character varying(50) |
av700b | character varying(50) |
av700wb | character varying(50) |
av800 | character varying(50) |
av900 | character varying(50) |
relaxometer | character varying(50) |
av1200 | character varying(50) |
av1300 | character varying(50) |
But using the method that open the planning the new instrument there
isn't:
tablename='planning_set_2006'
planning_table=Table(tablename, self.engine, autoload=True)
for f in planning_table.columns:
print f
planning_set_2006.gg
planning_set_2006.day
planning_set_2006.av1000
planning_set_2006.av200
planning_set_2006.av400
planning_set_2006.av500
planning_set_2006.av600
planning_set_2006.av700
planning_set_2006.av700b
planning_set_2006.av700wb
planning_set_2006.av800
planning_set_2006.av900
planning_set_2006.relaxometer
planning_set_2006.av1200
If I stop the CherryPy server and starts it again, the new instrument
is displayed in the planning. There are some reasons for this behaviour?
Thanks.
--
-------------------------------------------------------------------
(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
