In [1]:

    

from dumptruck import DumpTruck
dt=DumpTruck(dbname="data/events.sqlite")

dt.execute("select count(*) as c, min(start) as fd, min(end) from events where numposts>0")


    

    
Out[1]:





[OrderedDict([(u'c', 92371), (u'fd', u'1990-10-01 07:00:00'), (u'min(end)', u'2009-01-04 07:52:32')])]

In [2]:

    

dt.execute("select min(id) from events where error like '%JSON%' and id>110000")


    

    
Out[2]:





[OrderedDict([(u'min(id)', None)])]

In [3]:

    

dt.execute("select id from events where error like '%JSON%' limit 2")


    

    
Out[3]:





[]

In [14]:

    

import logging,sys,StringIO

b=StringIO.StringIO()

logging.basicConfig(file=b, level=logging.DEBUG)

from slscraper import eventdata

eventdata("184792",),b.getvalue()


    

    
Out[14]:





({'created': datetime.datetime(2013, 8, 28, 18, 16, 47),
  'description': u'dpa tickert live \xfcber das Fernseh-Duell von Bundeskanzlerin Angela Merkel und ihrem Herausforderer Peer Steinbr\xfcck',
  'discussion': {'Enabled': 0, 'Moderated': 0},
  'end': datetime.datetime(2013, 8, 30, 19, 57, 51),
  'error': "HTTPError('403 Client Error',)",
  'id': 184792,
  'iscommenting': 0,
  'isdeleted': 0,
  'islive': 1,
  'ismoderated': 0,
  'issyndicatable': 0,
  'issyndicated': 1,
  'language': 'de',
  'lastmodified': datetime.datetime(2013, 8, 30, 16, 57, 51),
  'location': {'Lat': 51.0, 'Long': 9.0},
  'meta': {'Secure': '0'},
  'metatitle': u'Kampf ums Kanzleramt: Fernseh-Duell Merkel - Steinbr\xfcck',
  'numcomments': 0,
  'numposts': 5,
  'pages': 1,
  'start': datetime.datetime(2013, 8, 30, 13, 45),
  'syndicatedcomments': 0,
  'title': u'Kampf ums Kanzleramt: Fernseh-Duell Merkel - Steinbr\xfcck'},
 '')

In [ ]: