Thanks again Arnar,
I'm sorry for my stupidity and for the time that you loose for me.
But I'm going crazy to understand everything. My brain is in overeating
state ;-)) Speaking in sqlAlchemy code:
>
> rules.. you should keep a table of days (with cols year, month, day) -
> but since this is an easily recreatable dataset, no table is really
> neccessary here.
days=Table('days', metadata,
Column('days_id', Integer, primary_key=True),
Column('year', Integer),
Column('month', Integer),
Column('day', Integer))
instrument=Table('instruments', metadata,
Column('instrument_id', Integer, primary_key=True),
Column('name', String))
>
planning=Table('planning', metadata,
Column('planning_id', Integer, primary_key=True),
Column('instrument_id', Integer,ForeignKey('instruments.instrument_id')),
Column('days_id', Integer, ForeignKey('days.days_id')),
Column('data', String))
I've already loose the way....
class Days(object): pass
class Instrument(object): pass
class Planning(object): pass
mapper(Days, days)
mapper(Instruments, instruments)
mapper(Planning, planning,
properties={ 'instruments' :relation(Instruments),
'days' : relation(Days)})
I think to be out of brain.
Please, if you can help me I offer you a wonderful coffee if you come to
Florence.
--
-------------------------------------------------------------------
(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
