Updating existing records Once a model instance has a primary key, any attempt to re-save it will result in an UPDATE rather than another INSERT: >>> blog.save() >>> blog.id 2 >>> blog.save() >>> blog arguments). This method is a shortcut that calls Model.select() with the given query, but limits the result set to 1. Additionally, if no model matches the given query, a DoesNotExist exception will be raised to iterate without caching each model returned, using much less memory when iterating over large result sets: # let's assume we've got 1M stat objects to dump to csv stats_qr = Stat.select().execute()

Updating existing records Once a model instance has a primary key, any attempt to re-save it will result in an UPDATE rather than another INSERT: >>> blog.save() >>> blog.id 2 >>> blog.save() >>> blog arguments). This method is a shortcut that calls Model.select() with the given query, but limits the result set to 1. Addition- ally, if no model matches the given query, a DoesNotExist exception will be raised to iterate without caching each model returned, using much less memory when iterating over large result sets: # let’s assume we’ve got 1M stat objects to dump to csv stats_qr = Stat.select().execute()

Updating existing records Once a model instance has a primary key, any attempt to re-save it will result in an UPDATE rather than another INSERT: >>> blog.save() >>> blog.id 2 >>> blog.save() >>> blog arguments). This method is a shortcut that calls Model.select() with the given query, but limits the result set to 1. Additionally, if no model matches the given query, a DoesNotExist exception will be raised to iterate without caching each model returned, using much less memory when iterating over large result sets: # let's assume we've got 1M stat objects to dump to csv stats_qr = Stat.select().execute()

Updating existing records Once a model instance has a primary key, any attempt to re-save it will result in an UPDATE rather than another INSERT: >>> blog.save() >>> blog.id 2 >>> blog.save() 1.3. Peewee arguments). This method is a shortcut that calls Model.select() with the given query, but limits the result set to 1. Addition- ally, if no model matches the given query, a DoesNotExist exception will be raised to iterate without caching each model returned, using much less memory when iterating over large result sets: # let’s assume we’ve got 1M stat objects to dump to csv stats_qr = Stat.select().execute()

implementations of the SQLite date manipulation functions, the REGEXP operator, and full-text search result ranking algorithms. Installing with git The project is hosted at https://github.com/coleifer/peewee Database.close() method: >>> db.close() True Calling close() on an already-closed connection will not result in an exception, but will return False: >>> db.connect() # Open connection. True >>> db.close() Database object safe to use with multiple threads. Each thread will have it’s own connection, and as a result any given thread will only have a single connection open at a given time. Context managers The

implementations of the SQLite date manipulation functions, the REG- EXP operator, and full-text search result ranking algorithms. 1.1.1 Installing with git The project is hosted at https://github.com/coleifer/peewee Database.close() method: >>> db.close() True Calling close() on an already-closed connection will not result in an exception, but will return False: >>> db.connect() # Open connection. True >>> db.close() Database object safe to use with multiple threads. Each thread will have it’s own connection, and as a result any given thread will only have a single connection open at a given time. 28 Chapter 1. Contents:

implementations of the SQLite date manipulation functions, the REGEXP operator, and full-text search result ranking algorithms. Installing with git The project is hosted at https://github.com/coleifer/peewee Database.close() method: >>> db.close() True Calling close() on an already-closed connection will not result in an exception, but will return False: >>> db.connect() # Open connection. True >>> db.close() wait_write(conn.fileno(), timeout=timeout) else: raise ValueError('poll() returned unexpected result') SQLite, because it is embedded in the Python application itself, does not do any socket operations

implementations of the SQLite date manipulation functions, the REG- EXP operator, and full-text search result ranking algorithms. 1.1.1 Installing with git The project is hosted at https://github.com/coleifer/peewee Database.close() method: >>> db.close() True Calling close() on an already-closed connection will not result in an exception, but will return False: >>> db.connect() # Open connection. True >>> db.close() POLL_WRITE: wait_write(conn.fileno(), timeout=timeout) else: raise ValueError('poll() returned unexpected result') SQLite, because it is embedded in the Python application itself, does not do any socket operations

implementations of the SQLite date manipulation functions, the REGEXP operator, and full-text search result ranking algorithms. Installing with git The project is hosted at https://github.com/coleifer/peewee Database.close() method: >>> db.close() True Calling close() on an already-closed connection will not result in an exception, but will return False: >>> db.connect() # Open connection. True >>> db.close() Database object safe to use with multiple threads. Each thread will have it’s own connection, and as a result any given thread will only have a single connection open at a given time. Context managers The

implementations of the SQLite date manipulation functions, the REG- EXP operator, and full-text search result ranking algorithms. 1.1.1 Installing with git The project is hosted at https://github.com/coleifer/peewee Database.close() method: >>> db.close() True Calling close() on an already-closed connection will not result in an exception, but will return False: >>> db.connect() # Open connection. True >>> db.close() Database object safe to use with multiple threads. Each thread will have it’s own connection, and as a result any given thread will only have a single connection open at a given time. Context managers The