|
|
from flask import jsonify |
|
|
from database import get_db |
|
|
|
|
|
def get_users(): |
|
|
"""Tüm kullanıcıları getirir""" |
|
|
try: |
|
|
db = get_db() |
|
|
users = db.execute('SELECT * FROM users').fetchall() |
|
|
return jsonify([dict(user) for user in users]) |
|
|
except Exception as e: |
|
|
return jsonify({"error": str(e)}), 500 |
|
|
|
|
|
def get_user(udid): |
|
|
"""UDID ile kullanıcıyı getirir (yoksa oluşturur)""" |
|
|
try: |
|
|
db = get_db() |
|
|
cursor = db.cursor() |
|
|
|
|
|
user = cursor.execute( |
|
|
'SELECT * FROM users WHERE udid = ?', |
|
|
(udid,) |
|
|
).fetchone() |
|
|
|
|
|
if user: |
|
|
return jsonify(dict(user)) |
|
|
|
|
|
|
|
|
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 |
|
|
|
|
|
except Exception as e: |
|
|
return jsonify({"error": str(e)}), 500 |
