package com.alibaba.druid.bvt.sql.oracle.visitor;
import java.util.List;
import org.junit.Assert;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
import com.alibaba.druid.sql.ast.SQLStatement;
import com.alibaba.druid.sql.dialect.oracle.parser.OracleStatementParser;
import com.alibaba.druid.sql.dialect.oracle.visitor.OracleExportParameterVisitor;
import com.alibaba.druid.sql.parser.SQLStatementParser;
import com.alibaba.druid.sql.visitor.ExportParameterVisitor;
import com.alibaba.druid.util.JdbcConstants;
import junit.framework.TestCase;
public class ExportParameterDotNumberTest extends TestCase {
/**
* Logger for this class
*/
private static final Logger LOG = LoggerFactory.getLogger(ExportParameterDotNumberTest.class);
String dbType = JdbcConstants.MYSQL;
public void test_exportParameter() throws Exception {
String[] sqls = { "INSERT INTO test_tab1 (name) VALUES ( 2.0 )",
"INSERT INTO test_tab1 (name) VALUES ( 2 )",
};
for(String sql : sqls){
final StringBuilder out = new StringBuilder();
final ExportParameterVisitor visitor = new OracleExportParameterVisitor(out);
SQLStatementParser parser = new OracleStatementParser(sql);
final SQLStatement parseStatement = parser.parseStatement();
parseStatement.accept(visitor);
final List<Object> plist = visitor.getParameters();
LOG.info("from_sql:{}",sql);
sql = out.toString();
LOG.info("to_sql:{} ==> plist:{}",sql,plist);
Assert.assertTrue(plist.size()>0);
}
}
}