You can do
db(db.table.field.regexp('your regex')).select()
db(db.table.field.regexp('your regex')).delete()
works with sqlite and postgresql only. The regex syntax may be different
between the two.
On Wednesday, 23 January 2013 00:31:25 UTC-6, Daniel Gonzalez wrote:
>
> Hi,
>
> I have this function to delete a user with a certain email address:
>
> def delete_user(self, email):
> my_query = self.db[self.web2py_user_table].email == email
> my_set = self.db(my_query)
> my_set.delete()
>
> Now I would like to implement a function to delete several users at once,
> based on a regex parameter:
>
> def delete_users(self, regex):
> my_query = <define query using regex>
> my_set = self.db(my_query)
> my_set.delete()
>
> Is it possible to do this?
>
> Thanks,
>
> Daniel
>
--
