package com.qianwen.core.sequence.range.db.provider;
|
|
import com.baomidou.mybatisplus.annotation.DbType;
|
import org.springframework.stereotype.Component;
|
|
@Component
|
|
public class DmSqlProvider implements SqlProvider {
|
@Override // com.qianwen.core.sequence.range.db.provider.SqlProvider
|
public String getExistTableSql() {
|
return "select count(*) from user_tables where table_name =upper('#tableName')";
|
}
|
|
@Override // com.qianwen.core.sequence.range.db.provider.SqlProvider
|
public String getCreateTableSql() {
|
return "CREATE TABLE #tableName (ID BIGINT NOT NULL,VALUE BIGINT NOT NULL,NAME VARCHAR (128) NOT NULL,CREATE_TIME TIMESTAMP (0) NOT NULL,UPDATE_TIME TIMESTAMP (0) NOT NULL,NOT CLUSTER PRIMARY KEY (ID),CONSTRAINT UK_NAME UNIQUE (NAME)) STORAGE (ON MAIN,CLUSTERBTR);";
|
}
|
|
@Override // com.qianwen.core.sequence.range.db.provider.SqlProvider
|
public Boolean support(DbType dbType) {
|
return Boolean.valueOf(DbType.DM.equals(dbType));
|
}
|
}
|
