sz-orm-cpp 7.6.0

//! # SZ-ORM C++ Bindings
//!
//! Provides sz-orm-core's Pool/Query API to C++ via `extern "C"` + C ABI
//! (SQLite backend, real and usable).
//!
//! C++ side wrapper see `cpp/szorm.h` (use `szorm::Pool` after `#include <szorm.h>`).

use std::ffi::{c_char, CStr, CString};

use sz_orm_cabi::{
    PoolConfigC, PoolMetricsC, PoolStatsC, QueryJsonResult, QueryResultC, SzOrmPoolHandle,
    SzOrmQueryBuilderHandle, SzOrmTransactionHandle,
};

/// Create connection pool (real creation, SQLite backend)
///
/// Returns handle, null indicates failure.
///
/// # Safety
///
/// SAFETY: `dsn` must be a valid NUL-terminated C string; `config` may be null.
#[no_mangle]
pub unsafe extern "C" fn sz_orm_cpp_pool_new(
    dsn: *const c_char,
    config: *const PoolConfigC,
) -> SzOrmPoolHandle {
    // SAFETY: 转发到 cabi
    unsafe { sz_orm_cabi::sz_orm_pool_new(dsn, config) }
}

/// Free connection pool
///
/// # Safety
///
/// SAFETY: handle must be a valid handle returned by `sz_orm_cpp_pool_new`.
#[no_mangle]
pub unsafe extern "C" fn sz_orm_cpp_pool_free(handle: SzOrmPoolHandle) {
    // SAFETY: 转发到 cabi
    unsafe { sz_orm_cabi::sz_orm_pool_free(handle) }
}

/// Health check (real acquire + ping)
///
/// # Safety
///
/// SAFETY: handle must be a valid handle returned by `sz_orm_cpp_pool_new`.
#[no_mangle]
pub unsafe extern "C" fn sz_orm_cpp_ping(handle: SzOrmPoolHandle) -> i32 {
    // SAFETY: 转发到 cabi
    unsafe { sz_orm_cabi::sz_orm_ping(handle) }
}

/// Execute query, return JSON row array (caller frees with `sz_orm_cpp_string_free`)
///
/// # Safety
///
/// SAFETY: handle must be a valid handle returned by `sz_orm_cpp_pool_new`;
/// `sql` must be a valid NUL-terminated C string.
#[no_mangle]
pub unsafe extern "C" fn sz_orm_cpp_query(
    handle: SzOrmPoolHandle,
    sql: *const c_char,
) -> *mut c_char {
    if handle.is_null() || sql.is_null() {
        return std::ptr::null_mut();
    }
    // SAFETY: 调用方保证 handle 有效
    let result = unsafe { sz_orm_cabi::sz_orm_query(handle, sql) };
    if result.is_null() {
        return std::ptr::null_mut();
    }
    // SAFETY: result 由 sz_orm_query 分配
    let result_box = unsafe { Box::from_raw(result) };
    let json = if result_box.success != 0 && !result_box.json.is_null() {
        // SAFETY: json 是有效 NUL 结尾 C 字符串
        unsafe { CStr::from_ptr(result_box.json) }
            .to_str()
            .map(|s| s.to_string())
            .unwrap_or_default()
    } else {
        // SAFETY: result_box 配对释放
        unsafe {
            sz_orm_cabi::sz_orm_query_result_free(Box::into_raw(result_box));
        }
        return std::ptr::null_mut();
    };
    // SAFETY: result_box 配对释放
    unsafe {
        sz_orm_cabi::sz_orm_query_result_free(Box::into_raw(result_box));
    }
    match CString::new(json) {
        Ok(c) => c.into_raw(),
        Err(_) => std::ptr::null_mut(),
    }
}

/// Free string returned by `sz_orm_cpp_query`
///
/// # Safety
///
/// SAFETY: `ptr` must be a pointer returned by `sz_orm_cpp_query` (or null).
#[no_mangle]
pub unsafe extern "C" fn sz_orm_cpp_string_free(ptr: *mut c_char) {
    if ptr.is_null() {
        return;
    }
    // SAFETY: ptr 由 CString::into_raw 分配，配对释放
    unsafe {
        drop(CString::from_raw(ptr));
    }
}

/// Execute write statement, return heap-allocated `QueryResultC` (free with `sz_orm_cpp_result_free`)
///
/// # Safety
///
/// SAFETY: handle must be a valid handle returned by `sz_orm_cpp_pool_new`;
/// `sql` must be a valid NUL-terminated C string.
#[no_mangle]
pub unsafe extern "C" fn sz_orm_cpp_execute(
    handle: SzOrmPoolHandle,
    sql: *const c_char,
) -> *mut QueryResultC {
    if handle.is_null() || sql.is_null() {
        return std::ptr::null_mut();
    }
    // SAFETY: 转发到 cabi
    let result = unsafe { sz_orm_cabi::sz_orm_execute(handle, sql) };
    Box::into_raw(Box::new(result))
}

/// Free result returned by `sz_orm_cpp_execute`
///
/// # Safety
///
/// SAFETY: `ptr` must be a pointer returned by `sz_orm_cpp_execute` (or null).
#[no_mangle]
pub unsafe extern "C" fn sz_orm_cpp_result_free(ptr: *mut QueryResultC) {
    if ptr.is_null() {
        return;
    }
    // SAFETY: ptr 由 sz_orm_cpp_execute 分配，配对释放
    unsafe {
        drop(Box::from_raw(ptr));
    }
}

/// Get version number
#[no_mangle]
pub extern "C" fn sz_orm_cpp_version() -> u32 {
    sz_orm_cabi::sz_orm_version()
}

// ============================================================================
// 事务 API 转发（REQ-BND-006）
// ============================================================================

/// Begin transaction, return transaction handle (null indicates failure)
///
/// # Safety
///
/// SAFETY: `handle` must be a valid handle returned by `sz_orm_cpp_pool_new`.
#[no_mangle]
pub unsafe extern "C" fn sz_orm_cpp_transaction_begin(
    handle: SzOrmPoolHandle,
) -> SzOrmTransactionHandle {
    // SAFETY: 转发到 cabi
    unsafe { sz_orm_cabi::sz_orm_transaction_begin(handle) }
}

