← Back to team overview

zeitgeist team mailing list archive

Re: [Bug 799531] Re: API for deletion of events within a timerange?

 

looks good
can you make it return the ids of the events that got deleted?
It should support a callback

2012/3/12 Trever Fischer <799531@xxxxxxxxxxxxxxxxxx>

> A potential solution?
>
> ** Patch added: "bzr.patch"
>
> https://bugs.launchpad.net/zeitgeist/+bug/799531/+attachment/2857018/+files/bzr.patch
>
> --
> You received this bug notification because you are a member of Activity
> Log Manager, which is the registrant for Activity Log Manager.
> https://bugs.launchpad.net/bugs/799531
>
> Title:
>  API for deletion of events within a timerange?
>
> Status in Activity Log Manager for Zeitgeist:
>  Invalid
> Status in Zeitgeist Framework:
>  New
>
> Bug description:
>  If I try to select date range more then a month it just freezes.
>
>  $ activity-log-manager
>  INFO:zeitgeist.client:Reconnected to Zeitgeist engine...
>  Error from Zeitgeist engine:
> org.freedesktop.DBus.Python.sqlite3.OperationalError: Traceback (most
> recent call last):
>    File "/usr/lib/pymodules/python2.7/dbus/service.py", line 702, in
> _message_cb
>      retval = candidate_method(self, *args, **keywords)
>    File "/usr/share/zeitgeist/_zeitgeist/engine/remote.py", line 337, in
> DeleteEvents
>      timestamps = self._engine.delete_events(event_ids, sender=sender)
>    File "/usr/share/zeitgeist/_zeitgeist/engine/main.py", line 838, in
> delete_events
>      % ",".join(["?"] * len(ids)), ids)
>    File "/usr/share/zeitgeist/_zeitgeist/engine/sql.py", line 74, in
> execute
>      return super(UnicodeCursor, self).execute(statement, parameters)
>  OperationalError: too many SQL variables
>
>  Version: 0.8.0-0ubuntu1~ppa2~natty
>
> To manage notifications about this bug go to:
> https://bugs.launchpad.net/activity-log-manager/+bug/799531/+subscriptions
>

-- 
You received this bug notification because you are a member of Activity
Log Manager, which is the registrant for Activity Log Manager.
https://bugs.launchpad.net/bugs/799531

Title:
  API for deletion of events within a timerange?

Status in Activity Log Manager for Zeitgeist:
  Invalid
Status in Zeitgeist Framework:
  New

Bug description:
  If I try to select date range more then a month it just freezes.

  $ activity-log-manager 
  INFO:zeitgeist.client:Reconnected to Zeitgeist engine...
  Error from Zeitgeist engine: org.freedesktop.DBus.Python.sqlite3.OperationalError: Traceback (most recent call last):
    File "/usr/lib/pymodules/python2.7/dbus/service.py", line 702, in _message_cb
      retval = candidate_method(self, *args, **keywords)
    File "/usr/share/zeitgeist/_zeitgeist/engine/remote.py", line 337, in DeleteEvents
      timestamps = self._engine.delete_events(event_ids, sender=sender)
    File "/usr/share/zeitgeist/_zeitgeist/engine/main.py", line 838, in delete_events
      % ",".join(["?"] * len(ids)), ids)
    File "/usr/share/zeitgeist/_zeitgeist/engine/sql.py", line 74, in execute
      return super(UnicodeCursor, self).execute(statement, parameters)
  OperationalError: too many SQL variables

  Version: 0.8.0-0ubuntu1~ppa2~natty

To manage notifications about this bug go to:
https://bugs.launchpad.net/activity-log-manager/+bug/799531/+subscriptions


References