SqlAlchemy truncate table with ORM

Question

I have been using orm for my app, and try not to use sql to avoid sql syntax error when changing between different dbms.

At the moment I am testing with sqlite and mysql. I figured out to delete a table we can use:

db.session.query(models.MyTable).delete()

Unfortunately this method does not really "truncate" the table, because It does not reset the counting of autoincrement to 0.

Is there anyway to do the real truncate in SqlAlchemy orm ?

Answer 1

SQLAlchemy delete(...) method is translated into SQL DELETE FROM query. This query does not resets any AUTO_INCREMENT counters. To reset a counter in MySQL you have to run a query like that:

ALTER TABLE tbl AUTO_INCREMENT = 100;

If I'm not mistaking, it has no analogue in SQLAlchemy.