I followed this blog ```https://www.dataquest.io/blog/apartment-finding-slackbot/```
` How I built a Slack bot to help me find an apartment in San Francisco <https://www.dataquest.io/blog/apartment-finding-slackbot/>` it says `that set the parameter as unique , in case of duplicates` and I did exactly the same On Sunday, May 21, 2017 at 7:45:09 PM UTC+8, R0R0N0A wrote: > > it's true that I insert the same record every time I run the code > But it's unique , right ? it shouldn't insert to the table right ? > > My purpose is loop the code and see if any new record updated , if so , > insert into the table . > > any where I did wrong ? > thanks > > On Sunday, May 21, 2017 at 6:50:03 PM UTC+8, bb1898 wrote: >> >> 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.
