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=?";
|
}
|
}
|
