PolyU IT Support for Research Apr 2020 Page-1 Notes for install Keras on Anaconda3: For some machines, you might find difficulties by following the official document of installing Keras for

message another message yet another message For full documentation on fields, see the Fields API notes Field types table Field Type Sqlite Postgresql MySQL IntegerField integer integer integer BigIntegerField table's columns. # Evaluates to SELECT id, username FROM users query = User.select() Note = Table('notes') query = (Note .select(Note.c.content, Note.c.timestamp, User.username) .join(User to select users and the number of notes they # have authored. query = (User .select( User.username, fn.COUNT(Note.c.id).alias('n_notes')) .join( Note,

join(User).where( (Tweet.pub_date >= today) & (User.active == True) ) Check out the docs for notes on the methods of querying. Why? peewee began when I was working on a small app in flask and found "id", "creator", "name" FROM "blog" WHERE "id" = ? LIMIT 1 PARAMS: [1000] For more information see notes on SelectQuery and Querying API in general. Selecting multiple records To simply get all instances primary key by default, though other types of data can be stored by specifying a column_class. See notes on non-integer primary keys. __init__(column_class[, ...]) Parameters: column_class – a reference

message another message yet another message For full documentation on fields, see the Fields API notes Field types table Field Type Sqlite Postgresql MySQL IntegerField integer integer integer BigIntegerField table's columns. # Evaluates to SELECT id, username FROM users query = User.select() Note = Table('notes') query = (Note .select(Note.c.content, Note.c.timestamp, User.username) .join(User to select users and the number of notes they # have authored. query = (User .select( User.username, fn.COUNT(Note.c.id).alias('n_notes')) .join( Note,

message another message yet another message For full documentation on fields, see the Fields API notes Field types table Field Type Sqlite Postgresql MySQL IntegerField integer integer integer BigIntegerField table's columns. # Evaluates to SELECT id, username FROM users query = User.select() Note = Table('notes') query = (Note .select(Note.c.content, Note.c.timestamp, User.username) .join(User to select users and the number of notes they # have authored. query = (User .select( User.username, fn.COUNT(Note.c.id).alias('n_notes')) .join( Note,

-flask/] as well as Part 2 [http://charlesleifer.com/blog/saturday-morning-hacks-revisiting-the-notes-app/] and Part 3 [http://charlesleifer.com/blog/saturday-morning-hacks-adding-full-text-search-t message another message yet another message For full documentation on fields, see the Fields API notes Field types table Field Type Sqlite Postgresql MySQL CharField varchar varchar varchar FixedCharField e-extension/] extension, which allows efficient querying of heirarchical tables. sqlite_ext API notes class SqliteExtDatabase(database, pragmas=(), c_extensions=True, **kwargs) pragmas – A list or tuple

"id", "creator", "name" FROM "blog" WHERE "id" = ? LIMIT 1 PARAMS: [1000] For more information see notes on SelectQuery and Querying API in general. Selecting multiple records To simply get all instances 10') order_by(*clauses) Parameters: clauses – Expression(s) to use as the ORDER BY clause, see notes below Return type: SelectQuery Note Adds the provided clause (a field name or alias) to the query’s transactions, check out the transactions cookbook. For notes on deferring instantiation of database, for example if loading configuration at run-time, see the notes on deferring initialization. Note The internals

foreign-keys, joins and relationships between models. For full documentation on fields, see the Fields API notes Field types table Field Type Sqlite Postgresql MySQL IntegerField integer integer integer Field Attention To preserve backwards-compatibility, the current release (Peewee 3.x) specifies legacy_table_names=True by default. In the next major release (Peewee 4.0), legacy_table_names will have a default value table's columns. # Evaluates to SELECT id, username FROM users query = User.select() Note = Table('notes') query = (Note .select(Note.c.content, Note.c.timestamp, User.username) .join(User

message another message yet another message For full documentation on fields, see the Fields API notes Field types table Field Type Sqlite Postgresql MySQL IntegerField integer integer integer BigIntegerField username FROM users query = User.select() Parameters: Parameters: Parameters: Note = Table('notes') query = (Note .select(Note.c.content, Note.c.timestamp, User.username) .join(User to select users and the number of notes they # have authored. query = (User .select( User.username, fn.COUNT(Note.c.id).alias('n_notes')) .join( Note,

peewee Documentation Release 1.0.0 charles leifer January 12, 2013 CONTENTS i ii peewee Documentation, Release 1.0.0 • a small orm • written in python • provides a lightweight querying interface including an admin interface and RESTful API, check out flask-peewee. CONTENTS 1 peewee Documentation, Release 1.0.0 2 CONTENTS CHAPTER ONE CONTENTS: 1.1 Overview peewee is a lightweight ORM written in editors Tweet.filter(Q(user__is_staff=True) | Q(user__is_superuser=True)) 3 peewee Documentation, Release 1.0.0 You can use python operators to create select queries: # how many active users are there