Hi,

I've subclassed the manager in a model to add a custom method.

class ClientManager(models.Manager):
    """This is a custom manager for the Client model, implementing
some custom
    methods for bulk editing of clients in the database in a more
efficient
    manner."""
    def disconnectAll(self):
        """This method is run at tug startup and shutdown to ensure
that all
        clients have the proper initial state of disconnected. It also
removes
        all SIP clients, since they cannot be persistent."""
        cursor = connection.cursor()
        cursor.execute("""
            UPDATE clients_client
            SET connected = 'f'
            """)
        cursor.execute("""
            DELETE FROM clients_client
            WHERE clientid like '%SIP'
            """)

This seems to work in production with postgreSQL, but on my laptop
with sqlite I'm seeing an issue.

Traceback (most recent call last):
  File "<console>", line 1, in <module>
  File "/home/msoulier/work/mitel-msl-tug/root/etc/e-smith/web/django/
teleworker/../teleworker/clients/models.py", line 22, in disconnectAll
    """)
  File "/home/msoulier/python/lib/python2.5/site-packages/django/db/
backends/util.py", line 21, in execute
    'sql': sql % params,
TypeError: not enough arguments for format string

It looks like the util backend doesn't allow the standard % character
for a LIKE comparison.

Mike
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups 
"Django users" group.
To post to this group, send email to django-users@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at 
http://groups.google.com/group/django-users?hl=en
-~----------~----~----~----~------~----~------~--~---

Reply via email to