Am 21.05.2017 um 12:28 schrieb R0R0N0A:
I have a table and some keys inside it
have two unique key
when i first run the code it runs okay
but when I sencond time run it
it says a unique key constrains
here's the matter that I need to loop the code to query some new updates
and insert to database
I dont know why except the first time . why other time I run it , it got
error
many thanks !
```
__tablename__ = 'listings'
id = Column(Integer,primary_key=True,autoincrement=True)
link = Column(String,unique=True)
title = Column(String)
img = Column(String,unique=True)
name = Column(String)
```
error code :
```
UNIQUE constraint failed: listings.img [SQL: 'INSERT INTO listings
(link, title, img, name) VALUES (?, ?, ?, ?)']
```
...
To post example code, please provide an MCVE: Minimal, Complete, and
Verifiable Example. See http://stackoverflow.com/help/mcve for a full
description.
Your example isn't complete or verifiable, but I'll guess: do you
perhaps try to insert the same record every time you run the code? You
don't show the values you're inserting, so guessing is all we can do.
How do you connect to your database? Did you try to use "echo=True" in
that call? That could tell you which query is sent to the database and
what values are used.
HTH
Sibylle
--
SQLAlchemy -
The Python SQL Toolkit and Object Relational Mapper
http://www.sqlalchemy.org/
To post example code, please provide an MCVE: Minimal, Complete, and Verifiable
Example. See http://stackoverflow.com/help/mcve for a full description.
---
You received this message because you are subscribed to the Google Groups "sqlalchemy" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to sqlalchemy+unsubscr...@googlegroups.com.
To post to this group, send email to sqlalchemy@googlegroups.com.
Visit this group at https://groups.google.com/group/sqlalchemy.
For more options, visit https://groups.google.com/d/optout.
