static async Task Main()
{
Program prog = new Program();
//Update Start Time in DB
using var cn = new SqlConnection()
{
ConnectionString = "Data Source = GANN; " + "Initial Catalog=gann;" + "User id=gann_user;" + "Password=[PASSWORD];"
};
//Get all Bitstring Files
var directory = @"../../../../ONNX-Inference/Data/Evolved_Bitstring/Bitstrings/";
var files = Directory.GetFiles(directory);
cn.Open();
foreach (string filePath in files)
{
// read data from file
using var inputFile = new System.IO.StreamReader(filePath);
string str = string.Empty;
while ((str = inputFile.ReadLine()) != null)
{
var byteArray = BitStringUtils.ConvertBitstring2ByteArray(str);
{
var dt = DateTime.UtcNow;
string statementStart = "UPDATE [gann].[dbo].[EvolvedFilesMeta] SET [StartTime] = @dt WHERE [Filename] = @fileName";
var cmd = new SqlCommand(statementStart, cn);
cmd.Parameters.Add("@dt", SqlDbType.DateTime);
cmd.Parameters.Add("@fileName", SqlDbType.NVarChar);
cmd.Parameters["@dt"].Value = dt;
cmd.Parameters["@fileName"].Value = Path.GetFileName(filePath);
cmd.ExecuteNonQuery();
cmd.Dispose();
Thread.Sleep(1000);
//send bytes converted from Tinyints
var success = Convert.ToBoolean(await prog.UploadFile(filePath, byteArray));
Thread.Sleep(1000);
if (success == true)
{
//Update End Time to DB if response is true
var dt2 = DateTime.UtcNow;
string statementEnd = "UPDATE [gann].[dbo].[EvolvedFilesMeta] SET [EndTime] = @dt2 WHERE [Filename] = @fileName";
var cmd2 = new SqlCommand(statementEnd, cn);
cmd2.Parameters.Add("@dt2", SqlDbType.DateTime);
cmd2.Parameters.Add("@fileName", SqlDbType.NVarChar);
cmd2.Parameters["@dt2"].Value = dt2;
cmd2.Parameters["@fileName"].Value = Path.GetFileName(filePath);
cmd2.ExecuteNonQuery();
cmd2.Dispose();
}
}
}
}
}
static DataObject LoadTENSORSFromFiles(string directory)
{
var files = Directory.GetFiles(directory);
DataObject obj = new DataObject
{
Tensors = new Dictionary <string, List <float[]> >()
};
foreach (string filename in files)
{
List <float[]> list = null;
// read data from file
using var inputFile = new System.IO.StreamReader(filename);
List <float[]> dataStr = new List <float[]>();
var x = 0;
string str = string.Empty;
while ((str = inputFile.ReadLine()) != null)
{
float[] ftArr = new float[1000];
var byteArray = BitStringUtils.ConvertBitstring2ByteArray(str);
for (int i = 0; i < byteArray.Length; i++)
{
float ft = byteArray[i];
ftArr[i] = ft;
}
dataStr.Add(ftArr);
x++;
}
list = new List <float[]>(dataStr);;
obj.Tensors.Add(filename, list);
}
return(obj);
}