/// Execute SQL in transaction, return heap-allocated `QueryResultC`
///
/// # Safety
///
/// SAFETY: `tx_handle` must be valid; `sql` must be a valid NUL-terminated C string.
#[no_mangle]
pub unsafe extern "C" fn sz_orm_cpp_transaction_execute(
    tx_handle: SzOrmTransactionHandle,
    sql: *const c_char,
) -> *mut QueryResultC {
    if tx_handle.is_null() || sql.is_null() {
        return std::ptr::null_mut();
    }
    // SAFETY: 转发到 cabi
    let result = unsafe { sz_orm_cabi::sz_orm_transaction_execute(tx_handle, sql) };
    Box::into_raw(Box::new(result))
}

/// Commit transaction, return 1=success 0=failure
///
/// # Safety
///
/// SAFETY: `tx_handle` must be valid.
#[no_mangle]
pub unsafe extern "C" fn sz_orm_cpp_transaction_commit(tx_handle: SzOrmTransactionHandle) -> i32 {
    // SAFETY: 转发到 cabi
    unsafe { sz_orm_cabi::sz_orm_transaction_commit(tx_handle) }
}

/// Rollback transaction, return 1=success 0=failure
///
/// # Safety
///
/// SAFETY: `tx_handle` must be valid.
#[no_mangle]
pub unsafe extern "C" fn sz_orm_cpp_transaction_rollback(tx_handle: SzOrmTransactionHandle) -> i32 {
    // SAFETY: 转发到 cabi
    unsafe { sz_orm_cabi::sz_orm_transaction_rollback(tx_handle) }
}

/// Free transaction handle (auto rollback if still active)
///
/// # Safety
///
/// SAFETY: `tx_handle` must be valid.
#[no_mangle]
pub unsafe extern "C" fn sz_orm_cpp_transaction_free(tx_handle: SzOrmTransactionHandle) {
    // SAFETY: 转发到 cabi
    unsafe { sz_orm_cabi::sz_orm_transaction_free(tx_handle) }
}

// ============================================================================
// 模型级 API 转发（REQ-BND-013）
// ============================================================================

/// Insert row on pool, return heap-allocated `QueryResultC`
///
/// # Safety
///
/// SAFETY: `handle` must be valid; all parameters must be valid NUL-terminated C strings.
#[no_mangle]
pub unsafe extern "C" fn sz_orm_cpp_model_insert(
    handle: SzOrmPoolHandle,
    table: *const c_char,
    fields_json: *const c_char,
    values_json: *const c_char,
) -> *mut QueryResultC {
    if handle.is_null() || table.is_null() || fields_json.is_null() || values_json.is_null() {
        return std::ptr::null_mut();
    }
    // SAFETY: 转发到 cabi
    let result =
        unsafe { sz_orm_cabi::sz_orm_model_insert(handle, table, fields_json, values_json) };
    Box::into_raw(Box::new(result))
}

/// Update row on pool, return heap-allocated `QueryResultC`
///
/// # Safety
///
/// SAFETY: `handle` must be valid; all parameters must be valid NUL-terminated C strings.
#[no_mangle]
pub unsafe extern "C" fn sz_orm_cpp_model_update(
    handle: SzOrmPoolHandle,
    table: *const c_char,
    set_json: *const c_char,
    where_clause: *const c_char,
    where_params_json: *const c_char,
) -> *mut QueryResultC {
    if handle.is_null() || table.is_null() || set_json.is_null() {
        return std::ptr::null_mut();
    }
    // SAFETY: 转发到 cabi
    let result = unsafe {
        sz_orm_cabi::sz_orm_model_update(handle, table, set_json, where_clause, where_params_json)
    };
    Box::into_raw(Box::new(result))
}

/// Delete row on pool, return heap-allocated `QueryResultC`
///
/// # Safety
///
/// SAFETY: `handle` must be valid; all parameters must be valid NUL-terminated C strings.
#[no_mangle]
pub unsafe extern "C" fn sz_orm_cpp_model_delete(
    handle: SzOrmPoolHandle,
    table: *const c_char,
    where_clause: *const c_char,
    where_params_json: *const c_char,
) -> *mut QueryResultC {
    if handle.is_null() || table.is_null() {
        return std::ptr::null_mut();
    }
    // SAFETY: 转发到 cabi
    let result =
        unsafe { sz_orm_cabi::sz_orm_model_delete(handle, table, where_clause, where_params_json) };
    Box::into_raw(Box::new(result))
}

/// Query row on pool, return JSON row array string (free with `sz_orm_cpp_string_free`)
///
/// # Safety
///
/// SAFETY: `handle` must be valid; all parameters must be valid NUL-terminated C strings.
#[no_mangle]
pub unsafe extern "C" fn sz_orm_cpp_model_find(
    handle: SzOrmPoolHandle,
    table: *const c_char,
    where_clause: *const c_char,
    where_params_json: *const c_char,
) -> *mut c_char {
    if handle.is_null() || table.is_null() {
        return std::ptr::null_mut();
    }
    // SAFETY: 转发到 cabi
    unsafe { sz_orm_cabi::sz_orm_model_find(handle, table, where_clause, where_params_json) }
}

/// Insert row in transaction, return heap-allocated `QueryResultC`
///
/// # Safety
///
/// SAFETY: `tx_handle` must be valid; all parameters must be valid NUL-terminated C strings.
#[no_mangle]
pub unsafe extern "C" fn sz_orm_cpp_model_insert_tx(
    tx_handle: SzOrmTransactionHandle,
    table: *const c_char,
    fields_json: *const c_char,
    values_json: *const c_char,
) -> *mut QueryResultC {
    if tx_handle.is_null() || table.is_null() || fields_json.is_null() || values_json.is_null() {
        return std::ptr::null_mut();
    }
    // SAFETY: 转发到 cabi
    let result =
        unsafe { sz_orm_cabi::sz_orm_model_insert_tx(tx_handle, table, fields_json, values_json) };
    Box::into_raw(Box::new(result))
}

/// Update row in transaction, return heap-allocated `QueryResultC`
///
/// # Safety
///
/// SAFETY: `tx_handle` must be valid; all parameters must be valid NUL-terminated C strings.
#[no_mangle]
pub unsafe extern "C" fn sz_orm_cpp_model_update_tx(
    tx_handle: SzOrmTransactionHandle,
    table: *const c_char,
    set_json: *const c_char,
    where_clause: *const c_char,
    where_params_json: *const c_char,
) -> *mut QueryResultC {
    if tx_handle.is_null() || table.is_null() || set_json.is_null() {
        return std::ptr::null_mut();
    }
    // SAFETY: 转发到 cabi
    let result = unsafe {
        sz_orm_cabi::sz_orm_model_update_tx(
            tx_handle,
            table,
            set_json,
            where_clause,
            where_params_json,
        )
    };
    Box::into_raw(Box::new(result))
}

