public void Construct()
{
var path = (GetPlatformOs.Current == PlatformOs.Windows) ? $@"c:/motNext/Tests/Sqlite/Test.sqlite" : $@"~/Projects/Tests/Sqlite/Test.sqlite";
try
{
var sqlite = new MotDatabaseServer <MotSqliteServer>(path);
// Only do the MOT8 test if its a 32 bit platform. In unit tests it fails otherwise.
// ODBC Connection Failed: ERROR [IM014] [Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application
if (GetPlatformOs.Current == PlatformOs.Windows && IntPtr.Size == 4)
{
// This fails because MOT only has 32 bit drivers and the unit test doesn't seem to want to enable "prefer 32 bit"
var odbc = new MotDatabaseServer <MotOdbcServer>($"dsn=MOT8;UID={MotAccessSecurity.DecodeString(_dbaUserName)};PWD={MotAccessSecurity.DecodeString(_dbaPassword)}");
}
// CleanUp
File.Delete(path);
}
catch (Exception ex)
{
Console.WriteLine(ex);
Assert.Fail(ex.Message);
}
}
public void SupervisorLogin()
{
try
{
if (GetPlatformOs.Current == PlatformOs.Windows)
{
var _dbServer = new MotDatabaseServer <MotOdbcServer>($"dsn=MOT8;UID={DecodeString(_dbaUserName)};PWD={DecodeString(_dbaPassword)}");
using (var test = new DataSet())
{
var db = _dbServer.ExecuteQuery(@"SELECT * FROM SYS.SYSTABLE where SYS.SYSTABLE.table_name = 'SynMed2Send'");
if (db.Tables.Count > 0 && db.Tables[0].Rows.Count > 0)
{
var _supportsSynMed = true;
}
}
}
}
catch (Exception ex)
{
Assert.Fail($"Faild at SupervisorLogin with {ex.Message}");
}
}
public void NullConstructor()
{
var path = (GetPlatformOs.Current == PlatformOs.Windows) ? $@"C/motNext/Tests/Sqlite/Test.sqlite" : $@"~/Projects/Tests/Sqlite/Test.sqlite";
try
{
var sqlite = new MotDatabaseServer <MotSqliteServer>(null);
Assert.Fail("Allowed to pass null DSN");
if (GetPlatformOs.Current == PlatformOs.Windows)
{
var odbc = new MotDatabaseServer <MotOdbcServer>($"dsn=MOT8;UID={_dbaUserName};PWD={_dbaPassword}");
Assert.Fail("Allowed to pass null DSN");
}
// CleanUp
File.Delete(path);
}
catch (Exception ex)
{
Console.WriteLine(ex);
}
}
