public static string SqlCreateOutputView(this OutputContext c)
{
var columnNames = string.Join(",", c.GetAllEntityOutputFields().Select(f => "[" + f.FieldName() + "] AS [" + f.Alias + "]"));
var sql = $@"CREATE VIEW [{c.Entity.OutputViewName(c.Process.Name)}] AS SELECT {columnNames},TflBatchId,TflKey FROM [{c.Entity.OutputTableName(c.Process.Name)}] WITH (NOLOCK);";
c.Debug(sql);
return(sql);
}
public static string SqlCreateOutput(this OutputContext c)
{
var columnsAndDefinitions = string.Join(",", c.GetAllEntityOutputFields().Select(f => "[" + f.FieldName() + "] " + f.SqlDataType() + " NOT NULL"));
var sql = $"CREATE TABLE [{c.Entity.OutputTableName(c.Process.Name)}]({columnsAndDefinitions}, TflBatchId INT NOT NULL, TflKey INT IDENTITY(1,1));";
c.Debug(sql);
return(sql);
}
public static string SqlCreateOutputView(this OutputContext c, IConnectionFactory cf)
{
var columnNames = string.Join(",", c.GetAllEntityOutputFields().Select(f => cf.Enclose(f.FieldName()) + " AS " + cf.Enclose(f.Alias)));
var sql = $@"CREATE VIEW {cf.Enclose(c.Entity.OutputViewName(c.Process.Name))} AS SELECT {columnNames} FROM {cf.Enclose(c.Entity.OutputTableName(c.Process.Name))}{cf.Terminator}";
c.Debug(() => sql);
return(sql);
}
public JsonStreamWriter2(OutputContext context, Stream stream)
{
_context = context;
_stream = stream;
_fields = context.GetAllEntityOutputFields().ToArray();
_formats = new string[_fields.Count()];
for (int i = 0; i < _fields.Length; i++)
{
_formats[i] = _fields[i].Format == string.Empty ? string.Empty : string.Concat("{0:", _fields[i].Format, "}");
}
}
public static string SqlCreateOutput(this OutputContext c, IConnectionFactory cf)
{
var columnsAndDefinitions = string.Join(",", c.GetAllEntityOutputFields().Select(f => cf.Enclose(f.FieldName()) + " " + cf.SqlDataType(f) + " NOT NULL"));
var sql = $"CREATE TABLE {cf.Enclose(c.Entity.OutputTableName(c.Process.Name))}({columnsAndDefinitions}, ";
if (cf.AdoProvider == AdoProvider.SqLite)
{
sql += $"PRIMARY KEY ({cf.Enclose(c.Entity.TflKey().FieldName())} ASC));";
}
else
{
sql += $"CONSTRAINT {Utility.Identifier("pk_" + c.Entity.OutputTableName(c.Process.Name) + "_tflkey")} PRIMARY KEY ({cf.Enclose(c.Entity.TflKey().FieldName())})){cf.Terminator}";
}
c.Debug(() => sql);
return(sql);
}