Hi,
I'm trying to rewrite an application using Turbogears 2.x framework.
There is a query in that application, which works fine on ms-sql server:
here is the query:
-------------------------
select
Firma_ID = Firma.ID,
Firma_Kod = Firma.Kod,
Firma_Ad = Firma.Unvan,
Nakliye_Tutar = Sum(Sv.Nakliye_Tutar),
Komisyon_Tutar= Sum(Sv.Komisyon_Tutar)
from
(Select
Sevkiyat.ID,
Sevkiyat.Tarih,
Sevkiyat.Arac_ID,
Sevkiyat.CH_Firma_ID,
Siparis.Odeme_Turu,
Siparis.Musteri_Fiyati,
Siparis.Miktar,
Musteri_Tutar = Siparis.Miktar * Siparis.Musteri_Fiyati,
Sevkiyat.Nakliye_Bedeli,
Sevkiyat.Nak_Miktar,
Nakliye_Tutar = case when Siparis.Odeme_Turu = 0 then
Sevkiyat.Nak_Miktar * Sevkiyat.Nakliye_Bedeli else 0 end,
Komisyon_Tutar = case when Siparis.Odeme_Turu = 1 then
(Siparis.Musteri_Fiyati * Siparis.Miktar) - (Sevkiyat.Nak_Miktar *
Sevkiyat.Nakliye_Bedeli) else 0 end
from Sevkiyat
left outer join Siparis on Siparis.ID = Sevkiyat.Siparis_ID
Where Sevkiyat.Nakliye_Odendi = 0 and Sevkiyat.CH_Firma_ID > 0) as Sv
left outer join Firma on Firma.ID = Sv.CH_Firma_ID
where Sv.Nakliye_Tutar > 0 or Sv.Komisyon_Tutar > 0
group by
Firma.ID, Firma.Kod, Firma.Unvan
order by
Firma_Kod
---------------
How can I make this query in python using sqlalchemy?
I've declared the tables using declarative_base and getting results from
queries but some compleks queries like this, I'm lost.
Please tell me some hints and keywords to search on google to find a
sulution.
--
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to sqlalch...@googlegroups.com.
To unsubscribe from this group, send email to
sqlalchemy+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en.
