66 lines
2.5 KiB
C#
66 lines
2.5 KiB
C#
// Probe pour compter les Interventions E2E_TEST dans BATIK_TEST.
|
|
// Vérifie qu'une seule Intervention correspond à l'opération E2E.
|
|
using System.Data.OleDb;
|
|
|
|
const string server = "127.0.0.1";
|
|
const int port = 4900;
|
|
const string user = "susana";
|
|
const string password = "123";
|
|
|
|
string BuildConnStr(string database) =>
|
|
$"Provider=PCSOFT.HFSQL;Data Source={server}:{port};Initial Catalog={database};User ID={user};Password={password}";
|
|
|
|
Console.WriteLine("=== Comptage Interventions E2E_TEST dans BATIK_TEST ===");
|
|
|
|
try
|
|
{
|
|
using var conn = new OleDbConnection(BuildConnStr("BATIK_TEST"));
|
|
conn.Open();
|
|
|
|
// Compter toutes les Interventions E2E_TEST.
|
|
using (var cmd = conn.CreateCommand())
|
|
{
|
|
cmd.CommandText = "SELECT COUNT(*) FROM Intervention WHERE IN_RefInterne LIKE 'E2E_TEST%'";
|
|
var count = cmd.ExecuteScalar();
|
|
Console.WriteLine($" Interventions E2E_TEST (IN_RefInterne LIKE 'E2E_TEST%'): {count}");
|
|
}
|
|
|
|
// Lister les Interventions E2E_TEST avec leurs détails.
|
|
using (var cmd = conn.CreateCommand())
|
|
{
|
|
cmd.CommandText = "SELECT IN_PKID, IN_RefInterne, IN_Titre, IN_Description FROM Intervention WHERE IN_RefInterne LIKE 'E2E_TEST%'";
|
|
using var reader = cmd.ExecuteReader();
|
|
Console.WriteLine("\n Détails des Interventions E2E_TEST:");
|
|
while (reader.Read())
|
|
{
|
|
Console.WriteLine($" IN_PKID={reader["IN_PKID"]}, Ref={reader["IN_RefInterne"]}, Titre={reader["IN_Titre"]}, Desc={reader["IN_Description"]}");
|
|
}
|
|
}
|
|
|
|
// Compter les MobLog pour l'opération Replay (operationId 0fce297f dans ML_Message JSON).
|
|
using (var cmd = conn.CreateCommand())
|
|
{
|
|
cmd.CommandText = "SELECT COUNT(*) FROM MobLog WHERE ML_Message LIKE '%0fce297f%'";
|
|
var count = cmd.ExecuteScalar();
|
|
Console.WriteLine($"\n MobLog pour operationId 0fce297f (Replay): {count}");
|
|
}
|
|
|
|
// Lister les MobLog pour l'opération Replay.
|
|
using (var cmd = conn.CreateCommand())
|
|
{
|
|
cmd.CommandText = "SELECT ML_PKID, ML_DateCreat, ML_Message, ML_Niveau FROM MobLog WHERE ML_Message LIKE '%0fce297f%'";
|
|
using var reader = cmd.ExecuteReader();
|
|
Console.WriteLine("\n Détails MobLog Replay:");
|
|
while (reader.Read())
|
|
{
|
|
Console.WriteLine($" ML_PKID={reader["ML_PKID"]}, Date={reader["ML_DateCreat"]}, Niveau={reader["ML_Niveau"]}, Msg={reader["ML_Message"]}");
|
|
}
|
|
}
|
|
}
|
|
catch (Exception ex)
|
|
{
|
|
Console.WriteLine($" ERREUR: {ex.Message}");
|
|
}
|
|
|
|
Console.WriteLine("\nProbe comptage terminé.");
|