#include <stdio.h>
|
#include <assert.h>
|
#include <stdlib.h>
|
#include <string.h>
|
#include <errno.h>
|
#include <stdbool.h>
|
#include <sys/types.h>
|
#include <unistd.h>
|
#include <ctype.h>
|
#include <inttypes.h>
|
|
#include <glib.h>
|
|
#include <pthread.h>
|
#include <gdbus.h>
|
|
#include "json-c/json.h"
|
#include "rkdb.h"
|
#include "common.h"
|
|
#define TABLE_EVENT_TRIGGERS "EventTriggers"
|
#define TABLE_EVENT_SCHEDULES "EventSchedules"
|
#define TABLE_REGIONAL_INVASION "RegionalInvasion"
|
#define TABLE_MOVE_DETECTION "MoveDetection"
|
#define TABLE_FACE_CONFIG "FaceConfig"
|
#define TABLE_FACE_LIST "FaceList"
|
#define TABLE_FACE_SNAPSHOT_RECORD "FaceSnapshotRecord"
|
#define TABLE_FACE_CONTROL_RECORD "FaceControlRecord"
|
#define TABLE_SMART_COVER "SmartCover"
|
#define TABLE_SMART_COVER_OVERLAY "SmartCoverOverlay"
|
#define TABLE_EVENT_VERSION "EventVersion"
|
#define TABLE_NOTIFICATION "Notification"
|
|
#define EVENT_VERSION "1.0.1"
|
|
int event_dbus_register(DBusConnection *dbus_conn)
|
{
|
g_dbus_register_interface(dbus_conn, "/",
|
DB_EVENT_INTERFACE,
|
methods,
|
signals, NULL, DB_EVENT_INTERFACE, NULL);
|
|
return 0;
|
}
|
|
void event_init(void)
|
{
|
char *col_para;
|
|
if (equal_version(TABLE_EVENT_VERSION, EVENT_VERSION))
|
return;
|
|
g_free(rkdb_drop(TABLE_EVENT_TRIGGERS));
|
g_free(rkdb_drop(TABLE_EVENT_SCHEDULES));
|
g_free(rkdb_drop(TABLE_REGIONAL_INVASION));
|
g_free(rkdb_drop(TABLE_MOVE_DETECTION));
|
g_free(rkdb_drop(TABLE_FACE_CONFIG));
|
g_free(rkdb_drop(TABLE_FACE_LIST));
|
g_free(rkdb_drop(TABLE_FACE_SNAPSHOT_RECORD));
|
g_free(rkdb_drop(TABLE_FACE_CONTROL_RECORD));
|
g_free(rkdb_drop(TABLE_SMART_COVER));
|
g_free(rkdb_drop(TABLE_SMART_COVER_OVERLAY));
|
g_free(rkdb_drop(TABLE_NOTIFICATION));
|
g_free(rkdb_drop(TABLE_EVENT_VERSION));
|
|
creat_version_table(TABLE_EVENT_VERSION, EVENT_VERSION);
|
|
col_para = "id INTEGER PRIMARY KEY AUTOINCREMENT," \
|
"sEventType TEXT," \
|
"iVideoInputChannelID INT DEFAULT 0," \
|
"iNotificationIO1Enabled INT DEFAULT 0," \
|
"iNotificationRecord1Enabled INT DEFAULT 0," \
|
"iNotificationEmailEnabled INT DEFAULT 0," \
|
"iNotificationCenterEnabled INT DEFAULT 0," \
|
"iNotificationFTPEnabled INT DEFAULT 0";
|
g_free(rkdb_create(TABLE_EVENT_TRIGGERS, col_para));
|
g_free(rkdb_insert(TABLE_EVENT_TRIGGERS, "id, sEventType", "0, 'VMD'"));
|
g_free(rkdb_insert(TABLE_EVENT_TRIGGERS, "id, sEventType", "1, 'VRI'"));
|
|
/*
|
0: for motion detect
|
1: for intrusion detect
|
2: for storage video plan
|
3: for storage screenshot. remark:must be last for add other type of schedule
|
example for no type: "[[{\"start\":0.73456,\"end\":0.5236}],[],[],[],[],[],[]]" add \" before string
|
example for types: "[[{\"start\":0.73456,\"end\":0.5236,\"type\":\"type0\"}],[],[],[],[],[],[]]" add \" before string
|
*/
|
col_para = "id INTEGER PRIMARY KEY AUTOINCREMENT," \
|
"sSchedulesJson TEXT";
|
g_free(rkdb_create(TABLE_EVENT_SCHEDULES, col_para));
|
g_free(rkdb_insert(TABLE_EVENT_SCHEDULES, "id, sSchedulesJson", "0, ''"));
|
g_free(rkdb_insert(TABLE_EVENT_SCHEDULES, "id, sSchedulesJson", "1, ''"));
|
g_free(rkdb_insert(TABLE_EVENT_SCHEDULES, "id, sSchedulesJson", "2, ''"));
|
g_free(rkdb_insert(TABLE_EVENT_SCHEDULES, "id, sSchedulesJson", "3, ''"));
|
|
col_para = "id INTEGER PRIMARY KEY AUTOINCREMENT," \
|
"iEnabled INT DEFAULT 0," \
|
"iTimeThreshold INT DEFAULT 0," \
|
"iProportion INT DEFAULT 0," \
|
"iSensitivityLevel INT DEFAULT 50," \
|
"iPositionX INT DEFAULT 0," \
|
"iPositionY INT DEFAULT 0," \
|
"iWidth INT DEFAULT 0," \
|
"iHeight INT DEFAULT 0";
|
g_free(rkdb_create(TABLE_REGIONAL_INVASION, col_para));
|
g_free(rkdb_insert(TABLE_REGIONAL_INVASION, "id", "0"));
|
|
col_para = "id INTEGER PRIMARY KEY AUTOINCREMENT," \
|
"iMotionDetectionEnabled INT DEFAULT 0," \
|
"iHighlightEnabled INT DEFAULT 0," \
|
"iSamplingInterval INT DEFAULT 2," \
|
"iStartTriggerTime INT DEFAULT 500," \
|
"iEndTriggerTime INT DEFAULT 500," \
|
"sRegionType TEXT DEFAULT 'grid'," \
|
"iRowGranularity INT DEFAULT 18," \
|
"iColumnGranularity INT DEFAULT 22," \
|
"iSensitivityLevel INT DEFAULT 0," \
|
"sGridMap TEXT DEFAULT '000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'";
|
g_free(rkdb_create(TABLE_MOVE_DETECTION, col_para));
|
g_free(rkdb_insert(TABLE_MOVE_DETECTION, "id", "0"));
|
|
col_para = "id INTEGER PRIMARY KEY AUTOINCREMENT," \
|
"iPromptVolume INT DEFAULT 50," \
|
"sLiveDetect TEXT DEFAULT 'open'," \
|
"sLiveDetectBeginTime TEXT DEFAULT '00:00'," \
|
"sLiveDetectEndTime TEXT DEFAULT '23:59'," \
|
"iLiveDetectThreshold INT DEFAULT 50," \
|
"iFaceDetectionThreshold INT DEFAULT 55," \
|
"iFaceRecognitionThreshold INT DEFAULT 50," \
|
"iFaceMinPixel INT DEFAULT 144," \
|
"iLeftCornerX INT DEFAULT 0," \
|
"iLeftCornerY INT DEFAULT 0," \
|
"iDetectWidth INT DEFAULT 720," \
|
"iDetectHeight INT DEFAULT 1280," \
|
"iNormalizedHeight INT DEFAULT 1280," \
|
"iNormalizedWidth INT DEFAULT 720";
|
g_free(rkdb_create(TABLE_FACE_CONFIG, col_para));
|
g_free(rkdb_insert(TABLE_FACE_CONFIG, "id", "0"));
|
|
col_para = "id INTEGER PRIMARY KEY AUTOINCREMENT," \
|
"sPicturePath TEXT DEFAULT ''," \
|
"sRegistrationTime TEXT DEFAULT '2020-01-01T00:00:00'," \
|
"iAge INT DEFAULT 20," \
|
"sListType TEXT DEFAULT 'permanent'," \
|
"sType TEXT DEFAULT 'whiteList'," \
|
"sName TEXT DEFAULT 'User'," \
|
"sGender TEXT DEFAULT 'male'," \
|
"sNation TEXT DEFAULT '汉'," \
|
"sCertificateType TEXT DEFAULT 'identityCard'," \
|
"sCertificateNumber TEXT DEFAULT ''," \
|
"sBirthday TEXT DEFAULT '2000-01-01'," \
|
"sTelephoneNumber TEXT DEFAULT ''," \
|
"sHometown TEXT DEFAULT ''," \
|
"sAddress TEXT DEFAULT ''," \
|
"iAccessCardNumber INT DEFAULT 0," \
|
"iLoadCompleted INT DEFAULT 0," \
|
"iFaceDBId INT DEFAULT -1," \
|
"sNote TEXT DEFAULT ''";
|
g_free(rkdb_create(TABLE_FACE_LIST, col_para));
|
|
col_para = "id INTEGER PRIMARY KEY AUTOINCREMENT," \
|
"sTime TEXT DEFAULT '2020-01-01T00:00:00'," \
|
"sPicturePath TEXT DEFAULT ''," \
|
"sStatus TEXT DEFAULT 'Processed'," \
|
"sNote TEXT DEFAULT 'Snapshot'";
|
g_free(rkdb_create(TABLE_FACE_SNAPSHOT_RECORD, col_para));
|
|
col_para = "id INTEGER PRIMARY KEY AUTOINCREMENT," \
|
"sTime TEXT DEFAULT '2020-01-01T00:00:00'," \
|
"iFaceId INT DEFAULT 0," \
|
"sSnapshotPath TEXT DEFAULT ''," \
|
"sStatus TEXT DEFAULT 'open'," \
|
"sSimilarity TEXT DEFAULT '75.00'";
|
g_free(rkdb_create(TABLE_FACE_CONTROL_RECORD, col_para));
|
|
/*
|
iWidthRatio, iFaceHeightRatio, iBodyHeightRatio /10 = really ratio
|
*/
|
col_para = "id INTEGER PRIMARY KEY AUTOINCREMENT," \
|
"iFaceEnabled INT DEFAULT 0," \
|
"iFaceRecognitionEnabled INT DEFAULT 0," \
|
"iStreamOverlayEnabled INT DEFAULT 0," \
|
"iImageOverlayEnabled INT DEFAULT 0," \
|
"iInfoOverlayEnabled INT DEFAULT 0," \
|
"sTargetImageType TEXT," \
|
"iWidthRatio INT DEFAULT 10," \
|
"iFaceHeightRatio INT DEFAULT 10," \
|
"iBodyHeightRatio INT DEFAULT 10," \
|
"sImageQuality TEXT";
|
g_free(rkdb_create(TABLE_SMART_COVER, col_para));
|
g_free(rkdb_insert(TABLE_SMART_COVER, "id, sTargetImageType, sImageQuality", "0, 'head', 'good'"));
|
|
col_para = "id INTEGER PRIMARY KEY AUTOINCREMENT," \
|
"iEnabled INT DEFAULT 0," \
|
"sName TEXT," \
|
"sInfo TEXT," \
|
"iOrder INT";
|
g_free(rkdb_create(TABLE_SMART_COVER_OVERLAY, col_para));
|
g_free(rkdb_insert(TABLE_SMART_COVER_OVERLAY, "id, sName, sInfo, iOrder", "0, 'deviceNum', '', 0"));
|
g_free(rkdb_insert(TABLE_SMART_COVER_OVERLAY, "id, sName, sInfo, iOrder", "1, 'snapTime', '', 1"));
|
g_free(rkdb_insert(TABLE_SMART_COVER_OVERLAY, "id, sName, sInfo, iOrder", "2, 'positonInfo', '', 2"));
|
|
col_para = "id INTEGER PRIMARY KEY AUTOINCREMENT," \
|
"sArrivalTime TEXT DEFAULT ''," \
|
"sTopic TEXT DEFAULT ''," \
|
"sOperation TEXT DEFAULT ''," \
|
"sSource TEXT DEFAULT ''," \
|
"sKey TEXT DEFAULT ''," \
|
"sData TEXT DEFAULT ''," \
|
"sMessage TEXT DEFAULT ''," \
|
"sDetails TEXT DEFAULT ''";
|
g_free(rkdb_create(TABLE_NOTIFICATION, col_para));
|
/* example */
|
// g_free(rkdb_insert(TABLE_NOTIFICATION, "sArrivalTime, sTopic, sOperation, sSource, sData",
|
// "'2020-08-06T12:00:00', 'tns1:VideoSource/MotionAlarm', 'Initialized', 'Source : VideoSource_1', 'State : false'"));
|
}
|
