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_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')
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')