/// Delete row in transaction, return heap-allocated `QueryResultC`
///
/// # Safety
///
/// SAFETY: `tx_handle` must be valid; all parameters must be valid NUL-terminated C strings.
#[no_mangle]
pub unsafe extern "C" fn sz_orm_cpp_model_delete_tx(
    tx_handle: SzOrmTransactionHandle,
    table: *const c_char,
    where_clause: *const c_char,
    where_params_json: *const c_char,
) -> *mut QueryResultC {
    if tx_handle.is_null() || table.is_null() {
        return std::ptr::null_mut();
    }
    // SAFETY: 转发到 cabi
    let result = unsafe {
        sz_orm_cabi::sz_orm_model_delete_tx(tx_handle, table, where_clause, where_params_json)
    };
    Box::into_raw(Box::new(result))
}

/// Query row in transaction, return JSON row array string (free with `sz_orm_cpp_string_free`)
///
/// # Safety
///
/// SAFETY: `tx_handle` must be valid; all parameters must be valid NUL-terminated C strings.
#[no_mangle]
pub unsafe extern "C" fn sz_orm_cpp_model_find_tx(
    tx_handle: SzOrmTransactionHandle,
    table: *const c_char,
    where_clause: *const c_char,
    where_params_json: *const c_char,
) -> *mut c_char {
    if tx_handle.is_null() || table.is_null() {
        return std::ptr::null_mut();
    }
    // SAFETY: 转发到 cabi
    unsafe { sz_orm_cabi::sz_orm_model_find_tx(tx_handle, table, where_clause, where_params_json) }
}

// ============================================================================
// QueryBuilder API 转发（v6.9.0 REQ-BND-QB）
// ============================================================================

/// Create QueryBuilder, return handle (null indicates failure)
///
/// # Safety
///
/// SAFETY: 返回的句柄必须通过 `sz_orm_cpp_qb_free` 释放。
#[no_mangle]
pub unsafe extern "C" fn sz_orm_cpp_qb_new(db_type: u32) -> SzOrmQueryBuilderHandle {
    // SAFETY: 转发到 cabi
    unsafe { sz_orm_cabi::sz_orm_qb_new(db_type) }
}

/// Set table name on QueryBuilder
///
/// # Safety
///
/// SAFETY: `qb` 必须有效；`table` 必须是有效的 NUL 终止 C 字符串。
#[no_mangle]
pub unsafe extern "C" fn sz_orm_cpp_qb_table(
    qb: SzOrmQueryBuilderHandle,
    table: *const c_char,
) -> i32 {
    // SAFETY: 转发到 cabi
    unsafe { sz_orm_cabi::sz_orm_qb_table(qb, table) }
}

/// Add WHERE eq condition
///
/// # Safety
///
/// SAFETY: `qb` 必须有效；`field` 和 `value_json` 必须是有效的 NUL 终止 C 字符串。
#[no_mangle]
pub unsafe extern "C" fn sz_orm_cpp_qb_where_eq(
    qb: SzOrmQueryBuilderHandle,
    field: *const c_char,
    value_json: *const c_char,
) -> i32 {
    // SAFETY: 转发到 cabi
    unsafe { sz_orm_cabi::sz_orm_qb_where_eq(qb, field, value_json) }
}

/// Add ORDER BY clause
///
/// # Safety
///
/// SAFETY: `qb` 必须有效；`field` 必须是有效的 NUL 终止 C 字符串。
#[no_mangle]
pub unsafe extern "C" fn sz_orm_cpp_qb_order_by(
    qb: SzOrmQueryBuilderHandle,
    field: *const c_char,
    desc: i32,
) -> i32 {
    // SAFETY: 转发到 cabi
    unsafe { sz_orm_cabi::sz_orm_qb_order_by(qb, field, desc) }
}

/// Set LIMIT
///
/// # Safety
///
/// SAFETY: `qb` 必须有效。
#[no_mangle]
pub unsafe extern "C" fn sz_orm_cpp_qb_limit(qb: SzOrmQueryBuilderHandle, limit: u64) -> i32 {
    // SAFETY: 转发到 cabi
    unsafe { sz_orm_cabi::sz_orm_qb_limit(qb, limit) }
}

/// Build SQL + params JSON, return C string (free with `sz_orm_cpp_qb_result_free`)
///
/// # Safety
///
/// SAFETY: `qb` 必须有效。
#[no_mangle]
pub unsafe extern "C" fn sz_orm_cpp_qb_build(qb: SzOrmQueryBuilderHandle) -> *mut c_char {
    // SAFETY: 转发到 cabi
    unsafe { sz_orm_cabi::sz_orm_qb_build(qb) }
}

/// Free QueryBuilder handle
///
/// # Safety
///
/// SAFETY: `qb` 必须是 `sz_orm_cpp_qb_new` 返回的句柄（或 null）。
#[no_mangle]
pub unsafe extern "C" fn sz_orm_cpp_qb_free(qb: SzOrmQueryBuilderHandle) {
    // SAFETY: 转发到 cabi
    unsafe { sz_orm_cabi::sz_orm_qb_free(qb) }
}

/// Free build result string
///
/// # Safety
///
/// SAFETY: `result` 必须是 `sz_orm_cpp_qb_build` 返回的指针（或 null）。
#[no_mangle]
pub unsafe extern "C" fn sz_orm_cpp_qb_result_free(result: *mut c_char) {
    // SAFETY: 转发到 cabi
    unsafe { sz_orm_cabi::sz_orm_qb_result_free(result) }
}

// ============================================================================
// ActiveModel API 转发（v6.9.0 REQ-BND-AM）
// ============================================================================

/// ActiveModel create (insert), return heap-allocated `QueryResultC`
///
/// # Safety
///
/// SAFETY: `handle` 必须有效；所有字符串参数必须是有效的 NUL 终止 C 字符串。
#[no_mangle]
pub unsafe extern "C" fn sz_orm_cpp_active_model_create(
    handle: SzOrmPoolHandle,
    table: *const c_char,
    fields_json: *const c_char,
    values_json: *const c_char,
) -> *mut QueryResultC {
    if handle.is_null() || table.is_null() || fields_json.is_null() || values_json.is_null() {
        return std::ptr::null_mut();
    }
    // SAFETY: 转发到 cabi
    let result =
        unsafe { sz_orm_cabi::sz_orm_model_insert(handle, table, fields_json, values_json) };
    Box::into_raw(Box::new(result))
}

