From: Frank W. <fra...@no...> - 2007-04-25 06:03:55
|
Hello Group, some days ago i tried to build a query like select sum(provision), verkauf_id, gebucht, rl_id from tda_verkauf group by verkauf_id, gebucht, rl_id with sqlobject and sqlbuilder. Select([Verkauf.q.verkaufID, Verkauf.q.rlID, Verkauf.q.gebucht, func.sum(Verkauf.q.provision)], groupBy=[Verkauf.q.verkaufID, Verkauf.q.rlID, Verkauf.q.gebucht]) it looks quite similar to what i wanted except that it contained a vast number of brackets around everything and especially the groupBy statement. SELECT tda_verkauf.verkauf_id, tda_verkauf.rl_id, tda_verkauf.gebucht, sum(tda_verkauf.provision) FROM tda_verkauf GROUP BY (tda_verkauf.verkauf_id, tda_verkauf.rl_id, tda_verkauf.gebucht) which in the end resulted in a not working statement (mysql). i then removed the sqlobject statement and just hardcoded the above which is just not as nice as keeping it dynamic with sqlobject... how to fix that one? Regards, Frank |
From: Oleg B. <ph...@ph...> - 2007-04-25 09:44:42
|
On Wed, Apr 25, 2007 at 08:03:48AM +0200, Frank Wagner wrote: > how to fix that one? By patching sqlbuilder.py. Or by waiting while someone fix it for you. Oleg. -- Oleg Broytmann http://phd.pp.ru/ ph...@ph... Programmers don't die, they just GOSUB without RETURN. |
From: Frank W. <fra...@no...> - 2007-04-25 10:24:09
|
Oy0pCgpvaywgdGhhdMK0cyBhbHdheXMgYSBzb2x1dGlvbi4KCmkganVzdCB0aG91Z2h0IGl0IHdh cyBtZSBkb2luZyBzb21ldGhpbmcgd3JvbmcuLi4KClJlZ2FyZHMsIEZyYW5rCg== |
From: Oleg B. <ph...@ph...> - 2007-04-25 10:45:30
|
On Wed, Apr 25, 2007 at 12:24:03PM +0200, Frank Wagner wrote: > i just thought it was me doing something wrong... No, that's a bug in sqlbuilder. I'd like to fix it, but I'm waiting for Luke Opperman to merge his revolutionary work into the trunk. He has merged .select() and DBConnection.queryForSelect() into sqlbuilder.Select(), thus making all SELECTs in one place, and giving sqlbuilder.Select() all the features of .select(). Oleg. -- Oleg Broytmann http://phd.pp.ru/ ph...@ph... Programmers don't die, they just GOSUB without RETURN. |
From: Frank W. <fra...@no...> - 2007-04-25 10:53:20
|
b2gsIHRoYXQgc291bmRzIGdyZWF0IQoKanVzdCBsZXQgdXMgYWxsIGtub3cgd2hlbiBpdMK0bGwg YmUgYXZhaWxhYmxlLgoKUmVnYXJkcywKRnJhbmsKCgoKCjIwMDcvNC8yNSwgT2xlZyBCcm95dG1h bm4gPHBoZEBwaGQucHAucnU+Ogo+IE9uIFdlZCwgQXByIDI1LCAyMDA3IGF0IDEyOjI0OjAzUE0g KzAyMDAsIEZyYW5rIFdhZ25lciB3cm90ZToKPiA+IGkganVzdCB0aG91Z2h0IGl0IHdhcyBtZSBk b2luZyBzb21ldGhpbmcgd3JvbmcuLi4KPgo+ICAgIE5vLCB0aGF0J3MgYSBidWcgaW4gc3FsYnVp bGRlci4gSSdkIGxpa2UgdG8gZml4IGl0LCBidXQgSSdtIHdhaXRpbmcgZm9yCj4gTHVrZSBPcHBl cm1hbiB0byBtZXJnZSBoaXMgcmV2b2x1dGlvbmFyeSB3b3JrIGludG8gdGhlIHRydW5rLiBIZSBo YXMgbWVyZ2VkCj4gLnNlbGVjdCgpIGFuZCBEQkNvbm5lY3Rpb24ucXVlcnlGb3JTZWxlY3QoKSBp bnRvIHNxbGJ1aWxkZXIuU2VsZWN0KCksIHRodXMKPiBtYWtpbmcgYWxsIFNFTEVDVHMgaW4gb25l IHBsYWNlLCBhbmQgZ2l2aW5nIHNxbGJ1aWxkZXIuU2VsZWN0KCkgYWxsIHRoZQo+IGZlYXR1cmVz IG9mIC5zZWxlY3QoKS4KPgo+IE9sZWcuCj4gLS0KPiAgICAgIE9sZWcgQnJveXRtYW5uICAgICAg ICAgICAgaHR0cDovL3BoZC5wcC5ydS8gICAgICAgICAgICBwaGRAcGhkLnBwLnJ1Cj4gICAgICAg ICAgICBQcm9ncmFtbWVycyBkb24ndCBkaWUsIHRoZXkganVzdCBHT1NVQiB3aXRob3V0IFJFVFVS Ti4KPgo+IC0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0KPiBUaGlzIFNGLm5ldCBlbWFpbCBpcyBzcG9uc29yZWQg YnkgREIyIEV4cHJlc3MKPiBEb3dubG9hZCBEQjIgRXhwcmVzcyBDIC0gdGhlIEZSRUUgdmVyc2lv biBvZiBEQjIgZXhwcmVzcyBhbmQgdGFrZQo+IGNvbnRyb2wgb2YgeW91ciBYTUwuIE5vIGxpbWl0 cy4gSnVzdCBkYXRhLiBDbGljayB0byBnZXQgaXQgbm93Lgo+IGh0dHA6Ly9zb3VyY2Vmb3JnZS5u ZXQvcG93ZXJiYXIvZGIyLwo+IF9fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19f X19fX19fX19fCj4gc3Fsb2JqZWN0LWRpc2N1c3MgbWFpbGluZyBsaXN0Cj4gc3Fsb2JqZWN0LWRp c2N1c3NAbGlzdHMuc291cmNlZm9yZ2UubmV0Cj4gaHR0cHM6Ly9saXN0cy5zb3VyY2Vmb3JnZS5u ZXQvbGlzdHMvbGlzdGluZm8vc3Fsb2JqZWN0LWRpc2N1c3MKPgo= |