PostgreSQL Exercises site, then you can load the data into a PostgreSQL database using the following commands: createdb peewee_test psql -U postgres -f clubdata.sql -d peewee_test -x -q To create the schema class Message(Model): user = ForeignKeyField(User, backref='messages') body = TextField() send_date = DateTimeField() This allows you to write code like the following: >>> print(some_message deactivates all user accounts whose registration has expired. After deactivating them, you want to send each user an email letting them know their account was deactivated. Rather than writing two queries

class Message(Model): user = ForeignKeyField(User, backref='messages') body = TextField() send_date = DateTimeField(default=datetime.datetime.now) This allows you to write code like the following: deactivates all user accounts whose registration has expired. After deactivating them, you want to send each user an email letting them know their account was deactivated. Rather than writing two queries registration_expired == True) .returning(User)) # Send an email to every user that was deactivated. for deactivate_user in query.execute(): send_deactivation_email(deactivated_user) The RETURNING

PostgreSQL Exercises site, then you can load the data into a PostgreSQL database using the following commands: createdb peewee_test psql -U postgres -f clubdata.sql -d peewee_test -x -q To create the schema class Message(Model): user = ForeignKeyField(User, backref='messages') body = TextField() send_date = DateTimeField() This allows you to write code like the following: >>> print(some_message deactivates all user accounts whose registration has expired. After deactivating them, you want to send each user an email letting them know their account was deactivated. Rather than writing two queries

PostgreSQL Exercises site, then you can load the data into a PostgreSQL database using the following commands: createdb peewee_test psql -U postgres -f clubdata.sql -d peewee_test -x -q To create the schema class Message(Model): user = ForeignKeyField(User, backref='messages') body = TextField() send_date = DateTimeField() This allows you to write code like the following: >>> print(some_message deactivates all user accounts whose registration has expired. After deactivating them, you want to send each user an email letting them know their account was deactivated. Rather than writing two queries

intuitive way: class Message(Model): user = ForeignKeyField(User, backref='messages') body = TextField() send_date = DateTimeField(default=datetime.datetime.now) This allows you to write code like the following: deactivates all user accounts whose registration has expired. After deactivating them, you want to send each user an email letting them know their account was deactivated. Rather than writing two queries where(User.registration_expired == True) .returning(User)) # Send an email to every user that was deactivated. for deactivate_user in query.execute(): send_deactivation_email(deactivated_user) The RETURNING clause

PostgreSQL Exercises site, then you can load the data into a PostgreSQL database using the following commands: createdb peewee_test psql -U postgres -f clubdata.sql -d peewee_test -x -q To create the schema intuitive way: class Message(Model): user = ForeignKeyField(User, backref='messages') body = TextField() send_date = DateTimeField() This allows you to write code like the following: >>> print(some_message deactivates all user accounts whose registration has expired. After deactivating them, you want to send each user an email letting them know their account was deactivated. Rather than writing two queries

PostgreSQL Exercises site, then you can load the data into a PostgreSQL database using the following commands: createdb peewee_test psql -U postgres -f clubdata.sql -d peewee_test -x -q To create the schema intuitive way: class Message(Model): user = ForeignKeyField(User, backref='messages') body = TextField() send_date = DateTimeField() This allows you to write code like the following: >>> print(some_message deactivates all user accounts whose registration has expired. After deactivating them, you want to send each user an email letting them know their account was deactivated. Rather than writing two queries

class Message(Model): user = ForeignKeyField(User, backref='messages') body = TextField() send_date = DateTimeField(default=datetime.datetime.now) This allows you to write code like the following: deactivates all user accounts whose registration has expired. After deactivating them, you want to send each user an email letting them know their account was deactivated. Rather than writing two queries registration_expired == True) .returning(User)) # Send an email to every user that was deactivated. for deactivate_user in query.execute(): send_deactivation_email(deactivated_user) The RETURNING

Release 3.6.0 class Message(Model): user = ForeignKeyField(User, backref='messages') body = TextField() send_date = DateTimeField(default=datetime.datetime.now) This allows you to write code like the following: deactivates all user accounts whose registration has expired. After deactivating them, you want to send each user an email letting them know their account was deactivated. Rather than writing two queries where(User.registration_expired == True) .returning(User)) # Send an email to every user that was deactivated. for deactivate_user in query.execute(): send_deactivation_email(deactivated_user) The RETURNING clause

Message(Model): user = ForeignKeyField(User, related_name='messages') body = TextField() send_date = DateTimeField() This allows you to write code like the following: >>> print some_message deactivates all user accounts whose registration has expired. After deactivating them, you want to send each user an email letting them know their account was deactivated. Rather than writing two queries registration_expired == True) .returning(User)) # Send an email to every user that was deactivated. for deactivate_user in query.execute(): send_deactivation_email(deactivated_user) The RETURNING