def test_it_saves_to_the_database(): sheets = extract.validate(extract.extract('fixture/simple.xlsx')) extract.save(sheets) data = scraperwiki.sql.select('* from Sheet1') row = data[2] assert_equals(row['Year'], 2012) assert_equals(row['Awesomeness'], 8)
def test_it_saves_a_unicode_csv_to_the_database(): sheets = extract.validate(extract.extract('fixture/mps_unicode.csv')) extract.save(sheets) data = scraperwiki.sql.select('* from swdata') row = data[460] assert_equals(row['MP Name'], 'Michelle Gildernew') assert_equals(row['Party'], u'Sinn Féin')