def test_discard_null_judgment(self):
# this tests issue #22
insert_row(self.scratch_db, 'claim', dict(
scraper_id='sr.campaign.qux',
campaign_id='qux',
company='Foo & Co.',
brand='',
claim='>80% of variables are metasyntactic'))
build_claim_table(self.output_db, self.scratch_db)
self.assertEqual(select_all(self.output_db, 'claim'), [])
def test_map_brand(self):
insert_row(self.scratch_db, 'claim', dict(
scraper_id='sr.campaign.qux',
campaign_id='qux',
company='Foo & Co.',
brand='BAR™',
claim='code of conduct mandates unreadable code',
judgment=-1))
build_claim_table(self.output_db, self.scratch_db)
self.assertEqual(
[strip_null(row) for row in select_all(self.output_db, 'claim')],
[dict(campaign_id='qux',
company='Foo',
brand='Bar',
scope='',
claim='code of conduct mandates unreadable code',
judgment=-1)])
def test_map_company(self):
insert_row(self.scratch_db, 'claim', dict(
scraper_id='sr.campaign.qux',
campaign_id='qux',
company='Foo & Co.',
brand='',
claim='>80% of variables are metasyntactic',
judgment=1))
build_claim_table(self.output_db, self.scratch_db)
self.assertEqual(
[strip_null(row) for row in select_all(self.output_db, 'claim')],
[dict(campaign_id='qux',
company='Foo',
brand='',
scope='',
claim='>80% of variables are metasyntactic',
judgment=1)])
