Hello everyone!
I've been searching information regarding this topic but without help
so far. I have a dbloader.py script that takes information from a
number of CSV files and dumps it into the database. After that we
execute a number of tests to check all services are working fine
(returning the right information and calculated data such as
availability and so on).
In these CSV files I have manually set up the id fields of every
table, but when I add the rows to the database, I am passing the id
value as part of the dictionary, therefore the sequence of the primary
key is not updated. So, after all data has been loaded, I'd like to
update the start value of the sequence.
It's PostgreSQL, therefore I could do something like:
maxid = engine.execute('select max(id) from <table>').fetchone()[0]
engine.execute("select setval('<table>_id_seq', %s)" % (maxid + 1))
But I'd like to do this properly, at SA level. Just in case database
changes in the future or just to satisfy myself. But I have not been
able to find the way to modify the attributes of the sequence of each
table I find in the metadata. I have found ways of retrieving the
nextid in the documentation, but not modifying it.
Is there a way to grab a sequence and set it's next value using the
abstractions SA facilitates?
Thanks in advance.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to sqlalchemy@googlegroups.com
To unsubscribe from this group, send email to
sqlalchemy+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en
-~----------~----~----~----~------~----~------~--~---
