# -*- mode: python; coding: utf-8 -*-
# :Progetto: sqlalchemy -- 
# :Creato:   lun 12 giu 2006 08:48:52 CEST
# :Autore:   Lallo Gaifas <lallo@artiemestieri.tn.it>
# :Licenza:  GNU General Public License
# 

"""
"""

__docformat__ = 'reStructuredText'

from sqlalchemy import *


# collegamento al database
metadata = BoundMetaData('postgres://localhost:5433/gampg', echo='debug')

IDDip=72
DaData='2006-03-01'
AData='2006-03-10'
TipoDati=True

dipendenti = Table('dipendenti', metadata,
                   Column('iddipendente', Integer,
                          Sequence('gen_IDDipendente'),
                          primary_key=True),
                   Column('nome', String),
                   Column('cognome', String))

dip = select(['*'],
       from_obj=[dipendenti, "diario_dipendente(:iddip,:dadata,:adata,:live)"],
       engine=metadata.engine)
print dip
dati = dip.execute(dict(iddip=IDDip, dadata=DaData, adata=AData, live=TipoDati))
#ok = metadata.engine.text('select * from diario_dipendente(:iddip,:dadata,:adata,:live)').execute(iddip=IDDip, dadata=DaData, adata=AData, live=TipoDati)

#link = ok.join_to('dipendenti')
#print link

#dataset = dipendenti.join(select(['*'],(from_obj=["diario_dipendente(:iddip,:dadata,:adata,:live)"]), engine=metadata.engine), dipendenti.c.iddipendente==diario_dipendente.c.iddipendente)
#print dataset
#presenze = Table('presenze', 
#print ok
for row in dati:
    print row

#dip = select(['*'],
#             from_obj=[dipendenti, "diario_dipendente(:iddip,:dadata,:adata,:live)"],
#             engine=metadata.engine)
#print dip
#dati = dip.execute(dict(iddip=IDDip, dadata=DaData, adata=AData, live=TipoDati))
#for row in dati:
#    print row
#query = dd.join(dipendenti)
#print query

#if __name__ == '__main__':
#    altra = metadata.engine.text('select iddipendente from diario_dipendente(:iddip,:dadata,:adata,:live)') 
#    dati = altra.execute(iddip=IDDip, dadata=DaData, adata=AData, live=TipoDati)
#    for row in dati:
#        print row

##     query = select(["IDDipendente"],
##                    from_obj=["diario_dipendente(:iddip,:dadata,:adata,:live)"],
##                    engine=metadata.engine)
##     comp = query.compile(bindparams=[bindparam('iddip', type=types.Integer),
##                                      bindparam('dadata', type=types.Date),
##                                      bindparam('adata', type=types.Date),
##                                      bindparam('live', type=types.Boolean)])
##     comp.execute(
##                   iddip=IDDip, dadata=DaData, adata=AData, live=TipoDati)

    
#    for row in dati:
#        print row
    
#conn = metadata.engine.connect()
#s = select(["*"],from_obj=["diario_dipendente(72,'2006-03-01','2006-03-10',True)"])

#if __name__ == '__main__':
#    result = conn.execute(s)
#    for row in result:
#        print row