public string CreateQuery(ProcedureData data)
{
var sql = CreateCommand.Replace("[PROCEDURE_NAME]", data.Name);
sql = sql.Replace("VARS", data.Vars);
sql = sql.Replace("SCRIPT", data.Script);
return(sql);
}
public string CreateQuery(FunctionData data)
{
var sql = CreateCommand.Replace("FUNCTIONAME", data.Name);
sql = sql.Replace("RETURNTYPE", data.ReturnType);
sql = sql.Replace("SCRIPTO", data.Script);
return(sql);
}
public string CreateQuery(CheckData checkHelper)
{
var sql = CreateCommand.Replace("TABLENAME", checkHelper.Table);
sql = sql.Replace("CHECKNAME", checkHelper.Name);
sql = sql.Replace("CONDITION", checkHelper.Script);
return(sql);
}
public string CreateQuery(string tableName)
{
var sql = CreateCommand.Replace("[TABLENAME]", tableName);
var start = sql.IndexOf('(');
sql = sql.Insert(start + 1, ConcatColumnNames());
start = sql.LastIndexOf(");");
sql = sql.Insert(start - 1, AddConstraints());
return(sql);
}