public void CreateTSQL(SampleSQLData sample, IList<object> sqlList, IDictionary<string, string> parameters) { string baseSQL = @"INSERT INTO {0} ({1}) VALUES ({2});"; string dataSQL = string.Empty; foreach (var row in sample.Rows) { string fields = string.Empty; string values = string.Empty; foreach (var schema in sample.Schema) { fields += "{0},".FormatWith(schema.Column); string value = JSON.DeserializeDynamic(row.ToString())[schema.Column]; if (parameters.ContainsKey(value)) { value = parameters[value]; } values += "{0},".FormatWith(ParserDataType.ParseSQL((ParserDataType.DataType)Enum.Parse(typeof(ParserDataType.DataType), schema.Type, true), value)); } dataSQL += baseSQL.FormatWith(sample.Table, fields.Substring(0, fields.LastIndexOf(',')), values.Substring(0, values.LastIndexOf(','))); } if (!string.IsNullOrEmpty(dataSQL)) { sqlList.Add(dataSQL); } }
public void CreateTSQL(SampleSQLData sample, IList<object> sqlList, IDictionary<string, string> parameters) { string baseSQL = @"DELETE FROM {0} WHERE {1};"; string dataSQL = string.Empty; foreach (var row in sample.Rows) { string fields = string.Empty; foreach (var key in sample.Keys) { Common.Schema schema = sample.Schema.SingleOrDefault(s => s.Column == key); string value = JSON.DeserializeDynamic(row.ToString())[schema.Column]; if (parameters.ContainsKey(value)) { value = parameters[value]; } string parsedValue = "{0}".FormatWith(ParserDataType.ParseSQL((ParserDataType.DataType)Enum.Parse(typeof(ParserDataType.DataType), schema.Type, true), value)); fields += "{0}={1} AND ".FormatWith(schema.Column, parsedValue); } dataSQL += baseSQL.FormatWith(sample.Table, fields.Substring(0, fields.LastIndexOf("AND"))); } if (!string.IsNullOrEmpty(dataSQL)) { sqlList.Add(dataSQL); } }
public static void Execute(IGenerateTSQL sqlCommand, SampleSQLData sample, IList<object> sqlList, IDictionary<string, string> dynamicParameters) { sqlCommand.CreateTSQL(sample, sqlList, dynamicParameters); }
public static void Execute(IGenerateTSQL sqlCommand, SampleSQLData sample, IList<object> sqlList) { sqlCommand.CreateTSQL(sample, sqlList); }