aboutsummaryrefslogtreecommitdiff
path: root/api/db.py
blob: 3b7a5568be774f46bcaa8d6e028e9029eff6d284 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
import os
import sqlite3

# open database
db_path = os.path.abspath("../database/database.db")
connection = sqlite3.connect(db_path, check_same_thread=False)
#!                                    ^^^ Dit is onveilig en goede multithreading support moet nog geïmplementeerd worden

# load the sql extension used in social/search
connection.enable_load_extension(True)
connection.load_extension("../database/levenshtein.sqlext")

# sql cursor
cursor = connection.cursor()