let’s close the connection: >>> db.close() This is just the basics! You can make your queries as complex as you like. All the other SQL clauses are available as well, such as: group_by() having() limit() postgresql my_postgresql_db > models.py Note pwiz generally works quite well with even large and complex database schemas, but in some cases it will not be able to introspect a column. You may need to go database.connect() # This hook ensures that the connection is closed when we've finished # processing the request. @app.teardown_request def _db_close(exc): if not database.is_closed():

let’s close the connection: >>> db.close() This is just the basics! You can make your queries as complex as you like. All the other SQL clauses are available as well, such as: • group_by() 1.2. Quickstart postgresql my_postgresql_db > models.py Note: pwiz generally works quite well with even large and complex database schemas, but in some cases it will not be able to introspect a column. You may need to go _db_connect(): database.connect() # This hook ensures that the connection is closed when we've finished # processing the request. @app.teardown_request def _db_close(exc): if not database.is_closed(): database.close()

let’s close the connection: db.close() This is just the basics! You can make your queries as complex as you like. All the other SQL clauses are available as well, such as: group_by() having() limit() booked, again Output the facility id that has the highest number of slots booked. Ensure that in the event of a tie, all tieing results get output. Postgres ONLY (as written). SELECT facid, total FROM ( database.connect() # This hook ensures that the connection is closed when we've finished # processing the request. @app.teardown_request def _db_close(exc): if not database.is_closed():

let’s close the connection: db.close() This is just the basics! You can make your queries as complex as you like. All the other SQL clauses are available as well, such as: group_by() having() limit() booked, again Output the facility id that has the highest number of slots booked. Ensure that in the event of a tie, all tieing results get output. Postgres ONLY (as written). SELECT facid, total FROM ( [http://initd.org/psycopg], which is a C extension, you can use the following code snippet to register event hooks that will make your connection async: from gevent.socket import wait_read, wait_write from

let’s close the connection: db.close() This is just the basics! You can make your queries as complex as you like. All the other SQL clauses are available as well, such as: • group_by() • having() booked, again Output the facility id that has the highest number of slots booked. Ensure that in the event of a tie, all tieing results get output. Postgres ONLY (as written). SELECT facid, total FROM ( Postgres and psycopg2, which is a C extension, you can use the following code snippet to register event hooks that will make your connection async: from gevent.socket import wait_read, wait_write from

let’s close the connection: db.close() This is just the basics! You can make your queries as complex as you like. All the other SQL clauses are available as well, such as: • group_by() • having() booked, again Output the facility id that has the highest number of slots booked. Ensure that in the event of a tie, all tieing results get output. Postgres ONLY (as written). SELECT facid, total FROM ( Postgres and psycopg2, which is a C extension, you can use the following code snippet to register event hooks that will make your connection async: from gevent.socket import wait_read, wait_write from

let’s close the connection: db.close() This is just the basics! You can make your queries as complex as you like. All the other SQL clauses are available as well, such as: group_by() having() limit() [http://initd.org/psycopg], which is a C extension, you can use the following code snippet to register event hooks that will make your connection async: from gevent.socket import wait_read, wait_write from database.connect() # This hook ensures that the connection is closed when we've finished # processing the request. @app.teardown_request def _db_close(exc): if not database.is_closed():

let’s close the connection: db.close() This is just the basics! You can make your queries as complex as you like. All the other SQL clauses are available as well, such as: • group_by() • having() Postgres and psycopg2, which is a C extension, you can use the following code snippet to register event hooks that will make your connection async: from gevent.socket import wait_read, wait_write from _db_connect(): database.connect() # This hook ensures that the connection is closed when we've finished # processing the request. @app.teardown_request def _db_close(exc): if not database.is_closed(): database.close()

let’s close the connection: db.close() This is just the basics! You can make your queries as complex as you like. All the other SQL clauses are available as well, such as: group_by() having() limit() booked, again Output the facility id that has the highest number of slots booked. Ensure that in the event of a tie, all tieing results get output. Postgres ONLY (as written). SELECT facid, total FROM ( database.connect() # This hook ensures that the connection is closed when we've finished # processing the request. @app.teardown_request def _db_close(exc): if not database.is_closed():

let’s close the connection: db.close() This is just the basics! You can make your queries as complex as you like. Check the documentation on querying for more info. Working with existing databases [http://initd.org/psycopg], which is a C extension, you can use the following code snippet to register event hooks that will make your connection async: from gevent.socket import wait_read, wait_write from database.connect() # This hook ensures that the connection is closed when we've finished # processing the request. @app.teardown_request def _db_close(exc): if not database.is_closed():