1 from .test_basics import BasicTest
6 from click.testing import CliRunner
7 from motion import create_user
10 def db_select(self, sql, parameter):
11 with postgresql.open(app.config.get("DATABASE"), user=app.config.get("USER"), password=app.config.get("PASSWORD")) as db:
12 rv = db.prepare(sql)(parameter)
15 class GeneralTests(BasicTest):
25 def test_create_user(self):
28 result = runner.invoke(create_user, [user])
29 assert result.exit_code == 0
30 self.assertIn("User 'John Doe' inserted.", result.output)
32 rv = db_select(self,"SELECT email FROM voter WHERE lower(email)=lower($1)", user)
33 self.assertIn(user, rv[0].get("email"))
35 result = runner.invoke(create_user, [user])
36 assert result.exit_code == 0
37 self.assertIn("User 'John Doe' already exists.", result.output)