org.teasoft.beex.android.TransformResultSetForAndroid Maven / Gradle / Ivy

Go to download
/*
 * Copyright 2020-2022 the original author.All rights reserved.
 * Kingstar([email protected])
 * 
 * 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.teasoft.beex.android;

import java.util.ArrayList;
import java.util.LinkedHashMap;
import java.util.List;
import java.util.Map;

import org.teasoft.honey.osql.core.HoneyConfig;
import org.teasoft.honey.osql.core.NameTranslateHandle;

import android.database.Cursor;

/**
 * 为Android的结果转换.
 * @author Kingstar
 * @since 1.17
 */
public class TransformResultSetForAndroid {

	private TransformResultSetForAndroid() {}

//	private static final int NULL = Cursor.FIELD_TYPE_NULL;
	private static final int INTEGER = Cursor.FIELD_TYPE_INTEGER;
	private static final int FLOAT = Cursor.FIELD_TYPE_FLOAT;
	private static final int STRING = Cursor.FIELD_TYPE_STRING;
	private static final int BLOB = Cursor.FIELD_TYPE_BLOB;

	@SuppressWarnings("rawtypes")
	public static String toJson(Cursor cursor, Class entityClass) {
		StringBuffer json = new StringBuffer("");
		int columnCount = cursor.getColumnCount();
		boolean ignoreNull = HoneyConfig.getHoneyConfig().selectJson_ignoreNull;
		String temp = "";

		String columnName;
		String value;
		while (cursor.moveToNext()) {
			json.append(",{");
			for (int i = 0; i < columnCount; i++) { // 0..n-1
				columnName = cursor.getColumnName(i);
				value = cursor.getString(cursor.getColumnIndex(columnName));
				if (value == null && ignoreNull) {
					continue;
				}
				json.append("\"");
				json.append(_toFieldName(columnName, entityClass));
				json.append("\":");

				if (value != null) {

//					if ("String".equals(HoneyUtil.getFieldType(rmeta.getColumnTypeName(i)))) {
					if (cursor.getType(i) == STRING) {
						json.append("\"");
						temp = value;
						temp = temp.replace("\\", "\\\\"); // 1
						temp = temp.replace("\"", "\\\""); // 2

						json.append(temp);
						json.append("\"");
					}

//					else if ("Date".equals(HoneyUtil.getFieldType(rmeta.getColumnTypeName(i)))) {
//						if (dateWithMillisecond) {
//							json.append(rs.getDate(i).getTime());
//						} else {
//							try {
//								temp = rs.getString(i);
//								Long.valueOf(temp); //test value
//								json.append(temp);
//							} catch (NumberFormatException e) {
//								json.append("\"");
//								json.append(temp.replace("\"", "\\\""));
//								json.append("\"");
//							}
//						}
//					} else if ("Time".equals(HoneyUtil.getFieldType(rmeta.getColumnTypeName(i)))) {
//						if (timeWithMillisecond) {
//							json.append(rs.getTime(i).getTime());
//						} else {
//							try {
//								temp = rs.getString(i);
//								Long.valueOf(temp); //test value
//								json.append(temp);
//							} catch (NumberFormatException e) {
//								json.append("\"");
//								json.append(temp.replace("\"", "\\\""));
//								json.append("\"");
//							}
//						}
//					} else if ("Timestamp".equals(HoneyUtil.getFieldType(rmeta.getColumnTypeName(i)))) {
//						if (timestampWithMillisecond) {
//							json.append(rs.getTimestamp(i).getTime());
//						} else {
//							try {
//								temp = rs.getString(i);
//								Long.valueOf(temp); //test value
//								json.append(temp);
//							} catch (NumberFormatException e) {
//								json.append("\"");
//								json.append(temp.replace("\"", "\\\""));
//								json.append("\"");
//							}
//						}
//					}

//					else if (longToString && "Long".equals(HoneyUtil.getFieldType(rmeta.getColumnTypeName(i)))) {
//						json.append("\"");
//						json.append(value);
//						json.append("\"");
//					} else {
					json.append(value);
//					}

				} else {// null
					json.append(value);
				}

				if (i != columnCount) json.append(","); // bug, if last field is null and ignore.
			} // one record end
			if (json.toString().endsWith(",")) json.deleteCharAt(json.length() - 1); // fix bug
			json.append("}");
		} // array end
		if (json.length() > 0) {
			json.deleteCharAt(0);
		}
		json.insert(0, "[");
		json.append("]");

		return json.toString();
	}

	@SuppressWarnings("rawtypes")
	private static String _toFieldName(String columnName, Class entityClass) {
		return NameTranslateHandle.toFieldName(columnName, entityClass);
	}

	public static List toStringsList(Cursor cursor) {
		List list = new ArrayList<>();

		int columnCount = cursor.getColumnCount();

		boolean nullToEmptyString = HoneyConfig
				.getHoneyConfig().returnStringList_nullToEmptyString;
		String str[] = null;
		while (cursor.moveToNext()) {
			str = new String[columnCount];
			String columnName;
			String value;
			for (int i = 0; i < columnCount; i++) {
				columnName = cursor.getColumnName(i);
				value = cursor.getString(cursor.getColumnIndex(columnName));
				if (nullToEmptyString && value == null) {
					str[i] = "";
				} else {
					str[i] = value;
				}
			}
			list.add(str);
		}
		return list;
	}

	public static List> toMapList(Cursor cursor) {
		List> list = new ArrayList<>();
		int columnCount = cursor.getColumnCount();
		Map rowMap = null;

		while (cursor.moveToNext()) {
			rowMap = new LinkedHashMap<>();
			String columnName;
			for (int i = 0; i < columnCount; i++) {
				columnName = cursor.getColumnName(i);
				rowMap.put(_toFieldName(columnName, null), getValue(cursor, i)); // ignore Column annotation
			}
			list.add(rowMap);
		}
		return list;
	}

	public static List> toMapListWithColumnName(Cursor cursor) {
		List> list = new ArrayList<>();
		int columnCount = cursor.getColumnCount();
		Map rowMap = null;

		while (cursor.moveToNext()) {
			rowMap = new LinkedHashMap<>();
			String columnName;
			for (int i = 0; i < columnCount; i++) {
				columnName = cursor.getColumnName(i);
				rowMap.put(columnName, cursor.getString(i)); // ignore Column annotation
			}
			list.add(rowMap);
		}
		return list;
	}

	private static Object getValue(Cursor cursor, int columnIndex) {

		int type = cursor.getType(columnIndex);

		switch (type) {
			case INTEGER:
				return cursor.getInt(columnIndex);
			case FLOAT:
				return cursor.getFloat(columnIndex);
			case STRING:
				return cursor.getString(columnIndex);
			case BLOB:
				return cursor.getBlob(columnIndex);

			default:
				return cursor.getString(columnIndex);
		}
	}

}