[CentralOH] 2014-10-17 道場 Scribbles 落書/惡文?

[jep200404 at columbus.rr.com]

zed a shaw
    Learn Python the Hard Way

--------------------------------------------------------------------------------

python
    PEP #8 http://legacy.python.org/dev/peps/pep-0008
    virtualenv
    pip (not easy_install)
    ipython
        (firefox or chrome)
    django
        djangoORM
            migrations
                awesome: https://docs.djangoproject.com/en/dev/topics/migrations/
            oracle support in 1.7???:
                https://docs.djangoproject.com/en/1.7/ref/databases/
            but seems to being developed for:
                https://docs.djangoproject.com/en/dev/ref/databases/#oracle-notes
    pytest
        
git
    http://git-scm.com/downloads
vim
    http://www.vim.org/download.php

--------------------------------------------------------------------------------

wp:R (programming language)

wp:Michael Burry
wp:The Big Short

SELECT_SQL = 'SELECT %s FROM %s WHERE %s'
Need to scrutinize code to see if data is properly quoted/escaped.
https://xkcd.com/327/
See page 17 of http://downloads.egenix.com/python/EPC-2008-Using-the-Python-Database-API.pdf

Stephanie Winston
TRAF

wp:trac

Pawpaw seeds

https://docs.python.org/2/library/collections.html#collections.OrderedDict

http://legacy.python.org/dev/peps/pep-0249/
https://wiki.python.org/moin/DatabaseProgramming
https://wiki.python.org/moin/DbApiFaq
https://wiki.python.org/moin/DbApiCheatSheet
https://wiki.python.org/moin/HigherLevelDatabaseProgramming
ORMs are wonderful
    SQLAlchemy
        What the best way to migrate?
            https://code.google.com/p/sqlalchemy-migrate/?
            http://sqlalchemy-migrate.readthedocs.org/en/latest/?
            http://pyvideo.org/video/2693/sane-schema-migrations-with-alembic-and-sqlalchem?
    django ORM

Good video on how to access databases.
    http://www.egenix.com/library/presentations/EuroPython2008-Using-the-Python-Database-API/
See page 17!!!:
    old but English: http://downloads.egenix.com/python/EPC-2008-Using-the-Python-Database-API.pdf
See page 18!!!:
    newer but Deutsche Sprache: http://www.zope.de/tagung/Dresden_2010/Python-Datenbankprogrammierung_mal.pdf

https://wiki.python.org/moin/Oracle
http://cx-oracle.sourceforge.net/
https://pypi.python.org/pypi/cx_Oracle/
    pip install cx_Oracle