Python get_session Examples

Example #1

from database.connection.mysql_connection import get_session

session = get_session()


class GenericDao():
    def insert_record(self, record):
        session.add(record)
        session.commit()
        session.flush()
        #print('inserted record :: {}'.format(record))

    def get_all_records(self, Type):
        return get_session().query(Type).all()

Example #2

 def get_all_records(self, Type):
     return get_session().query(Type).all()

Example #3

 def insert_record(self, record):
     session = get_session()
     session.add(record)
     session.commit()
     session.flush()
     print('inserted record :: {}'.format(record))

Example #4

File: locations_dao.py Project: pankajti/travelenzy

 def find_state_by_name(self, name):
     return get_session().query(state).filter_by(name=name).all()

Example #5

File: locations_dao.py Project: pankajti/travelenzy

 def find_country_by_name(self, name):
     return get_session().query(country).filter_by(name=name).all()

Example #6

File: locations_dao.py Project: pankajti/travelenzy

 def find_location_by_name(self, name):
     return get_session().query(location).filter_by(name=name)

Example #7

 def find_details_by_location_name(self, name):
     location = self.find_location_by_name(name).all()[0]
     return get_session().query(location_details).filter_by(
         location_id=location.id).all()