internal void Initialize(string databasePath, string databaseOptions, string mmeCode = null)
{
try
{
var connectionString = $"data source={databasePath};{databaseOptions}";
_mmeCode = mmeCode;
_sqLiteDbService = new SQLiteDbService(new SQLiteConnection(connectionString));
_msSqlDbService = new DatabaseProxy(Settings.Default.CentralDatabase);
_communication.PostDbSyncState(DeviceConnectionState.ConnectionInProcess, string.Empty);
// AfterSyncWithServerRoutineHandler("Synchronization of the local database with a central database is prohibited by parameter DisableResultDB");
// else
// SyncWithServer(AfterSyncWithServerRoutineHandler);
}
catch (Exception e)
{
SystemHost.Journal.AppendLog(ComplexParts.Sync, LogMessageType.Error, $"Local database not synced with a central database. Reason: {e.ToString()}");
}
}
static void Main(string[] args)
{
string mmeCode = "MME013";
SQLiteDbService q = new SQLiteDbService(new SQLiteConnection(new SQLiteConnectionStringBuilder()
{
DataSource = "SCME_ResultsDB_Local.sqlite",
DefaultTimeout = 15,
SyncMode = SynchronizationModes.Full,
JournalMode = SQLiteJournalModeEnum.Truncate,
FailIfMissing = true
}.ToString()));
var w = new MSSQLDbService(new SqlConnection(new SqlConnectionStringBuilder()
{
DataSource = @"tcp:192.168.0.134, 1444",
InitialCatalog = "SCME_ResultsDB",
IntegratedSecurity = false,
ConnectTimeout = 15,
UserID = "sa",
Password = "******"
}.ToString()));
if (w.GetMmeCodes().Count(m => m.Key == mmeCode) == 0)
{
w.InsertMmeCode(mmeCode);
}
var e = q.GetProfilesDeepByMmeCode(mmeCode);
foreach (var i in e)
{
w.InsertUpdateProfile(null, i, mmeCode);
}
e = null;
}
