Skip to content

Instantly share code, notes, and snippets.

@aGHz
Last active April 27, 2016 21:25
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save aGHz/d4e47c131c48a819975f to your computer and use it in GitHub Desktop.
Save aGHz/d4e47c131c48a819975f to your computer and use it in GitHub Desktop.
Kronolog syntax
+ generic item, sub-tasks track progress
- open task
~ in progress task
= completed task
* informational item, sub-tasks do not track progress
- generic sub-item (not necessarily task)
x n/a, wontfix, cancelled
/ n/a, wontfix, cancelled
> command
` code
# calendar
\ output, results
" quote, answer
! important
? question
: link
@aGHz
Copy link
Author

aGHz commented Feb 11, 2016

Example:

Tue 2016-02-09
==============
+ route lifecycle
    ~ crawl
    = update_from_vrv
    ~ test update_from_[kv]rv
        = create smaller known_routes_view
        ~ test update_from_krv
            = route added to krv (limit to 15)
            = route removed from krv (limit down to 12)
            ~ route readded to krv (limit up to 14)
            - readded route removed from krv (limit down to 13)
            - re-removed route readded to krv (limit back up to 15)
            > select legacy_repr, db_krv_added, db_krv_removed, db_vrv_added, db_vrv_removed from an_route_lifecycles where locale = 'en';
= do something
* list the fields in an SQLAlchemy model:
    ` from sqlalchemy import inspect
      [attr.key for attr in inspect(RouteLifecycle).attrs]
* print SQLAlchemy query in the dialect you want
    : http://nicolascadou.com/blog/2014/01/printing-actual-sqlalchemy-queries/
    ` from sqlalchemy.dialects import postgresql
      int str(q.statement.compile(dialect=postgresql.dialect()))
* find -exec grep
    > find . -name '*.sql' -exec grep -Hni --color=yes "values" {} +

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment