Comment 8 for bug 799531

Revision history for this message
Seif Lotfy (seif) wrote : 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 <email address hidden>

> 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
>