Get DDL SQL command for create table by class. - Android Database

Android examples for Database:Table Create

Description

Get DDL SQL command for create table by class.

Demo Code


import android.database.sqlite.SQLiteDatabase;
import java.lang.reflect.Field;
import java.util.ArrayList;
import java.util.Date;

public class Main{
    /**/*w w w .ja  v  a  2s.  c  o  m*/
     * Get DDL command for create table by class. Class must be marked by
     * {@link DatabaseTable} annotation. Class fields must be marked by
     * {@link DatabaseField} annotation.
     * 
     * @param mappedClass
     */
    public static String createTableQuery(Class<?> mappedClass) {
        if (mappedClass == null) {
            throw new IllegalArgumentException(
                    "mappedClass should not be null");
        }
        DatabaseTable classAnnotation = mappedClass
                .getAnnotation(DatabaseTable.class);
        if (classAnnotation == null) {
            throw new IllegalArgumentException(
                    "Class must be marked by DatabaseTable annotation. Class is "
                            + mappedClass);
        }

        String tableName = classAnnotation.name();
        if (tableName == null || tableName.length() <= 0) {
            tableName = mappedClass.getSimpleName();
        }

        ArrayList<Field> mappedFields = new ArrayList<Field>();
        ArrayList<DatabaseField> fieldsAnnotations = new ArrayList<DatabaseField>();
        Field[] fields = mappedClass.getDeclaredFields();
        for (Field field : fields) {
            DatabaseField fieldAnnotation = field
                    .getAnnotation(DatabaseField.class);
            if (fieldAnnotation != null) {
                mappedFields.add(field);
                fieldsAnnotations.add(fieldAnnotation);
            }
        }
        int columnsCount = mappedFields.size();
        if (columnsCount <= 0) {
            throw new IllegalArgumentException(
                    "Class fields mut be marked by DatabaseField anatation");
        }

        StringBuilder sql = new StringBuilder();
        sql.append("CREATE ");
        if (classAnnotation.isTemporary()) {
            sql.append("TEMPORARY ");
        }
        sql.append("TABLE ");
        if (classAnnotation.isNotExist()) {
            sql.append("IF NOT EXISTS ");
        }

        sql.append(tableName);
        sql.append(" ");

        sql.append("( ");

        for (int i = 0; i < columnsCount; i++) {
            Field field = mappedFields.get(i);
            DatabaseField fieldAnnotation = fieldsAnnotations.get(i);

            String columnName = fieldAnnotation.name();
            if (columnName == null || columnName.length() <= 0) {
                columnName = field.getName();
            }

            String columnType = getType(field.getType());

            sql.append(columnName);
            sql.append(" ");
            sql.append(columnType);
            sql.append(" ");

            if (fieldAnnotation.isPrimaryKey()) {
                sql.append("PRIMARY KEY ");
            } else {
                if (fieldAnnotation.isUnique()) {
                    sql.append("UNIQUE ");
                }
                if (fieldAnnotation.isNotNull()) {
                    sql.append("NOT NULL ");
                }
            }

            if (i != columnsCount - 1) {
                sql.append(", ");
            }
        }

        sql.append(") ");
        return sql.toString();
    }
    /**
     * Get name of column type by field class.
     *
     * @return - name of class.
     */
    private static String getType(Class<?> inClass) {
        if (inClass.isAssignableFrom(Integer.class)
                || inClass.isAssignableFrom(int.class)
                || inClass.isAssignableFrom(long.class)
                || inClass.isAssignableFrom(Long.class)
                || inClass.isAssignableFrom(Short.class)
                || inClass.isAssignableFrom(short.class)
                || inClass.isAssignableFrom(byte.class)
                || inClass.isAssignableFrom(Byte.class)
                || inClass.isAssignableFrom(Date.class)
                || inClass.isAssignableFrom(Boolean.class)
                || inClass.isAssignableFrom(boolean.class)) {
            return "INTEGER";
        }
        if (inClass.isAssignableFrom(Double.class)
                || inClass.isAssignableFrom(double.class)
                || inClass.isAssignableFrom(Float.class)
                || inClass.isAssignableFrom(float.class)) {
            return "REAL";
        }
        if (inClass.isAssignableFrom(String.class)
                || inClass.isAssignableFrom(CharSequence.class)) {
            return "TEXT";
        }
        if (inClass.isAssignableFrom(Byte[].class)
                || inClass.isAssignableFrom(byte[].class)) {
            return "BLOB";
        }
        return null;
    }
}

Related Tutorials