Guest User

Untitled

a guest
Mar 28th, 2018
102
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.69 KB | None | 0 0
  1. def alter_sequence(last_id):
  2. try:
  3. dbname = settings.DATABASES['default']['NAME']
  4. user = settings.DATABASES['default']['USER']
  5. host = settings.DATABASES['default']['HOST']
  6. password = settings.DATABASES['default']['PASSWORD']
  7. port = settings.DATABASES['default']['PORT']
  8. connection = psycopg2.connect(
  9. dbname=dbname,
  10. user=user,
  11. password=password,
  12. host=host,
  13. port=port,
  14. )
  15. cursor = connection.cursor()
  16. cursor.execute('ALTER SEQUENCE "gs_requests_id_seq" RESTART WITH {}'.format(last_id))
  17. connection.close()
  18. except Exception as e:
  19. print(e)
  20. pass
Add Comment
Please, Sign In to add comment