Database Errors Logging queries Adding a new Database Driver Models and Fields Fields Creating model tables Model options and table metadata Indexes and Constraints Non-integer Primary Keys, Composite Keys valued logic Adding user-defined operators Expressions Foreign Keys Traversing foreign keys Joining tables Implementing Many to Many Self-joins Performance Techniques Avoiding N+1 queries Iterating over Migrations Reflection Database URL Connection pool Test Utils Flask Utils Query Builder Declaring tables Select queries Insert queries Update queries Delete queries More Hacks Optimistic Locking Top object

queries Adding a new Database Driver Models and Fields Fields Field-naming conflicts Creating model tables Model options and table metadata Indexes and Constraints Non-integer Primary Keys, Composite Keys valued logic Adding user-defined operators Expressions Foreign Keys Traversing foreign keys Joining tables Implementing Many to Many Self-joins Performance Techniques Avoiding N+1 queries Iterating over Migrations Reflection Database URL Connection pool Test Utils Flask Utils Query Builder Declaring tables Select queries Insert queries Update queries Delete queries Query Objects More Hacks Optimistic

Database Errors Logging queries Adding a new Database Driver Models and Fields Fields Creating model tables Model options and table metadata Indexes and Constraints Non-integer Primary Keys, Composite Keys Basic Exercises Joins and Subqueries Modifying Data Aggregation Recursion Query Builder Declaring tables Select queries Insert queries Update queries Delete queries Query Objects More Hacks Optimistic com/coleifer/peewee/issues?state=open] on GitHub or contact me [http://charlesleifer.com/contact/]. Indices and tables Index Module Index Search Page Installing and Testing Most users will want to simply install the

Database Errors Logging queries Adding a new Database Driver Models and Fields Fields Creating model tables Model options and table metadata Indexes and Constraints Non-integer Primary Keys, Composite Keys valued logic Adding user-defined operators Expressions Foreign Keys Traversing foreign keys Joining tables Implementing Many to Many Self-joins Performance Techniques Avoiding N+1 queries Iterating over Migrations Reflection Database URL Connection pool Test Utils Flask Utils Query Builder Declaring tables Select queries Insert queries Update queries Delete queries Query Objects More Hacks Optimistic

Database Errors Logging queries Adding a new Database Driver Models and Fields Fields Creating model tables Model options and table metadata Indexes and Constraints Non-integer Primary Keys, Composite Keys SQL Injection Relationships and Joins Model definitions Performing simple joins Joining multiple tables Selecting from multiple sources Subqueries Multiple foreign-keys to the same Model Joining on arbitrary Basic Exercises Joins and Subqueries Modifying Data Aggregation Recursion Query Builder Declaring tables Select queries Insert queries Update queries Delete queries Query Objects More Hacks Optimistic

Contributing Patches Bugs Questions Managing your Database Creating a database connection and tables Using Postgresql Using SQLite Using BerkeleyDB Using MySQL Connecting using a Database URL Multi-threaded Generating skeleton code Adding a new Database Driver Models and Fields Fields Creating model tables Model options and table metadata Indexes and Constraints Non-integer Primary Keys, Composite Keys valued logic Adding user-defined operators Expressions Foreign Keys Traversing foreign keys Joining tables Implementing Many to Many Self-joins Performance Techniques Avoiding N+1 queries Iterating over

Validation Callback Methods Behaviors DataSources Model Attributes Additional Methods and Properties Virtual fields Transactions Core Libraries General Purpose General Purpose Behaviors Behaviors Components Acl controlled Application Preparing our Application Preparing to Add Auth Initialize the Db Acl tables Acts As a Requester Creating ACOs (Access Control Objects) Simple Acl controlled Application - part users having apache 2.4 and above, you need to modify the configuration file for your httpd.conf or virtual host configuration to look like the following: Options FollowSymLinks

Example app Running the example Diving into the code Model API (smells like django) Creating tables Model instances Model options Model methods Fields Field types table Self-referential Foreign Keys model generator Signal support Sqlite Extensions Swee’pea, syntactic sugar for peewee Indices and tables Index Module Index Search Page © Copyright charles leifer. Created using Sphinx 1.1.2. index next peewee.BooleanField(default=True) Database and Connection Recipes Creating a database connection and tables While it is not necessary to explicitly connect to the database before using it, managing connections

Configuration Configuration Engines Bootstrapping CakePHP Application::bootstrap() Disabling Generic Tables Routing Quick Tour Connecting Routes Route Elements Reserved Route Elements Configuring Route Entities Retrieving Data & Results Sets Validating Data Saving Data Deleting Data Associations - Linking Tables Together Behaviors Schema System Schema Cache Shell AuthComponent Suggested Reading Before Continuing the foreign key would be article_category_id. Join tables, used in BelongsToMany relationships between models, should be named after the model tables they will join or the bake command won’t work, arranged

Storing Runtime Configuration Restoring Runtime Configuration Configuration Engines Disabling Generic Tables Routing RouterBuilder Quick Tour Connecting Routes Route Elements Reserved Route Elements Configuring Entities Retrieving Data & Results Sets Validating Data Saving Data Deleting Data Associations - Linking Tables Together Behaviors Schema System Schema Cache Tool Caching Cache Configuring Cache Engines Cache::setConfig foreign key would be menu_link_id. Join (or “junction”) tables are used in BelongsToMany relationships between models. These should be named for the tables they connect. The names should be pluralized and sorted