Package org.tmatesoft.sqljet.core.table

Examples of org.tmatesoft.sqljet.core.table.ISqlJetTransaction

114
115
116
117
118
119
120
121
122
123
124
            }
        });
    }

    public boolean isNull(final int field) throws SqlJetException {
        return (Boolean) db.runReadTransaction(new ISqlJetTransaction() {
            public Object run(SqlJetDb db) throws SqlJetException {
                return btreeTable.isNull(field);
            }
        });
    }
View Full Code Here
122
123
124
125
126
127
128
129
130
131
132
            }
        });
    }

    public String getString(final int field) throws SqlJetException {
        return (String) db.runReadTransaction(new ISqlJetTransaction() {
            public Object run(SqlJetDb db) throws SqlJetException {
                return btreeTable.getString(field);
            }
        });
    }
View Full Code Here
130
131
132
133
134
135
136
137
138
139
140
            }
        });
    }

    public long getInteger(final int field) throws SqlJetException {
        return (Long) db.runReadTransaction(new ISqlJetTransaction() {
            public Object run(SqlJetDb db) throws SqlJetException {
                return btreeTable.getInteger(field);
            }
        });
    }
View Full Code Here
138
139
140
141
142
143
144
145
146
147
148
            }
        });
    }

    public double getFloat(final int field) throws SqlJetException {
        return (Double) db.runReadTransaction(new ISqlJetTransaction() {
            public Object run(SqlJetDb db) throws SqlJetException {
                return btreeTable.getFloat(field);
            }
        });
    }
View Full Code Here
146
147
148
149
150
151
152
153
154
155
156
            }
        });
    }

    public byte[] getBlobAsArray(final int field) throws SqlJetException {
        return (byte[]) db.runReadTransaction(new ISqlJetTransaction() {
            public Object run(SqlJetDb db) throws SqlJetException {
                ISqlJetMemoryPointer buffer = btreeTable.getBlob(field);
                return buffer != null ? SqlJetUtility.readByteBuffer(buffer) : null;
            }
        });
View Full Code Here
155
156
157
158
159
160
161
162
163
164
165
            }
        });
    }

    public InputStream getBlobAsStream(final int field) throws SqlJetException {
        return (InputStream) db.runReadTransaction(new ISqlJetTransaction() {
            public Object run(SqlJetDb db) throws SqlJetException {
                ISqlJetMemoryPointer buffer = btreeTable.getBlob(field);
                return buffer != null ? new ByteArrayInputStream(SqlJetUtility.readByteBuffer(buffer)) : null;
            }
        });
View Full Code Here
164
165
166
167
168
169
170
171
172
173
174
            }
        });
    }

    public Object getValue(final int field) throws SqlJetException {
        return db.runReadTransaction(new ISqlJetTransaction() {
            public Object run(SqlJetDb db) throws SqlJetException {
                Object value = btreeTable.getValue(field);
                if (value instanceof ISqlJetMemoryPointer) {
                    return new ByteArrayInputStream(SqlJetUtility.readByteBuffer((ISqlJetMemoryPointer) value));
                }
View Full Code Here
176
177
178
179
180
181
182
183
184
185
186
            }
        });
    }

    public boolean getBoolean(final int field) throws SqlJetException {
        return (Boolean) db.runReadTransaction(new ISqlJetTransaction() {
            public Object run(SqlJetDb db) throws SqlJetException {
                return btreeTable.getInteger(field) != 0;
            }
        });
    }
View Full Code Here
86
87
88
89
90
91
92
93
94
95
96
    /**
     * @throws SqlJetException
     */
    protected void computeRows(final boolean current) throws SqlJetException {
        db.runReadTransaction(new ISqlJetTransaction() {
            public Object run(SqlJetDb db) throws SqlJetException {
                try {

                    internalMove = true;

View Full Code Here
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
        deflate(new File(DB_ARCHIVE), DB_FILE_NAME, dbFile1, true);

        final SqlJetDb db1 = SqlJetDb.open(dbFile1, false);
        final SqlJetDb db2 = SqlJetDb.open(dbFile2, true);

        db2.runWriteTransaction(new ISqlJetTransaction() {
            public Object run(SqlJetDb db) throws SqlJetException {
                db.createTable("create table rep_cache (hash text not null primary key, "
                        + "                        revision integer not null, "
                        + "                        offset integer not null, "
                        + "                        size integer not null, "
                        + "                        expanded_size integer not null); ");
                return null;
            }
        });

        db1.runReadTransaction(new ISqlJetTransaction() {
            public Object run(SqlJetDb db) throws SqlJetException {
                ISqlJetCursor c = null;
                final Collection<Object> values = new ArrayList<Object>();
                final Collection<Collection<Object>> block = new LinkedList<Collection<Object>>();
                try {
                    c = db.getTable("rep_cache").open();
                    long currentRev = 0;
                    while (!c.eof()) {
                        values.clear();
                        for (int i = 0; i < c.getFieldsCount(); i++) {
                            values.add(c.getValue(i));
                        }
                        long rev = c.getInteger(1);
                        if (rev != currentRev) {
                            db2.runWriteTransaction(new ISqlJetTransaction() {
                                public Object run(SqlJetDb db) throws SqlJetException {
                                    for (Collection<Object> row : block) {
                                        db2.getTable("rep_cache").insert(row.toArray());
                                    }
                                    return null;
                                }
                            });

                            currentRev = rev;
                            block.clear();
                        }
                        block.add(new ArrayList<Object>(values));
                        c.next();
                    }
                    if (!block.isEmpty()) {
                        db2.runWriteTransaction(new ISqlJetTransaction() {
                            public Object run(SqlJetDb db) throws SqlJetException {
                                for (Collection<Object> row : block) {
                                    db2.getTable("rep_cache").insert(row.toArray());
                                }
                                return null;
View Full Code Here
TOP

Related Classes of org.tmatesoft.sqljet.core.table.ISqlJetTransaction

  • org.tmatesoft.sqljet.browser.core.data.DataTableModel
  • org.tmatesoft.sqljet.core.AbstractNewDbTest
  • org.tmatesoft.sqljet.core.internal.table.SqlJetCursor
  • org.tmatesoft.sqljet.core.internal.table.SqlJetIndexOrderCursor
  • org.tmatesoft.sqljet.core.internal.table.SqlJetIndexScopeCursor
  • org.tmatesoft.sqljet.core.internal.table.SqlJetRowNumCursor
  • org.tmatesoft.sqljet.core.internal.table.SqlJetTable
  • org.tmatesoft.sqljet.core.internal.table.SqlJetTableDataCursor
  • org.tmatesoft.sqljet.core.schema.CaseInsensitiveNamesTest
  • org.tmatesoft.sqljet.core.schema.ConcurrentSchemaModificationTest$TransactionTask
    • 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.