Python - SQLAlchemy using exists() to check if data already in table?

Question

So I have the following Feeds class

class Feeds(DeclarativeBase):
    __tablename__ = "rawFeeds"

    id = Column(Integer, primary_key=True)
    link = Column('link', String)
    date = Column('date', String)
    source = Column('source', String)

def __init__(self, link, date, source):
    self.link = link
    self.date = date
    self.source = source

and I want to run a check to see if data already exists in a table (to avoid adding duplicates). I'm using the following statement, but no matter what I try it always produces a True result

if session.query(exists().where(Feeds.link==item['link'][0])):
    print "Already exists"
else:
    #add to database

Can anyone help me figure out what I'm doing wrong? I've read the SQLAlchemy docs over and over, but I can't figure out what the error here is. Thanks.

Owen · Accepted Answer · 2013-09-03 04:24:01Z

2

session.query() returns a Query object as per the documentation:

http://docs.sqlalchemy.org/en/rel_0_7/orm/query.html

This will mean that your if statement will always evaluate to true.

answered Sep 3, 2013 at 4:24

Owen

1,73611 silver badges15 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

JDGD Over a year ago

Thanks, in case anyone else has this problem I modified the If statement to the following: session.query(Feeds).filter(Feeds.link==item['link'][0]).scalar()

Collectives™ on Stack Overflow

Python - SQLAlchemy using exists() to check if data already in table?

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related