/// ActiveModel set (update), return heap-allocated `QueryResultC`
///
/// # Safety
///
/// SAFETY: `handle` 必须有效；所有字符串参数必须是有效的 NUL 终止 C 字符串。
#[no_mangle]
pub unsafe extern "C" fn sz_orm_cpp_active_model_set(
    handle: SzOrmPoolHandle,
    table: *const c_char,
    set_json: *const c_char,
    where_clause: *const c_char,
    where_params_json: *const c_char,
) -> *mut QueryResultC {
    if handle.is_null() || table.is_null() || set_json.is_null() {
        return std::ptr::null_mut();
    }
    // SAFETY: 转发到 cabi
    let result = unsafe {
        sz_orm_cabi::sz_orm_model_update(handle, table, set_json, where_clause, where_params_json)
    };
    Box::into_raw(Box::new(result))
}

/// ActiveModel get (find), return JSON string (free with `sz_orm_cpp_string_free`)
///
/// # Safety
///
/// SAFETY: `handle` 必须有效；所有字符串参数必须是有效的 NUL 终止 C 字符串。
#[no_mangle]
pub unsafe extern "C" fn sz_orm_cpp_active_model_get(
    handle: SzOrmPoolHandle,
    table: *const c_char,
    where_clause: *const c_char,
    where_params_json: *const c_char,
) -> *mut c_char {
    if handle.is_null() || table.is_null() {
        return std::ptr::null_mut();
    }
    // SAFETY: 转发到 cabi
    unsafe { sz_orm_cabi::sz_orm_model_find(handle, table, where_clause, where_params_json) }
}

/// ActiveModel save (insert), return heap-allocated `QueryResultC`
///
/// # Safety
///
/// SAFETY: `handle` 必须有效；所有字符串参数必须是有效的 NUL 终止 C 字符串。
#[no_mangle]
pub unsafe extern "C" fn sz_orm_cpp_active_model_save(
    handle: SzOrmPoolHandle,
    table: *const c_char,
    fields_json: *const c_char,
    values_json: *const c_char,
) -> *mut QueryResultC {
    if handle.is_null() || table.is_null() || fields_json.is_null() || values_json.is_null() {
        return std::ptr::null_mut();
    }
    // SAFETY: 转发到 cabi
    let result =
        unsafe { sz_orm_cabi::sz_orm_model_insert(handle, table, fields_json, values_json) };
    Box::into_raw(Box::new(result))
}

/// ActiveModel delete, return heap-allocated `QueryResultC`
///
/// # Safety
///
/// SAFETY: `handle` 必须有效；所有字符串参数必须是有效的 NUL 终止 C 字符串。
#[no_mangle]
pub unsafe extern "C" fn sz_orm_cpp_active_model_delete(
    handle: SzOrmPoolHandle,
    table: *const c_char,
    where_clause: *const c_char,
    where_params_json: *const c_char,
) -> *mut QueryResultC {
    if handle.is_null() || table.is_null() {
        return std::ptr::null_mut();
    }
    // SAFETY: 转发到 cabi
    let result =
        unsafe { sz_orm_cabi::sz_orm_model_delete(handle, table, where_clause, where_params_json) };
    Box::into_raw(Box::new(result))
}

/// Get pool statistics
///
/// # Safety
///
/// SAFETY: handle must be a valid handle returned by `sz_orm_cpp_pool_new`.
#[no_mangle]
pub unsafe extern "C" fn sz_orm_cpp_pool_stats(handle: SzOrmPoolHandle) -> PoolStatsC {
    // SAFETY: 转发到 cabi，handle 有效性由调用方保证
    unsafe { sz_orm_cabi::sz_orm_pool_stats(handle) }
}

/// Get pool metrics
///
/// # Safety
///
/// SAFETY: handle must be a valid handle returned by `sz_orm_cpp_pool_new`.
#[no_mangle]
pub unsafe extern "C" fn sz_orm_cpp_pool_metrics(handle: SzOrmPoolHandle) -> PoolMetricsC {
    // SAFETY: 转发到 cabi，handle 有效性由调用方保证
    unsafe { sz_orm_cabi::sz_orm_pool_metrics(handle) }
}

/// Query single row as JSON
///
/// # Safety
///
/// SAFETY: handle must be valid; sql must be a valid NUL-terminated C string.
#[no_mangle]
pub unsafe extern "C" fn sz_orm_cpp_query_one(
    handle: SzOrmPoolHandle,
    sql: *const c_char,
) -> *mut QueryJsonResult {
    // SAFETY: 转发到 cabi，参数有效性由调用方保证
    unsafe { sz_orm_cabi::sz_orm_query_one(handle, sql) }
}

/// Execute batch SQL
///
/// # Safety
///
/// SAFETY: handle must be valid; sql must be a valid NUL-terminated C string.
#[no_mangle]
pub unsafe extern "C" fn sz_orm_cpp_execute_batch(
    handle: SzOrmPoolHandle,
    sql: *const c_char,
) -> QueryResultC {
    // SAFETY: 转发到 cabi，参数有效性由调用方保证
    unsafe { sz_orm_cabi::sz_orm_execute_batch(handle, sql) }
}

/// Free query result
///
/// # Safety
///
/// SAFETY: result must be a valid pointer returned by `sz_orm_cpp_query_one`.
#[no_mangle]
pub unsafe extern "C" fn sz_orm_cpp_query_result_free(result: *mut QueryJsonResult) {
    // SAFETY: 转发到 cabi，result 有效性由调用方保证
    unsafe { sz_orm_cabi::sz_orm_query_result_free(result) }
}

/// Get error description string
///
/// # Safety
///
/// SAFETY: Caller must free the returned string with `sz_orm_cpp_string_free`.
#[no_mangle]
pub unsafe extern "C" fn sz_orm_cpp_error_description(code: i32) -> *mut c_char {
    // SAFETY: 转发到 cabi
    unsafe { sz_orm_cabi::sz_orm_error_description(code) }
}

