{ "info": { "author": "Jorge Blanco", "author_email": "py@jorgeblan.co", "bugtrack_url": null, "classifiers": [ "Development Status :: 4 - Beta", "License :: OSI Approved :: GNU General Public License v2 (GPLv2)", "Programming Language :: Python :: 2.7", "Topic :: Office/Business :: Financial" ], "description": "# newsstand_db\n\nCreate, search and analyze a DB with your Apple's newsstand app information\n\n*(TODO: Add Usage reference)*\n\n## Developer Reference\n\n### Package reference\n\n- How To Package Your Python Code\n\t- http://www.scotttorborg.com/python-packaging/index.html\n- Merging classes from different modules\n\t- http://stackoverflow.com/questions/2505166/python-class-design-splitting-up-big-classes-into-multiple-ones-to-group-funct\n- Import * setup\n\t- http://docs.python.org/2/tutorial/modules.html#importing-from-a-package\n- Organizing Python classes in modules and/or packages\n\t- http://stackoverflow.com/questions/3842616/organizing-python-classes-in-modules-and-or-packages/13258827#13258827\n\t\t\n### SQLite reference\n\n- General\n\t- http://www.tutorialspoint.com/sqlite/sqlite_python.htm\n\t- http://docs.python.org/2/library/sqlite3.html#sqlite3.Cursor.execute\n- SQL code to get the list of tables in a SQLite DB + schema\n\t- http://stackoverflow.com/questions/305378/get-list-of-tables-db-schema-dump-etc-in-sqlite-databases\n- SQL default record value\n\t- http://stackoverflow.com/questions/2059266/sqlite-setting-the-default-value-in-create-table\n- Python CSV to SQLite\n\t- http://stackoverflow.com/questions/5942402/python-csv-to-sqlite\n\t- http://stackoverflow.com/questions/2887878/importing-a-csv-file-into-a-sqlite3-database-table-using-python\n- CSV module reference\n\t- http://docs.python.org/2/library/csv.html\n- Reading a UTF8 CSV file\n\t- http://stackoverflow.com/questions/904041/reading-a-utf8-csv-file-with-python\n- SQL WHERE clause\n\t- http://www.w3schools.com/sql/sql_where.asp\n- SQL IN operator\n\t- http://www.w3schools.com/sql/sql_in.asp\n- SQL DISTINCT operator\n\t- http://stackoverflow.com/questions/4790162/sqlite-select-disticnt-values-of-a-column-without-ordering\n\t\n\n### Unit Test reference\n\n- General\n\t- http://docs.python.org/2/library/unittest.html\n- Derive class error\n\t- http://stackoverflow.com/questions/7562775/deriving-a-class-from-testcase-throws-two-errors\n- Unit test in PyDev\n\t- http://pydev.org/manual_adv_pyunit.html\n- Assert system exit\n\t- http://stackoverflow.com/questions/15672151/is-it-possible-for-a-unit-test-to-assert-that-a-method-calls-sys-exit\n\n### Aptana Studio\n\n- Setting GitHub project in Aptana\n\t- http://stackoverflow.com/questions/9677837/how-to-set-up-git-with-aptana-studio-3\n\t\n### Other\n\n- String join\n\t- http://stackoverflow.com/questions/493819/python-join-why-is-it-string-joinlist-instead-of-list-joinstring/493831#493831\n- List comprehensions\n\t- http://www.secnetix.de/olli/Python/list_comprehensions.hawk\n\t- http://stackoverflow.com/questions/8049798/understanding-nested-list-comprehension\n\t- http://stackoverflow.com/questions/3900215/ignore-an-element-while-building-list-in-python\n\t- http://stackoverflow.com/questions/4260280/python-if-else-in-list-comprehension\n- Index ranges\n\t- http://effbot.org/zone/python-list.htm\n- MD5 Checksum of files\n\t- http://stackoverflow.com/questions/1131220/get-md5-hash-of-big-files-in-python\n- Pythonic way to get the largest item in a list\n\t- http://stackoverflow.com/questions/1874194/pythonic-way-to-get-the-largest-item-in-a-list\n- Limit float to two decimal places\n\t- http://stackoverflow.com/questions/455612/python-limiting-floats-to-two-decimal-points\n- Check if file exists\n\t- http://stackoverflow.com/questions/82831/how-do-i-check-if-a-file-exists-using-python\n- Multiple arguments in functions\n\t- http://stackoverflow.com/questions/919680/python-can-a-variable-number-of-arguments-be-passed-to-a-function\n- Searching for files based on a pattern\n\t- http://stackoverflow.com/questions/3348753/python-search-file-using-wildcard\n- Argparse reference\n\t- http://docs.python.org/2/library/argparse.html#module-argparse\n- Run a shell command\n\t- http://stackoverflow.com/questions/89228/calling-an-external-command-in-python\n- Pad a string\n\t- http://stackoverflow.com/questions/5676646/fill-out-a-python-string-with-spaces\n- Get absolute path\n\t- http://stackoverflow.com/questions/51520/how-to-get-an-absolute-file-path-in-python\n- Error reference\n\t- http://docs.python.org/2/tutorial/errors.html\t\n- Handling exceptions\n\t- http://www.tutorialspoint.com/python/python_exceptions.htm\n- Subprocess reference (call shell command)\n\t- http://docs.python.org/2/library/subprocess.html\n\t- http://stackoverflow.com/questions/89228/calling-an-external-command-in-python\n- Converting list to *args in Python\n\t- http://stackoverflow.com/questions/3941517/converting-list-to-args-in-python/3941541#3941541\n- Variable arguments for functions\n\t- http://stackoverflow.com/questions/919680/python-can-a-variable-number-of-arguments-be-passed-to-a-function\n- Add one year to current date\n\t- http://stackoverflow.com/questions/15741618/add-one-year-in-current-date-python", "description_content_type": null, "docs_url": null, "download_url": "UNKNOWN", "downloads": { "last_day": -1, "last_month": -1, "last_week": -1 }, "home_page": "https://github.com/jorgeblanco/newsstand_db", "keywords": "apple newsstand ios analytics database db", "license": "GPLv2", "maintainer": null, "maintainer_email": null, "name": "newsstand_db", "package_url": "https://pypi.org/project/newsstand_db/", "platform": "UNKNOWN", "project_url": "https://pypi.org/project/newsstand_db/", "project_urls": { "Download": "UNKNOWN", "Homepage": "https://github.com/jorgeblanco/newsstand_db" }, "release_url": "https://pypi.org/project/newsstand_db/0.5.1/", "requires_dist": null, "requires_python": null, "summary": "Create, search and analyze a DB with your Apple's newsstand app information", "version": "0.5.1" }, "last_serial": 904858, "releases": { "0.1": [ { "comment_text": "", "digests": { "md5": "35ea2fae309311089e6bbd495e82a7a0", "sha256": "35bc7ccdd84c3e883b96bd95794ec804465eae285b2ea3938291f0494b33fef8" }, "downloads": -1, "filename": "newsstand_db-0.1.tar.gz", "has_sig": false, "md5_digest": "35ea2fae309311089e6bbd495e82a7a0", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 1997, "upload_time": "2013-10-24T06:03:27", "url": "https://files.pythonhosted.org/packages/56/31/1d33bafb327d1bb8787c3d496d5e56f3ad185132771986dd9cd06a54f303/newsstand_db-0.1.tar.gz" } ], "0.5": [ { "comment_text": "", "digests": { "md5": "be9e4c2f1f9ea82c46fcd36a5262a512", "sha256": "089870225283e56307e3b0a824d64985247f1a064596c012b586440f7e36fcc6" }, "downloads": -1, "filename": "newsstand_db-0.5.tar.gz", "has_sig": false, "md5_digest": "be9e4c2f1f9ea82c46fcd36a5262a512", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 10979, "upload_time": "2013-10-28T03:23:48", "url": "https://files.pythonhosted.org/packages/64/a3/37f641f98ee90cdcf3156f8db88d1fcee00f535e5ace7d9d8caed5d0e222/newsstand_db-0.5.tar.gz" } ], "0.5.1": [ { "comment_text": "", "digests": { "md5": "46e93baa93d0b4871c74c59f0e1dff4c", "sha256": "7028f448ca56eaf31bd697360a50a0fafca8d044b3bc15af4a5f56e2ddaa45d0" }, "downloads": -1, "filename": "newsstand_db-0.5.1.tar.gz", "has_sig": false, "md5_digest": "46e93baa93d0b4871c74c59f0e1dff4c", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 10986, "upload_time": "2013-10-28T04:24:58", "url": "https://files.pythonhosted.org/packages/a4/4f/87060bf1e4821b2f7619cf0cab5d8e49546fff18fdc192f60f017c315f71/newsstand_db-0.5.1.tar.gz" } ] }, "urls": [ { "comment_text": "", "digests": { "md5": "46e93baa93d0b4871c74c59f0e1dff4c", "sha256": "7028f448ca56eaf31bd697360a50a0fafca8d044b3bc15af4a5f56e2ddaa45d0" }, "downloads": -1, "filename": "newsstand_db-0.5.1.tar.gz", "has_sig": false, "md5_digest": "46e93baa93d0b4871c74c59f0e1dff4c", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 10986, "upload_time": "2013-10-28T04:24:58", "url": "https://files.pythonhosted.org/packages/a4/4f/87060bf1e4821b2f7619cf0cab5d8e49546fff18fdc192f60f017c315f71/newsstand_db-0.5.1.tar.gz" } ] }