diff options
| author | Zdenek Prikryl <zprikryl@redhat.com> | 2009-02-11 16:11:32 +0100 |
|---|---|---|
| committer | Zdenek Prikryl <zprikryl@redhat.com> | 2009-02-11 16:11:32 +0100 |
| commit | 8c4cc76ad21758ad40886720bd9f85e3e0a579e4 (patch) | |
| tree | 57fd841c80f18b201d1483d0fc018157cb8db573 /lib/Plugins/SQLite3.cpp | |
| parent | f570c04d61bae344a50e20275669227bbdde829c (diff) | |
| download | abrt-8c4cc76ad21758ad40886720bd9f85e3e0a579e4.tar.gz abrt-8c4cc76ad21758ad40886720bd9f85e3e0a579e4.tar.xz abrt-8c4cc76ad21758ad40886720bd9f85e3e0a579e4.zip | |
added new column
Diffstat (limited to 'lib/Plugins/SQLite3.cpp')
| -rw-r--r-- | lib/Plugins/SQLite3.cpp | 23 |
1 files changed, 15 insertions, 8 deletions
diff --git a/lib/Plugins/SQLite3.cpp b/lib/Plugins/SQLite3.cpp index b28a866..c6cf8f4 100644 --- a/lib/Plugins/SQLite3.cpp +++ b/lib/Plugins/SQLite3.cpp @@ -85,6 +85,8 @@ void CSQLite3::GetTable(const std::string& pCommand, vector_database_rows_t& pTa break; case 4: row.m_sReported = table[jj + ncol]; break; + case 5: row.m_sTime = table[jj + ncol]; + break; default: break; } @@ -125,11 +127,12 @@ void CSQLite3::Create() Exec("CREATE TABLE "TABLE_NAME" (" DATABASE_COLUMN_UUID" VARCHAR NOT NULL," - DATABASE_COLUMN_UID" VARCHAR(64) NOT NULL," + DATABASE_COLUMN_UID" VARCHAR NOT NULL," DATABASE_COLUMN_DEBUG_DUMP_PATH" VARCHAR NOT NULL," - DATABASE_COLUMN_COUNT" INT(10) NOT NULL DEFAULT 1," - DATABASE_COLUMN_REPORTED" INT(10) NOT NULL DEFAULT 0," - "PRIMARY KEY (UUID, UID));"); + DATABASE_COLUMN_COUNT" INT NOT NULL DEFAULT 1," + DATABASE_COLUMN_REPORTED" INT NOT NULL DEFAULT 0," + DATABASE_COLUMN_TIME" VARCHAR NOT NULL DEFAULT 0," + "PRIMARY KEY ("DATABASE_COLUMN_UUID","DATABASE_COLUMN_UID"));"); } void CSQLite3::DisConnect() @@ -139,23 +142,27 @@ void CSQLite3::DisConnect() void CSQLite3::Insert(const std::string& pUUID, const std::string& pUID, - const std::string& pDebugDumpPath) + const std::string& pDebugDumpPath, + const std::string& pTime) { if (!Exist(pUUID, pUID)) { Exec("INSERT INTO "TABLE_NAME"(" DATABASE_COLUMN_UUID"," DATABASE_COLUMN_UID"," - DATABASE_COLUMN_DEBUG_DUMP_PATH")" + DATABASE_COLUMN_DEBUG_DUMP_PATH"," + DATABASE_COLUMN_TIME")" " VALUES ('"+pUUID+"'," "'"+pUID+"'," - "'"+pDebugDumpPath+"'" + "'"+pDebugDumpPath+"'," + "'"+pTime+"'" ");"); } else { Exec("UPDATE "TABLE_NAME" " - "SET "DATABASE_COLUMN_COUNT" = "DATABASE_COLUMN_COUNT" + 1 " + "SET "DATABASE_COLUMN_COUNT" = "DATABASE_COLUMN_COUNT" + 1, " + DATABASE_COLUMN_TIME" = '"+pTime+"' " "WHERE "DATABASE_COLUMN_UUID" = '"+pUUID+"' " "AND "DATABASE_COLUMN_UID" = '"+pUID+"';"); } |