pers.clare.hisql.store.SQLCrudStore Maven / Gradle / Ivy

Go to download
Show more of this group Show more artifacts with this name
Show all versions of hi-sql Show documentation
Have fun using SQL
The newest version!
package pers.clare.hisql.store;


import pers.clare.hisql.function.FieldSetter;
import pers.clare.hisql.query.SQLQueryBuilder;
import pers.clare.hisql.util.SQLStoreUtil;

import java.lang.reflect.Constructor;
import java.lang.reflect.Field;
import java.util.Map;

public class SQLCrudStore extends SQLStore {
    private final String tableName;

    private final FieldColumn[] fieldColumns;
    private final Field autoKey;
    private final Field[] keyFields;
    private String count;
    private SQLQueryBuilder countById;
    private String select;
    private SQLQueryBuilder selectById;
    private String delete;
    private SQLQueryBuilder deleteById;

    // Force the use of PreparedStatement
    private boolean ps;


    public SQLCrudStore(
            Constructor constructor
            , Map fieldSetMap
            , String tableName
            , FieldColumn[] fieldColumns
            , Field autoKey
            , Field[] keyFields
            , boolean ps
    ) {
        super(constructor, fieldSetMap);
        this.tableName = tableName;
        this.fieldColumns = fieldColumns;
        this.autoKey = autoKey;
        this.keyFields = keyFields;
        this.ps = ps;
    }

    public String getTableName() {
        return tableName;
    }

    public FieldColumn[] getFieldColumns() {
        return fieldColumns;
    }

    public Field getAutoKey() {
        return autoKey;
    }

    public Field[] getKeyFields() {
        return keyFields;
    }

    public String getCount() {
        if (count == null) {
            count = "select count(*) from " + tableName;
        }
        return count;
    }

    public SQLQueryBuilder getCountById() {
        if (countById == null) {
            countById = SQLStoreUtil.buildCountById(fieldColumns, tableName);
        }
        return countById;
    }

    public String getSelect() {
        if (select == null) {
            select = SQLStoreUtil.buildSelect(fieldColumns, tableName);
        }
        return select;
    }

    public SQLQueryBuilder getSelectById() {
        if (selectById == null) {
            selectById = SQLStoreUtil.getSelectById(fieldColumns, tableName);
        }
        return selectById;
    }

    public String getDelete() {
        if (delete == null) {
            delete = "delete from " + tableName;
        }
        return delete;
    }

    public SQLQueryBuilder getDeleteById() {
        if (deleteById == null) {
            deleteById = SQLStoreUtil.buildDeleteById(fieldColumns, tableName);
        }
        return deleteById;
    }

    public boolean isPs() {
        return ps;
    }
}