From dd9811703ad623e6b3ddc51e58ef5cc801f41951 Mon Sep 17 00:00:00 2001 From: ComradeCrow Date: Wed, 17 May 2023 23:25:10 -0700 Subject: save to db is working --- src/sqliteinterface.cpp | 5 +++-- 1 file changed, 3 insertions(+), 2 deletions(-) (limited to 'src/sqliteinterface.cpp') diff --git a/src/sqliteinterface.cpp b/src/sqliteinterface.cpp index c34576b..e59fd8a 100644 --- a/src/sqliteinterface.cpp +++ b/src/sqliteinterface.cpp @@ -66,10 +66,11 @@ void SqliteInterface::createTables() { } } -void SqliteInterface::saveInstance(const string& uri, float health, const string& location) { +void SqliteInterface::saveInstance(const char *uri, float health, const char *location) { char *errmsg = 0; - int rc = sqlite3_exec(db, sqlite3_mprintf("INSERT INTO INSTANCES (%Q, %F.2, %Q)", uri, health, location), callback, 0, &errmsg); + char *sqlExec = sqlite3_mprintf("REPLACE INTO INSTANCES VALUES(%Q, '%.3f', %Q);", uri, health, location); + int rc = sqlite3_exec(db, sqlExec, callback, 0, &errmsg); if( rc != SQLITE_OK ){ fprintf(stderr, "SQL error: %s\n", errmsg); sqlite3_free(errmsg); -- cgit 1.4.1-2-gfad0