/// Check if table exists
///
/// # Safety
///
/// SAFETY: handle must be valid; table must be a valid NUL-terminated C string.
#[no_mangle]
pub unsafe extern "C" fn sz_orm_cpp_table_exists(
    handle: SzOrmPoolHandle,
    table: *const c_char,
) -> i32 {
    // SAFETY: 转发到 cabi，参数有效性由调用方保证
    unsafe { sz_orm_cabi::sz_orm_table_exists(handle, table) }
}

/// Count rows in table
///
/// # Safety
///
/// SAFETY: handle must be valid; table must be a valid NUL-terminated C string.
#[no_mangle]
pub unsafe extern "C" fn sz_orm_cpp_count(handle: SzOrmPoolHandle, table: *const c_char) -> i64 {
    // SAFETY: 转发到 cabi，参数有效性由调用方保证
    unsafe { sz_orm_cabi::sz_orm_count(handle, table) }
}

#[cfg(test)]
mod tests {
    use super::*;

    fn test_pool() -> SzOrmPoolHandle {
        let dsn = CString::new("sqlite::memory:").unwrap();
        // SAFETY: dsn 有效
        unsafe { sz_orm_cpp_pool_new(dsn.as_ptr(), std::ptr::null()) }
    }

    #[test]
    fn test_cpp_pool_new_creates_real_pool() {
        let pool = test_pool();
        assert!(!pool.is_null(), "pool_new should create a real pool");
        // SAFETY: pool 有效
        unsafe { sz_orm_cpp_pool_free(pool) };
    }

    #[test]
    fn test_cpp_ping_healthy() {
        let pool = test_pool();
        assert!(!pool.is_null());
        // SAFETY: pool 有效
        let healthy = unsafe { sz_orm_cpp_ping(pool) };
        assert_eq!(healthy, 1, "fresh pool should be healthy");
        // SAFETY: pool 有效
        unsafe { sz_orm_cpp_pool_free(pool) };
    }

    #[test]
    fn test_cpp_execute_and_query_roundtrip() {
        let pool = test_pool();
        assert!(!pool.is_null());

        let create =
            CString::new("CREATE TABLE users (id INTEGER PRIMARY KEY, name TEXT)").unwrap();
        // SAFETY: pool/sql 有效
        let rp = unsafe { sz_orm_cpp_execute(pool, create.as_ptr()) };
        assert!(!rp.is_null(), "CREATE should succeed");
        // SAFETY: rp 由 sz_orm_cpp_execute 分配
        let r = unsafe { Box::from_raw(rp) };
        assert_eq!(
            r.success, 1,
            "CREATE should succeed, got code {}",
            r.error_code
        );
        // SAFETY: r 配对释放
        unsafe { sz_orm_cpp_result_free(Box::into_raw(r)) };

        let insert = CString::new("INSERT INTO users (name) VALUES ('Alice'), ('Bob')").unwrap();
        // SAFETY: pool/sql 有效
        let rp = unsafe { sz_orm_cpp_execute(pool, insert.as_ptr()) };
        assert!(!rp.is_null(), "INSERT should succeed");
        // SAFETY: rp 由 sz_orm_cpp_execute 分配
        let r = unsafe { Box::from_raw(rp) };
        assert_eq!(r.success, 1);
        assert_eq!(r.rows_affected, 2, "two rows inserted");
        // SAFETY: r 配对释放
        unsafe { sz_orm_cpp_result_free(Box::into_raw(r)) };

        let q = CString::new("SELECT id, name FROM users ORDER BY id").unwrap();
        // SAFETY: pool/sql 有效
        let json_ptr = unsafe { sz_orm_cpp_query(pool, q.as_ptr()) };
        assert!(!json_ptr.is_null(), "query should return JSON");
        // SAFETY: json_ptr 有效
        let json = unsafe { CStr::from_ptr(json_ptr) }
            .to_string_lossy()
            .into_owned();
        assert!(
            json.contains("Alice"),
            "query rows should contain Alice: {json}"
        );
        assert!(
            json.contains("Bob"),
            "query rows should contain Bob: {json}"
        );
        // SAFETY: json_ptr 由 sz_orm_cpp_query 分配，配对释放
        unsafe { sz_orm_cpp_string_free(json_ptr) };

        // SAFETY: pool 有效
        unsafe { sz_orm_cpp_pool_free(pool) };
    }

    #[test]
    fn test_cpp_query_invalid_sql_returns_null() {
        let pool = test_pool();
        assert!(!pool.is_null());
        let q = CString::new("SELECT * FROM nonexistent").unwrap();
        // SAFETY: pool/sql 有效
        let json_ptr = unsafe { sz_orm_cpp_query(pool, q.as_ptr()) };
        assert!(json_ptr.is_null(), "invalid SQL should return null");
        // SAFETY: pool 有效
        unsafe { sz_orm_cpp_pool_free(pool) };
    }

    #[test]
    fn test_cpp_null_args() {
        // SAFETY: null 参数合法调用
        let pool = unsafe { sz_orm_cpp_pool_new(std::ptr::null(), std::ptr::null()) };
        assert!(pool.is_null());
        // SAFETY: null 参数合法调用
        let r = unsafe { sz_orm_cpp_execute(std::ptr::null_mut(), std::ptr::null()) };
        assert!(r.is_null());
        // SAFETY: null 参数合法调用
        let q = unsafe { sz_orm_cpp_query(std::ptr::null_mut(), std::ptr::null()) };
        assert!(q.is_null());
    }

    #[test]
    fn test_cpp_version() {
        let v = sz_orm_cpp_version();
        assert!(v >= 1, "version should be >= 1, got {v}");
    }

    #[test]
    fn test_cpp_free_null_safe() {
        // SAFETY: null 参数合法调用
        unsafe { sz_orm_cpp_string_free(std::ptr::null_mut()) };
        // SAFETY: null 参数合法调用
        unsafe { sz_orm_cpp_result_free(std::ptr::null_mut()) };
    }

    #[test]
    fn test_cpp_ping_after_free_returns_zero() {
        // 使用 null handle 测试 ping（而非释放后的 UAF）
        // SAFETY: null handle 合法调用
        let healthy = unsafe { sz_orm_cpp_ping(std::ptr::null_mut()) };
        assert_eq!(healthy, 0, "null pool should not be healthy");
    }

