Khalid's Python Journal

+ -

Pages

Label :

5 Khalid's Python Journal: Cheat Sheet for SQL Syntax http://www.w3schools.com/sql/sql_quickref.asp

Python for ios

http://itunes.apple.com/us/app/python-for-ios/id485729872?mt=8
csv to sqlite3 via shell

sqlite> create table test (id integer, datatype_id integer, level integer, meaning text); sqlite> .separator "," sql...
using a sql statementto assign keys & values to a dict

If you run a sql statement, and want to iterate over the cursor to assign keys and values to a dictionary, do the following: >>...
Cheat Sheet for SQL Syntax

http://www.w3schools.com/sql/sql_quickref.asp
Generators

Generators are merely functions that use yield instead of return. Also, the retain the state of all the local variables between calls. d...
SQL tutorial (great site)

http://www.w3schools.com/sql/default.asp
Good sqlite3 tutorial

http://www.blog.pythonlibrary.org/2012/07/18/python-a-simple-step-by-step-sqlite-tutorial/
a crafty little list comp

>>> l ['khalid', 'majid'] >>> l2=['my name is {}'.format(y) for y in l] >>> l2 [...
Elegance

Pythonic = Elegance = Simplicity at the far end of Complexity
Functions are What They Return

Below is regex exercise where you can see how in if iteration below I a strip() method, which is basically reserved for strings, to a funct...