# HG changeset patch
# User Goffi <goffi@goffi.org>
# Date 1630502702 -7200
# Node ID 05db744f194f1a8f23c78f9694e47ed316c7f420
# Parent  257135d5c5c205938ab8419e308c3d0dcd84ebf6
core (memory/sql_mapping): remove autoincrement:

SQLite specific behaviour with autoincrement (https://sqlite.org/autoinc.html) is actually
already handled by SQLAlchemy, and unsetting autoincrement cause troubles when storing new
objects.

diff -r 257135d5c5c2 -r 05db744f194f sat/memory/sqla_mapping.py
--- a/sat/memory/sqla_mapping.py	Wed Sep 01 15:24:59 2021 +0200
+++ b/sat/memory/sqla_mapping.py	Wed Sep 01 15:25:02 2021 +0200
@@ -151,9 +151,6 @@
         Integer,
         primary_key=True,
         nullable=True,
-        # settings autoincrement would have negative performance impact
-        # cf. https://sqlite.org/autoinc.html
-        autoincrement=False
     )
     name = Column(Text, unique=True)
 
@@ -316,8 +313,6 @@
     id = Column(
         Integer,
         primary_key=True,
-        # cf. note for Profile.id
-        autoincrement=False
     )
     history_uid = Column(ForeignKey("history.uid", ondelete="CASCADE"))
     message = Column(Text)
@@ -339,8 +334,6 @@
     id = Column(
         Integer,
         primary_key=True,
-        # cf. note for Profile.id
-        autoincrement=False,
     )
     history_uid = Column(ForeignKey("history.uid", ondelete="CASCADE"))
     subject = Column(Text)
@@ -362,8 +355,6 @@
     id = Column(
         Integer,
         primary_key=True,
-        # cf. note for Profile.id
-        autoincrement=False,
     )
     history_uid = Column(ForeignKey("history.uid", ondelete="CASCADE"))
     thread_id = Column(Text)