| //+------------------------------------------------------------------+
|
| //| RegisterTerminal: регистрация терминала в базе |
|
| //+------------------------------------------------------------------+
|
| int RegisterTerminal()
|
| {
|
| const string folder = InstanceFolder();
|
| const string path = TerminalInfoString(TERMINAL_DATA_PATH);
|
| const string company = TerminalInfoString(TERMINAL_COMPANY);
|
| const int build = (int)TerminalInfoInteger(TERMINAL_BUILD);
|
| const long now = (long)TimeGMT();
|
|
|
| const string sql =
|
| "INSERT INTO terminals (folder, path, company, build, first_seen, last_seen) "
|
| "VALUES (?1, ?2, ?3, ?4, ?5, ?5) "
|
| "ON CONFLICT(folder) DO UPDATE SET "
|
| " path = excluded.path,"
|
| " company = excluded.company,"
|
| " build = excluded.build,"
|
| " last_seen = excluded.last_seen";
|
| // ... DatabasePrepare / DatabaseBind / DatabaseRead, см. полный листинг
|
| }
|