示例#1
0
    def test_genusername__invalid_ascii_character(self):
        from nuvavaalit.models import Voter
        from nuvavaalit.scripts.populate import CreateVoters

        session = DBSession()

        cs = CreateVoters(None, None)

        # Make sure we don't have any existing voters.
        self.assertEquals(0, session.query(Voter).count())
        self.assertEquals(0, len(cs.usernames))

        self.assertEquals(u"kai.lauta-portti", cs.genusername(u"Käi".split(), u"Läutä-pör'tti"))
示例#2
0
    def test_genusername__no_duplicate(self):
        from nuvavaalit.models import Voter
        from nuvavaalit.scripts.populate import CreateVoters

        session = DBSession()

        cs = CreateVoters(None, None)

        # Make sure we don't have any existing voters.
        self.assertEquals(0, session.query(Voter).count())
        self.assertEquals(0, len(cs.usernames))

        self.assertEquals(u"kai.lautaportti", cs.genusername(u"Kai".split(), u"Lautaportti"))
        self.assertEquals(u"pertti.pasanen", cs.genusername(u"Pertti Sakari".split(), u"Pasanen"))
        self.assertEquals(u"fuu.bar.boo", cs.genusername(u"Füü".split(), u"Bär bÖÖ"))
示例#3
0
    def test_genusername__duplicates_wo_middlename_fallback(self):
        from nuvavaalit.models import Voter
        from nuvavaalit.scripts.populate import CreateVoters

        session = DBSession()

        cs = CreateVoters(None, None)

        # Make sure we don't have any existing voters.
        self.assertEquals(0, session.query(Voter).count())
        self.assertEquals(0, len(cs.usernames))

        # First username without duplicate.
        self.assertEquals(u"foo.boo", cs.genusername(u"Föö".split(), u"Böö"))
        # Without middle name we start using suffixes right away.
        self.assertEquals(u"foo.boo2", cs.genusername(u"Föö".split(), u"Böö"))
        self.assertEquals(u"foo.boo3", cs.genusername(u"Föö".split(), u"Böö"))
示例#4
0
    def test_genusername__duplicates(self):
        from nuvavaalit.models import Voter
        from nuvavaalit.scripts.populate import CreateVoters

        session = DBSession()

        cs = CreateVoters(None, None)

        # Make sure we don't have any existing voters.
        self.assertEquals(0, session.query(Voter).count())
        self.assertEquals(0, len(cs.usernames))

        # First username without duplicate.
        self.assertEquals(u"foo.boo", cs.genusername(u"Föö Büü".split(), u"Böö"))
        # First duplicate uses the middle initial.
        self.assertEquals(u"foo.b.boo", cs.genusername(u"Föö Büü".split(), u"Böö"))
        # Second duplicate uses the full middle name.
        self.assertEquals(u"foo.buu.boo", cs.genusername(u"Föö Büü".split(), u"Böö"))
        # Subsequent duplicates use an increasing suffix without the middle name.
        self.assertEquals(u"foo.boo2", cs.genusername(u"Föö Büü".split(), u"Böö"))
        self.assertEquals(u"foo.boo3", cs.genusername(u"Föö Büü".split(), u"Böö"))
示例#5
0
    def test_run__no_existing_voters(self):
        """Tests a successful operation which creates the Voter instances and
        the associated filesystem artifacts. There are now existing Voters in
        the database.
        """
        from nuvavaalit.models import Voter
        from nuvavaalit.scripts.populate import CreateVoters

        session = DBSession()

        xlsx_file = self.filename("input.xlsx")
        output = self.filename("voters.xls")

        data = [
            ("Rögers", "Bück Williäm", "Sömewhere street", "04320", "Helsinki"),
            ("Li", "Jët Huan", "Chinä road 23", "04300", "Helsinki"),
            ("Cöllisiön", "Näme Föö", "Cöllider curve 4", "05400", "Helsinki"),
            ("Cöllisiön", "Näme Bär", "Cöllider curve 7", "05400", "Helsinki"),
        ]
        wb = openpyxl.Workbook()
        ws = wb.get_active_sheet()
        for row, values in enumerate(data, start=1):
            for col, value in enumerate(values, start=1):
                ws.cell(row=row, column=col).value = value
        wb.save(filename=xlsx_file)

        cs = CreateVoters(xlsx_file, output)

        # Make sure we don't have any existing voters.
        self.assertEquals(0, session.query(Voter).count())
        self.assertEquals(0, len(cs.usernames))

        cs.run()

        # Make sure the Excel sheet got created.
        self.assertTrue(os.path.exists(output))

        # Check the Itella list. All voters without a GSM or email must be present.
        wb = xlrd.open_workbook(filename=output)
        ws = wb.sheet_by_index(0)
        self.assertEquals(5, ws.nrows)
        self.assertEquals(6, ws.ncols)
        self.assertEquals(ws.cell_value(1, 0), u"buck.rogers")
        self.assertEquals(ws.cell_value(1, 1), u"7xs464kc")
        self.assertEquals(ws.cell_value(1, 2), u"Bück Williäm Rögers")
        self.assertEquals(ws.cell_value(1, 3), u"Sömewhere street")
        self.assertEquals(ws.cell_value(1, 4), u"04320")
        self.assertEquals(ws.cell_value(1, 5), u"Helsinki")

        # Check created Voter objects. All voters must be present.
        voters = session.query(Voter).order_by(Voter.username).all()
        self.assertEquals(4, len(voters))

        self.assertEquals(voters[0].username, u"buck.rogers")
        self.assertEquals(voters[0].firstname, u"Bück")
        self.assertEquals(voters[0].lastname, u"Rögers")

        self.assertEquals(voters[1].username, u"jet.li")
        self.assertEquals(voters[1].firstname, u"Jët")
        self.assertEquals(voters[1].lastname, u"Li")

        self.assertEquals(voters[2].username, u"name.b.collision")
        self.assertEquals(voters[2].firstname, u"Näme")
        self.assertEquals(voters[2].lastname, u"Cöllisiön")

        self.assertEquals(voters[3].username, u"name.collision")
        self.assertEquals(voters[3].firstname, u"Näme")
        self.assertEquals(voters[3].lastname, u"Cöllisiön")