def get(cls, id): """Return Customer object with id""" session = SQL_Session() result = session.query(Customer).filter(Customer.id == id).first() session.close() return result
@classmethod def get(cls, id): """Return Customer object with id""" session = SQL_Session() result = session.query(Customer).filter(Customer.id == id).first() session.close() return result if __name__ == "__main__": # Build DB SQL_Base.metadata.create_all(sql_engine) # Get a session object session = SQL_Session() session.add(Customer(name="Apple", sites=["apple.com"])) session.add(Customer(name="Google", sites=["google.com", "google.co.uk"])) session.add(Customer(name="Amazon")) # Save everything session.commit() # Print everything for row in session.query(Customer).all(): print row # Close the session session.close()