Lines Matching refs:append
232 sb.append("ID=").append(entry.id);
237 sb.append(" ").append(columnName).append("=")
238 .append((value == null) ? "null" : value.toString());
249 sb.append("ID=").append(entry.id);
254 sb.append(" ").append(columnName).append("=")
255 .append((value == null) ? "null" : value.toString());
301 sql.append(tableName);
302 sql.append(" (_id INTEGER PRIMARY KEY AUTOINCREMENT");
306 sql.append(',');
307 sql.append(column.name);
308 sql.append(' ');
309 sql.append(SQLITE_TYPES[column.type]);
311 sql.append(" DEFAULT ");
312 sql.append(column.defaultValue);
316 unique.append(column.name);
318 unique.append(',').append(column.name);
324 sql.append(",UNIQUE(").append(unique).append(')');
326 sql.append(");");
334 sql.append("CREATE INDEX ");
335 sql.append(tableName);
336 sql.append("_index_");
337 sql.append(column.name);
338 sql.append(" ON ");
339 sql.append(tableName);
340 sql.append(" (");
341 sql.append(column.name);
342 sql.append(");");
351 sql.append("CREATE VIRTUAL TABLE ");
352 sql.append(ftsTableName);
353 sql.append(" USING FTS3 (_id INTEGER PRIMARY KEY");
358 sql.append(',');
359 sql.append(columnName);
360 sql.append(" TEXT");
363 sql.append(");");
370 insertSql.append(ftsTableName);
371 insertSql.append(" (_id");
374 insertSql.append(',');
375 insertSql.append(column.name);
378 insertSql.append(") VALUES (new._id");
381 insertSql.append(",new.");
382 insertSql.append(column.name);
385 insertSql.append(");");
389 sql.append("CREATE TRIGGER ");
390 sql.append(tableName);
391 sql.append("_insert_trigger AFTER INSERT ON ");
392 sql.append(tableName);
393 sql.append(" FOR EACH ROW BEGIN ");
394 sql.append(insertSqlString);
395 sql.append("END;");
400 sql.append("CREATE TRIGGER ");
401 sql.append(tableName);
402 sql.append("_update_trigger AFTER UPDATE ON ");
403 sql.append(tableName);
404 sql.append(" FOR EACH ROW BEGIN ");
405 sql.append(insertSqlString);
406 sql.append("END;");
411 sql.append("CREATE TRIGGER ");
412 sql.append(tableName);
413 sql.append("_delete_trigger AFTER DELETE ON ");
414 sql.append(tableName);
415 sql.append(" FOR EACH ROW BEGIN DELETE FROM ");
416 sql.append(ftsTableName);
417 sql.append(" WHERE _id = old._id; END;");
426 sql.append(tableName);
427 sql.append(';');
432 sql.append("DROP TABLE IF EXISTS ");
433 sql.append(tableName);
434 sql.append(FULL_TEXT_INDEX_SUFFIX);
435 sql.append(';');
443 sql.append(mTableName);
444 sql.append(";");
