41 lines
983 B
C++
41 lines
983 B
C++
|
#include "LogBean.h"
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
LogBean::LogBean()
|
||
|
|
{
|
||
|
|
}
|
||
|
|
|
||
|
|
|
||
|
|
LogBean::~LogBean()
|
||
|
|
{
|
||
|
|
}
|
||
|
|
|
||
|
|
|
||
|
|
void LogBean::CreateIfNoExist(SQLite::Database* db)
|
||
|
|
{
|
||
|
|
if (db == nullptr)return;
|
||
|
|
if (db->tableExists(LOG_TABLE_NAME))return;
|
||
|
|
char buffer[1024];
|
||
|
|
sprintf_s(buffer, sizeof(buffer), "CREATE TABLE %s(%s INTEGER PRIMARY KEY AUTOINCREMENT,%s LONG,%s VARCHAR(20),%s VARCHAR(500))",
|
||
|
|
LOG_TABLE_NAME.c_str(),
|
||
|
|
LOG_FIELD_ID.c_str(),
|
||
|
|
LOG_FIELD_INSERT_TIME.c_str(),
|
||
|
|
LOG_FIELD_LEVEL.c_str(),
|
||
|
|
LOG_FIELD_CONTENT.c_str()
|
||
|
|
);
|
||
|
|
db->exec(buffer);
|
||
|
|
sprintf_s(buffer, sizeof(buffer), "CREATE INDEX IF NOT EXISTS idx_%s_%s ON %s (%s)",
|
||
|
|
LOG_TABLE_NAME.c_str(),
|
||
|
|
LOG_FIELD_INSERT_TIME.c_str(),
|
||
|
|
LOG_TABLE_NAME.c_str(),
|
||
|
|
LOG_FIELD_INSERT_TIME.c_str()
|
||
|
|
);
|
||
|
|
db->exec(buffer);
|
||
|
|
}
|
||
|
|
|
||
|
|
const string LogBean::LOG_TABLE_NAME="Log";
|
||
|
|
const string LogBean::LOG_FIELD_ID="id";
|
||
|
|
const string LogBean::LOG_FIELD_INSERT_TIME="insert_time";
|
||
|
|
const string LogBean::LOG_FIELD_LEVEL="level";
|
||
|
|
const string LogBean::LOG_FIELD_CONTENT="content";
|