Class UpdateTest

src/test/java/com/sql/parse/statement/UpdateTest.java:16–204

@date 2019年4月30日上午09:58:02 @desc Update测试类

 * @desc Update测试类
 */
public class UpdateTest {
    private static final Logger logger = LogManager.getLogger(UpdateTest.class);

    private String table;
    private String column1;
    private String column2;
    private String column3;
    private String value1;
    private String value2;
    private String simpleSql;

    @Before
    public void before() {
        // TODO Auto-generated method stub
        table = "table";
        column1 = "column1";
        column2 = "column2";
        column3 = "column3";
        value1 = "1";
        value2 = "2";
        simpleSql = "update " + table + " set pk = 1";
    }

    @Test
    public void testParse() {
        try {
            Update update = Update.parse(simpleSql);
            Assert.assertEquals(
                    SqlFormatter.format(update.getSql()),
                    SqlFormatter.format("UPDATE table SET pk = 1 WHERE 1 = 2")
            );
            Assert.assertEquals(
                    SqlFormatter.format(update.getSql(false)),
                    SqlFormatter.format("UPDATE table SET pk = 1")
            );
        } catch (Exception e) {
            Assert.fail(e.getMessage());
        }
    }

    /**
     * @desc 最简单的更新
     */
    @Test
    public void testSimpleUpdate() {
        try {
            Update update = Update.parse(simpleSql);
            update.addColumn(new UpdateItem(column1, value1));
            Assert.assertEquals(
                    SqlFormatter.format(update.getSql()),
                    SqlFormatter.format("UPDATE table SET pk = 1, column1 = 1 WHERE 1 = 2")
            );
            Assert.assertEquals(
                    SqlFormatter.format(update.getSql(false)),
                    SqlFormatter.format("UPDATE table SET pk = 1, column1 = 1")
            );
        } catch (Exception e) {
            Assert.fail(e.getMessage());