File size: 924 Bytes
e2d2b86 1d9ece6 a8d8e84 6f7ceff a8d8e84 1d9ece6 a8d8e84 637f0af 6f7ceff 637f0af |
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 |
from flask import jsonify
from database import get_db
def get_users():
"""Tüm kullanıcıları getirir"""
db = get_db()
users = db.execute('SELECT * FROM users').fetchall()
return jsonify([dict(user) for user in users])
def get_user(udid):
"""UDID ile kullanıcıyı getirir (yoksa oluşturur)"""
db = get_db()
cursor = db.cursor()
user = cursor.execute(
'SELECT * FROM users WHERE udid = ?',
(udid,)
).fetchone()
if user:
return jsonify(dict(user))
# Kullanıcı yoksa otomatik oluştur
cursor.execute(
'INSERT INTO users (udid, name, premium_account, usage_limit, invoice) VALUES (?, ?, ?, ?, ?)',
(udid, 'guest', False, 3, 'empty')
)
db.commit()
new_user = cursor.execute(
'SELECT * FROM users WHERE udid = ?',
(udid,)
).fetchone()
return jsonify(dict(new_user)), 201 |