2-tuples are # a tuple of column names to index and a boolean indicating # whether the index is unique or not. indexes = ( # Specify a unique multi-column index on from/to-user. (('from_user', 'to_user') relationship, we create a row in the Relationship table pointing from one user to another. Due to the unique index on from_user and to_user, we will be sure not to end up with duplicate rows: user = get_object_or_404(User Documentation, Release 3.5.0 • null = False – allow null values • index = False – create an index on this column • unique = False – create a unique index on this column. See also adding composite indexes. • column_name

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 latest version BerkeleyDB [http://www.oracle.com/technetwork/database/database- technologies/berkeleydb/downloads/index.html] can be compiled with a SQLite frontend, which works with Peewee. Compiling can be tricky so # a tuple of column names to index and a boolean indicating # whether the index is unique or not. indexes = ( # Specify a unique multi-column index on from/to-user. (('from_user'

2-tuples are # a tuple of column names to index and a boolean indicating # whether the index is unique or not. indexes = ( # Specify a unique multi-column index on from/to-user. (('from_user', 'to_user') relationship, we create a row in the Relationship table pointing from one user to another. Due to the unique index on from_user and to_user, we will be sure not to end up with duplicate rows: user = get_object_or_404(User are allowed to be stored • index = False – boolean indicating whether to create an index on this column • unique = False – boolean indicating whether to create a unique index on this column. See also adding

2-tuples are # a tuple of column names to index and a boolean indicating # whether the index is unique or not. indexes = ( # Specify a unique multi-column index on from/to-user. (('from_user', 'to_user') relationship, we create a row in the Relationship table pointing from one user to another. Due to the unique index on from_user and to_user, we will be sure not to end up with duplicate rows: user = get_object_or_404(User are allowed to be stored • index = False – boolean indicating whether to create an index on this column • unique = False – boolean indicating whether to create a unique index on this column. See also adding

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 latest version BerkeleyDB [http://www.oracle.com/technetwork/database/database- technologies/berkeleydb/downloads/index.html] can be compiled with a SQLite frontend, which works with Peewee. Compiling can be tricky so # a tuple of column names to index and a boolean indicating # whether the index is unique or not. indexes = ( # Specify a unique multi-column index on from/to-user. (('from_user'

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 latest version BerkeleyDB [http://www.oracle.com/technetwork/database/database- technologies/berkeleydb/downloads/index.html] can be compiled with a SQLite frontend, which works with Peewee. Compiling can be tricky so # a tuple of column names to index and a boolean indicating # whether the index is unique or not. indexes = ( # Specify a unique multi-column index on from/to-user. (('from_user'

2-tuples are # a tuple of column names to index and a boolean indicating # whether the index is unique or not. indexes = ( # Specify a unique multi-column index on from/to-user. (('from_user', 'to_user') relationship, we create a row in the Relationship table pointing from one user to another. Due to the unique index on from_user and to_user, we will be sure not to end up with duplicate rows: user = get_object_or_404(User their default values: • null = False – allow null values • index = False – create an index on this column • unique = False – create a unique index on this column. See also adding composite indexes. • column_name

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 latest version BerkeleyDB [http://www.oracle.com/technetwork/database/database- technologies/berkeleydb/downloads/index.html] can be compiled with a SQLite frontend, which works with Peewee. Compiling can be tricky so # a tuple of column names to index and a boolean indicating # whether the index is unique or not. indexes = ( # Specify a unique multi-column index on from/to-user. (('from_user'

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 latest version BerkeleyDB [http://www.oracle.com/technetwork/database/database- technologies/berkeleydb/downloads/index.html] can be compiled with a SQLite frontend, which works with Peewee. Compiling can be tricky so # a tuple of column names to index and a boolean indicating # whether the index is unique or not. indexes = ( # Specify a unique multi-column index on from/to-user. (('from_user'

ForeignKeyField(User, related_name='related_to') class Meta: indexes = ( # Specify a unique multi-column index on from/to-user. (('from_user', 'to_user'), True), ) # a dead simple one-to-many relationship: one relationship, we create a row in the Relationship table pointing from one user to another. Due to the unique index on from_user and to_user, we will be sure not to end up with duplicate rows: user = get_object_or_404(User are allowed to be stored • index = False – boolean indicating whether to create an index on this column • unique = False – boolean indicating whether to create a unique index on this column. See also adding