static string ExecuteSqlCIOrder()
{
string fileName = DeleteFileIfExists("Demo3SimpleExecuteSql.html");
//TODO: put current dir on interpret string , like env
var receiveFolder = new ReceiverFolderHierarchical(@"#static:Directory.GetCurrentDirectory()#\SqlToExecute", "*.sql");
var dbConnection = new DBDataConnection <SqlConnection>();
dbConnection.ConnectionString = "#file:SqlServerConnectionString#";
var senderSql = new SenderSqlToDBSqlServer(dbConnection);
var si = new SimpleJob();
si.Receivers.Add(0, receiveFolder);
si.Senders.Add(0, senderSql);
return(si.SerializeMe());
}
private bool disposedValue = false; // To detect redundant calls
protected virtual void Dispose(bool disposing)
{
if (!disposedValue)
{
if (disposing)
{
// TODO: dispose managed state (managed objects).
}
if (Connection != null)
{
Connection.Dispose();
Connection = null;
}
valuesToBeSent = null;
disposedValue = true;
}
}
public async Task TestSqlFolder()
{
#region arrange
var dir = AppContext.BaseDirectory;
var conection = GetSqlServerConnectionString();
var folderSql = Path.Combine(dir, "SqlToExecute");
var receiverFolder = new ReceiverFolderHierarchical(folderSql, "*.sql");
var con = new DBDataConnection <SqlConnection>();
con.ConnectionString = conection;
var senderSqlServer = new SenderSqlToDBSqlServer(con);
#endregion
#region act
var j = new SimpleJob();
j.Receivers.Add(0, receiverFolder);
j.Senders.Add(0, senderSqlServer);
await j.Execute();
#endregion
#region assert
receiverFolder.valuesRead?.Length.ShouldBeGreaterThan(1);
using (var conn = new SqlConnection(conection))
{
await conn.OpenAsync();
using (var cmd = conn.CreateCommand())
{
cmd.CommandType = CommandType.Text;
cmd.CommandText = "select count(ID) from TestAndrei";
var res = await cmd.ExecuteScalarAsync();
res.ShouldNotBeNull();
var text = res.ToString();
text.ShouldBe("1");
}
}
#endregion
}
public SenderSqlToDBSqlServer(DBDataConnection <SqlConnection> connection) : base(connection)
{
}
public SenderSqlToDB(DBDataConnection <T> connection)
{
OrderBy = "FullName";
Connection = connection;
}
