Hi,
I cannot find out how correctly to write in SQLAlchemy the following
SQL statement:
select
f.logical_name,
f.filesize,
fs.name,
ft.name
from t_processed_dataset pd
join t_processing p
on p.primary_dataset = pd.primary_dataset
and p.name = pd.name
join t_block b
on b.processing = p.id
join t_block_status bs
on bs.id = b.status
left join t_file f
on f.inblock = b.id
left join t_file_status fs
on fs.id = f.status
left join t_file_type ft
on ft.id = f.type
where pd.id='%s' and b.id='%s'
order by f.logical_name
I would appreciate your help.
Valentin.
-------------------------------------------------------------------------
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
[email protected]
https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users
