private static void InsertCamerasAndGpus(SQLiteConnection conn, UsageRecord record, List <Camera> cameras, List <GpuInfo> gpus)
{
// Finish creating camera records and add them to the DB.
foreach (Camera camera in cameras)
{
camera.UsageRecordID = record.ID;
conn.Insert(camera);
}
// Add Gpu records to the DB.
foreach (GpuInfo gpu in gpus)
{
gpu.UsageRecordID = record.ID;
conn.Insert(gpu);
}
}
//public static void RetroactiveFixData()
//{
// UsageRecord record = GetUsageRecord(11);
// record.Total_FPS = 0;
// record.Total_MPPS = 0;
// List<Camera> cameras = GetCameras(11);
// foreach (var cam in cameras)
// {
// float MP = cam.Pixels / 1000000f;
// record.Total_FPS += cam.FPS;
// record.Total_MPPS += MP * cam.FPS;
// }
// db.Update(record);
//}
public static void AddUsageRecord(UsageRecordUpload.v2.Upload_Record obj)
{
BugFixer.Fix(obj);
// Create objects
UsageRecord record = new UsageRecord();
// v1 Properties
record.Secret = obj.Secret;
record.Timestamp = TimeUtil.GetTimeInMsSinceEpoch();
record.OS = obj.OS;
record.HelperVersion = obj.HelperVersion;
record.BiVersion = obj.BiVersion;
record.CpuModel = obj.CpuModel;
record.CpuMHz = obj.CpuMHz;
record.CpuUsage = obj.CpuUsage;
record.BiCpuUsage = obj.BiCpuUsage;
record.CpuThreads = obj.CpuThreads;
record.MemMB = obj.MemMB;
record.BiMemUsageMB = obj.BiMemUsageMB;
record.BiPeakVirtualMemUsageMB = obj.BiPeakVirtualMemUsageMB;
record.MemFreeMB = obj.MemFreeMB;
record.HwAccel = (HWAccel)obj.HwAccel;
record.RamGiB = obj.RamGiB;
record.RamChannels = obj.RamChannels;
record.RamMHz = obj.RamMHz;
// v2 properties
record.DimmLocations = obj.DimmLocations;
record.ServiceMode = obj.ServiceMode;
record.ConsoleOpen = obj.ConsoleOpen;
record.ConsoleWidth = obj.ConsoleWidth;
record.ConsoleHeight = obj.ConsoleHeight;
record.LivePreviewFPS = obj.LivePreviewFPS;
// Cameras
List <Camera> cameras = new List <Camera>();
record.CameraCount = (byte)Math.Min(255, obj.cameras.Length);
record.Total_FPS = record.Total_Megapixels = record.Total_MPPS = 0;
foreach (var cam in obj.cameras)
{
Camera camera = new Camera();
camera.Pixels = cam.Pixels;
camera.FPS = cam.FPS;
camera.LimitDecode = cam.LimitDecode;
camera.Hwaccel = (HWAccelCamera)cam.Hwaccel;
camera.Type = (CameraType)cam.Type;
camera.CapType = (ScreenCapType)cam.CapType;
camera.MotionDetector = cam.MotionDetector;
camera.RecordTriggerType = (RecordingTriggerType)cam.RecordTriggerType;
camera.RecordFormat = (RecordingFormat)cam.RecordFormat;
camera.DirectToDisk = cam.DirectToDisk;
camera.VCodec = cam.VCodec;
float MP = cam.Pixels / 1000000f;
record.Total_Megapixels += MP;
record.Total_FPS += cam.FPS;
record.Total_MPPS += MP * cam.FPS;
cameras.Add(camera);
}
// GPUs
List <GpuInfo> gpus = new List <GpuInfo>();
foreach (var gpu in obj.gpus)
{
GpuInfo gi = new GpuInfo();
gi.Name = gpu.Name;
gi.DriverVersion = gpu.Version;
gpus.Add(gi);
}
// Add to performance data table
db.RunInTransaction(() =>
{
List <UsageRecord> existing = db.Query <UsageRecord>("SELECT * FROM UsageRecord WHERE Secret = ? AND CpuModel = ?", record.Secret, record.CpuModel);
if (existing.Count > 0)
{
record.ID = existing[0].ID;
int rC = db.Execute("DELETE FROM Camera WHERE UsageRecordID = ?", record.ID);
int rG = db.Execute("DELETE FROM GpuInfo WHERE UsageRecordID = ?", record.ID);
db.Update(record);
}
else
{
// Add usage record to DB
int rowsAffected = db.Insert(record);
if (rowsAffected == 0)
{
Logger.Debug("Failed to insert record: " + JsonConvert.SerializeObject(record));
return;
}
}
InsertCamerasAndGpus(db, record, cameras, gpus);
});
// Add to archive table, which is maintained for the purpose of eventually maybe including history graphing for systems.
record.ID = 0;
archive.RunInTransaction(() =>
{
// Add usage record to DB
int rowsAffected = archive.Insert(record);
if (rowsAffected == 0)
{
Logger.Debug("Failed to insert record into archive table: " + JsonConvert.SerializeObject(record));
return;
}
InsertCamerasAndGpus(archive, record, cameras, gpus);
});
}
