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

import com.baomidou.mybatisplus.annotation.DbType;
import org.springframework.stereotype.Component;

@Component

public class OracleSqlProvider 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 NUMBER (20,0)  NOT NULL,value NUMBER (20,0)  NOT NULL,name VARCHAR2 (128 BYTE) ,create_time DATE  NOT NULL,update_time DATE  NOT NULL)";
    }

    @Override // com.qianwen.core.sequence.range.db.provider.SqlProvider
    public String getUpdateRangeSql() {
        return "UPDATE #tableName SET value=?,update_time=? WHERE name=? AND value=?";
    }

    @Override // com.qianwen.core.sequence.range.db.provider.SqlProvider
    public String getSelectRangeSql() {
        return "SELECT value FROM #tableName WHERE name=?";
    }

    @Override // com.qianwen.core.sequence.range.db.provider.SqlProvider
    public Boolean support(DbType dbType) {
        return Boolean.valueOf(DbType.ORACLE.equals(dbType));
    }
}