All Downloads are FREE. Search and download functionalities are using the official Maven repository.

org.yx.db.sql.MapedSql Maven / Gradle / Ivy

Go to download

A quick developing framewort for internet company

There is a newer version: 4.0.2
Show newest version
/**
 * Copyright (C) 2016 - 2030 youtongluan.
 *
 * 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 org.yx.db.sql;

import java.io.StringWriter;
import java.util.ArrayList;
import java.util.List;

import org.yx.common.ItemJoiner;
import org.yx.db.DBGson;
import org.yx.db.event.DBEvent;
import org.yx.log.LogKits;

import com.google.gson.stream.JsonWriter;

public class MapedSql {

	public MapedSql() {
		this.paramters = new ArrayList<>();
	}

	public MapedSql(String sql, List paramters) {
		this.sql = sql;
		this.paramters = paramters;
	}

	String sql;
	private List paramters;
	DBEvent event;

	public String getSql() {
		return sql;
	}

	public void setSql(String sql) {
		this.sql = sql;
	}

	public List getParamters() {
		return paramters;
	}

	public void addParam(Object p) {
		this.paramters.add(p);
	}

	public void addParams(List ps) {
		if (ps == null || ps.isEmpty()) {
			return;
		}
		this.paramters.addAll(ps);
	}

	public DBEvent getEvent() {
		return event;
	}

	public void setEvent(DBEvent event) {
		this.event = event;
	}

	@Override
	public String toString() {
		return sql + " -- " + paramters;
	}

	public static interface JsonWriterVisitor {
		void visit(JsonWriter writer) throws Exception;
	}

	public String toJson(JsonWriterVisitor visitor) throws Exception {
		StringWriter stringWriter = new StringWriter();
		JsonWriter writer = new JsonWriter(stringWriter);
		writer.setSerializeNulls(true);
		writer.beginObject();
		writer.name("sql").value(sql);
		writer.name("hash").value(sql.hashCode());
		String params = DBGson.toJson(paramters);
		params = LogKits.clipIfNecessary(params);
		writer.name("paramters").value(params);
		if (visitor != null) {
			visitor.visit(writer);
		}
		writer.endObject();
		writer.flush();
		writer.close();
		return stringWriter.toString();

	}

	public static MapedSql merge(List mapeds, ItemJoiner joiner) {
		List params = new ArrayList<>();
		for (MapedSql maped : mapeds) {
			joiner.item().append(maped.sql);
			params.addAll(maped.paramters);
		}

		return new MapedSql(joiner.toCharSequence(true).toString(), params);
	}
}
 















© 2015 - 2024 Weber Informatics LLC | Privacy Policy