database.py

from flask import g
import sqlite3


def connect_to_database():
    sql = sqlite3.connect('C:/Users/anuja/PycharmProjects/TourGuideSchedule/guideschedule.db')
    sql.row_factory = sqlite3.Row
    return sql

def get_database():
    if not hasattr(g, 'guideschedule_db'):
        g.guideschedule_db = connect_to_database()
    return g.guideschedule_db