Lines Matching defs:sql
82 private void logExecSql(SQLiteDatabase db, String sql) {
83 // Log.i(TAG, sql);
84 db.execSQL(sql);
208 StringBuilder sql = new StringBuilder("CREATE TABLE ");
209 sql.append(tableName);
210 sql.append(" (_id INTEGER PRIMARY KEY");
216 sql.append(',');
217 sql.append(column.name);
218 sql.append(' ');
219 sql.append(SQLITE_TYPES[column.type]);
221 sql.append(' ');
222 sql.append(column.extraSql);
226 sql.append(");");
227 logExecSql(db, sql.toString());
228 sql.setLength(0);
235 sql.append("CREATE INDEX ");
236 sql.append(tableName);
237 sql.append("_index_");
238 sql.append(column.name);
239 sql.append(" ON ");
240 sql.append(tableName);
241 sql.append(" (");
242 sql.append(column.name);
243 sql.append(");");
244 logExecSql(db, sql.toString());
245 sql.setLength(0);
252 sql.append("CREATE VIRTUAL TABLE ");
253 sql.append(ftsTableName);
254 sql.append(" USING FTS3 (_id INTEGER PRIMARY KEY");
260 sql.append(',');
261 sql.append(columnName);
262 sql.append(" TEXT");
265 sql.append(");");
266 logExecSql(db, sql.toString());
267 sql.setLength(0);
293 sql.append("CREATE TRIGGER ");
294 sql.append(tableName);
295 sql.append("_insert_trigger AFTER INSERT ON ");
296 sql.append(tableName);
297 sql.append(" FOR EACH ROW BEGIN ");
298 sql.append(insertSqlString);
299 sql.append("END;");
300 logExecSql(db, sql.toString());
301 sql.setLength(0);
304 sql.append("CREATE TRIGGER ");
305 sql.append(tableName);
306 sql.append("_update_trigger AFTER UPDATE ON ");
307 sql.append(tableName);
308 sql.append(" FOR EACH ROW BEGIN ");
309 sql.append(insertSqlString);
310 sql.append("END;");
311 logExecSql(db, sql.toString());
312 sql.setLength(0);
315 sql.append("CREATE TRIGGER ");
316 sql.append(tableName);
317 sql.append("_delete_trigger AFTER DELETE ON ");
318 sql.append(tableName);
319 sql.append(" FOR EACH ROW BEGIN DELETE FROM ");
320 sql.append(ftsTableName);
321 sql.append(" WHERE _id = old._id; END;");
322 logExecSql(db, sql.toString());
323 sql.setLength(0);
329 StringBuilder sql = new StringBuilder("DROP TABLE IF EXISTS ");
330 sql.append(tableName);
331 sql.append(';');
332 logExecSql(db, sql.toString());
333 sql.setLength(0);
336 sql.append("DROP TABLE IF EXISTS ");
337 sql.append(tableName);
338 sql.append(FULL_TEXT_INDEX_SUFFIX);
339 sql.append(';');
340 logExecSql(db, sql.toString());
346 StringBuilder sql = new StringBuilder("DELETE FROM ");
347 sql.append(mTableName);
348 sql.append(";");
349 logExecSql(db, sql.toString());
