Package org.lealone.command

Examples of org.lealone.command.Prepared

79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
     */
    public HBasePrimaryIndexCursor(TableFilter filter, SearchRow first, SearchRow last) {
        session = (HBaseSession) filter.getSession();
        HRegionServer rs = session.getRegionServer();

        Prepared p = filter.getPrepared();
        if (!(p instanceof WithWhereClause))
            throw DbException.throwInternalError("not instanceof WithWhereClause: " + p);

        regionName = Bytes.toBytes(((WithWhereClause) p).getWhereClauseSupport().getRegionName());
        if (regionName == null)
            throw DbException.throwInternalError("regionName is null");

        fetchSize = p.getFetchSize();
        defaultColumnFamilyName = ((HBaseTable) filter.getTable()).getDefaultColumnFamilyNameAsBytes();
        columnCount = filter.getTable().getColumns().length;

        //select语句
        //对于下面两种类型的sql，columns会是null
View Full Code Here
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
        return count;
    }

    private void execute(String sql) {
        try {
            Prepared command = session.prepare(sql);
            if (command.isQuery()) {
                command.query(0);
            } else {
                command.update();
            }
            if (session.getAutoCommit()) {
                session.commit(false);
            }
        } catch (DbException e) {
View Full Code Here
56
57
58
59
60
61
62
63
64
    public synchronized static void createIndexTableIfNotExists(Session session, String indexName) {
        StringBuilder buff = new StringBuilder("CREATE HBASE TABLE IF NOT EXISTS ");
        buff.append(indexName).append(" (COLUMN FAMILY ").append(Bytes.toString(MetaDataAdmin.DEFAULT_COLUMN_FAMILY));
        buff.append("(C char))");

        Prepared p = session.prepare(buff.toString(), true);
        p.setExecuteDirec(true);
        p.update();
    }
View Full Code Here
62
63
64
65
66
67
68
69
70
        p.setExecuteDirec(true);
        p.update();
    }

    public synchronized static void dropIndexTableIfExists(Session session, String indexName) {
        Prepared p = session.prepare("DROP TABLE IF EXISTS " + indexName, true);
        p.setExecuteDirec(true);
        p.update();
    }
View Full Code Here
93
94
95
96
97
98
99
100
101
102
103
104
        buff.append(" FROM ").append(table.getSQL());
        if (sample > 0) {
            buff.append(" LIMIT 1 SAMPLE_SIZE ").append(sample);
        }
        String sql = buff.toString();
        Prepared command = session.prepare(sql);
        ResultInterface result = command.query(0);
        result.next();
        for (int j = 0; j < columns.length; j++) {
            int selectivity = result.currentRow()[j].getInt();
            columns[j].setSelectivity(selectivity);
        }
View Full Code Here
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
    @Override
    public void add(Session session, Row row) {
        if (indexType.isUnique()) {
            byte[] key = getStartKey(row);
            Prepared p = session.prepare(select, true);
            p.getParameters().get(0).setValue(ValueString.get(Bytes.toString(key)));
            ResultInterface r = p.query(1);
            try {
                if (r.next()) {
                    SearchRow r2 = getRow(new Buffer(Bytes.toBytes(r.currentRow()[0].getString())));
                    if (compareRows(row, r2) == 0) {
                        if (!containsNullAndAllowMultipleNull(r2)) {
                            throw getDuplicateKeyException();
                        }
                    }
                }
            } finally {
                r.close();
            }
        }

        Prepared p = session.prepare(insert, true);
        p.getParameters().get(0).setValue(ValueString.get(Bytes.toString(getKey(row))));
        p.update();
    }
View Full Code Here
136
137
138
139
140
141
142
143
144
        //Update这种类型的SQL不需要先删除再insert，只需直接insert即可
        if (((HBaseRow) row).isForUpdate())
            return;

        //删除操作转成insert null操作
        Prepared p = session.prepare(delete, true);
        p.getParameters().get(0).setValue(ValueString.get(Bytes.toString(getKey(row))));
        p.update();
    }
View Full Code Here
43
44
45
46
47
48
49
50
51
52
53
54
    public void setExpression(int index, Expression expr) {
        expressions.add(index, expr);
    }

    private void setParameters() {
        Prepared prepared = procedure.getPrepared();
        ArrayList<Parameter> params = prepared.getParameters();
        for (int i = 0; params != null && i < params.size() && i < expressions.size(); i++) {
            Expression expr = expressions.get(i);
            Parameter p = params.get(i);
            p.setValue(expr.getValue(session));
        }
View Full Code Here
53
54
55
56
57
58
59
60
            p.setValue(expr.getValue(session));
        }
    }

    public boolean isQuery() {
        Prepared prepared = procedure.getPrepared();
        return prepared.isQuery();
    }
View Full Code Here
59
60
61
62
63
64
65
66
        return prepared.isQuery();
    }

    public int update() {
        setParameters();
        Prepared prepared = procedure.getPrepared();
        return prepared.update();
    }
View Full Code Here
TOP

Related Classes of org.lealone.command.Prepared

  • org.lealone.command.ddl.AlterTableAlterColumn
  • org.lealone.command.ddl.Analyze
  • org.lealone.command.dml.ExecuteProcedure
  • org.lealone.command.dml.RunScriptCommand
  • org.lealone.dbobject.constraint.ConstraintReferential
  • org.lealone.dbobject.table.TableView
  • org.lealone.engine.Database
  • org.lealone.engine.MetaRecord
  • org.lealone.expression.Parameter
  • org.lealone.hbase.command.CommandParallel
    • Copyright © 2018 www.massapicom. All rights reserved.
    All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.