newsstand_db 0.5.1

Create, search and analyze a DB with your Apple's newsstand app information

# newsstand_db

Create, search and analyze a DB with your Apple's newsstand app information

*(TODO: Add Usage reference)*

## Developer Reference

### Package reference

- How To Package Your Python Code
- http://www.scotttorborg.com/python-packaging/index.html
- Merging classes from different modules
- http://stackoverflow.com/questions/2505166/python-class-design-splitting-up-big-classes-into-multiple-ones-to-group-funct
- Import * setup
- http://docs.python.org/2/tutorial/modules.html#importing-from-a-package
- Organizing Python classes in modules and/or packages
- http://stackoverflow.com/questions/3842616/organizing-python-classes-in-modules-and-or-packages/13258827#13258827

### SQLite reference

- General
- http://www.tutorialspoint.com/sqlite/sqlite_python.htm
- http://docs.python.org/2/library/sqlite3.html#sqlite3.Cursor.execute
- SQL code to get the list of tables in a SQLite DB + schema
- http://stackoverflow.com/questions/305378/get-list-of-tables-db-schema-dump-etc-in-sqlite-databases
- SQL default record value
- http://stackoverflow.com/questions/2059266/sqlite-setting-the-default-value-in-create-table
- Python CSV to SQLite
- http://stackoverflow.com/questions/5942402/python-csv-to-sqlite
- http://stackoverflow.com/questions/2887878/importing-a-csv-file-into-a-sqlite3-database-table-using-python
- CSV module reference
- http://docs.python.org/2/library/csv.html
- Reading a UTF8 CSV file
- http://stackoverflow.com/questions/904041/reading-a-utf8-csv-file-with-python
- SQL WHERE clause
- http://www.w3schools.com/sql/sql_where.asp
- SQL IN operator
- http://www.w3schools.com/sql/sql_in.asp
- SQL DISTINCT operator
- http://stackoverflow.com/questions/4790162/sqlite-select-disticnt-values-of-a-column-without-ordering


### Unit Test reference

- General
- http://docs.python.org/2/library/unittest.html
- Derive class error
- http://stackoverflow.com/questions/7562775/deriving-a-class-from-testcase-throws-two-errors
- Unit test in PyDev
- http://pydev.org/manual_adv_pyunit.html
- Assert system exit
- http://stackoverflow.com/questions/15672151/is-it-possible-for-a-unit-test-to-assert-that-a-method-calls-sys-exit

### Aptana Studio

- Setting GitHub project in Aptana
- http://stackoverflow.com/questions/9677837/how-to-set-up-git-with-aptana-studio-3

### Other

- String join
- http://stackoverflow.com/questions/493819/python-join-why-is-it-string-joinlist-instead-of-list-joinstring/493831#493831
- List comprehensions
- http://www.secnetix.de/olli/Python/list_comprehensions.hawk
- http://stackoverflow.com/questions/8049798/understanding-nested-list-comprehension
- http://stackoverflow.com/questions/3900215/ignore-an-element-while-building-list-in-python
- http://stackoverflow.com/questions/4260280/python-if-else-in-list-comprehension
- Index ranges
- http://effbot.org/zone/python-list.htm
- MD5 Checksum of files
- http://stackoverflow.com/questions/1131220/get-md5-hash-of-big-files-in-python
- Pythonic way to get the largest item in a list
- http://stackoverflow.com/questions/1874194/pythonic-way-to-get-the-largest-item-in-a-list
- Limit float to two decimal places
- http://stackoverflow.com/questions/455612/python-limiting-floats-to-two-decimal-points
- Check if file exists
- http://stackoverflow.com/questions/82831/how-do-i-check-if-a-file-exists-using-python
- Multiple arguments in functions
- http://stackoverflow.com/questions/919680/python-can-a-variable-number-of-arguments-be-passed-to-a-function
- Searching for files based on a pattern
- http://stackoverflow.com/questions/3348753/python-search-file-using-wildcard
- Argparse reference
- http://docs.python.org/2/library/argparse.html#module-argparse
- Run a shell command
- http://stackoverflow.com/questions/89228/calling-an-external-command-in-python
- Pad a string
- http://stackoverflow.com/questions/5676646/fill-out-a-python-string-with-spaces
- Get absolute path
- http://stackoverflow.com/questions/51520/how-to-get-an-absolute-file-path-in-python
- Error reference
- http://docs.python.org/2/tutorial/errors.html
- Handling exceptions
- http://www.tutorialspoint.com/python/python_exceptions.htm
- Subprocess reference (call shell command)
- http://docs.python.org/2/library/subprocess.html
- http://stackoverflow.com/questions/89228/calling-an-external-command-in-python
- Converting list to *args in Python
- http://stackoverflow.com/questions/3941517/converting-list-to-args-in-python/3941541#3941541
- Variable arguments for functions
- http://stackoverflow.com/questions/919680/python-can-a-variable-number-of-arguments-be-passed-to-a-function
- Add one year to current date
- http://stackoverflow.com/questions/15741618/add-one-year-in-current-date-python