Basically, I am trying to compare *between *dates here. One other query
works but the ones specified earlier (below) do not. I am sure that there
is some programming mistake from my side. But I am not sure what it is -
Tickets = db((db.issues.date_today >= daysix) & (db.issues.date_today <=
today)).select(db.issues.ticket_no)
Here,
today = datetime.date.today()# day 1
daysix = today - datetime.timedelta(days=5) # day6
Rahul
On Tuesday, July 31, 2018 at 5:18:26 PM UTC+5:30, Rahul wrote:
>
> Hi Anthony,
> I am printing this to console - The query is trying to fetch
> records that have an ETA in next 15 days
>
> print db(((db.issues.eta_date > today) & (db.issues.eta_date <=
> fifteen_days_ahead)) & (db.issues.workspace == user_workspace) & (db.
> issues.created_by == logged_in_user))._select()
>
> Here is the query output (Just removed a few fields only in between as
> there were many) - If needed I will send the entire query.
> SELECT "issues"."id", "issues"."ticket_no", "issues"."project_name",
> "issues"."sub_project", "issues"."team", "issues"."date_today", "issues".
> "category", "issues"."created_by", "issues"."workspace", "issues".
> "eta_date", "issues"."notify" FROM "issues" WHERE (((("issues"."eta_date"
> > '2018-07-31') AND ("issues"."eta_date" <= '2018-08-14')) AND ("issues".
> "workspace" = 'WS1')) AND ("issues"."created_by" = 'rahul'));
>
> Let me know if anything else is needed -
>
> Thank you
> Rahul
>
>
> On Monday, July 30, 2018 at 11:23:05 PM UTC+5:30, Anthony wrote:
>>
>> Can you print out the raw SQL via ._select() so we can see exactly what
>> is being sent to the database when the error occurs?
>>
>> On Monday, July 30, 2018 at 5:39:35 AM UTC-4, Rahul wrote:
>>>
>>> Okay I followed everyones instructions
>>> I installed psycopg2 and the application is using this by default.
>>> However it is giving me the same errors I got before. I did not earlier use
>>> "%s" % but in the example I provided I just gave it a try as somewhere I
>>> think it referred to a string issue.
>>>
>>> 1.
>>> 2.
>>> 3.
>>> 4.
>>> 5.
>>> 6.
>>> 7.
>>> 8.
>>> 9.
>>> 10.
>>> 11.
>>> 12.
>>> 13.
>>> 14.
>>> 15.
>>> 16.
>>> 17.
>>> 18.
>>> 19.
>>> 20.
>>> 21.
>>> 22.
>>> 23.
>>>
>>> Traceback (most recent call last):
>>> File "D:\web2py\web2py\gluon\restricted.py", line 219, in restricted
>>> exec(ccode, environment)
>>> File "D:/web2py/web2py/applications/Target/controllers/default.py"
>>> <http://127.0.0.1:8000/admin/default/edit/Target/controllers/default.py>,
>>> line 15360, in <module>
>>> File "D:\web2py\web2py\gluon\globals.py", line 409, in <lambda>
>>> self._caller = lambda f: f()
>>> File "D:/web2py/web2py/applications/Target/controllers/default.py"
>>> <http://127.0.0.1:8000/admin/default/edit/Target/controllers/default.py>,
>>> line 714, in dashboard
>>> alertRows=s.select()
>>> File "D:\web2py\web2py\gluon\packages\dal\pydal\objects.py", line 2211,
>>> in select
>>> return adapter.select(self.query, fields, attributes)
>>> File "D:\web2py\web2py\gluon\packages\dal\pydal\adapters\base.py", line
>>> 762, in select
>>> return self._select_aux(sql, fields, attributes, colnames)
>>> File "D:\web2py\web2py\gluon\packages\dal\pydal\adapters\base.py", line
>>> 718, in _select_aux
>>> rows = self._select_aux_execute(sql)
>>> File "D:\web2py\web2py\gluon\packages\dal\pydal\adapters\base.py", line
>>> 712, in _select_aux_execute
>>> self.execute(sql)
>>> File "D:\web2py\web2py\gluon\packages\dal\pydal\adapters\__init__.py",
>>> line 67, in wrap
>>> return f(*args, **kwargs)
>>> File "D:\web2py\web2py\gluon\packages\dal\pydal\adapters\base.py", line
>>> 412, in execute
>>> rv = self.cursor.execute(command, *args[1:], **kwargs)
>>> InternalError: current transaction is aborted, commands ignored until end
>>> of transaction block
>>>
>>>
>>> <class 'psycopg2.InternalError'> current transaction is aborted,
>>> commands ignored until end of transaction block
>>>
>>> Any suggestions?
>>>
>>> Rahul
>>>
>>> On Sunday, July 29, 2018 at 10:24:07 PM UTC+5:30, Joe Barnhart wrote:
>>>>
>>>> I’d get rid of the idiom:
>>>>
>>>> db.colname==“%s”%pythonvar
>>>>
>>>> Just replace it with:
>>>>
>>>> db.colname==pythonvar
>>>>
>>>> — Joe
>>>
>>>
--
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 [email protected].
For more options, visit https://groups.google.com/d/optout.
