private void ExecuteFromFile(string path, ExecutionContext context) { Logger.LogMessage(path); using (var reader = new StreamReader(path)) using (var sqlReader = new SqlScriptReader(reader)) ExecuteSql(sqlReader, context); }
private void ExecuteSql(SqlScriptReader sqlReader, ExecutionContext context) { var connectionInfo = new ConnectionInfo { ConnectionName = (string)context.ResolveVariable(ConnectionName), DataSource = (string)context.ResolveVariable(DataSource), InitialCatalog = InitialCatalog, InitialCatalogName = (string)context.ResolveVariable(InitialCatalogName), UserName = (string)context.ResolveVariable(UserName), Password = (string)context.ResolveVariable(Password) }; var connectionString = MsSqlDataContext.GetConnectionString(connectionInfo, context.ConnectionStrings) ?? context.ConnectionStrings.Repository; while (sqlReader.ReadScript()) { var script = sqlReader.Script; var sb = new StringBuilder(); //TODO: [DIREF] get options from DI through constructor using (var ctx = new MsSqlDataContext(connectionString, DataOptions.GetLegacyConfiguration(), CancellationToken.None)) { ctx.ExecuteReaderAsync(script, async(reader, cancel) => { do { if (reader.HasRows) { var first = true; while (await reader.ReadAsync(cancel).ConfigureAwait(false)) { if (first) { for (int i = 0; i < reader.FieldCount; i++) { sb.Append(reader.GetName(i)).Append("\t"); } Logger.LogMessage(sb.ToString()); sb.Clear(); first = false; } for (int i = 0; i < reader.FieldCount; i++) { sb.Append(reader[i]).Append("\t"); } Logger.LogMessage(sb.ToString()); sb.Clear(); } } } while (await reader.NextResultAsync(cancel).ConfigureAwait(false)); return(Task.FromResult(0)); }).GetAwaiter().GetResult(); } } Logger.LogMessage("Script is successfully executed."); }
private void ExecuteFromText(string text, ExecutionContext context) { text = text.Trim(); if (text.StartsWith("<![CDATA[") && text.EndsWith("]]>")) { text = text.Substring(9, text.Length - 12).Trim(); } using (var reader = new StringReader(text)) using (var sqlReader = new SqlScriptReader(reader)) ExecuteSql(sqlReader, context); }
private void ExecuteSql(SqlScriptReader sqlReader, ExecutionContext context) { while (sqlReader.ReadScript()) { var script = sqlReader.Script; var sb = new StringBuilder(); using (var proc = DataProvider.CreateDataProcedure(script, ConnectionName, InitialCatalog)) { proc.CommandType = CommandType.Text; using (var reader = proc.ExecuteReader()) { do { if (reader.HasRows) { var first = true; while (reader.Read()) { if (first) { for (int i = 0; i < reader.FieldCount; i++) { sb.Append(reader.GetName(i)).Append("\t"); } Logger.LogMessage(sb.ToString()); sb.Clear(); first = false; } for (int i = 0; i < reader.FieldCount; i++) { sb.Append(reader[i]).Append("\t"); } Logger.LogMessage(sb.ToString()); sb.Clear(); } } //Logger.LogMessage("---------------------"); } while (reader.NextResult()); } } } Logger.LogMessage("Script is successfully executed."); }
public IList <SqlScript> GetUpdateStepsBeginningFromVersion(Version versionBegin, Version versionEnd = null) { var updateSteps = new List <SqlScript>(); foreach (var embeddedScript in this.FindEmbeddedScripts(versionBegin, versionEnd).ToList()) { var fileNameWithoutExtension = this.GetVersionFromScript(embeddedScript); var updateStepVersion = Version.Parse(fileNameWithoutExtension ?? throw new InvalidOperationException()); var fullResourceName = $"{GetScriptsNamespace(this._assembly)}.{embeddedScript}"; using (var sqlScriptStream = this._assembly.GetManifestResourceStream(fullResourceName)) { var scriptStreamReader = new SqlScriptReader(sqlScriptStream); var updateStep = new SqlScript(updateStepVersion, new List <string>(scriptStreamReader.ToList())); updateSteps.Add(updateStep); } } return(updateSteps); }
private void ExecuteFromText(string text, ExecutionContext context) { using (var reader = new StringReader(text)) using (var sqlReader = new SqlScriptReader(reader)) ExecuteSql(sqlReader, context); }