static GDateTime* daemon_data_sqlite_data_real_UserLastSeen (DaemonDataIDataAccess* base, const gchar* username, const gchar* channel, const gchar* server, GError** error) {
DaemonDataSqliteData * self;
GDateTime* result = NULL;
gchar* _tmp0_;
gchar* commandText;
sqlite3_stmt* statement = NULL;
sqlite3_stmt* _tmp1_ = NULL;
gchar* _tmp2_;
gchar* _tmp3_;
gchar* _tmp4_;
gint _tmp5_;
gint _tmp6_;
gint64 _tmp8_;
GDateTime* _tmp9_ = NULL;
self = (DaemonDataSqliteData*) base;
g_return_val_if_fail (username != NULL, NULL);
g_return_val_if_fail (channel != NULL, NULL);
g_return_val_if_fail (server != NULL, NULL);
_tmp0_ = g_strdup ("SELECT Timestamp,Type FROM Log WHERE Username = @1 AND Channel = @2 AN" \
"D Server = @3 ORDER BY Timestamp DESC LIMIT 1");
commandText = _tmp0_;
sqlite3_prepare_v2 (self->priv->_database, commandText, -1, &_tmp1_, NULL);
_sqlite3_finalize0 (statement);
statement = _tmp1_;
_tmp2_ = g_strdup (username);
sqlite3_bind_text (statement, 1, _tmp2_, -1, g_free);
_tmp3_ = g_strdup (channel);
sqlite3_bind_text (statement, 2, _tmp3_, -1, g_free);
_tmp4_ = g_strdup (server);
sqlite3_bind_text (statement, 3, _tmp4_, -1, g_free);
_tmp5_ = sqlite3_step (statement);
if (_tmp5_ != SQLITE_ROW) {
result = NULL;
_sqlite3_finalize0 (statement);
_g_free0 (commandText);
return result;
}
_tmp6_ = sqlite3_column_int (statement, 1);
if (_tmp6_ != ((gint) DAEMON_DATA_EVENT_TYPES_Left)) {
GDateTime* _tmp7_ = NULL;
_tmp7_ = g_date_time_new_now_local ();
result = _tmp7_;
_sqlite3_finalize0 (statement);
_g_free0 (commandText);
return result;
}
_tmp8_ = sqlite3_column_int64 (statement, 0);
_tmp9_ = daemon_helpers_date_time_converter_FromUnixTimestamp (_tmp8_);
result = _tmp9_;
_sqlite3_finalize0 (statement);
_g_free0 (commandText);
return result;
}
void irc_sq_lite_db_Insert (IRCMessage* message) {
char* commandText;
sqlite3_stmt* statement;
sqlite3_stmt* _tmp0_ = NULL;
sqlite3_stmt* _tmp1_;
g_return_if_fail (message != NULL);
if (irc_sq_lite_db_DataBase == NULL) {
fprintf (stdout, "Datenbank wird erstellt!\n");
irc_sq_lite_db_CreateDB ();
}
commandText = g_strdup ("INSERT INTO MyLogData (Username, Message, Channel, Server, Timestamp) " \
"VALUES (@1, @2, @3, @4, @5)");
statement = NULL;
sqlite3_prepare_v2 (irc_sq_lite_db_DataBase, commandText, -1, &_tmp0_, NULL);
statement = (_tmp1_ = _tmp0_, _sqlite3_finalize0 (statement), _tmp1_);
sqlite3_bind_text (statement, 1, g_strdup (irc_message_get_Username (message)), -1, g_free);
sqlite3_bind_text (statement, 2, g_strdup (irc_message_get_MessageContent (message)), -1, g_free);
sqlite3_bind_text (statement, 3, g_strdup (irc_message_get_Channel (message)), -1, g_free);
sqlite3_bind_text (statement, 4, g_strdup (irc_message_get_Server (message)), -1, g_free);
sqlite3_bind_int64 (statement, 5, irc_message_get_UnixTime (message));
sqlite3_step (statement);
_sqlite3_finalize0 (statement);
_g_free0 (commandText);
}
static GList* daemon_data_sqlite_data_real_GetLog (DaemonDataIDataAccess* base, const gchar* channel, const gchar* server, GError** error) {
DaemonDataSqliteData * self;
GList* result = NULL;
gchar* _tmp0_;
gchar* commandText;
sqlite3_stmt* statement = NULL;
sqlite3_stmt* _tmp1_ = NULL;
gchar* _tmp2_;
gchar* _tmp3_;
gint _result_;
GList* results;
GError * _inner_error_ = NULL;
self = (DaemonDataSqliteData*) base;
g_return_val_if_fail (channel != NULL, NULL);
g_return_val_if_fail (server != NULL, NULL);
_tmp0_ = g_strdup ("SELECT * FROM Log WHERE Channel = @1 AND Server = @2 ORDER BY Timestam" \
"p DESC LIMIT 50");
commandText = _tmp0_;
sqlite3_prepare_v2 (self->priv->_database, commandText, -1, &_tmp1_, NULL);
_sqlite3_finalize0 (statement);
statement = _tmp1_;
_tmp2_ = g_strdup (channel);
sqlite3_bind_text (statement, 1, _tmp2_, -1, g_free);
_tmp3_ = g_strdup (server);
sqlite3_bind_text (statement, 2, _tmp3_, -1, g_free);
_result_ = 0;
results = NULL;
{
gboolean _tmp4_;
_tmp4_ = TRUE;
while (TRUE) {
gint _tmp5_;
if (!_tmp4_) {
if (!(_result_ == SQLITE_ROW)) {
break;
}
}
_tmp4_ = FALSE;
_tmp5_ = sqlite3_step (statement);
_result_ = _tmp5_;
switch (_result_) {
case SQLITE_DONE:
{
{
break;
}
}
case SQLITE_ROW:
{
{
const gchar* _tmp6_ = NULL;
gchar* _tmp7_;
gchar* username;
const gchar* _tmp8_ = NULL;
gchar* _tmp9_;
gchar* data;
const gchar* _tmp10_ = NULL;
gchar* _tmp11_;
gchar* eventChannel;
const gchar* _tmp12_ = NULL;
gchar* _tmp13_;
gchar* eventServer;
gint64 _tmp14_;
GDateTime* _tmp15_ = NULL;
GDateTime* timestamp;
gint _tmp16_;
DaemonDataEventTypes type;
DaemonEventsLogEvent* current;
DaemonEventsLogEvent* _tmp21_;
_tmp6_ = sqlite3_column_text (statement, 0);
_tmp7_ = g_strdup (_tmp6_);
username = _tmp7_;
_tmp8_ = sqlite3_column_text (statement, 1);
_tmp9_ = g_strdup (_tmp8_);
data = _tmp9_;
_tmp10_ = sqlite3_column_text (statement, 2);
_tmp11_ = g_strdup (_tmp10_);
eventChannel = _tmp11_;
_tmp12_ = sqlite3_column_text (statement, 3);
_tmp13_ = g_strdup (_tmp12_);
eventServer = _tmp13_;
_tmp14_ = sqlite3_column_int64 (statement, 4);
_tmp15_ = daemon_helpers_date_time_converter_FromUnixTimestamp (_tmp14_);
timestamp = _tmp15_;
_tmp16_ = sqlite3_column_int (statement, 5);
type = (DaemonDataEventTypes) _tmp16_;
current = NULL;
switch (type) {
case DAEMON_DATA_EVENT_TYPES_Joined:
{
{
DaemonEventsStatusEvent* _tmp17_ = NULL;
_tmp17_ = daemon_events_status_event_new_WithTimestamp (username, DAEMON_EVENTS_STATUS_CHANGE_Join, eventChannel, eventServer, timestamp);
_g_object_unref0 (current);
current = (DaemonEventsLogEvent*) _tmp17_;
break;
}
}
case DAEMON_DATA_EVENT_TYPES_Left:
{
{
DaemonEventsStatusEvent* _tmp18_ = NULL;
_tmp18_ = daemon_events_status_event_new_WithTimestamp (username, DAEMON_EVENTS_STATUS_CHANGE_Leave, eventChannel, eventServer, timestamp);
_g_object_unref0 (current);
current = (DaemonEventsLogEvent*) _tmp18_;
break;
}
}
case DAEMON_DATA_EVENT_TYPES_ChangedName:
{
{
DaemonEventsChangeNameEvent* _tmp19_ = NULL;
_tmp19_ = daemon_events_change_name_event_new_WithTimestamp (username, data, eventChannel, eventServer, timestamp);
_g_object_unref0 (current);
current = (DaemonEventsLogEvent*) _tmp19_;
break;
}
}
case DAEMON_DATA_EVENT_TYPES_Message:
{
{
DaemonEventsMessageEvent* _tmp20_ = NULL;
_tmp20_ = daemon_events_message_event_new_WithTimestamp (username, data, eventChannel, eventServer, timestamp);
_g_object_unref0 (current);
current = (DaemonEventsLogEvent*) _tmp20_;
break;
}
}
default:
break;
}
_tmp21_ = _g_object_ref0 (current);
results = g_list_append (results, _tmp21_);
_g_object_unref0 (current);
_g_date_time_unref0 (timestamp);
_g_free0 (eventServer);
_g_free0 (eventChannel);
_g_free0 (data);
_g_free0 (username);
break;
}
}
default:
{
{
const gchar* _tmp22_ = NULL;
GError* _tmp23_ = NULL;
_tmp22_ = sqlite3_errmsg (self->priv->_database);
_tmp23_ = g_error_new_literal (DAEMON_DATA_DATA_ACCESS_ERROR, DAEMON_DATA_DATA_ACCESS_ERROR_ReadError, _tmp22_);
_inner_error_ = _tmp23_;
if (_inner_error_->domain == DAEMON_DATA_DATA_ACCESS_ERROR) {
g_propagate_error (error, _inner_error_);
__g_list_free__g_object_unref0_0 (results);
_sqlite3_finalize0 (statement);
_g_free0 (commandText);
return NULL;
} else {
__g_list_free__g_object_unref0_0 (results);
_sqlite3_finalize0 (statement);
_g_free0 (commandText);
g_critical ("file %s: line %d: uncaught error: %s (%s, %d)", __FILE__, __LINE__, _inner_error_->message, g_quark_to_string (_inner_error_->domain), _inner_error_->code);
g_clear_error (&_inner_error_);
return NULL;
}
}
}
}
}
}
result = results;
_sqlite3_finalize0 (statement);
_g_free0 (commandText);
return result;
}
void daemon_data_sqlite_data_LogMessageEvent (DaemonDataSqliteData* self, DaemonEventsMessageEvent* event, GError** error) {
gchar* _tmp0_;
gchar* commandText;
sqlite3_stmt* statement = NULL;
sqlite3_stmt* _tmp1_ = NULL;
const gchar* _tmp2_ = NULL;
gchar* _tmp3_;
const gchar* _tmp4_ = NULL;
gchar* _tmp5_;
const gchar* _tmp6_ = NULL;
gchar* _tmp7_;
const gchar* _tmp8_ = NULL;
gchar* _tmp9_;
gint64 _tmp10_;
gint _tmp11_;
GError * _inner_error_ = NULL;
g_return_if_fail (self != NULL);
g_return_if_fail (event != NULL);
_tmp0_ = g_strdup ("INSERT INTO Log (Username, Data, Channel, Server, Timestamp, Type) VAL" \
"UES (@1, @2, @3, @4, @5, @6)");
commandText = _tmp0_;
sqlite3_prepare_v2 (self->priv->_database, commandText, -1, &_tmp1_, NULL);
_sqlite3_finalize0 (statement);
statement = _tmp1_;
_tmp2_ = daemon_events_log_event_get_Username ((DaemonEventsLogEvent*) event);
_tmp3_ = g_strdup (_tmp2_);
sqlite3_bind_text (statement, 1, _tmp3_, -1, g_free);
_tmp4_ = daemon_events_message_event_get_Message (event);
_tmp5_ = g_strdup (_tmp4_);
sqlite3_bind_text (statement, 2, _tmp5_, -1, g_free);
_tmp6_ = daemon_events_log_event_get_Channel ((DaemonEventsLogEvent*) event);
_tmp7_ = g_strdup (_tmp6_);
sqlite3_bind_text (statement, 3, _tmp7_, -1, g_free);
_tmp8_ = daemon_events_log_event_get_Server ((DaemonEventsLogEvent*) event);
_tmp9_ = g_strdup (_tmp8_);
sqlite3_bind_text (statement, 4, _tmp9_, -1, g_free);
_tmp10_ = daemon_events_log_event_get_UnixTimestamp ((DaemonEventsLogEvent*) event);
sqlite3_bind_int64 (statement, 5, _tmp10_);
sqlite3_bind_int (statement, 6, (gint) DAEMON_DATA_EVENT_TYPES_Message);
_tmp11_ = sqlite3_step (statement);
if (_tmp11_ != SQLITE_DONE) {
const gchar* _tmp12_ = NULL;
GError* _tmp13_ = NULL;
_tmp12_ = sqlite3_errmsg (self->priv->_database);
_tmp13_ = g_error_new_literal (DAEMON_DATA_DATA_ACCESS_ERROR, DAEMON_DATA_DATA_ACCESS_ERROR_WriteError, _tmp12_);
_inner_error_ = _tmp13_;
if (_inner_error_->domain == DAEMON_DATA_DATA_ACCESS_ERROR) {
g_propagate_error (error, _inner_error_);
_sqlite3_finalize0 (statement);
_g_free0 (commandText);
return;
} else {
_sqlite3_finalize0 (statement);
_g_free0 (commandText);
g_critical ("file %s: line %d: uncaught error: %s (%s, %d)", __FILE__, __LINE__, _inner_error_->message, g_quark_to_string (_inner_error_->domain), _inner_error_->code);
g_clear_error (&_inner_error_);
return;
}
}
_sqlite3_finalize0 (statement);
_g_free0 (commandText);
}
void irc_sq_lite_db_ShowLog (const char* username) {
sqlite3* _tmp0_ = NULL;
sqlite3* _tmp1_;
char* commandText;
sqlite3_stmt* statement;
sqlite3_stmt* _tmp2_ = NULL;
sqlite3_stmt* _tmp3_;
gint _result_;
GList* results;
g_return_if_fail (username != NULL);
fprintf (stdout, "Datenbank wird ausgelesen!\n");
sqlite3_open (IRC_SQ_LITE_DB__path, &_tmp0_);
irc_sq_lite_db_DataBase = (_tmp1_ = _tmp0_, _sqlite3_close0 (irc_sq_lite_db_DataBase), _tmp1_);
commandText = g_strdup ("SELECT * FROM MyLogData WHERE Username = @1 ORDER BY Timestamp DESC LI" \
"MIT 10");
statement = NULL;
sqlite3_prepare_v2 (irc_sq_lite_db_DataBase, commandText, -1, &_tmp2_, NULL);
statement = (_tmp3_ = _tmp2_, _sqlite3_finalize0 (statement), _tmp3_);
sqlite3_bind_text (statement, 1, g_strdup (username), -1, g_free);
_result_ = sqlite3_step (statement);
results = NULL;
while (TRUE) {
char* Username;
char* MessageContent;
char* Channel;
char* Server;
GDateTime* FromUnixTime;
IRCMessage* msg;
if (!(_result_ == SQLITE_ROW)) {
break;
}
Username = g_strdup (sqlite3_column_text (statement, 0));
MessageContent = g_strdup (sqlite3_column_text (statement, 1));
Channel = g_strdup (sqlite3_column_text (statement, 2));
Server = g_strdup (sqlite3_column_text (statement, 3));
FromUnixTime = g_date_time_new_from_unix_local (g_ascii_strtoll (sqlite3_column_text (statement, 4), NULL, 0));
msg = irc_message_new (Username, MessageContent, Channel, Server, FromUnixTime);
results = g_list_append (results, _irc_message_ref0 (msg));
_result_ = sqlite3_step (statement);
_irc_message_unref0 (msg);
_g_date_time_unref0 (FromUnixTime);
_g_free0 (Server);
_g_free0 (Channel);
_g_free0 (MessageContent);
_g_free0 (Username);
}
{
GList* r_collection;
GList* r_it;
r_collection = results;
for (r_it = r_collection; r_it != NULL; r_it = r_it->next) {
IRCMessage* r;
r = _irc_message_ref0 ((IRCMessage*) r_it->data);
{
fprintf (stdout, "%s\n", irc_message_get_MessageContent (r));
_irc_message_unref0 (r);
}
}
}
__g_list_free_irc_message_unref0 (results);
_sqlite3_finalize0 (statement);
_g_free0 (commandText);
}
GeeArrayList* graph_media_modelos_sentimientos_lista_sentimientos (GraphMediaModelosSentimientos* self) {
GeeArrayList* result = NULL;
sqlite3_stmt* query = NULL;
gchar* sql = NULL;
const gchar* _tmp0_ = NULL;
gchar* _tmp1_ = NULL;
gchar* _tmp2_ = NULL;
gchar* _tmp3_ = NULL;
gchar* _tmp4_ = NULL;
gint res = 0;
sqlite3* _tmp5_ = NULL;
const gchar* _tmp6_ = NULL;
sqlite3_stmt* _tmp7_ = NULL;
gint _tmp8_ = 0;
gint _tmp9_ = 0;
GeeArrayList* sentimientos = NULL;
GeeArrayList* _tmp10_ = NULL;
g_return_val_if_fail (self != NULL, NULL);
_tmp0_ = ((GraphMediaModelosTablas*) self)->nombre_tabla;
_tmp1_ = g_strdup_printf ("FROM %s WHERE 1", _tmp0_);
_tmp2_ = _tmp1_;
_tmp3_ = g_strconcat ("SELECT id, nombre, descripcion ", _tmp2_, NULL);
_tmp4_ = _tmp3_;
_g_free0 (_tmp2_);
sql = _tmp4_;
_tmp5_ = graph_media_modelos_tablas_bd;
_tmp6_ = sql;
_tmp8_ = sqlite3_prepare_v2 (_tmp5_, _tmp6_, -1, &_tmp7_, NULL);
_sqlite3_finalize0 (query);
query = _tmp7_;
res = _tmp8_;
_tmp9_ = res;
_vala_assert (_tmp9_ == SQLITE_OK, "res == Sqlite.OK");
_tmp10_ = gee_array_list_new (GRAPH_MEDIA_MODELOS_TYPE_SENTIMIENTO, (GBoxedCopyFunc) graph_media_modelos_sentimiento_ref, graph_media_modelos_sentimiento_unref, NULL, NULL, NULL);
sentimientos = _tmp10_;
while (TRUE) {
sqlite3_stmt* _tmp11_ = NULL;
gint _tmp12_ = 0;
gint _tmp13_ = 0;
GraphMediaModelosSentimiento* celda = NULL;
GraphMediaModelosSentimiento* _tmp14_ = NULL;
GraphMediaModelosSentimiento* _tmp15_ = NULL;
sqlite3_stmt* _tmp16_ = NULL;
gint64 _tmp17_ = 0LL;
GraphMediaModelosSentimiento* _tmp18_ = NULL;
sqlite3_stmt* _tmp19_ = NULL;
const gchar* _tmp20_ = NULL;
gchar* _tmp21_ = NULL;
GraphMediaModelosSentimiento* _tmp22_ = NULL;
sqlite3_stmt* _tmp23_ = NULL;
const gchar* _tmp24_ = NULL;
gchar* _tmp25_ = NULL;
GeeArrayList* _tmp26_ = NULL;
GraphMediaModelosSentimiento* _tmp27_ = NULL;
_tmp11_ = query;
_tmp12_ = sqlite3_step (_tmp11_);
res = _tmp12_;
_tmp13_ = res;
if (!(_tmp13_ == SQLITE_ROW)) {
break;
}
_tmp14_ = graph_media_modelos_sentimiento_new ();
celda = _tmp14_;
_tmp15_ = celda;
_tmp16_ = query;
_tmp17_ = sqlite3_column_int64 (_tmp16_, 0);
_tmp15_->id = _tmp17_;
_tmp18_ = celda;
_tmp19_ = query;
_tmp20_ = sqlite3_column_text (_tmp19_, 1);
_tmp21_ = g_strdup (_tmp20_);
_g_free0 (_tmp18_->nombre);
_tmp18_->nombre = _tmp21_;
_tmp22_ = celda;
_tmp23_ = query;
_tmp24_ = sqlite3_column_text (_tmp23_, 2);
_tmp25_ = g_strdup (_tmp24_);
_g_free0 (_tmp22_->descripcion);
_tmp22_->descripcion = _tmp25_;
_tmp26_ = sentimientos;
_tmp27_ = celda;
gee_abstract_collection_add ((GeeAbstractCollection*) _tmp26_, _tmp27_);
_graph_media_modelos_sentimiento_unref0 (celda);
}
result = sentimientos;
_g_free0 (sql);
_sqlite3_finalize0 (query);
return result;
}
GraphMediaModelosSentimiento* graph_media_modelos_sentimientos_get_sentimiento_por_id (GraphMediaModelosSentimientos* self, gint64 id) {
GraphMediaModelosSentimiento* result = NULL;
sqlite3_stmt* query = NULL;
gint64 _tmp0_ = 0LL;
gboolean _tmp1_ = FALSE;
gchar* sql = NULL;
const gchar* _tmp2_ = NULL;
gchar* _tmp3_ = NULL;
gint res = 0;
sqlite3* _tmp4_ = NULL;
const gchar* _tmp5_ = NULL;
sqlite3_stmt* _tmp6_ = NULL;
gint _tmp7_ = 0;
gint _tmp8_ = 0;
sqlite3_stmt* _tmp9_ = NULL;
gint64 _tmp10_ = 0LL;
gint _tmp11_ = 0;
gint _tmp12_ = 0;
sqlite3_stmt* _tmp13_ = NULL;
gint _tmp14_ = 0;
gint _tmp15_ = 0;
GraphMediaModelosSentimiento* celda = NULL;
GraphMediaModelosSentimiento* _tmp16_ = NULL;
GraphMediaModelosSentimiento* _tmp17_ = NULL;
sqlite3_stmt* _tmp18_ = NULL;
gint64 _tmp19_ = 0LL;
GraphMediaModelosSentimiento* _tmp20_ = NULL;
sqlite3_stmt* _tmp21_ = NULL;
const gchar* _tmp22_ = NULL;
gchar* _tmp23_ = NULL;
GraphMediaModelosSentimiento* _tmp24_ = NULL;
sqlite3_stmt* _tmp25_ = NULL;
const gchar* _tmp26_ = NULL;
gchar* _tmp27_ = NULL;
g_return_val_if_fail (self != NULL, NULL);
_tmp0_ = id;
_tmp1_ = graph_media_modelos_tablas_existe_id ((GraphMediaModelosTablas*) self, _tmp0_);
if (!_tmp1_) {
result = NULL;
_sqlite3_finalize0 (query);
return result;
}
_tmp2_ = ((GraphMediaModelosTablas*) self)->nombre_tabla;
_tmp3_ = g_strdup_printf ("SELECT %s FROM %s WHERE id=?", "*", _tmp2_);
sql = _tmp3_;
_tmp4_ = graph_media_modelos_tablas_bd;
_tmp5_ = sql;
_tmp7_ = sqlite3_prepare_v2 (_tmp4_, _tmp5_, -1, &_tmp6_, NULL);
_sqlite3_finalize0 (query);
query = _tmp6_;
res = _tmp7_;
_tmp8_ = res;
_vala_assert (_tmp8_ == SQLITE_OK, "res == Sqlite.OK");
_tmp9_ = query;
_tmp10_ = id;
_tmp11_ = sqlite3_bind_int64 (_tmp9_, 1, _tmp10_);
res = _tmp11_;
_tmp12_ = res;
_vala_assert (_tmp12_ == SQLITE_OK, "res == Sqlite.OK");
_tmp13_ = query;
_tmp14_ = sqlite3_step (_tmp13_);
res = _tmp14_;
_tmp15_ = res;
_vala_assert (_tmp15_ == SQLITE_ROW, "res == Sqlite.ROW");
_tmp16_ = graph_media_modelos_sentimiento_new ();
celda = _tmp16_;
_tmp17_ = celda;
_tmp18_ = query;
_tmp19_ = sqlite3_column_int64 (_tmp18_, 0);
_tmp17_->id = _tmp19_;
_tmp20_ = celda;
_tmp21_ = query;
_tmp22_ = sqlite3_column_text (_tmp21_, 1);
_tmp23_ = g_strdup (_tmp22_);
_g_free0 (_tmp20_->nombre);
_tmp20_->nombre = _tmp23_;
_tmp24_ = celda;
_tmp25_ = query;
_tmp26_ = sqlite3_column_text (_tmp25_, 2);
_tmp27_ = g_strdup (_tmp26_);
_g_free0 (_tmp24_->descripcion);
_tmp24_->descripcion = _tmp27_;
result = celda;
_g_free0 (sql);
_sqlite3_finalize0 (query);
return result;
}
static gboolean graph_media_modelos_sentimientos_existe_sentimiento (GraphMediaModelosSentimientos* self, GraphMediaModelosSentimiento* s) {
gboolean result = FALSE;
sqlite3_stmt* query = NULL;
GraphMediaModelosSentimiento* _tmp0_ = NULL;
gint64 _tmp1_ = 0LL;
gchar* sql = NULL;
const gchar* _tmp5_ = NULL;
gchar* _tmp6_ = NULL;
gchar* _tmp7_ = NULL;
gchar* _tmp8_ = NULL;
gchar* _tmp9_ = NULL;
gint res = 0;
sqlite3* _tmp10_ = NULL;
const gchar* _tmp11_ = NULL;
sqlite3_stmt* _tmp12_ = NULL;
gint _tmp13_ = 0;
gint _tmp14_ = 0;
sqlite3_stmt* _tmp15_ = NULL;
GraphMediaModelosSentimiento* _tmp16_ = NULL;
const gchar* _tmp17_ = NULL;
gchar* _tmp18_ = NULL;
GDestroyNotify _tmp19_ = NULL;
gint _tmp20_ = 0;
gint _tmp21_ = 0;
sqlite3_stmt* _tmp22_ = NULL;
gint _tmp23_ = 0;
gint _tmp24_ = 0;
g_return_val_if_fail (self != NULL, FALSE);
g_return_val_if_fail (s != NULL, FALSE);
_tmp0_ = s;
_tmp1_ = _tmp0_->id;
if (_tmp1_ != ((gint64) (-1))) {
GraphMediaModelosSentimiento* _tmp2_ = NULL;
gint64 _tmp3_ = 0LL;
gboolean _tmp4_ = FALSE;
_tmp2_ = s;
_tmp3_ = _tmp2_->id;
_tmp4_ = graph_media_modelos_tablas_existe_id ((GraphMediaModelosTablas*) self, _tmp3_);
result = _tmp4_;
_sqlite3_finalize0 (query);
return result;
}
_tmp5_ = ((GraphMediaModelosTablas*) self)->nombre_tabla;
_tmp6_ = g_strdup_printf ("FROM %s WHERE nombre=?", _tmp5_);
_tmp7_ = _tmp6_;
_tmp8_ = g_strconcat ("SELECT id, nombre, descripcion ", _tmp7_, NULL);
_tmp9_ = _tmp8_;
_g_free0 (_tmp7_);
sql = _tmp9_;
_tmp10_ = graph_media_modelos_tablas_bd;
_tmp11_ = sql;
_tmp13_ = sqlite3_prepare_v2 (_tmp10_, _tmp11_, -1, &_tmp12_, NULL);
_sqlite3_finalize0 (query);
query = _tmp12_;
res = _tmp13_;
_tmp14_ = res;
_vala_assert (_tmp14_ == SQLITE_OK, "res == Sqlite.OK");
_tmp15_ = query;
_tmp16_ = s;
_tmp17_ = _tmp16_->nombre;
_tmp18_ = g_strdup (_tmp17_);
_tmp19_ = g_free;
_tmp20_ = sqlite3_bind_text (_tmp15_, 1, _tmp18_, -1, _tmp19_);
res = _tmp20_;
_tmp21_ = res;
_vala_assert (_tmp21_ == SQLITE_OK, "res == Sqlite.OK");
_tmp22_ = query;
_tmp23_ = sqlite3_step (_tmp22_);
res = _tmp23_;
_tmp24_ = res;
result = _tmp24_ == SQLITE_ROW;
_g_free0 (sql);
_sqlite3_finalize0 (query);
return result;
}
gboolean graph_media_modelos_sentimientos_editar (GraphMediaModelosSentimientos* self, GraphMediaModelosSentimiento* sentimiento) {
gboolean result = FALSE;
GraphMediaModelosSentimiento* _tmp0_ = NULL;
gboolean _tmp1_ = FALSE;
gchar* columnas = NULL;
gchar* _tmp2_ = NULL;
sqlite3_stmt* query = NULL;
gchar* sql = NULL;
const gchar* _tmp3_ = NULL;
const gchar* _tmp4_ = NULL;
gchar* _tmp5_ = NULL;
gint res = 0;
sqlite3* _tmp6_ = NULL;
const gchar* _tmp7_ = NULL;
sqlite3_stmt* _tmp8_ = NULL;
gint _tmp9_ = 0;
gint _tmp10_ = 0;
sqlite3_stmt* _tmp11_ = NULL;
GraphMediaModelosSentimiento* _tmp12_ = NULL;
const gchar* _tmp13_ = NULL;
gchar* _tmp14_ = NULL;
GDestroyNotify _tmp15_ = NULL;
gint _tmp16_ = 0;
gint _tmp17_ = 0;
sqlite3_stmt* _tmp18_ = NULL;
GraphMediaModelosSentimiento* _tmp19_ = NULL;
const gchar* _tmp20_ = NULL;
gchar* _tmp21_ = NULL;
GDestroyNotify _tmp22_ = NULL;
gint _tmp23_ = 0;
gint _tmp24_ = 0;
sqlite3_stmt* _tmp25_ = NULL;
GraphMediaModelosSentimiento* _tmp26_ = NULL;
gint64 _tmp27_ = 0LL;
gint _tmp28_ = 0;
gint _tmp29_ = 0;
sqlite3_stmt* _tmp30_ = NULL;
gint _tmp31_ = 0;
gint _tmp32_ = 0;
g_return_val_if_fail (self != NULL, FALSE);
g_return_val_if_fail (sentimiento != NULL, FALSE);
_tmp0_ = sentimiento;
_tmp1_ = graph_media_modelos_sentimiento_es_valido (_tmp0_);
if (!_tmp1_) {
result = FALSE;
return result;
}
_tmp2_ = g_strdup ("nombre=?, descripcion=?");
columnas = _tmp2_;
_tmp3_ = ((GraphMediaModelosTablas*) self)->nombre_tabla;
_tmp4_ = columnas;
_tmp5_ = g_strdup_printf ("UPDATE %s SET %s WHERE id=?", _tmp3_, _tmp4_);
sql = _tmp5_;
_tmp6_ = graph_media_modelos_tablas_bd;
_tmp7_ = sql;
_tmp9_ = sqlite3_prepare_v2 (_tmp6_, _tmp7_, -1, &_tmp8_, NULL);
_sqlite3_finalize0 (query);
query = _tmp8_;
res = _tmp9_;
_tmp10_ = res;
_vala_assert (_tmp10_ == SQLITE_OK, "res == Sqlite.OK");
_tmp11_ = query;
_tmp12_ = sentimiento;
_tmp13_ = _tmp12_->nombre;
_tmp14_ = g_strdup (_tmp13_);
_tmp15_ = g_free;
_tmp16_ = sqlite3_bind_text (_tmp11_, 1, _tmp14_, -1, _tmp15_);
res = _tmp16_;
_tmp17_ = res;
_vala_assert (_tmp17_ == SQLITE_OK, "res == Sqlite.OK");
_tmp18_ = query;
_tmp19_ = sentimiento;
_tmp20_ = _tmp19_->descripcion;
_tmp21_ = g_strdup (_tmp20_);
_tmp22_ = g_free;
_tmp23_ = sqlite3_bind_text (_tmp18_, 2, _tmp21_, -1, _tmp22_);
res = _tmp23_;
_tmp24_ = res;
_vala_assert (_tmp24_ == SQLITE_OK, "res == Sqlite.OK");
_tmp25_ = query;
_tmp26_ = sentimiento;
_tmp27_ = _tmp26_->id;
_tmp28_ = sqlite3_bind_int64 (_tmp25_, 3, _tmp27_);
res = _tmp28_;
_tmp29_ = res;
_vala_assert (_tmp29_ == SQLITE_OK, "res == Sqlite.OK");
_tmp30_ = query;
_tmp31_ = sqlite3_step (_tmp30_);
res = _tmp31_;
_tmp32_ = res;
result = _tmp32_ == SQLITE_DONE;
_g_free0 (sql);
_sqlite3_finalize0 (query);
_g_free0 (columnas);
return result;
}
GraphMediaModelosSentimiento* graph_media_modelos_sentimientos_agregar (GraphMediaModelosSentimientos* self, GraphMediaModelosSentimiento* sentimiento) {
GraphMediaModelosSentimiento* result = NULL;
GraphMediaModelosSentimiento* _tmp0_ = NULL;
gboolean _tmp1_ = FALSE;
sqlite3_stmt* query = NULL;
gchar* sql = NULL;
const gchar* _tmp4_ = NULL;
gchar* _tmp5_ = NULL;
gchar* _tmp6_ = NULL;
gchar* _tmp7_ = NULL;
gchar* _tmp8_ = NULL;
gint res = 0;
sqlite3* _tmp9_ = NULL;
const gchar* _tmp10_ = NULL;
sqlite3_stmt* _tmp11_ = NULL;
gint _tmp12_ = 0;
gint _tmp13_ = 0;
sqlite3_stmt* _tmp14_ = NULL;
GraphMediaModelosSentimiento* _tmp15_ = NULL;
const gchar* _tmp16_ = NULL;
gchar* _tmp17_ = NULL;
GDestroyNotify _tmp18_ = NULL;
gint _tmp19_ = 0;
gint _tmp20_ = 0;
sqlite3_stmt* _tmp21_ = NULL;
GraphMediaModelosSentimiento* _tmp22_ = NULL;
const gchar* _tmp23_ = NULL;
gchar* _tmp24_ = NULL;
GDestroyNotify _tmp25_ = NULL;
gint _tmp26_ = 0;
gint _tmp27_ = 0;
sqlite3_stmt* _tmp28_ = NULL;
gint _tmp29_ = 0;
gint _tmp30_ = 0;
GraphMediaModelosSentimiento* _tmp31_ = NULL;
sqlite3* _tmp32_ = NULL;
gint64 _tmp33_ = 0LL;
GraphMediaModelosSentimiento* _tmp34_ = NULL;
GraphMediaModelosSentimiento* _tmp35_ = NULL;
g_return_val_if_fail (self != NULL, NULL);
g_return_val_if_fail (sentimiento != NULL, NULL);
_tmp0_ = sentimiento;
_tmp1_ = graph_media_modelos_sentimientos_existe_sentimiento (self, _tmp0_);
if (_tmp1_) {
GraphMediaModelosSentimiento* _tmp2_ = NULL;
GraphMediaModelosSentimiento* _tmp3_ = NULL;
_tmp2_ = sentimiento;
_tmp3_ = _graph_media_modelos_sentimiento_ref0 (_tmp2_);
result = _tmp3_;
return result;
}
_tmp4_ = ((GraphMediaModelosTablas*) self)->nombre_tabla;
_tmp5_ = g_strdup_printf ("INSERT INTO %s (nombre, descripcion) ", _tmp4_);
_tmp6_ = _tmp5_;
_tmp7_ = g_strconcat (_tmp6_, "VALUES (?, ?)", NULL);
_tmp8_ = _tmp7_;
_g_free0 (_tmp6_);
sql = _tmp8_;
_tmp9_ = graph_media_modelos_tablas_bd;
_tmp10_ = sql;
_tmp12_ = sqlite3_prepare_v2 (_tmp9_, _tmp10_, -1, &_tmp11_, NULL);
_sqlite3_finalize0 (query);
query = _tmp11_;
res = _tmp12_;
_tmp13_ = res;
_vala_assert (_tmp13_ == SQLITE_OK, "res == Sqlite.OK");
_tmp14_ = query;
_tmp15_ = sentimiento;
_tmp16_ = _tmp15_->nombre;
_tmp17_ = g_strdup (_tmp16_);
_tmp18_ = g_free;
_tmp19_ = sqlite3_bind_text (_tmp14_, 1, _tmp17_, -1, _tmp18_);
res = _tmp19_;
_tmp20_ = res;
_vala_assert (_tmp20_ == SQLITE_OK, "res == Sqlite.OK");
_tmp21_ = query;
_tmp22_ = sentimiento;
_tmp23_ = _tmp22_->descripcion;
_tmp24_ = g_strdup (_tmp23_);
_tmp25_ = g_free;
_tmp26_ = sqlite3_bind_text (_tmp21_, 2, _tmp24_, -1, _tmp25_);
res = _tmp26_;
_tmp27_ = res;
_vala_assert (_tmp27_ == SQLITE_OK, "res == Sqlite.OK");
_tmp28_ = query;
_tmp29_ = sqlite3_step (_tmp28_);
res = _tmp29_;
_tmp30_ = res;
if (_tmp30_ != SQLITE_DONE) {
result = NULL;
_g_free0 (sql);
_sqlite3_finalize0 (query);
return result;
}
_tmp31_ = sentimiento;
_tmp32_ = graph_media_modelos_tablas_bd;
_tmp33_ = sqlite3_last_insert_rowid (_tmp32_);
_tmp31_->id = _tmp33_;
_tmp34_ = sentimiento;
_tmp35_ = _graph_media_modelos_sentimiento_ref0 (_tmp34_);
result = _tmp35_;
_g_free0 (sql);
_sqlite3_finalize0 (query);
return result;
}