# app.py
from flask import Flask, render_template, request, jsonify
import sqlite3
import random
import json
import re

app = Flask(__name__)
DATABASE = 'typography_css.db'
FONTS = [
  "Arial, sans-serif",
  "'Times New Roman', serif",
  "'Courier New', monospace",
  "Verdana, sans-serif",
  "Georgia, serif",
  "'Comic Sans MS', cursive",
  "'Trebuchet MS', sans-serif",
  "Impact, sans-serif",
  "'Brush Script MT', cursive",
  "'Segoe UI', sans-serif"
]
TEXT_ALIGNMENTS = ['left', 'center', 'right']
FONT_WEIGHTS = ['normal', 'bold', 'italic', 'bold italic']

def get_db():
  conn = sqlite3.connect(DATABASE)
  conn.row_factory = sqlite3.Row
  return conn

def init_db():
  with app.app_context():
    db = get_db()
    with app.open_resource('schema.sql', mode='r') as f:
      db.cursor().executescript(f.read())
    db.commit()

@app.cli.command('initdb')
def initdb_command():
  """Initialize the database for CSS typography."""
  init_db()
  print('Initialized the database for CSS typography.')

def generate_random_style():
  return {
    'font-family': random.choice(FONTS),
    'font-size': f'{random.randint(20, 50)}px',
    'color': f'rgb({random.randint(0, 255)}, \
                   {random.randint(0, 255)}, \
                   {random.randint(0, 255)})',
    'background-color': 
      random.choice([None, f'rgba({random.randint(200, 255)}, \
                                  {random.randint(200, 255)}, \
                                  {random.randint(200, 255)}, 0.3)']),
    'text-align': random.choice(TEXT_ALIGNMENTS),
    'font-weight': random.choice(FONT_WEIGHTS),
    'text-shadow': f'{random.randint(-2, 2)}px \
                     {random.randint(-2, 2)}px 1px rgba(0, 0, 0, 0.5)' \
                   if random.choice([True, False]) else None,
    '-webkit-text-stroke': f'{random.randint(0, 1)}px \
                           rgb({random.randint(0, 100)}, \
                               {random.randint(0, 100)}, \
                               {random.randint(0, 100)})' \
                           if random.choice([True, False]) else None,
    'transform': f'rotate({random.randint(-5, 5)}deg)' \
                 if random.choice([True, False]) else None
  }

@app.route('/')
def index():
  return render_template('index.html')

@app.route('/api/settings')
def get_settings():
  db = get_db()
  settings = \
    db.execute('SELECT id, name FROM typography_settings_css').fetchall()
  db.close()
  return jsonify([{'id': row['id'], 
                   'name': row['name']} for row in settings])

@app.route('/generate_css', methods=['POST'])
def generate_css():
  text = request.form['text']
  delimiters = r'([。\n、,.?!！?…・]|[\s])'
  parts = [part for part in re.split(delimiters, text) if part]
  styles = [generate_random_style() for _ in range(len(parts))]
  return jsonify({'parts': parts, 'styles': styles})

@app.route('/save_setting_css', methods=['POST'])
def save_setting_css():
  name = request.form['setting_name']
  text = request.form['text']
  styles = request.form['styles']
  db = get_db()
  try:
    db.execute('''
      INSERT INTO typography_settings_css (name, text, styles)
      VALUES (?, ?, ?)
    ''', (name, text, styles))
    db.commit()
    message = '設定を保存しました。'
    success = True
  except sqlite3.IntegrityError:
    message = '同じ名前の設定が既に存在します。'
    success = False
  db.close()
  return jsonify({'message': message, 'success': success})

@app.route('/load_setting_css/<int:setting_id>')
def load_setting_css(setting_id):
  db = get_db()
  setting = \
    db.execute('SELECT text, styles FROM typography_settings_css WHERE id = ?',
      (setting_id,)).fetchone()
  db.close()
  if setting:
    return jsonify({'text': setting['text'], 'styles': setting['styles']})
  return jsonify({'error': '設定が見つかりません。'}), 404

@app.route('/load_random_setting_css')
def load_random_setting_css():
  db = get_db()
  settings = db.execute('SELECT id FROM typography_settings_css').fetchall()
  if not settings:
    db.close()
    return jsonify({'error': '保存された設定がありません。'}), 404
  random_setting_id = random.choice([row['id'] for row in settings])
  setting = \
    db.execute('SELECT text, styles FROM typography_settings_css WHERE id = ?',
      (random_setting_id,)).fetchone()
  db.close()
  if setting:
    return jsonify({'text': setting['text'], 'styles': setting['styles']})
  return jsonify({'error': 'ランダムな設定の読み込みに失敗しました。'}), 500

if __name__ == '__main__':
  app.run(debug=True)