can find more self-contained Peewee examples, like a blog app [https://github.com/coleifer/peewee/tree/master/examples/blog]. I strongly recommend opening an interactive shell session and running the source-code [https://github.com/coleifer/peewee/tree/master/examples/twitter] on github. There is also an example blog app [https://github.com/coleifer/peewee/tree/master/examples/blog] if that’s more to your com/coleifer/peewee/blob/master/examples/], including: Example blog app [https://github.com/coleifer/peewee/tree/master/examples/blog] using Flask and peewee. Also see accompanying blog post [http://charlesleifer

source-code [https://github.com/coleifer/peewee/tree/master/examples/twitter] on github. There is also an example blog app [https://github.com/coleifer/peewee/tree/master/examples/blog] if that’s more to your com/coleifer/peewee/blob/master/examples/], including: Example blog app [https://github.com/coleifer/peewee/tree/master/examples/blog] using Flask and peewee. Also see accompanying blog post [http://charlesleifer -with-python/] you might enjoy as well. Analytics web-service [https://github.com/coleifer/peewee/tree/master/examples/analytics] (like a lite version of Google Analytics). Also check out the companion

the tree() method: >>> KV.create(key='b', value={'x1': {'y1': 'z1', 'y2': 'z2'}, 'x2': [1, 2]}) >>> tree = KV.value.tree().alias('tree') >>> query = KV.select(KV.key, tree.c.fullkey, tree.c.value) value).from_(KV, tree) >>> query.tuples()[:] [('a', '$', {'k1': 'v1'}), ('a', '$.k1', 'v1'), ('b', '$', {'x1': {'y1': 'z1', 'y2': 'z2'}, 'x2': [1, 2]}), ('b', '$.x2', [1, 2]), ('b', '$.x2[0]', 1), ('b' 2), ('b', '$.x1', {'y1': 'z1', 'y2': 'z2'}), ('b', '$.x1.y1', 'z1'), ('b', '$.x1.y2', 'z2')] The tree() and children() methods are powerful. For more information on how to utilize them, see the json1

Recursive CTEs Peewee supports recursive CTEs. Recursive CTEs can be useful when, for example, you have a tree data-structure represented by a parent-link foreign key. Suppose, for example, that we have a hierarchy that a query will be used as a common table expression. For example, if we are modelling a category tree and are using a parent-link foreign key, we can retrieve all categories and their absolute depths the tree() method: >>> KV.create(key='b', value={'x1': {'y1': 'z1', 'y2': 'z2'}, 'x2': [1, 2]}) >>> tree = KV.value.tree().alias('tree') >>> query = KV.select(KV.key, tree.c.fullkey, tree.c.value)

source-code [https://github.com/coleifer/peewee/tree/master/examples/twitter] on github. There is also an example blog app [https://github.com/coleifer/peewee/tree/master/examples/blog] if that’s more to your com/coleifer/peewee/blob/master/examples/], including: Example blog app [https://github.com/coleifer/peewee/tree/master/examples/blog] using Flask and peewee. Also see accompanying blog post [http://charlesleifer -with-python/] you might enjoy as well. Analytics web-service [https://github.com/coleifer/peewee/tree/master/examples/analytics] (like a lite version of Google Analytics). Also check out the companion

source-code [https://github.com/coleifer/peewee/tree/master/examples/twitter] on github. There is also an example blog app [https://github.com/coleifer/peewee/tree/master/examples/blog] if that’s more to your com/coleifer/peewee/blob/master/examples/], including: Example blog app [https://github.com/coleifer/peewee/tree/master/examples/blog] using Flask and peewee. Also see accompanying blog post [http://charlesleifer -with-python/] you might enjoy as well. Analytics web-service [https://github.com/coleifer/peewee/tree/master/examples/analytics] (like a lite version of Google Analytics). Also check out the companion

source-code [https://github.com/coleifer/peewee/tree/master/examples/twitter] on github. There is also an example blog app [https://github.com/coleifer/peewee/tree/master/examples/blog] if that’s more to your com/coleifer/peewee/blob/master/examples/], including: Example blog app [https://github.com/coleifer/peewee/tree/master/examples/blog] using Flask and peewee. Also see accompanying blog post [http://charlesleifer -with-python/] you might enjoy as well. Analytics web-service [https://github.com/coleifer/peewee/tree/master/examples/analytics] (like a lite version of Google Analytics). Also check out the companion

source-code [https://github.com/coleifer/peewee/tree/master/examples/twitter] on github. There is also an example blog app [https://github.com/coleifer/peewee/tree/master/examples/blog] if that’s more to your com/coleifer/peewee/blob/master/examples/], including: Example blog app [https://github.com/coleifer/peewee/tree/master/examples/blog] using Flask and peewee. Also see accompanying blog post [http://charlesleifer -with-python/] you might enjoy as well. Analytics web-service [https://github.com/coleifer/peewee/tree/master/examples/analytics] (like a lite version of Google Analytics). Also check out the companion

it’s possible for us to create recursive queries. This is enormously advantageous for working with tree and graph- structured data - imagine retrieving all of the relations of a graph node to a given depth primitive types, NULL for arrays and objects. • id: a unique ID referencing the current node in the tree. • parent: the ID of the containing node. • fullkey: the full path describing the current element examples, see my blog post on JSON1. SQLite documentation on json_each. tree([path=None]) The tree function corresponds to json_tree, a table-valued function that recursively walks the JSON value provided

it’s possible for us to create recursive queries. This is enormously advantageous for working with tree and graph- structured data - imagine retrieving all of the relations of a graph node to a given depth primitive types, NULL for arrays and objects. • id: a unique ID referencing the current node in the tree. • parent: the ID of the containing node. • fullkey: the full path describing the current element examples, see my blog post on JSON1. SQLite documentation on json_each. tree([path=None]) The tree function corresponds to json_tree, a table-valued function that recursively walks the JSON value provided