how to make Query, which is always "True" (1=1 or so) ?

[Jurgis Pralgauskis]

Hi,

   I dynamically generate queries from my search form fields/filters.
   and then map reduce the query list...
   But if no filter is selected, I get empty list...

  So I  try to add dummy query to the beginning:
  Query(db, db._adapter.EQ, 1, 1)

  but I get

AttributeError: 'SQLite' object has no attribute 'EQ'

[Marlysson Silva]

How are you making your query map reduce?

[Jurgis Pralgauskis]

How are you making your query map reduce?

query = reduce(lambda a, b: (a & b), queries)

[Martin Weissenboeck]

Could this solve the problem?

db.define_table("mytable", Field("myvalue"))

mytable contains:

3 selected

mytable.id	mytable.myvalue
1	abc
2	bcd
3	def

----------------------------------------------------------------

def testqueries():

    queries=[True]

    qa = db.mytable.myvalue.contains("a")

    qb = db.mytable.myvalue.contains("b")

    qc = db.mytable.myvalue.contains("c")

    queries.append(qa)

    queries.append(qb)

    w = db(reduce(lambda a,b: (a&b), queries)).select(db.mytable.ALL)

    return locals()

Testqueries

qa	:	<Query (LOWER(mytable.myvalue) LIKE '%a%' ESCAPE '\')>
qb	:	<Query (LOWER(mytable.myvalue) LIKE '%b%' ESCAPE '\')>
qc	:	<Query (LOWER(mytable.myvalue) LIKE '%c%' ESCAPE '\')>
queries	:	True <Query (LOWER(mytable.myvalue) LIKE '%a%' ESCAPE '\')> <Query (LOWER(mytable.myvalue) LIKE '%b%' ESCAPE '\')>
w	:	mytable.id mytable.myvalue 1 abc

----------------------------------------------------------------

def testqueries():

    queries=[True]

    w = db(reduce(lambda a,b: (a&b), queries)).select(db.mytable.ALL)

    return locals()

Testqueries

queries : True w : mytable.id mytable.myvalue 1 abc 2 bcd 3 def

----------------------------------------------------------------

Regards, Martin

2016-11-25 13:32 GMT+01:00 Jurgis Pralgauskis <jurgis.pr...@gmail.com>:

How are you making your query map reduce?

query = reduce(lambda a, b: (a & b), queries)

--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
---
You received this message because you are subscribed to the Google Groups "web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[Anthony]

db.mytable.id > 0

Anthony

[Anthony]

You can also simply specify a query as raw SQL:

db(('1 = 1')).select(db.mytable.ALL)

Anthony