tests: fix sequence values for fixed id entries

backend/src/appenlight/tests/conftest.py

@@ -90,7 +90,8 b' def default_data(base_app):'
 
 
 @pytest.fixture
-def clean_tables():
+def clean_tables(request):
+    def fin():
     tables = Base.metadata.tables.keys()
     transaction.begin()
     for t in tables:
@@ -100,20 +101,23 b' def clean_tables():'
     mark_changed(session)
     transaction.commit()
 
+    request.addfinalizer(fin)
+
 
 @pytest.fixture
 def default_user():
     from appenlight.models.user import User
     from appenlight.models.auth_token import AuthToken
     transaction.begin()
+    session = DBSession()
     user = User(id=1,
                 user_name='testuser',
                 status=1,
                 email='[e-mail]')
-    DBSession.add(user)
+    session.add(user)
     token = AuthToken(token='1234')
     user.auth_tokens.append(token)
-    DBSession.flush()
+    session.execute("SELECT nextval('users_id_seq')")
     transaction.commit()
     return user
 
@@ -123,11 +127,12 b' def default_application(default_user):'
     from appenlight.models.application import Application
 
     transaction.begin()
+    session = DBSession()
     application = Application(
         resource_id=1, resource_name='testapp', api_key='xxxx')
-    DBSession.add(application)
+    session.add(application)
     default_user.resources.append(application)
-    DBSession.flush()
+    session.execute("SELECT nextval('resources_resource_id_seq')")
     transaction.commit()
     return application