new_query = query.where(MyModel.field == ‘value’) unwrap() API for recursively unwrapping “wrapped” nodes. Base case is to return self. class Source([alias=None]) A source of row tuples, for example a table END AS "num_str" # FROM "numbers" class NodeList(nodes[, glue=' '[, parens=False]]) nodes (list) – Zero or more nodes. glue (str) – How to join the nodes when converting to SQL parens (bool) – Whether to list of nodes, a multi-part clause, a list of parameters, etc. CommaNodeList(nodes) nodes (list) – Zero or more nodes. a NodeList Represent a list of nodes joined by commas. EnclosedNodeList(nodes) nodes

new_query = query.where(MyModel.field == 'value') unwrap() API for recursively unwrapping “wrapped” nodes. Base case is to return self. class Source([alias=None]) A source of row tuples, for example a table END AS "num_str" # FROM "numbers" class NodeList(nodes[, glue=' '[, parens=False]]) nodes (list) – Zero or more nodes. glue (str) – How to join the nodes when converting to SQL parens (bool) – Whether to list of nodes, a multi-part clause, a list of parameters, etc. CommaNodeList(nodes) nodes (list) – Zero or more nodes. a NodeList Represent a list of nodes joined by commas. EnclosedNodeList(nodes) nodes

new_query = query.where(MyModel.field == 'value') unwrap() API for recursively unwrapping “wrapped” nodes. Base case is to return self. class Source([alias=None]) A source of row tuples, for example a table END AS "num_str" # FROM "numbers" class NodeList(nodes[, glue=' '[, parens=False]]) nodes (list) – Zero or more nodes. glue (str) – How to join the nodes when converting to SQL parens (bool) – Whether to list of nodes, a multi-part clause, a list of parameters, etc. CommaNodeList(nodes) nodes (list) – Zero or more nodes. a NodeList Represent a list of nodes joined by commas. EnclosedNodeList(nodes) nodes

new_query = query.where(MyModel.field == 'value') unwrap() API for recursively unwrapping “wrapped” nodes. Base case is to return self. class Source([alias=None]) A source of row tuples, for example a table END AS "num_str" # FROM "numbers" class NodeList(nodes[, glue=' '[, parens=False]]) nodes (list) – Zero or more nodes. glue (str) – How to join the nodes when converting to SQL parens (bool) – Whether to list of nodes, a multi-part clause, a list of parameters, etc. CommaNodeList(nodes) nodes (list) – Zero or more nodes. a NodeList Represent a list of nodes joined by commas. EnclosedNodeList(nodes) nodes

new_query = query.where(MyModel.field == 'value') unwrap() API for recursively unwrapping “wrapped” nodes. Base case is to return self. class Source([alias=None]) A source of row tuples, for example a table "num_str" # FROM "numbers" class NodeList(nodes[, glue=’ ’[, parens=False]]) Parameters • nodes (list) – Zero or more nodes. • glue (str) – How to join the nodes when converting to SQL. • parens (bool) Represent a list of nodes, a multi-part clause, a list of parameters, etc. CommaNodeList(nodes) Parameters nodes (list) – Zero or more nodes. Returns a NodeList Represent a list of nodes joined by commas

new_query = query.where(MyModel.field == 'value') unwrap() API for recursively unwrapping “wrapped” nodes. Base case is to return self. class Source([alias=None]) A source of row tuples, for example a table "num_str" # FROM "numbers" class NodeList(nodes[, glue=’ ’[, parens=False]]) Parameters • nodes (list) – Zero or more nodes. • glue (str) – How to join the nodes when converting to SQL. • parens (bool) Represent a list of nodes, a multi-part clause, a list of parameters, etc. CommaNodeList(nodes) Parameters nodes (list) – Zero or more nodes. Returns a NodeList Represent a list of nodes joined by commas

new_query = query.where(MyModel.field == 'value') unwrap() API for recursively unwrapping “wrapped” nodes. Base case is to return self. class Source([alias=None]) A source of row tuples, for example a table "num_str" # FROM "numbers" class NodeList(nodes[, glue=’ ’[, parens=False]]) Parameters • nodes (list) – Zero or more nodes. • glue (str) – How to join the nodes when converting to SQL. • parens (bool) Represent a list of nodes, a multi-part clause, a list of parameters, etc. CommaNodeList(nodes) Parameters nodes (list) – Zero or more nodes. Returns a NodeList Represent a list of nodes joined by commas

atabase.db') db.load_extension('/path/to/closure') model_class – The model class containing the nodes in the tree. foreign_key – The self-referential parent-node field on the model class. If not provided include_node=False]]) Retrieve all descendants of the given node. If a depth is specified, only nodes at that depth (relative to the given node) will be returned. node = Category.get(Category.name == depth=None[, include_node=False]]) Retrieve all ancestors of the given node. If a depth is specified, only nodes at that depth (relative to the given node) will be returned. node = Category.get(Category.name ==

db.load_extension('/path/to/closure') Parameters • model_class – The model class containing the nodes in the tree. • foreign_key – The self-referential parent-node field on the model class. If not provided include_node=False]]) Retrieve all descendants of the given node. If a depth is specified, only nodes at that depth (relative to the given node) will be returned. 96 Chapter 1. Contents: peewee Documentation depth=None[, include_node=False]]) Retrieve all ancestors of the given node. If a depth is specified, only nodes at that depth (relative to the given node) will be returned. node = Category.get(Category.name ==

new_query = query.where(MyModel.field == 'value') unwrap() API for recursively unwrapping “wrapped” nodes. Base case is to return self. is_alias() API for determining if a node, at any point, has been explicitly END AS "num_str" # FROM "numbers" class NodeList(nodes[, glue=' '[, parens=False]]) nodes (list) – Zero or more nodes. glue (str) – How to join the nodes when converting to SQL parens (bool) – Whether to list of nodes, a multi-part clause, a list of parameters, etc. CommaNodeList(nodes) nodes (list) – Zero or more nodes. a NodeList Represent a list of nodes joined by commas. EnclosedNodeList(nodes) nodes