public DequeueSeqment(int indentCount, Queue queue, string output)
: base(indentCount)
{
DependsOnSegments.Add(new ConnectionSegment(indentCount, queue));
Methods.Add(queueMessage
.Replace("#stoage-account", queue.StorageAccount)
.Replace("#queue", queue.QueueName));
FunctionCode = $"var {output} = await dequeue_{queue.QueueName};";
}
public EnqueueSeqment(int indentCount, Queue queue, string message)
: base(indentCount)
{
DependsOnSegments.Add(new ConnectionSegment(indentCount, queue));
Methods.Add(queueMessage
.Replace("#storage-account", queue.StorageAccount)
.Replace("#queue", queue.QueueName)
.Replace("#message", message));
FunctionCode = $"enqueue_{queue.QueueName}({message});";
}
public UpdateSegment(int indentCount, string methodName, Sql sql, string statement,
List <Parameter> parameters)
: base(indentCount)
{
Requires.Add("var Request = require('tedious').Request;");
DependsOnSegments.Add(new ConnectionSegement(indentCount, sql));
DependsOnModules.Add("\"tedious\": \"5.0.3\"");
Methods.Add(updateMethod
.Replace("#method-name", methodName)
.Replace("#sql", statement)
.Replace("#database", sql.DbName)
.Replace("#parameters", string.Join(',', parameters.Select(p => p.Name.Replace("@", ""))))
.Replace("#add-params", Helper.CreateParameters(parameters)));
FunctionCode = $"await {methodName}({string.Join(',', parameters.Select(p => p.Value)).Trim()});";
}
public SelectSegment(int indentCount, string methodName, Sql sql,
string statement, string assignTo, List <Parameter> parameters,
ReturnAs returnAs = ReturnAs.Array)
: base(indentCount)
{
Requires.Add("var Request = require('tedious').Request;");
DependsOnSegments.Add(new ConnectionSegement(indentCount, sql));
DependsOnModules.Add("\"tedious\": \"5.0.3\"");
Methods.Add(selectMethod
.Replace("#method-name", methodName)
.Replace("#sql", statement)
.Replace("#database", sql.DbName)
.Replace("#scalar", (returnAs == ReturnAs.Scalar).ToLowerString())
.Replace("#entity", (returnAs == ReturnAs.Entity).ToLowerString())
.Replace("#parameters", string.Join(',', parameters.Select(p => p.Name.Replace("@", ""))))
.Replace("#add-params", Helper.CreateParameters(parameters)));;
FunctionCode = $"var {assignTo} = await {methodName}({string.Join(',', parameters.Select(p => p.Value)).Trim()});";
}
public InsertSegment(int indentCount, string methodName, Sql sql,
string statement, string assignTo, List <Parameter> parameters, bool returnsId)
: base(indentCount)
{
Requires.Add("var Request = require('tedious').Request;");
DependsOnSegments.Add(new ConnectionSegement(indentCount, sql));
DependsOnModules.Add("\"tedious\": \"5.0.3\"");
Methods.Add(insertMethod
.Replace("#method-name", methodName)
.Replace("#sql", statement)
.Replace("#database", sql.DbName)
.Replace("#returns-id", returnsId.ToLowerString())
.Replace("#parameters", string.Join(',', parameters.Select(p => p.Name.Replace("@", ""))))
.Replace("#add-params", Helper.CreateParameters(parameters)));
if (!string.IsNullOrWhiteSpace(assignTo))
{
FunctionCode = $"{assignTo} = await {methodName}({string.Join(',', parameters.Select(p => p.Value)).Trim()});";
}
else
{
FunctionCode = $"await {methodName}({string.Join(',', parameters.Select(p => p.Value)).Trim()});";
}
}
