[sqlalchemy] Re: Retrieving Objects from DB

2016-12-16 Thread 'Simon Moon' via sqlalchemy
class Machine(Base): __tablename__='machine' id = Column(Integer, primary_key=True) name = Column(String(250), nullable=False) comment= Column(String(250)) tags = Column(String(250), nullable=True) class GeneralMeasurementData(Base):

[sqlalchemy] Retrieving Objects from DB

2016-12-16 Thread 'Simon Moon' via sqlalchemy
Dear All, I want to do something like this: (MachineExists,), = session.query(exists().where(Machine.name.like('%'+machine+'%'))) if not MachineExists: print("Specify machine name better") return m =