com.sharksharding.sql.ast.statement.SQLUpdateStatement Maven / Gradle / Ivy

Go to download
Show more of this group Show more artifacts with this name
Show all versions of shark Show documentation
shark mysql sharding
The newest version!
/*
 * Copyright 1999-2101 Alibaba Group Holding Ltd.
 *
 * Licensed under the Apache License, Version 2.0 (the "License");
 * you may not use this file except in compliance with the License.
 * You may obtain a copy of the License at
 *
 *      http://www.apache.org/licenses/LICENSE-2.0
 *
 * Unless required by applicable law or agreed to in writing, software
 * distributed under the License is distributed on an "AS IS" BASIS,
 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
 * See the License for the specific language governing permissions and
 * limitations under the License.
 */
package com.sharksharding.sql.ast.statement;

import java.util.ArrayList;
import java.util.Arrays;
import java.util.List;

import com.sharksharding.exception.SqlParserException;
import com.sharksharding.sql.ast.SQLExpr;
import com.sharksharding.sql.ast.SQLName;
import com.sharksharding.sql.ast.SQLStatementImpl;
import com.sharksharding.sql.visitor.SQLASTVisitor;

public class SQLUpdateStatement extends SQLStatementImpl {

	protected final List items = new ArrayList();
	protected SQLExpr where;

	protected SQLTableSource tableSource;

	public SQLUpdateStatement() {

	}

	public SQLUpdateStatement(String dbType) {
		super(dbType);
	}

	public SQLTableSource getTableSource() {
		return tableSource;
	}

	public void setTableSource(SQLExpr expr) {
		this.setTableSource(new SQLExprTableSource(expr));
	}

	public void setTableSource(SQLTableSource tableSource) {
		if (tableSource != null) {
			tableSource.setParent(this);
		}
		this.tableSource = tableSource;
	}

	public SQLName getTableName() {
		if (tableSource instanceof SQLExprTableSource) {
			SQLExprTableSource exprTableSource = (SQLExprTableSource) tableSource;
			return (SQLName) exprTableSource.getExpr();
		}
		return null;
	}

	public SQLExpr getWhere() {
		return where;
	}

	/**
	 * 通过正则表达式拆分where后的数据
	 * 
	 * @author gaoxianglong
	 * 
	 * @throws SqlParserException
	 * 
	 * @return List columns
	 */
	public List getWhere_() {
		List columns = null;
		if (null == where) {
			throw new SqlParserException("no condition");
		} else {
			columns = Arrays.asList(where.toString().split("\\s"));
		}
		return columns;
	}

	public void setWhere(SQLExpr where) {
		if (where != null) {
			where.setParent(this);
		}
		this.where = where;
	}

	public List getItems() {
		return items;
	}

	public void addItem(SQLUpdateSetItem item) {
		this.items.add(item);
		item.setParent(this);
	}

	@Override
	public void output(StringBuffer buf) {
		buf.append("UPDATE ");

		this.tableSource.output(buf);

		buf.append(" SET ");
		for (int i = 0, size = items.size(); i < size; ++i) {
			if (i != 0) {
				buf.append(", ");
			}
			items.get(i).output(buf);
		}

		if (this.where != null) {
			buf.append(" WHERE ");
			this.where.output(buf);
		}
	}

	@Override
	protected void accept0(SQLASTVisitor visitor) {
		if (visitor.visit(this)) {
			acceptChild(visitor, tableSource);
			acceptChild(visitor, items);
			acceptChild(visitor, where);
		}
		visitor.endVisit(this);
	}
}