#!/usr/bin/env bash
# onx-db-drop-table — DROP TABLE (tabloyu komple sil)
# Input:  {"db_name":"onx_xxx_app","table":"wp_logs"}
# Output: {"db_name":...,"table":...,"dropped":true}

SCRIPT_DIR="$(cd "$(dirname "${BASH_SOURCE[0]}")" && pwd)"
source "${SCRIPT_DIR}/_lib/common.sh"

require_root
require_cmd mysql
onx_json_input

DB_NAME="$(onx_json_field db_name)"
TABLE="$(onx_json_field table)"

[[ -z "$DB_NAME" ]] && onx_die 1 "db_name zorunlu"
[[ -z "$TABLE" ]]   && onx_die 1 "table zorunlu"
[[ "$DB_NAME" =~ ^[a-z0-9_]+$ ]]   || onx_die 1 "Gecersiz db_name: '${DB_NAME}'"
[[ "$TABLE" =~ ^[a-zA-Z0-9_]+$ ]]  || onx_die 1 "Gecersiz table: '${TABLE}'"

onx_log "db-drop-table: db=${DB_NAME} table=${TABLE}"

mysql_exec "$DB_NAME" "DROP TABLE IF EXISTS \`${TABLE}\`" \
    || onx_die 3 "DROP TABLE basarisiz: ${DB_NAME}.${TABLE}"

json_ok "{\"db_name\":\"${DB_NAME}\",\"table\":\"${TABLE}\",\"dropped\":true}"
