public void Init_AT_SQLServer2()
{
string server = "SQL6005.site4now.net";
string db = "DB_A44F11_StockAPPro2dev";
string user = "******";
string password = "******";
DBSQLViewModel AuditTrailConnection = null;
AuditTrailConnection = new DBSQLViewModel(new SQLServerEngine());
string AT_ConnectionString = DB_SQL.GenConnectionString(DBType.SQLServer, server, db, user, password);
AuditTrailConnection.Open(AT_ConnectionString, true);
AuditTrailViewModel.Current.Init(new DBAndFileAuditTrailWriter(AuditTrailConnection, string.Format(@"{0}", AuditTrailFileName)));
// AuditTrailViewModel.Current.MaxLines = 5;
//AuditTrailViewModel.Current.Clean(); // prend en compte uniquement nombre ligne
Assert.AreEqual(true, AuditTrailConnection.CheckConnection());
}
public void Init_AT_PG()
{
string server = "postgresql-zpf.alwaysdata.net";
string db = "zpf_postgresql";
string user = "******";
string password = "******";
DBSQLViewModel AuditTrailConnection = null;
AuditTrailConnection = new DBSQLViewModel(new PostgreSQLEngine());
string AT_ConnectionString = DB_SQL.GenConnectionString(DBType.PostgreSQL, server, db, user, password);
AuditTrailConnection.Open(AT_ConnectionString, true);
AuditTrailViewModel.Current.Init(new DBAndFileAuditTrailWriter(AuditTrailConnection, string.Format(@"{0}", AuditTrailFileName)));
AuditTrailViewModel.Current.MaxLines = 5;
AuditTrailViewModel.Current.Clean(); // prend en compte uniquement nombre ligne
Assert.AreEqual(true, AuditTrailConnection.CheckConnection());
}
