records Aggregating records Retrieving Scalar Values SQL Functions, Subqueries and “Raw expressions” Security and SQL Injection Window functions Retrieving row tuples / dictionaries / namedtuples Returning example we’ll use some different models in a many-to-many configuration: class Photo(Model): image = CharField() class Tag(Model): name = CharField() class PhotoTag(Model): photo = ForeignKeyField(Photo) executing any type of query 2. RawQuery for executing SELECT queries and returning model instances. Security and SQL Injection By default peewee will parameterize queries, so any parameters passed in by the

operators Three valued logic Adding user-defined operators Expressions SQL Functions SQL Helper Security and SQL Injection API Documentation Database Query-builder Fields Schema Manager Model Query-builder example we’ll use some different models in a many-to-many configuration: class Photo(Model): image = CharField() class Tag(Model): name = CharField() class PhotoTag(Model): photo = ForeignKeyField(Photo) executing any type of query 2. RawQuery for executing SELECT queries and returning model instances. Security and SQL Injection By default peewee will parameterize queries, so any parameters passed in by the

records Aggregating records Retrieving Scalar Values SQL Functions, Subqueries and “Raw expressions” Security and SQL Injection Window functions Retrieving row tuples / dictionaries / namedtuples Returning example we’ll use some different models in a many-to-many configuration: class Photo(Model): image = CharField() class Tag(Model): name = CharField() class PhotoTag(Model): photo = ForeignKeyField(Photo) executing any type of query 2. RawQuery for executing SELECT queries and returning model instances. Security and SQL Injection By default peewee will parameterize queries, so any parameters passed in by the

records Aggregating records Retrieving Scalar Values SQL Functions, Subqueries and “Raw expressions” Security and SQL Injection Window functions Retrieving row tuples / dictionaries / namedtuples Returning example we’ll use some different models in a many-to-many configuration: class Photo(Model): image = CharField() class Tag(Model): name = CharField() class PhotoTag(Model): photo = ForeignKeyField(Photo) executing any type of query 2. RawQuery for executing SELECT queries and returning model instances. Security and SQL Injection By default peewee will parameterize queries, so any parameters passed in by the

operators Three valued logic Adding user-defined operators Expressions SQL Functions SQL Helper Security and SQL Injection Relationships and Joins Model definitions Performing simple joins Joining multiple example we’ll use some different models in a many-to-many configuration: class Photo(Model): image = CharField() class Tag(Model): name = CharField() class PhotoTag(Model): photo = ForeignKeyField(Photo) executing any type of query 2. RawQuery for executing SELECT queries and returning model instances. Security and SQL Injection By default peewee will parameterize queries, so any parameters passed in by the

this example we’ll use some different models in a many-to-many configuration: class Photo(Model): image = CharField() class Tag(Model): name = CharField() class PhotoTag(Model): photo = ForeignKeyField(Photo) any type of query 2. RawQuery for executing SELECT queries and returning model instances. 1.8.6 Security and SQL Injection By default peewee will parameterize queries, so any parameters passed in by the perspective which model the ManyToManyField goes on, since the back-reference is just the mirror image. In order to write valid Python, though, you will need to add the ManyToManyField on the second model

this example we’ll use some different models in a many-to-many configuration: class Photo(Model): image = CharField() class Tag(Model): name = CharField() class PhotoTag(Model): photo = ForeignKeyField(Photo) any type of query 2. RawQuery for executing SELECT queries and returning model instances. 1.8.17 Security and SQL Injection By default peewee will parameterize queries, so any parameters passed in by the perspective which model the ManyToManyField goes on, since the back-reference is just the mirror image. In order to write valid Python, though, you will need to add the ManyToManyField on the second model

this example we’ll use some different models in a many-to-many configuration: class Photo(Model): image = CharField() class Tag(Model): name = CharField() class PhotoTag(Model): (continues on next page) any type of query 2. RawQuery for executing SELECT queries and returning model instances. 1.8.17 Security and SQL Injection By default peewee will parameterize queries, so any parameters passed in by the perspective which model the ManyToManyField goes on, since the back-reference is just the mirror image. In order to write valid Python, though, you will need to add the ManyToManyField on the second model

this example we’ll use some different models in a many-to-many configuration: class Photo(Model): image = CharField() class Tag(Model): name = CharField() class PhotoTag(Model): photo = ForeignKeyField(Photo) any type of query 2. RawQuery for executing SELECT queries and returning model instances. 1.8.6 Security and SQL Injection By default peewee will parameterize queries, so any parameters passed in by the perspective which model the ManyToManyField goes on, since the back-reference is just the mirror image. In order to write valid Python, though, you will need to add the ManyToManyField on the second model

records Aggregating records Retrieving Scalar Values SQL Functions, Subqueries and “Raw expressions” Security and SQL Injection Window functions Retrieving raw tuples / dictionaries Returning Clause Query example we’ll use some different models in a many-to-many configuration: class Photo(Model): image = CharField() class Tag(Model): name = CharField() class PhotoTag(Model): photo = ForeignKeyField(Photo) Person.raw('select * from person'): print person.name # .raw() will return model instances. Security and SQL Injection By default peewee will parameterize queries, so any parameters passed in by the