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()); }
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 }