#!/usr/bin/env python3
"""
Sözlük Veritabanı Yönetim Paneli
- Kayıt listeleme (checkbox ile seçim)
- Toplu silme
- Tekli düzenleme
- Yeni kayıt ekleme
- Arama ve filtreleme
"""
import sqlite3
from flask import Flask, render_template_string, jsonify, request
import os
app = Flask(__name__)
DATABASE = '/mnt/pdfs/dictionary.db'
def get_db():
conn = sqlite3.connect(DATABASE)
conn.row_factory = sqlite3.Row
return conn
HTML_TEMPLATE = '''
Sözlük Yönetimi
'''
@app.route('/')
def index():
return render_template_string(HTML_TEMPLATE)
@app.route('/api/categories')
def get_categories():
try:
conn = get_db()
cursor = conn.cursor()
cursor.execute('''
SELECT category, COUNT(*) as cnt
FROM technical_terms
GROUP BY category
ORDER BY cnt DESC
''')
categories = [{'name': row['category'], 'count': row['cnt']} for row in cursor.fetchall()]
conn.close()
return jsonify({'categories': categories})
except Exception as e:
return jsonify({'error': str(e)}), 500
@app.route('/api/data')
def get_data():
try:
limit = request.args.get('limit', 100, type=int)
offset = request.args.get('offset', 0, type=int)
search = request.args.get('search', '')
category = request.args.get('category', '')
conn = get_db()
cursor = conn.cursor()
# Build query
where_clauses = []
params = []
if search:
where_clauses.append('(canonical_en LIKE ? OR canonical_tr LIKE ?)')
params.extend([f'%{search}%', f'%{search}%'])
if category:
where_clauses.append('category = ?')
params.append(category)
where_sql = f"WHERE {' AND '.join(where_clauses)}" if where_clauses else ""
# Get total count
cursor.execute(f'SELECT COUNT(*) FROM technical_terms {where_sql}', params)
total = cursor.fetchone()[0]
# Get data
cursor.execute(f'''
SELECT term_id, canonical_en, canonical_tr, category, confidence_score, created_at
FROM technical_terms
{where_sql}
ORDER BY created_at DESC
LIMIT ? OFFSET ?
''', params + [limit, offset])
data = [dict(row) for row in cursor.fetchall()]
conn.close()
return jsonify({'data': data, 'total': total})
except Exception as e:
return jsonify({'error': str(e)}), 500
@app.route('/api/add', methods=['POST'])
def add_record():
try:
data = request.get_json()
conn = get_db()
cursor = conn.cursor()
cursor.execute('''
INSERT INTO technical_terms (canonical_en, canonical_tr, category, confidence_score)
VALUES (?, ?, ?, ?)
''', (
data.get('canonical_en'),
data.get('canonical_tr'),
data.get('category'),
data.get('confidence_score', 0.9)
))
conn.commit()
new_id = cursor.lastrowid
conn.close()
return jsonify({'success': True, 'id': new_id})
except Exception as e:
return jsonify({'success': False, 'error': str(e)}), 500
@app.route('/api/update/', methods=['POST'])
def update_record(term_id):
try:
data = request.get_json()
conn = get_db()
cursor = conn.cursor()
cursor.execute('''
UPDATE technical_terms
SET canonical_en = ?, canonical_tr = ?, category = ?, confidence_score = ?
WHERE term_id = ?
''', (
data.get('canonical_en'),
data.get('canonical_tr'),
data.get('category'),
data.get('confidence_score', 0.9),
term_id
))
conn.commit()
conn.close()
return jsonify({'success': True})
except Exception as e:
return jsonify({'success': False, 'error': str(e)}), 500
@app.route('/api/delete', methods=['POST'])
def delete_records():
try:
data = request.get_json()
ids = data.get('ids', [])
if not ids:
return jsonify({'success': False, 'error': 'No IDs provided'})
conn = get_db()
cursor = conn.cursor()
placeholders = ','.join(['?' for _ in ids])
cursor.execute(f'DELETE FROM technical_terms WHERE term_id IN ({placeholders})', ids)
deleted = cursor.rowcount
conn.commit()
conn.close()
return jsonify({'success': True, 'deleted': deleted})
except Exception as e:
return jsonify({'success': False, 'error': str(e)}), 500
if __name__ == '__main__':
app.run(host='0.0.0.0', port=5000, debug=True)