Python get_engine Examples

Example #1

File: load_data.py Project: mlakewood/food_truck

def main():
    parser = argparse.ArgumentParser(description='Get the data from data.sfgov on food trucks and populate the db with it.')
    parser.add_argument('-u','--url', help='The database url to populate', required=True)
    args = vars(parser.parse_args())

    food_truck_db = args['url']
    
    truck_request = requests.get('http://data.sfgov.org/resource/rqzj-sfat.json')

    if truck_request.status_code != 200:
        raise Exception("Error getting data. Status code: %s, Message: %s" % truck_request.status, truck_request.data)

    truck_list = json.loads(truck_request.content)
    engine = get_engine(food_truck_db)
    session = get_db_session(engine)

    session.query(FoodTruck).delete()

    for t in truck_list:
        print t['applicant']
        try:
            new_truck = FoodTruck(t['applicant'], t['location']['latitude'], t['location']['longitude'])
            new_truck.fooditems = t['fooditems']
            session.add(new_truck)

            session.commit()
        except flask_sqlalchemy.sqlalchemy.exc.IntegrityError:
            session.rollback()
            continue
        except KeyError:
            continue

Example #2

File: test_food_trucks.py Project: jaimegago/food_truck

    def setUp(self):
        test_sql = 'sqlite:///test_db.sql'
        self.engine = get_engine(test_sql)
        self.db = init_db(self.engine, Base)
        self.db_session = get_db_session(self.engine)
        my_app.config['DB_SESSION'] = self.db_session

        self.app = my_app.test_client()

Example #3

File: create_db.py Project: jaimegago/food_truck

def main():
    parser = argparse.ArgumentParser(description='Create the data base for the food truck app.')
    parser.add_argument('-u','--url', help='The database url to create', required=True)
    args = vars(parser.parse_args())

    food_truck_db = args['url']
    engine = get_engine(food_truck_db)
    init_db(engine, Base)

Example #4

File: test_food_trucks.py Project: mlakewood/food_truck

    def setUp(self):
        test_sql = 'sqlite:///test_db.sql'
        self.engine = get_engine(test_sql)
        self.db = init_db(self.engine, Base)
        self.db_session = get_db_session(self.engine)
        my_app.config['DB_SESSION'] = self.db_session

        self.app = my_app.test_client()

Example #5

File: create_db.py Project: mlakewood/food_truck

def main():
    parser = argparse.ArgumentParser(
        description='Create the data base for the food truck app.')
    parser.add_argument('-u',
                        '--url',
                        help='The database url to create',
                        required=True)
    args = vars(parser.parse_args())

    food_truck_db = args['url']
    engine = get_engine(food_truck_db)
    init_db(engine, Base)

Example #6

File: run_server.py Project: mlakewood/food_truck

def run_server():
    parser = argparse.ArgumentParser(description='Create the data base for the food truck app.')
    parser.add_argument('-u','--url', help='The database url to create', required=True)
    args = vars(parser.parse_args())

    food_truck_db = args['url']
    
    from food_trucks.db import get_engine, get_db_session
    engine = get_engine(food_truck_db)
    my_app.config['DB_SESSION'] = get_db_session(engine)
    define_urls(my_app)
    my_app.debug = True
    return my_app

Example #7

File: run_server.py Project: mlakewood/food_truck

def run_server():
    parser = argparse.ArgumentParser(
        description='Create the data base for the food truck app.')
    parser.add_argument('-u',
                        '--url',
                        help='The database url to create',
                        required=True)
    args = vars(parser.parse_args())

    food_truck_db = args['url']

    from food_trucks.db import get_engine, get_db_session
    engine = get_engine(food_truck_db)
    my_app.config['DB_SESSION'] = get_db_session(engine)
    define_urls(my_app)
    my_app.debug = True
    return my_app

Example #8

 def setUp(self):
     # self.db_fd, app.config['DATABASE'] = tempfile.mkstemp()
     test_sql = 'sqlite:///test_db.sql'
     self.engine = get_engine(test_sql)
     self.db = init_db(self.engine, Base)
     self.db_session = get_db_session(self.engine)

Example #9

File: test_food_truck.py Project: jaimegago/food_truck

 def setUp(self):
     # self.db_fd, app.config['DATABASE'] = tempfile.mkstemp()
     test_sql = 'sqlite:///test_db.sql'
     self.engine = get_engine(test_sql)
     self.db = init_db(self.engine, Base)
     self.db_session = get_db_session(self.engine)