    #[test]
    fn test_cpp_multiple_pools_independent() {
        let dsn1 = CString::new("sqlite::memory:").unwrap();
        // SAFETY: dsn1 有效
        let pool1 = unsafe { sz_orm_cpp_pool_new(dsn1.as_ptr(), std::ptr::null()) };
        let dsn2 = CString::new("sqlite::memory:").unwrap();
        // SAFETY: dsn2 有效
        let pool2 = unsafe { sz_orm_cpp_pool_new(dsn2.as_ptr(), std::ptr::null()) };
        assert!(!pool1.is_null());
        assert!(!pool2.is_null());
        assert_ne!(pool1, pool2, "pools should have distinct handles");
        // SAFETY: pools 有效
        unsafe {
            sz_orm_cpp_pool_free(pool1);
            sz_orm_cpp_pool_free(pool2);
        }
    }

    #[test]
    fn test_cpp_execute_empty_sql() {
        let pool = test_pool();
        assert!(!pool.is_null());
        let create = CString::new("CREATE TABLE cpp_e (id INTEGER PRIMARY KEY)").unwrap();
        // SAFETY: pool/sql 有效
        let r = unsafe { sz_orm_cpp_execute(pool, create.as_ptr()) };
        // SAFETY: r 配对释放
        unsafe { sz_orm_cpp_result_free(r) };
        // SAFETY: pool 有效
        unsafe { sz_orm_cpp_pool_free(pool) };
    }

    #[test]
    fn test_cpp_query_empty_table() {
        let pool = test_pool();
        assert!(!pool.is_null());
        let create = CString::new("CREATE TABLE empty_t (id INTEGER PRIMARY KEY)").unwrap();
        // SAFETY: pool/sql 有效
        let r = unsafe { sz_orm_cpp_execute(pool, create.as_ptr()) };
        // SAFETY: r 配对释放
        unsafe { sz_orm_cpp_result_free(r) };
        let q = CString::new("SELECT id FROM empty_t").unwrap();
        // SAFETY: pool/sql 有效
        let json_ptr = unsafe { sz_orm_cpp_query(pool, q.as_ptr()) };
        assert!(
            !json_ptr.is_null(),
            "empty table query should still return JSON"
        );
        // SAFETY: json_ptr 有效
        let json = unsafe { CStr::from_ptr(json_ptr) }
            .to_string_lossy()
            .into_owned();
        assert!(
            json.contains("[]") || json.is_empty() || json.contains("id"),
            "empty result should be empty array: {json}"
        );
        // SAFETY: json_ptr 配对释放
        unsafe { sz_orm_cpp_string_free(json_ptr) };
        // SAFETY: pool 有效
        unsafe { sz_orm_cpp_pool_free(pool) };
    }

    // ===== 新增测试：事务 + 模型级 API 转发（REQ-BND-006/013/014）=====

    fn model_test_pool() -> SzOrmPoolHandle {
        let pool = test_pool();
        assert!(!pool.is_null());
        let create =
            CString::new("CREATE TABLE cm_t (id INTEGER PRIMARY KEY, name TEXT, age INTEGER)")
                .unwrap();
        // SAFETY: pool/sql 有效
        let r = unsafe { sz_orm_cpp_execute(pool, create.as_ptr()) };
        // SAFETY: r 配对释放
        unsafe { sz_orm_cpp_result_free(r) };
        pool
    }

    unsafe fn free_cpp_result(ptr: *mut QueryResultC) -> QueryResultC {
        if ptr.is_null() {
            return QueryResultC {
                success: 0,
                error_code: sz_orm_cabi::SzOrmErrorCode::InvalidArgument.as_i32(),
                rows_affected: 0,
                last_insert_id: 0,
            };
        }
        // SAFETY: ptr 由 sz_orm_cpp_model_* 分配
        let r = unsafe { Box::from_raw(ptr) };
        *r
    }

    unsafe fn free_cpp_str(ptr: *mut c_char) -> String {
        if ptr.is_null() {
            return String::new();
        }
        // SAFETY: ptr 有效
        let s = unsafe { CStr::from_ptr(ptr) }
            .to_string_lossy()
            .into_owned();
        // SAFETY: ptr 配对释放
        unsafe { sz_orm_cpp_string_free(ptr) };
        s
    }

