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());
}
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 static bool CreateTable(DBSQLViewModel _dBSQLViewModel = null)
{
bool Result = true;
if (!_dBSQLViewModel.CheckConnection())
{
return(false);
}
DB_SQL.QuickQueryInt(_dBSQLViewModel, "select PK from AuditTrail where 1=2");
if (DB_SQL._ViewModel != null && DB_SQL._ViewModel.LastError == "")
{
return(true);
}
;
if (Result)
{
// - - - - - -
#region Create table & co
string SQL = "";
switch (_dBSQLViewModel.DBType)
{
case DBType.Firebird: return(false); break; // ToDo CHM
case DBType.SQLServer: SQL = AuditTrail.PostScript_MSSQL; break;
case DBType.SQLite: SQL = AuditTrail.PostScript_SQLite; break;
case DBType.PostgreSQL: SQL = AuditTrail.PostScript_PGSQL; break;
case DBType.MySQL: SQL = AuditTrail.PostScript_MySQL; break;
}
;
// - - - - - -
DB_SQL.CreateTable(_dBSQLViewModel, typeof(AuditTrail), SQL, "");
#endregion
// - - - - - -
if (!Result)
{
Log.Write(new AuditTrail()
{
Level = ErrorLevel.Error, Message = _dBSQLViewModel.LastError + Environment.NewLine + _dBSQLViewModel.LastQuery
});
if (Debugger.IsAttached)
{
Debugger.Break();
}
;
return(false);
}
}
;
return(Result);
}