Title: fuck Author: waterapple Pastebin link: http://pastebin.com/NBaae5mC First Edit: Friday 27th of March 2015 04:43:07 AM CDT Last Edit: Friday 27th of March 2015 04:43:07 AM CDT *** Remote Interpreter Reinitialized  *** >>> 2015-03-27 17:37:17,986 - DEBUG - Logging started. 2015-03-27 17:37:17,987 - DEBUG - Opening DB connection 2015-03-27 17:37:17,996 INFO sqlalchemy.engine.base.Engine SELECT CAST('test plain returns' AS VARCHAR(60)) AS anon_1 2015-03-27 17:37:17,996 - INFO - SELECT CAST('test plain returns' AS VARCHAR(60)) AS anon_1 2015-03-27 17:37:17,999 INFO sqlalchemy.engine.base.Engine () 2015-03-27 17:37:17,999 - INFO - () 2015-03-27 17:37:18,000 INFO sqlalchemy.engine.base.Engine SELECT CAST('test unicode returns' AS VARCHAR(60)) AS anon_1 2015-03-27 17:37:18,000 - INFO - SELECT CAST('test unicode returns' AS VARCHAR(60)) AS anon_1 2015-03-27 17:37:18,002 INFO sqlalchemy.engine.base.Engine () 2015-03-27 17:37:18,002 - INFO - () 2015-03-27 17:37:18,003 INFO sqlalchemy.engine.base.Engine PRAGMA table_info("blogs") 2015-03-27 17:37:18,003 - INFO - PRAGMA table_info("blogs") 2015-03-27 17:37:18,012 INFO sqlalchemy.engine.base.Engine () 2015-03-27 17:37:18,012 - INFO - () 2015-03-27 17:37:18,013 INFO sqlalchemy.engine.base.Engine PRAGMA table_info("posts") 2015-03-27 17:37:18,013 - INFO - PRAGMA table_info("posts") 2015-03-27 17:37:18,016 INFO sqlalchemy.engine.base.Engine () 2015-03-27 17:37:18,016 - INFO - () 2015-03-27 17:37:18,016 INFO sqlalchemy.engine.base.Engine PRAGMA table_info("media") 2015-03-27 17:37:18,016 - INFO - PRAGMA table_info("media") 2015-03-27 17:37:18,019 INFO sqlalchemy.engine.base.Engine () 2015-03-27 17:37:18,019 - INFO - () 2015-03-27 17:37:18,019 - DEBUG - Session connected to DB 2015-03-27 17:37:19,138 - DEBUG - info_dict{u'meta': {u'status': 200, u'msg': u'OK'}, u'response': {u'blog': {u'ask_anon': False, u'updated': 1427311294, u'description': u'The official feed from the people behind Tumblr.', u'title': u'Tumblr Staff', u'url': u'http://staff.tumblr.com/', u'ask_page_title': u'', u'share_likes': False, u'posts': 1203, u'is_nsfw': False, u'ask': False, u'name': u'staff'}}} 2015-03-27 17:37:19,151 - DEBUG - self.info_post_count: 1203 2015-03-27 17:37:19,153 - DEBUG - Adding blog metadata to DB 2015-03-27 17:37:19,155 INFO sqlalchemy.engine.base.Engine BEGIN (implicit) 2015-03-27 17:37:19,155 - INFO - BEGIN (implicit) 2015-03-27 17:37:19,160 INFO sqlalchemy.engine.base.Engine SELECT blogs.primary_key, blogs.date_added, blogs.date_last_saved, blogs.poster_username, blogs.blog_domain, blogs.info_title, blogs.info_posts, blogs.info_name, blogs.info_updated, blogs.info_description, blogs.info_ask, blogs.info_ask_anon, blogs.info_likes, blogs.info_is_nsfw, blogs.info_share_likes, blogs.info_url, blogs.info_ask_page_title FROM blogs WHERE blogs.poster_username IS NULL 2015-03-27 17:37:19,160 - INFO - SELECT blogs.primary_key, blogs.date_added, blogs.date_last_saved, blogs.poster_username, blogs.blog_domain, blogs.info_title, blogs.info_posts, blogs.info_name, blogs.info_updated, blogs.info_description, blogs.info_ask, blogs.info_ask_anon, blogs.info_likes, blogs.info_is_nsfw, blogs.info_share_likes, blogs.info_url, blogs.info_ask_page_title FROM blogs WHERE blogs.poster_username IS NULL 2015-03-27 17:37:19,173 INFO sqlalchemy.engine.base.Engine () 2015-03-27 17:37:19,173 - INFO - () 2015-03-27 17:37:19,177 INFO sqlalchemy.engine.base.Engine SELECT blogs.primary_key, blogs.date_added, blogs.date_last_saved, blogs.poster_username, blogs.blog_domain, blogs.info_title, blogs.info_posts, blogs.info_name, blogs.info_updated, blogs.info_description, blogs.info_ask, blogs.info_ask_anon, blogs.info_likes, blogs.info_is_nsfw, blogs.info_share_likes, blogs.info_url, blogs.info_ask_page_title FROM blogs WHERE blogs.blog_domain = ? 2015-03-27 17:37:19,177 - INFO - SELECT blogs.primary_key, blogs.date_added, blogs.date_last_saved, blogs.poster_username, blogs.blog_domain, blogs.info_title, blogs.info_posts, blogs.info_name, blogs.info_updated, blogs.info_description, blogs.info_ask, blogs.info_ask_anon, blogs.info_likes, blogs.info_is_nsfw, blogs.info_share_likes, blogs.info_url, blogs.info_ask_page_title FROM blogs WHERE blogs.blog_domain = ? 2015-03-27 17:37:19,187 INFO sqlalchemy.engine.base.Engine ('staff.tumblr.com',) 2015-03-27 17:37:19,187 - INFO - ('staff.tumblr.com',) 2015-03-27 17:37:19,188 - DEBUG - Creating user entry 2015-03-27 17:37:19,197 INFO sqlalchemy.engine.base.Engine ROLLBACK 2015-03-27 17:37:19,197 - INFO - ROLLBACK 2015-03-27 17:37:19,201 - CRITICAL - Unhandled exception! 2015-03-27 17:37:19,203 - ERROR - invalid literal for int() with base 10: 'http://staff.tumblr.com/' (original cause: ValueError: invalid literal for int() with base 10: 'http://staff.tumblr.com/') u'INSERT INTO blogs (date_added, date_last_saved, poster_username, blog_domain, info_title, info_posts, info_name, info_updated, info_description, info_ask, info_ask_anon, info_likes, info_is_nsfw, info_share_likes, info_url, info_ask_page_title) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)' [{'date_last_saved': None, 'info_ask_page_title': u'', 'info_likes': None, 'info_url': u'http://staff.tumblr.com/', 'poster_username': None, 'info_title': 1203, 'info_name': u'staff', 'info_updated': 1427311294, 'info_posts': 1203, 'info_is_nsfw': False, 'info_ask_anon': False, 'info_share_likes': False, 'date_added': 1427449039, 'info_description': u'The official feed from the people behind Tumblr.', 'blog_domain': None, 'info_ask': False}] Traceback (most recent call last):   File "C:\Users\User\Dropbox\AnonArchive Folder\ctrl-s\tumblr_api_to_db\main.py", line 318, in main     classy_play()   File "C:\Users\User\Dropbox\AnonArchive Folder\ctrl-s\tumblr_api_to_db\main.py", line 306, in classy_play     blog = tumblr_blog(session, consumer_key = config.consumer_key, blog_url = "staff.tumblr.com")   File "C:\Users\User\Dropbox\AnonArchive Folder\ctrl-s\tumblr_api_to_db\main.py", line 38, in __init__     self.insert_user_into_db()   File "C:\Users\User\Dropbox\AnonArchive Folder\ctrl-s\tumblr_api_to_db\main.py", line 284, in insert_user_into_db     self.session.commit()   File "C:\Python27\lib\site-packages\sqlalchemy\orm\session.py", line 788, in commit     self.transaction.commit()   File "C:\Python27\lib\site-packages\sqlalchemy\orm\session.py", line 384, in commit     self._prepare_impl()   File "C:\Python27\lib\site-packages\sqlalchemy\orm\session.py", line 364, in _prepare_impl     self.session.flush()   File "C:\Python27\lib\site-packages\sqlalchemy\orm\session.py", line 1985, in flush     self._flush(objects)   File "C:\Python27\lib\site-packages\sqlalchemy\orm\session.py", line 2103, in _flush     transaction.rollback(_capture_exception=True)   File "C:\Python27\lib\site-packages\sqlalchemy\util\langhelpers.py", line 60, in __exit__     compat.reraise(exc_type, exc_value, exc_tb)   File "C:\Python27\lib\site-packages\sqlalchemy\orm\session.py", line 2067, in _flush     flush_context.execute()   File "C:\Python27\lib\site-packages\sqlalchemy\orm\unitofwork.py", line 372, in execute     rec.execute(self)   File "C:\Python27\lib\site-packages\sqlalchemy\orm\unitofwork.py", line 526, in execute     uow   File "C:\Python27\lib\site-packages\sqlalchemy\orm\persistence.py", line 65, in save_obj     mapper, table, insert)   File "C:\Python27\lib\site-packages\sqlalchemy\orm\persistence.py", line 602, in _emit_insert_statements     execute(statement, params)   File "C:\Python27\lib\site-packages\sqlalchemy\engine\base.py", line 841, in execute     return meth(self, multiparams, params)   File "C:\Python27\lib\site-packages\sqlalchemy\sql\elements.py", line 322, in _execute_on_connection     return connection._execute_clauseelement(self, multiparams, params)   File "C:\Python27\lib\site-packages\sqlalchemy\engine\base.py", line 938, in _execute_clauseelement     compiled_sql, distilled_params   File "C:\Python27\lib\site-packages\sqlalchemy\engine\base.py", line 1005, in _execute_context     None, None)   File "C:\Python27\lib\site-packages\sqlalchemy\engine\base.py", line 1271, in _handle_dbapi_exception     exc_info   File "C:\Python27\lib\site-packages\sqlalchemy\util\compat.py", line 199, in raise_from_cause     reraise(type(exception), exception, tb=exc_tb)   File "C:\Python27\lib\site-packages\sqlalchemy\engine\base.py", line 1001, in _execute_context     context = constructor(dialect, self, conn, *args)   File "C:\Python27\lib\site-packages\sqlalchemy\engine\default.py", line 579, in _init_compiled     param.append(processors[key](compiled_params[key]))   File "C:\Python27\lib\site-packages\sqlalchemy\processors.py", line 56, in boolean_to_int     return int(value) StatementError: invalid literal for int() with base 10: 'http://staff.tumblr.com/' (original cause: ValueError: invalid literal for int() with base 10: 'http://staff.tumblr.com/') u'INSERT INTO blogs (date_added, date_last_saved, poster_username, blog_domain, info_title, info_posts, info_name, info_updated, info_description, info_ask, info_ask_anon, info_likes, info_is_nsfw, info_share_likes, info_url, info_ask_page_title) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)' [{'date_last_saved': None, 'info_ask_page_title': u'', 'info_likes': None, 'info_url': u'http://staff.tumblr.com/', 'poster_username': None, 'info_title': 1203, 'info_name': u'staff', 'info_updated': 1427311294, 'info_posts': 1203, 'info_is_nsfw': False, 'info_ask_anon': False, 'info_share_likes': False, 'date_added': 1427449039, 'info_description': u'The official feed from the people behind Tumblr.', 'blog_domain': None, 'info_ask': False}]