package com.qianwen.core.sequence.range.db.provider;

import com.baomidou.mybatisplus.annotation.DbType;


public interface SqlProvider {
    String getCreateTableSql();

    Boolean support(DbType dbType);

    default String getExistTableSql() {
        return null;
    }

    default String getInsertRangeSql() {
        return "INSERT INTO #tableName (id,name,value,create_time,update_time) VALUES(?,?,?,?,?)";
    }

    default String getUpdateRangeSql() {
        return "UPDATE #tableName SET value=?,update_time=? WHERE name=? AND value=?";
    }

    default String getSelectRangeSql() {
        return "SELECT value FROM #tableName WHERE name=?";
    }
}