Search in sources :

Example 1 with Function

use of com.robotoworks.mechanoid.db.sqliteModel.Function in project mechanoid by robotoworks.

the class ModelUtil method getInferredColumnType.

public static ColumnType getInferredColumnType(final ResultColumn col) {
    Expression expr = col.getExpression();
    boolean _matched = false;
    if (!_matched) {
        if (expr instanceof CastExpression) {
            _matched = true;
            SqliteDataType _type = ((CastExpression) expr).getType();
            return ModelUtil.toColumnType(_type);
        }
    }
    if (!_matched) {
        if (expr instanceof ColumnSourceRef) {
            _matched = true;
            ColumnSource _column = ((ColumnSourceRef) expr).getColumn();
            if ((_column instanceof ResultColumn)) {
                ColumnSource _column_1 = ((ColumnSourceRef) expr).getColumn();
                ColumnType _inferredColumnType = ModelUtil.getInferredColumnType(((ResultColumn) _column_1));
                return ((ColumnType) _inferredColumnType);
            } else {
                ColumnSource _column_2 = ((ColumnSourceRef) expr).getColumn();
                return ((ColumnDef) _column_2).getType();
            }
        }
    }
    if (!_matched) {
        if (expr instanceof ExprConcat) {
            _matched = true;
            return ColumnType.TEXT;
        }
    }
    if (!_matched) {
        if (expr instanceof Function) {
            _matched = true;
            boolean _or = false;
            boolean _or_1 = false;
            boolean _or_2 = false;
            boolean _or_3 = false;
            boolean _or_4 = false;
            String _name = ((Function) expr).getName();
            boolean _equalsIgnoreCase = _name.equalsIgnoreCase("count");
            if (_equalsIgnoreCase) {
                _or_4 = true;
            } else {
                String _name_1 = ((Function) expr).getName();
                boolean _equalsIgnoreCase_1 = _name_1.equalsIgnoreCase("length");
                _or_4 = _equalsIgnoreCase_1;
            }
            if (_or_4) {
                _or_3 = true;
            } else {
                String _name_2 = ((Function) expr).getName();
                boolean _equalsIgnoreCase_2 = _name_2.equalsIgnoreCase("random");
                _or_3 = _equalsIgnoreCase_2;
            }
            if (_or_3) {
                _or_2 = true;
            } else {
                String _name_3 = ((Function) expr).getName();
                boolean _equalsIgnoreCase_3 = _name_3.equalsIgnoreCase("last_insert_rowid");
                _or_2 = _equalsIgnoreCase_3;
            }
            if (_or_2) {
                _or_1 = true;
            } else {
                String _name_4 = ((Function) expr).getName();
                boolean _equalsIgnoreCase_4 = _name_4.equalsIgnoreCase("changes");
                _or_1 = _equalsIgnoreCase_4;
            }
            if (_or_1) {
                _or = true;
            } else {
                String _name_5 = ((Function) expr).getName();
                boolean _equalsIgnoreCase_5 = _name_5.equalsIgnoreCase("total_changes");
                _or = _equalsIgnoreCase_5;
            }
            if (_or) {
                return ColumnType.INTEGER;
            } else {
                boolean _or_5 = false;
                boolean _or_6 = false;
                boolean _or_7 = false;
                boolean _or_8 = false;
                boolean _or_9 = false;
                String _name_6 = ((Function) expr).getName();
                boolean _equalsIgnoreCase_6 = _name_6.equalsIgnoreCase("abs");
                if (_equalsIgnoreCase_6) {
                    _or_9 = true;
                } else {
                    String _name_7 = ((Function) expr).getName();
                    boolean _equalsIgnoreCase_7 = _name_7.equalsIgnoreCase("avg");
                    _or_9 = _equalsIgnoreCase_7;
                }
                if (_or_9) {
                    _or_8 = true;
                } else {
                    String _name_8 = ((Function) expr).getName();
                    boolean _equalsIgnoreCase_8 = _name_8.equalsIgnoreCase("round");
                    _or_8 = _equalsIgnoreCase_8;
                }
                if (_or_8) {
                    _or_7 = true;
                } else {
                    String _name_9 = ((Function) expr).getName();
                    boolean _equalsIgnoreCase_9 = _name_9.equalsIgnoreCase("sum");
                    _or_7 = _equalsIgnoreCase_9;
                }
                if (_or_7) {
                    _or_6 = true;
                } else {
                    String _name_10 = ((Function) expr).getName();
                    boolean _equalsIgnoreCase_10 = _name_10.equalsIgnoreCase("total");
                    _or_6 = _equalsIgnoreCase_10;
                }
                if (_or_6) {
                    _or_5 = true;
                } else {
                    String _name_11 = ((Function) expr).getName();
                    boolean _equalsIgnoreCase_11 = _name_11.equalsIgnoreCase("likelihood");
                    _or_5 = _equalsIgnoreCase_11;
                }
                if (_or_5) {
                    return ColumnType.REAL;
                } else {
                    boolean _or_10 = false;
                    String _name_12 = ((Function) expr).getName();
                    boolean _equalsIgnoreCase_12 = _name_12.equalsIgnoreCase("randomblob");
                    if (_equalsIgnoreCase_12) {
                        _or_10 = true;
                    } else {
                        String _name_13 = ((Function) expr).getName();
                        boolean _equalsIgnoreCase_13 = _name_13.equalsIgnoreCase("zeroblob");
                        _or_10 = _equalsIgnoreCase_13;
                    }
                    if (_or_10) {
                        return ColumnType.BLOB;
                    }
                }
            }
            return ColumnType.TEXT;
        }
    }
    return ColumnType.TEXT;
}
Also used : SqliteDataType(com.robotoworks.mechanoid.db.sqliteModel.SqliteDataType) ColumnSourceRef(com.robotoworks.mechanoid.db.sqliteModel.ColumnSourceRef) Function(com.robotoworks.mechanoid.db.sqliteModel.Function) ColumnType(com.robotoworks.mechanoid.db.sqliteModel.ColumnType) ExprConcat(com.robotoworks.mechanoid.db.sqliteModel.ExprConcat) SelectCoreExpression(com.robotoworks.mechanoid.db.sqliteModel.SelectCoreExpression) SelectExpression(com.robotoworks.mechanoid.db.sqliteModel.SelectExpression) Expression(com.robotoworks.mechanoid.db.sqliteModel.Expression) CastExpression(com.robotoworks.mechanoid.db.sqliteModel.CastExpression) ResultColumn(com.robotoworks.mechanoid.db.sqliteModel.ResultColumn) ColumnDef(com.robotoworks.mechanoid.db.sqliteModel.ColumnDef) CastExpression(com.robotoworks.mechanoid.db.sqliteModel.CastExpression) ColumnSource(com.robotoworks.mechanoid.db.sqliteModel.ColumnSource)

Aggregations

CastExpression (com.robotoworks.mechanoid.db.sqliteModel.CastExpression)1 ColumnDef (com.robotoworks.mechanoid.db.sqliteModel.ColumnDef)1 ColumnSource (com.robotoworks.mechanoid.db.sqliteModel.ColumnSource)1 ColumnSourceRef (com.robotoworks.mechanoid.db.sqliteModel.ColumnSourceRef)1 ColumnType (com.robotoworks.mechanoid.db.sqliteModel.ColumnType)1 ExprConcat (com.robotoworks.mechanoid.db.sqliteModel.ExprConcat)1 Expression (com.robotoworks.mechanoid.db.sqliteModel.Expression)1 Function (com.robotoworks.mechanoid.db.sqliteModel.Function)1 ResultColumn (com.robotoworks.mechanoid.db.sqliteModel.ResultColumn)1 SelectCoreExpression (com.robotoworks.mechanoid.db.sqliteModel.SelectCoreExpression)1 SelectExpression (com.robotoworks.mechanoid.db.sqliteModel.SelectExpression)1 SqliteDataType (com.robotoworks.mechanoid.db.sqliteModel.SqliteDataType)1