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); } }