def StoreRecords(data, table):
'''Store records in a ScraperWiki database.'''
try:
for record in data:
scraperwiki.sqlite.save(record.keys(), record, table_name=table)
except Exception as e:
print "%s Failed to store record in database." % item('error')
print e
return False
def StoreRecords(data, table):
'''Store records in a ScraperWiki database.'''
try:
for record in data:
scraperwiki.sqlite.save(record.keys(), record, table_name=table)
except Exception as e:
print "%s Failed to store record in database." % item('error')
print e
return False
def CleanTable(table_name, verbose=True):
'''Clean all records from table in database.'''
#
# SQL statement.
#
print '%s Cleaning table `%s`.' % (item('bullet'), table_name)
sql = 'delete from {table_name}'.format(table_name=table_name)
#
# SQL execution.
#
try:
scraperwiki.sqlite.execute(sql)
if verbose:
print '%s Table `%s` cleaned successfully.' % (item('bullet'), table_name)
except Exception as e:
if verbose:
print '%s Failed to clean table `%s`.' % (item('error'), table_name)
print e
return False
def ReadAllRecords(table_name, verbose=True):
'''Clean all records from table in database.'''
#
# SQL statement.
#
sql = 'select * from %s' % table_name
#
# SQL execution.
#
try:
return scraperwiki.sqlite.execute(sql)['data']
except Exception as e:
if verbose:
print '%s Failed to read table `%s`.' % (item('error'), table_name)
print e
return False
