this works for me and this time I tried:
>>> db.define_table('a',Field('b'))
>>> query=db.a
>>> print db(query)._select("CASE WHEN 1=1 THEN 0 ELSE 1 END");
SELECT CASE WHEN 1=1 THEN 0 ELSE 1 END FROM a WHERE (a.id > 0);
>>> rows = db(query).select("CASE WHEN 1=1 THEN 0 ELSE 1 END");
On Dec 30, 9:16 am, Harkirat <[email protected]> wrote:
> I already tried the None approach and it didn't work. It returns
> "TypeError: 'NoneType' object is not callable"
>
> Doing the executesql just defeats the purpose of the DAL. We want to
> code to be database independent.
>
> I am in no hurry so if you can post a working sample of this whenever
> you have time that would be great.
>
> Thanks for all your help in this matter.
>
> H.
>
> On Dec 29, 8:12 pm, mdipierro <[email protected]> wrote:
>
> > It is definitively possible. It just that I cannot test it right now.
> > Try:
>
> > db(query).select(Expression("CASE WHEN 1=1 THEN 0 ELSE 1 END",None));
>
> > else you can use
>
> > db.executesql("... any raw sql ...")
>
> > the latter is the safe way. Always works.
>
> > On Dec 29, 6:55 pm, Harkirat <[email protected]> wrote:
>
> > > Thanks for the suggestion Massimo! I haven't been able to get it to
> > > work though.
> > > That syntax returns an error "TypeError: __init__() takes at least 3
> > > arguments (2 given)"
> > > Tried looking at the Expression class defined in DAL.py for what
> > > arguments it needs but haven't been able to figure this out.
> > > Any more suggestions?
>
> > > If this does not work we will most likely have to shift to SQL Alchemy
> > > and I do like working with the DAL so I am keeping my fingers crossed
> > > and hoping there is work around for this.
>
> > > Harkirat
>
> > > On Dec 29, 11:56 am, mdipierro <[email protected]> wrote:
>
> > > > You should be able to doL
>
> > > > from gluon.dal import Expression
>
> > > > db(query).select(Expression("CASE WHEN 1=1 THEN 0 ELSE 1 END"));
>
> > > > Nut I never tried.
>
> > > > On Dec 29, 8:37 am, Harkirat <[email protected]> wrote:
>
> > > > > Hi All !
> > > > > I am new to web2py and my company is building an enterprise
> > > > > level web application that will run on the desktop and also mobile
> > > > > apps using web2py! So far it has been a gr8 experience working with
> > > > > web2py and kudos to all the developers that made such an awesome
> > > > > framework !
>
> > > > > I am trying to write some queries in the DAL that require a CASE
> > > > > statement e.g.
> > > > > SELECT CASE WHEN 1=1 THEN 0 ELSE 1 END
>
> > > > > Is there a way to write this in the DAL?
>
> > > > > Thanks in advance for your help!
>
> > > > > Harkirat
>
>
