public void insertContent(Parameter parameter, Event event) throws SQLException {
if (this.database == null || !this.database.isOpen()) {
try {
this.database = (SQLiteDatabase) dataManager.getDatabaseHelper().openDatabaseConnection();
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
// String sql = "INSERT INTO event_contents (reading_value,reading_time,event_parameter_id,
// generated_event_id) "
// + " VALUES (?,?,?,?);";
ContentValues values = new ContentValues();
values.put(
"reading_value",
String.valueOf(
Content.parseContent(parameter.getDataType(), parameter.getContent().getValue())));
values.put("reading_time", parameter.getContent().getTime().getTime());
values.put("event_parameter_id", parameter.getId());
values.put("generated_event_id", event.getDatabaseId());
// executar
parameter
.getContent()
.setId((int) (long) this.database.insertOrThrow("event_contents", null, values));
if (DeveloperSettings.SHOW_DAO_SQL) {
Log.d(
"SQL_DEBUG",
"INSERT INTO event_contents (id,reading_value,reading_time,event_parameter_id) "
+ " VALUES ("
+ parameter.getContent().getId()
+ ",'"
+ Content.parseContent(parameter.getDataType(), parameter.getContent().getValue())
+ "',"
+ ",'"
+ parameter.getContent().getTime().getTime()
+ "',"
+ ","
+ parameter.getId()
+ ");");
}
}
