File size: 1,099 Bytes
ff14304 6761847 5d57d55 b9521ec 5d57d55 882e90a 6761847 d31320d 6761847 ff14304 5d57d55 882e90a 5d57d55 ee6afd3 5d57d55 882e90a 5d57d55 6761847 5d57d55 6761847 5d57d55 882e90a 6761847 5d57d55 6761847 882e90a 5d57d55 |
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 |
import sqlite3
import os
from flask import g
def get_db_path():
if os.path.exists('/data'):
return '/data/udids.db'
elif os.path.exists('/home/user_data'):
return '/home/user_data/udids.db'
return 'udids.db'
def get_db():
if 'db' not in g:
db_path = get_db_path()
os.makedirs(os.path.dirname(db_path), exist_ok=True)
g.db = sqlite3.connect(db_path)
g.db.row_factory = sqlite3.Row
return g.db
def close_db(e=None):
db = g.pop('db', None)
if db is not None:
db.close()
def init_db(app):
with app.app_context():
db = get_db()
cursor = db.cursor()
cursor.execute('''
CREATE TABLE IF NOT EXISTS udids (
id INTEGER PRIMARY KEY AUTOINCREMENT,
udid TEXT NOT NULL UNIQUE
)
''')
# Örnek veri ekleme
cursor.execute('SELECT COUNT(*) FROM udids')
if cursor.fetchone()[0] == 0:
cursor.execute('INSERT INTO udids (udid) VALUES (?)', ('deneme-udid',))
db.commit() |