public async Task MultiPOTest()
{
var connector = Nglib.DATA.CONNECTOR.ConnectorTests.GetDefaultConenctor();
DataPoSampleProvider dataPoSampleProvider = new DataPoSampleProvider(connector);
CollectionPO <DataPoSample> samples = new CollectionPO <DataPoSample>();
for (int i = 0; i < 50; i++)
{
samples.Add(new DataPoSample()
{
Pseudo = "manysamples" + i.ToString()
});
}
await dataPoSampleProvider.InsertPOAsync(samples.ToArray());
foreach (var item in samples)
{
item.Pseudo = "Oi" + item.Pseudo;
}
await dataPoSampleProvider.SavePOAsync(samples.ToArray());
Console.WriteLine(samples.Count);
}
public async Task FullOnePOTest()
{
Assert.IsNotNull(DataAnnotationsFactory.TableAttributeType); // les annotations doivent avoir été chargées
var connector = Nglib.DATA.CONNECTOR.ConnectorTests.GetDefaultConenctor();
DataPoSampleProvider dataPoSampleProvider = new DataPoSampleProvider(connector);
// Insert
DataPoSample dataPoSample = new DataPoSample();
dataPoSample.Pseudo = "test";
dataPoSample.FluxXml.SetObject("/param/sut1", "valeur1", DATA.ACCESSORS.DataAccessorOptionEnum.None);
dataPoSample.FluxXml["/param/sut2"] = "valeur2";
await dataPoSampleProvider.InsertPOAsync(dataPoSample);
Assert.IsTrue(dataPoSample.TestId > 0);
// Select
dataPoSample = dataPoSampleProvider.GetFirstPO(dataPoSample.TestId);
// save
dataPoSample.FluxXml["/param/sut2"] = "valeurX2";
dataPoSample.FluxXml["/param/sut3"] = "valeur2";
dataPoSample.Pseudo = "test2";
await dataPoSampleProvider.SavePOAsync(dataPoSample);
// update
// Delete
dataPoSample = dataPoSampleProvider.GetFirstPO(dataPoSample.TestId);
await dataPoSampleProvider.DeletePOAsync(dataPoSample);
Assert.IsTrue(dataPoSample.TestId > 0);
}
public async Task PertTest1_pre()
{
System.Diagnostics.Stopwatch watch = new System.Diagnostics.Stopwatch();
int nb = 0;
Nglib.DATA.CONNECTOR.IDataConnector connector = new Nglib.DATA.CONNECTOR.ConnectorGeneric();
connector.SetConnectionString(Nglib.DATA.CONNECTOR.ConnectorTests.TestConnectionString, "Npgsql");
connector.QueryCompleted += Connector_QueryCompleted;
try
{
connector.Open(true);
System.Data.Common.DbConnection connect = (System.Data.Common.DbConnection)connector.GetDbConnection();
watch.Start();
DataPoSampleProvider provider = new DataPoSampleProvider(connector);
Console.WriteLine(string.Format("elapsed:{0}ms - nb:{1} executes={2}ms -{3}ms", watch.ElapsedMilliseconds, nb, totalelapsedExecute, totalelapsedConnector));
CollectionPO <DataPoSample> listtest = provider.GetListPO("SELECT * FROM tests");
Console.WriteLine(string.Format("elapsed:{0}ms - nb:{1} executes={2}ms -{3}ms", watch.ElapsedMilliseconds, nb, totalelapsedExecute, totalelapsedConnector));
nb = listtest.Count;
for (int i = 0; i < 100; i++)
{
DataPoSample item = provider.GetFirstPO(6);
item.Pseudo = "tesperf_po_" + i.ToString();
provider.SavePO(item);
i++;
}
Console.WriteLine(string.Format("elapsed:{0}ms - nb:{1} executes={2}ms -{3}ms", watch.ElapsedMilliseconds, nb, totalelapsedExecute, totalelapsedConnector));
await provider.InsertPOAsync(new DataPoSample()
{
Pseudo = "totu"
});
watch.Stop();
}
catch (Exception ex)
{
throw;
}
finally
{
connector.Close();
}
Console.WriteLine(string.Format("elapsed:{0}ms - nb:{1} executes={2}ms -{3}ms", watch.ElapsedMilliseconds, nb, totalelapsedExecute, totalelapsedConnector));
}
public async Task DevPOTest()
{
var connector = Nglib.DATA.CONNECTOR.ConnectorTests.GetDefaultConenctor();
DataPoSampleProvider dataPoSampleProvider = new DataPoSampleProvider(connector);
DataPoSample dataPoSample = dataPoSampleProvider.GetFirstPO(6);
var test0 = dataPoSample.GetObject("jsonb", DataAccessorOptionEnum.None);
var test = dataPoSample.GetObject("multicols1", DataAccessorOptionEnum.None);
Console.WriteLine(test);
string DnForTalosAdmins = dataPoSample.FluxXml.GetString("/param/DnForTalosAdmins");
string flux = "<?xml version=\"1.0\" encoding=\"utf-16\"?>\r\n<param>\r\n\t<empty true=\"False\" />\r\n\t<maval>e20a0115320b41679c8500e4e651690e</maval>\r\n</param>";
await dataPoSampleProvider.UpdatePOAsync(new DataPoSample[] { dataPoSample }, "fluxxml", flux);
Console.WriteLine("test");
}
public async Task FluxPOTest()
{
var connector = Nglib.DATA.CONNECTOR.ConnectorTests.GetDefaultConenctor();
DataPoSampleProvider dataPoSampleProvider = new DataPoSampleProvider(connector);
}