    #[test]
    fn test_cpp_model_insert_find_roundtrip() {
        let pool = model_test_pool();
        let table = CString::new("cm_t").unwrap();
        let fields = CString::new(r#"["name","age"]"#).unwrap();
        let values = CString::new(r#"["Alice",30]"#).unwrap();
        // SAFETY: pool/table/fields/values 有效
        let r = unsafe {
            sz_orm_cpp_model_insert(pool, table.as_ptr(), fields.as_ptr(), values.as_ptr())
        };
        // SAFETY: r 有效
        let r = unsafe { free_cpp_result(r) };
        assert_eq!(
            r.success, 1,
            "cpp model_insert should succeed, code={}",
            r.error_code
        );
        assert_eq!(r.rows_affected, 1);

        let where_clause = CString::new("name = ?").unwrap();
        let where_params = CString::new(r#"["Alice"]"#).unwrap();
        // SAFETY: pool/table/where 有效
        let ptr = unsafe {
            sz_orm_cpp_model_find(
                pool,
                table.as_ptr(),
                where_clause.as_ptr(),
                where_params.as_ptr(),
            )
        };
        assert!(!ptr.is_null());
        // SAFETY: ptr 有效
        let json = unsafe { free_cpp_str(ptr) };
        assert!(
            json.contains("Alice"),
            "cpp model_find should contain Alice: {json}"
        );
        // SAFETY: pool 有效
        unsafe { sz_orm_cpp_pool_free(pool) };
    }

    #[test]
    fn test_cpp_model_update_delete_find() {
        let pool = model_test_pool();
        let table = CString::new("cm_t").unwrap();
        let fields = CString::new(r#"["name","age"]"#).unwrap();
        let values = CString::new(r#"["Bob",25]"#).unwrap();
        // SAFETY: pool/table/fields/values 有效
        let r = unsafe {
            sz_orm_cpp_model_insert(pool, table.as_ptr(), fields.as_ptr(), values.as_ptr())
        };
        // SAFETY: r 有效
        unsafe { free_cpp_result(r) };

        let set_json = CString::new(r#"{"age":26}"#).unwrap();
        let where_clause = CString::new("name = ?").unwrap();
        let where_params = CString::new(r#"["Bob"]"#).unwrap();
        // SAFETY: pool/table/set/where 有效
        let r = unsafe {
            sz_orm_cpp_model_update(
                pool,
                table.as_ptr(),
                set_json.as_ptr(),
                where_clause.as_ptr(),
                where_params.as_ptr(),
            )
        };
        // SAFETY: r 有效
        let r = unsafe { free_cpp_result(r) };
        assert_eq!(
            r.success, 1,
            "cpp model_update should succeed, code={}",
            r.error_code
        );

        // SAFETY: pool/table/where 有效
        let ptr = unsafe {
            sz_orm_cpp_model_find(
                pool,
                table.as_ptr(),
                where_clause.as_ptr(),
                where_params.as_ptr(),
            )
        };
        // SAFETY: ptr 有效
        let json = unsafe { free_cpp_str(ptr) };
        assert!(
            json.contains("26"),
            "cpp find after update should contain age 26: {json}"
        );

        // SAFETY: pool/table/where 有效
        let r = unsafe {
            sz_orm_cpp_model_delete(
                pool,
                table.as_ptr(),
                where_clause.as_ptr(),
                where_params.as_ptr(),
            )
        };
        // SAFETY: r 有效
        let r = unsafe { free_cpp_result(r) };
        assert_eq!(
            r.success, 1,
            "cpp model_delete should succeed, code={}",
            r.error_code
        );

        // SAFETY: pool/table/where 有效
        let ptr = unsafe {
            sz_orm_cpp_model_find(
                pool,
                table.as_ptr(),
                where_clause.as_ptr(),
                where_params.as_ptr(),
            )
        };
        // SAFETY: ptr 有效
        let json = unsafe { free_cpp_str(ptr) };
        assert!(
            json == "[]" || json == "null" || json.is_empty(),
            "cpp find after delete should be empty: {json}"
        );
        // SAFETY: pool 有效
        unsafe { sz_orm_cpp_pool_free(pool) };
    }

    #[test]
    fn test_cpp_model_insert_illegal_table() {
        let pool = model_test_pool();
        let table = CString::new("cm_t; DROP--").unwrap();
        let fields = CString::new(r#"["name"]"#).unwrap();
        let values = CString::new(r#"["X"]"#).unwrap();
        // SAFETY: pool/table/fields/values 有效（table 含注入向量）
        let r = unsafe {
            sz_orm_cpp_model_insert(pool, table.as_ptr(), fields.as_ptr(), values.as_ptr())
        };
        // SAFETY: r 有效
        let r = unsafe { free_cpp_result(r) };
        assert_eq!(r.success, 0, "illegal table should fail");
        assert_eq!(
            r.error_code,
            sz_orm_cabi::SzOrmErrorCode::InvalidArgument.as_i32()
        );
        // SAFETY: pool 有效
        unsafe { sz_orm_cpp_pool_free(pool) };
    }

    #[test]
    fn test_cpp_transaction_model_rollback() {
        let pool = model_test_pool();
        // SAFETY: pool 有效
        let tx = unsafe { sz_orm_cpp_transaction_begin(pool) };
        assert!(!tx.is_null());

        let table = CString::new("cm_t").unwrap();
        let fields = CString::new(r#"["name","age"]"#).unwrap();
        let values = CString::new(r#"["TxUser",99]"#).unwrap();
        // SAFETY: tx/table/fields/values 有效
        let r = unsafe {
            sz_orm_cpp_model_insert_tx(tx, table.as_ptr(), fields.as_ptr(), values.as_ptr())
        };
        // SAFETY: r 有效
        let r = unsafe { free_cpp_result(r) };
        assert_eq!(
            r.success, 1,
            "cpp model_insert_tx should succeed, code={}",
            r.error_code
        );

        // SAFETY: tx 有效
        assert_eq!(unsafe { sz_orm_cpp_transaction_rollback(tx) }, 1);
        // SAFETY: tx 有效
        unsafe { sz_orm_cpp_transaction_free(tx) };

        let where_clause = CString::new("name = ?").unwrap();
        let where_params = CString::new(r#"["TxUser"]"#).unwrap();
        // SAFETY: pool/table/where 有效
        let ptr = unsafe {
            sz_orm_cpp_model_find(
                pool,
                table.as_ptr(),
                where_clause.as_ptr(),
                where_params.as_ptr(),
            )
        };
        // SAFETY: ptr 有效
        let json = unsafe { free_cpp_str(ptr) };
        assert!(
            json == "[]" || json == "null" || json.is_empty(),
            "cpp find after rollback should be empty: {json}"
        );
        // SAFETY: pool 有效
        unsafe { sz_orm_cpp_pool_free(pool) };
    }

    #[test]
    fn test_cpp_transaction_model_commit() {
        let pool = model_test_pool();
        // SAFETY: pool 有效
        let tx = unsafe { sz_orm_cpp_transaction_begin(pool) };
        assert!(!tx.is_null());

        let table = CString::new("cm_t").unwrap();
        let fields = CString::new(r#"["name","age"]"#).unwrap();
        let values = CString::new(r#"["CommitUser",50]"#).unwrap();
        // SAFETY: tx/table/fields/values 有效
        let r = unsafe {
            sz_orm_cpp_model_insert_tx(tx, table.as_ptr(), fields.as_ptr(), values.as_ptr())
        };
        // SAFETY: r 有效
        unsafe { free_cpp_result(r) };

        // SAFETY: tx 有效
        assert_eq!(unsafe { sz_orm_cpp_transaction_commit(tx) }, 1);
        // SAFETY: tx 有效
        unsafe { sz_orm_cpp_transaction_free(tx) };

        let where_clause = CString::new("name = ?").unwrap();
        let where_params = CString::new(r#"["CommitUser"]"#).unwrap();
        // SAFETY: pool/table/where 有效
        let ptr = unsafe {
            sz_orm_cpp_model_find(
                pool,
                table.as_ptr(),
                where_clause.as_ptr(),
                where_params.as_ptr(),
            )
        };
        // SAFETY: ptr 有效
        let json = unsafe { free_cpp_str(ptr) };
        assert!(
            json.contains("CommitUser"),
            "cpp find after commit should contain CommitUser: {json}"
        );
        // SAFETY: pool 有效
        unsafe { sz_orm_cpp_pool_free(pool) };
    }

    // ===== v6.9.0 新增测试：QueryBuilder + ActiveModel 转发 =====

    #[test]
    fn test_cpp_qb_new_and_free() {
        // SAFETY: db_type=0 (MySQL) 合法
        let qb = unsafe { sz_orm_cpp_qb_new(0) };
        assert!(!qb.is_null(), "qb_new should return non-null handle");
        // SAFETY: qb 有效
        unsafe { sz_orm_cpp_qb_free(qb) };
    }

    #[test]
    fn test_cpp_qb_full_chain() {
        // SAFETY: db_type=0 (MySQL) 合法
        let qb = unsafe { sz_orm_cpp_qb_new(0) };
        assert!(!qb.is_null());

        let table = CString::new("users").unwrap();
        // SAFETY: qb 有效
        assert_eq!(
            unsafe { sz_orm_cpp_qb_table(qb, table.as_ptr()) },
            sz_orm_cabi::SzOrmErrorCode::Ok.as_i32()
        );

        let field = CString::new("status").unwrap();
        let value = CString::new(r#""active""#).unwrap();
        // SAFETY: qb 有效
        assert_eq!(
            unsafe { sz_orm_cpp_qb_where_eq(qb, field.as_ptr(), value.as_ptr()) },
            sz_orm_cabi::SzOrmErrorCode::Ok.as_i32()
        );

        let order_field = CString::new("id").unwrap();
        // SAFETY: qb 有效
        assert_eq!(
            unsafe { sz_orm_cpp_qb_order_by(qb, order_field.as_ptr(), 1) },
            sz_orm_cabi::SzOrmErrorCode::Ok.as_i32()
        );

        // SAFETY: qb 有效
        assert_eq!(
            unsafe { sz_orm_cpp_qb_limit(qb, 10) },
            sz_orm_cabi::SzOrmErrorCode::Ok.as_i32()
        );

        // SAFETY: qb 有效
        let result_ptr = unsafe { sz_orm_cpp_qb_build(qb) };
        assert!(!result_ptr.is_null(), "qb_build should return JSON");
        // SAFETY: result_ptr 有效
        let json = unsafe { CStr::from_ptr(result_ptr) }
            .to_string_lossy()
            .into_owned();
        // SAFETY: result_ptr 配对释放
        unsafe { sz_orm_cpp_qb_result_free(result_ptr) };

        assert!(json.contains("users"), "SQL should contain table: {json}");
        assert!(
            json.contains("status"),
            "SQL should contain where field: {json}"
        );

        // SAFETY: qb 有效
        unsafe { sz_orm_cpp_qb_free(qb) };
    }

    #[test]
    fn test_cpp_qb_invalid_db_type() {
        // SAFETY: 无效 db_type 返回 null
        let qb = unsafe { sz_orm_cpp_qb_new(999) };
        assert!(qb.is_null(), "invalid db_type should return null");
    }

    #[test]
    fn test_cpp_qb_free_null_is_noop() {
        // SAFETY: null 指针 free 是安全空操作
        unsafe { sz_orm_cpp_qb_free(std::ptr::null_mut()) };
    }

    #[test]
    fn test_cpp_active_model_create_get_delete() {
        let pool = model_test_pool();

        let table = CString::new("cm_t").unwrap();
        let fields = CString::new(r#"["name","age"]"#).unwrap();
        let values = CString::new(r#"["AMUser",42]"#).unwrap();
        // SAFETY: pool/table/fields/values 有效
        let r = unsafe {
            sz_orm_cpp_active_model_create(pool, table.as_ptr(), fields.as_ptr(), values.as_ptr())
        };
        // SAFETY: r 有效
        let r = unsafe { free_cpp_result(r) };
        assert_eq!(r.success, 1, "active_model create should succeed");

        let where_clause = CString::new("name = ?").unwrap();
        let where_params = CString::new(r#"["AMUser"]"#).unwrap();
        // SAFETY: pool/table/where 有效
        let ptr = unsafe {
            sz_orm_cpp_active_model_get(
                pool,
                table.as_ptr(),
                where_clause.as_ptr(),
                where_params.as_ptr(),
            )
        };
        // SAFETY: ptr 有效
        let json = unsafe { free_cpp_str(ptr) };
        assert!(json.contains("AMUser"), "get should find AMUser: {json}");

        // SAFETY: pool/table/where 有效
        let r = unsafe {
            sz_orm_cpp_active_model_delete(
                pool,
                table.as_ptr(),
                where_clause.as_ptr(),
                where_params.as_ptr(),
            )
        };
        // SAFETY: r 有效
        let r = unsafe { free_cpp_result(r) };
        assert_eq!(r.success, 1, "active_model delete should succeed");

        // SAFETY: pool 有效
        unsafe { sz_orm_cpp_pool_free(pool) };
    }

    #[test]
    fn test_cpp_active_model_set_update() {
        let pool = model_test_pool();

        let table = CString::new("cm_t").unwrap();
        let fields = CString::new(r#"["name","age"]"#).unwrap();
        let values = CString::new(r#"["SetUser",20]"#).unwrap();
        // SAFETY: pool/table/fields/values 有效
        let r = unsafe {
            sz_orm_cpp_active_model_save(pool, table.as_ptr(), fields.as_ptr(), values.as_ptr())
        };
        // SAFETY: r 有效
        unsafe { free_cpp_result(r) };

        let set_json = CString::new(r#"{"age":21}"#).unwrap();
        let where_clause = CString::new("name = ?").unwrap();
        let where_params = CString::new(r#"["SetUser"]"#).unwrap();
        // SAFETY: pool/table/set/where 有效
        let r = unsafe {
            sz_orm_cpp_active_model_set(
                pool,
                table.as_ptr(),
                set_json.as_ptr(),
                where_clause.as_ptr(),
                where_params.as_ptr(),
            )
        };
        // SAFETY: r 有效
        let r = unsafe { free_cpp_result(r) };
        assert_eq!(r.success, 1, "active_model set should succeed");

        // SAFETY: pool/table/where 有效
        let ptr = unsafe {
            sz_orm_cpp_active_model_get(
                pool,
                table.as_ptr(),
                where_clause.as_ptr(),
                where_params.as_ptr(),
            )
        };
        // SAFETY: ptr 有效
        let json = unsafe { free_cpp_str(ptr) };
        assert!(
            json.contains("21"),
            "get after set should contain age 21: {json}"
        );

        // SAFETY: pool 有效
        unsafe { sz_orm_cpp_pool_free(pool) };
    }
}