All Downloads are FREE. Search and download functionalities are using the official Maven repository.
  • Log In
  • Register

    • qlking.preprocessor.1.0.3.source-code.Q Maven / Gradle / Ivy

    package com.memtrip.sqlking.gen;

import android.database.Cursor;
import android.content.ContentValues;
import com.memtrip.sqlking.common.SQLQuery;
import com.memtrip.sqlking.common.Resolver;

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

public class Q {

    public static class DefaultResolver implements Resolver {

        @Override
        public SQLQuery getSQLQuery(Class classDef) {
            <#assign isAssignableFrom><#list tables as table>
            } else if (classDef.isAssignableFrom(${table.getPackage()}.${table.getName()?cap_first}.class)) {
                return new ${table.getName()?cap_first}();
            
            }
${isAssignableFrom?remove_beginning("            } else ")} else {
                throw new IllegalStateException("Please ensure all SQL tables are annotated with @Table");
            }
        }
    }
<#list tables as table>
<#assign getColumnNames><#list table.getColumns() as column>"${column.getName()}",
<#assign unionInsertColumnNames><#list table.getColumns() as column>${column.getName()},
<#assign packagedTableName>${table.getPackage()}.${table.getName()?cap_first}
    public static class ${table.getName()?cap_first} implements SQLQuery {
        <#list table.getColumns() as column>
        public static final String ${formatConstant(column.getName())} = "${column.getName()}";
        

        @Override
        public String getTableName() {
            return "${table.getName()}";
        }

        @Override
        public String getTableInsertQuery() {
            return ${assembleCreateTable(table)}
        }

        @Override
        public String[] buildUnionInsertQuery(Object[] modelsToInsert) {
            List> chunks = new ArrayList<>();
            List models = new ArrayList<>();

            for (int i = 0; i < modelsToInsert.length; i++) {
                models.add(modelsToInsert[i]);

                if ((i+1) % 500 == 0) {
                    chunks.add(new ArrayList<>(models));
                    models.clear();
                }
            }

            if (models.size() > 0) {
                chunks.add(models);
            }

            String[] unionInsertQueries = new String[chunks.size()];
            for (int i = 0; i < chunks.size(); i++) {
                unionInsertQueries[i] = buildInsertQuery(chunks.get(i));
            }

            return unionInsertQueries;
        }

        private String buildInsertQuery(List models) {
            StringBuilder sb = new StringBuilder();

            sb.append("INSERT INTO ${table.getName()?cap_first} ");

            for (int i = 0; i < models.size(); i++) {
                ${packagedTableName} ${table.getName()?lower_case} = (${packagedTableName})models.get(i);

                if (i == 0){
                    sb.append("(${unionInsertColumnNames?remove_ending(",")}) ");
                    sb.append("SELECT ");
                    <#list table.getColumns() as column>
                    <#assign getter>${table.getName()?lower_case}.get${column.getName()?cap_first}()
                    sb.append("${getInsertValue(column.getType(),getter)} AS ${column.getName()}, ");
                    
                    sb.delete(sb.length()-2,sb.length());
                } else {
                    sb.append(" UNION ALL SELECT ");
                    <#list table.getColumns() as column>
                    <#assign getter>${table.getName()?lower_case}.get${column.getName()?cap_first}()
                    sb.append("${getInsertValue(column.getType(),getter)}, ");
                    
                    sb.delete(sb.length()-2,sb.length());
                }
            }

            return sb.toString();
        }

        private String assembleBlob(byte[] val) {
            if (val != null) {
                StringBuilder sb = new StringBuilder();

                for (byte b : val)
                    sb.append(String.format("%02X ", b));

                return sb.toString();
            } else {
                return "NULL";
            }
        }

        @Override
        public ${packagedTableName}[] retrieveSQLSelectResults(Cursor cursor) {
            ${packagedTableName}[] result = new ${packagedTableName}[cursor.getCount()];

            cursor.moveToFirst();
            for (int i = 0; !cursor.isAfterLast(); i++) {
                ${packagedTableName} ${table.getName()?lower_case} = new ${packagedTableName}();

                for (int x = 0; x < cursor.getColumnCount(); x++) {
                <#assign retrieveSQLSelectResults><#list table.getColumns() as column>
                    } else if (cursor.getColumnName(x).equals(${formatConstant(column.getName())})) {
                        ${table.getName()?lower_case}.set${column.getName()?cap_first}(${getCursorGetter(column.getType())});
                    
                    }
                    ${retrieveSQLSelectResults?remove_beginning("                    } else ")}
                }

                result[i] = ${table.getName()?lower_case};
                cursor.moveToNext();
            }

            cursor.close();

            return result;
        }

        @Override
        public String[] getColumnNames() {
            return new String[]{${getColumnNames?remove_ending(",")}};
        }

        @Override
        public ContentValues getContentValues(Object model) {
            ${packagedTableName} ${table.getName()?lower_case} = (${packagedTableName})model;

            ContentValues contentValues = new ContentValues();
            <#list table.getColumns() as column>
            contentValues.put(${formatConstant(column.getName())}, ${table.getName()?lower_case}.get${column.getName()?cap_first}());
            

            return contentValues;
        }
    }

}    
    
    
    

    




    
    
    © 2015 - 2025 Weber Informatics LLC | Privacy Policy