// 一行初始化
QtMyBatisHelper::initialize(":/config/database.json");

// 简单查询
QVariantList users = QtMyBatisHelper::selectList("User.findAll");

// 参数化查询
QVariant user = QtMyBatisHelper::selectOne("User.findById", {{"id", 1}});

#include <QCoreApplication>
#include <QDebug>
#include <QtMyBatisORM/qtmybatishelper.h>

int main(int argc, char *argv[])
{
    QCoreApplication app(argc, argv);
    
    // 1. 初始化ORM (一行代码完成所有配置)
    if (!QtMyBatisHelper::initialize(":/config/database.json")) {
        qCritical() << "数据库初始化失败";
        return 1;
    }
    
    // 2. 开启调试模式 (可选)
    QtMyBatisHelper::enableDebugMode(true);
    
    // 3. 基础查询操作
    try {
        // 查询所有用户
        QVariantList users = QtMyBatisHelper::selectList("User.findAll");
        qDebug() << "用户总数:" << users.size();
        
        // 查询单个用户
        QVariantMap params;
        params["id"] = 1;
        QVariant user = QtMyBatisHelper::selectOne("User.findById", params);
        
        if (!user.isNull()) {
            QVariantMap userMap = user.toMap();
            qDebug() << "用户信息:" << userMap["name"].toString() 
                     << userMap["email"].toString();
        }
        
        // 插入新用户
        QVariantMap newUser;
        newUser["name"] = "张三";
        newUser["email"] = "[email protected]";
        newUser["phone"] = "13800138000";
        
        int rowsAffected = QtMyBatisHelper::insert("User.insert", newUser);
        qDebug() << "插入结果:" << (rowsAffected > 0 ? "成功" : "失败");
        
        // 搜索用户
        QVariantMap searchParams;
        searchParams["name"] = "张";
        QVariantList searchResults = QtMyBatisHelper::selectList("User.findByName", searchParams);
        qDebug() << "搜索到" << searchResults.size() << "个用户";
        
    } catch (const QtMyBatisException& e) {
        qCritical() << "数据库操作异常:" << e.message();
        return 1;
    }
    
    return 0;
}

#include <QtMyBatisORM/qtmybatishelper.h>

void transferMoney(int fromUserId, int toUserId, double amount) {
    // 开始事务
    if (!QtMyBatisHelper::beginTransaction()) {
        throw std::runtime_error("无法开始事务");
    }
    
    try {
        // 检查余额
        QVariant fromUser = QtMyBatisHelper::selectOne("User.findById", {{"id", fromUserId}});
        double balance = fromUser.toMap()["balance"].toDouble();
        
        if (balance < amount) {
            throw std::runtime_error("余额不足");
        }
        
        // 扣除转出方余额
        QtMyBatisHelper::update("User.updateBalance", {
            {"id", fromUserId}, 
            {"balance", balance - amount}
        });
        
        // 增加转入方余额
        QVariant toUser = QtMyBatisHelper::selectOne("User.findById", {{"id", toUserId}});
        double toBalance = toUser.toMap()["balance"].toDouble();
        
        QtMyBatisHelper::update("User.updateBalance", {
            {"id", toUserId}, 
            {"balance", toBalance + amount}
        });
        
        // 记录转账日志
        QtMyBatisHelper::insert("TransferLog.insert", {
            {"from_user_id", fromUserId},
            {"to_user_id", toUserId},
            {"amount", amount},
            {"status", "completed"}
        });
        
        // 提交事务
        QtMyBatisHelper::commit();
        qDebug() << "转账成功:" << amount << "元";
        
    } catch (const std::exception& e) {
        // 回滚事务
        QtMyBatisHelper::rollback();
        qCritical() << "转账失败，已回滚:" << e.what();
        throw;
    }
}

void batchInsertUsers(const QList<QVariantMap>& users) {
    // 使用事务进行批量操作
    QtMyBatisHelper::beginTransaction();
    
    try {
        for (const QVariantMap& user : users) {
            QtMyBatisHelper::insert("User.insert", user);
        }
        
        QtMyBatisHelper::commit();
        qDebug() << "批量插入成功:" << users.size() << "个用户";
        
    } catch (const QtMyBatisException& e) {
        QtMyBatisHelper::rollback();
        qCritical() << "批量插入失败:" << e.message();
    }
}

// 使用示例
QList<QVariantMap> users = {
    {{"name", "用户1"}, {"email", "[email protected]"}},
    {{"name", "用户2"}, {"email", "[email protected]"}},
    {{"name", "用户3"}, {"email", "[email protected]"}}
};
batchInsertUsers(users);

// 条件查询
QVariantMap searchCriteria;
searchCriteria["minAge"] = 18;
searchCriteria["maxAge"] = 65;
searchCriteria["city"] = "北京";

QVariantList results = QtMyBatisHelper::selectList("User.searchByCriteria", searchCriteria);

// 分页查询
QVariantMap pageParams;
pageParams["offset"] = 0;
pageParams["limit"] = 20;
QVariantList pageResults = QtMyBatisHelper::selectList("User.findWithPaging", pageParams);

// 统计查询
QVariant countResult = QtMyBatisHelper::selectOne("User.count");
int totalUsers = countResult.toMap()["total"].toInt();
qDebug() << "用户总数:" << totalUsers;

// 聚合查询
QVariantMap stats = QtMyBatisHelper::selectOne("Order.getStatistics").toMap();
qDebug() << "今日订单:" << stats["today_orders"].toInt();
qDebug() << "总销售额:" << stats["total_amount"].toDouble();

// 开启性能监控
QtMyBatisHelper::enablePerformanceMonitoring(true);

// 获取性能统计信息
PerformanceStats stats = QtMyBatisHelper::getPerformanceStats();
qDebug() << "查询总数:" << stats.totalQueries;
qDebug() << "平均响应时间:" << stats.averageResponseTime << "ms";
qDebug() << "缓存命中率:" << stats.cacheHitRate << "%";

// 获取连接池状态
ConnectionPoolStats poolStats = QtMyBatisHelper::getConnectionPoolStats();
qDebug() << "活跃连接:" << poolStats.activeConnections;
qDebug() << "空闲连接:" << poolStats.idleConnections;
qDebug() << "总连接数:" << poolStats.totalConnections;

// 清空指定缓存
QtMyBatisHelper::clearCache("User.findAll");

// 清空所有缓存
QtMyBatisHelper::clearAllCache();

// 获取缓存统计
CacheStats cacheStats = QtMyBatisHelper::getCacheStats();
qDebug() << "缓存大小:" << cacheStats.size;
qDebug() << "命中次数:" << cacheStats.hits;
qDebug() << "未命中次数:" << cacheStats.misses;