public string GerarBody() { var baseProc = NomeTabela.TratarNomeTabela().ToUpper(); var header = new StringBuilder(); header.Append(new PostgreGet().Init($"{ParamtersInput.Prefixos.Procedure}S_{baseProc}", NomeTabela, ListaAtributosTabela)); header.Append(new PostgreBuscar().Init($"{ParamtersInput.Prefixos.Procedure}S_{baseProc}_ID", NomeTabela, ListaAtributosTabela)); header.Append(new PostgreInsert().Init($"{ParamtersInput.Prefixos.Procedure}I_{baseProc}", NomeTabela, ListaAtributosTabela)); header.Append(new PostgreUpdate().Init($"{ParamtersInput.Prefixos.Procedure}U_{baseProc}", NomeTabela, ListaAtributosTabela)); header.Append(new PostgreDelete().Init($"{ParamtersInput.Prefixos.Procedure}D_{baseProc}", NomeTabela, ListaAtributosTabela)); return(header.ToString()); }
public string GerarBody() { var baseProc = NomeTabela.TratarNomeTabela().ToUpper(); var header = new StringBuilder(); header.Append(new MySqlGet().Init($"{NomeTabela.TratarNomeProcedure(OperationProcedure.List)}", NomeTabela, ListaAtributosTabela)); header.Append(new MySqlBuscar().Init($"{NomeTabela.TratarNomeProcedure(OperationProcedure.Search)}", NomeTabela, ListaAtributosTabela)); header.Append(new MySqlInsert().Init($"{NomeTabela.TratarNomeProcedure(OperationProcedure.Insert)}", NomeTabela, ListaAtributosTabela)); header.Append(new MySqlUpdate().Init($"{NomeTabela.TratarNomeProcedure(OperationProcedure.Update)}", NomeTabela, ListaAtributosTabela)); header.Append(new MySqlDelete().Init($"{NomeTabela.TratarNomeProcedure(OperationProcedure.Delete)}", NomeTabela, ListaAtributosTabela)); return(header.ToString()); }
public string GerarBody() { var atributos = new SQLTables().ListarAtributos(NomeTabela); var classe = new StringBuilder(); classe.Append($"package model;{N}{N}"); classe.Append(Imports()); classe.Append("@XmlRootElement" + N); classe.Append($"public class {NomeTabela.ToFirstCharToUpper()} {{{N}"); classe.Append(AtributosHeader(atributos)); classe.Append(AtributosBody(atributos)); classe.Append("}" + Environment.NewLine); return(classe.ToString()); }
private StringBuilder MontaTodosParametrosInsert() { var parametro = new StringBuilder(); parametro.Append($" INSERT INTO {NomeTabela}" + Environment.NewLine); parametro.Append(" ("); for (var i = 0; i < ListaAtributosTabela.Count; i++) { if (i == ListaAtributosTabela.Count - 1) { parametro.Append($" {ListaAtributosTabela[i].COLUMN_NAME}"); } else if (i == 0) { parametro.Append($"{ListaAtributosTabela[i].COLUMN_NAME}," + Environment.NewLine); } else { parametro.Append($" {ListaAtributosTabela[i].COLUMN_NAME}," + Environment.NewLine); } } parametro.Append(")" + Environment.NewLine); parametro.Append(" VALUES" + Environment.NewLine); parametro.Append(" ("); for (var i = 0; i < ListaAtributosTabela.Count; i++) { if (i == ListaAtributosTabela.Count - 1) { parametro.Append($" P_{ListaAtributosTabela[i].COLUMN_NAME}"); } else if (i == 0) { parametro.Append($"{NomeTabela.TratarNomeSequence()}," + Environment.NewLine); } else { parametro.Append($" P_{ListaAtributosTabela[i].COLUMN_NAME}," + Environment.NewLine); } } parametro.Append(");"); return(parametro); }
public StringBuilder GerarInterfaceSharProc() { var nomeProcBase = NomeTabela.TratarNomeTabela(); var classe = new StringBuilder(); classe.Append("using System;" + N + N); classe.Append("namespace MeuProjeto" + N); classe.Append("{" + N); classe.Append($" public interface {nomeProcBase.ToLowerInvariant()}RequestRepository : IADORepository" + N); classe.Append(" {" + N + N); classe.Append(GetInterfacesMethod()); classe.Append(" }" + N); classe.Append("}" + N); return(classe); }
public string GerarClasse() { var template = Tratamentos.PathTemplate(); var connection = new MySqlConnectionStringModel(ParamtersInput.ConnectionString); var p = String.Format(template, connection.host, connection.user, connection.database, connection.password, connection.port, parametrosQuery(false), parametrosQuery(true), NomeTabela.TratarNomeProcedure(OperationProcedure.Search), NomeTabela.TratarNomeProcedure(OperationProcedure.List), NomeTabela.TratarNomeProcedure(OperationProcedure.Insert), NomeTabela.TratarNomeProcedure(OperationProcedure.Update), NomeTabela.TratarNomeProcedure(OperationProcedure.Delete)); return(p); }
public string GerarBody() { var classe = new StringBuilder(); classe.Append("namespace Model" + N); classe.Append("{" + N); classe.Append($" public class {NomeTabela.ToFirstCharToUpper()}" + N); classe.Append(" {" + N + N); foreach (var item in ListaAtributosTabela) { classe.Append($" public string {item.COLUMN_NAME} {{ get; set; }}" + N); classe.Append(N); } classe.Append(" }" + N); classe.Append("}" + N); return(GerarUsing() + classe.ToString()); }
public StringBuilder GerarClasse() { var classe = new StringBuilder(); classe.Append(Imports()); classe.Append($"namespace meuprojeto{N}{{{N}"); classe.Append($" public class {NomeTabela.ToFirstCharToUpper()}Dao : FirebirdRepository {{ {N}{N}"); classe.Append(GetById()); classe.Append(N); classe.Append(GetAll()); classe.Append(N); classe.Append(Add()); classe.Append(N); classe.Append(Update()); classe.Append(N); classe.Append(Delete()); classe.Append($" }}{N}"); classe.Append($"}}"); return(classe); }
public StringBuilder GerarBodyCSharpProc() { var nomeProcBase = NomeTabela.TratarNomeTabelaMySql(); var classe = new StringBuilder(); classe.Append("using System.Net;" + N); classe.Append("using System;" + N + N); classe.Append("namespace MeuProjeto" + N); classe.Append("{" + N); classe.Append($" public class {nomeProcBase.ToLowerInvariant()}RequestRepository : ADORepository" + N); classe.Append(" {" + N + N); classe.Append(GetById(nomeProcBase)); classe.Append(Add(nomeProcBase)); classe.Append(Update(nomeProcBase)); classe.Append(" }" + N); classe.Append("}" + N); return(classe); }
public StringBuilder GerarPackageHeader() { var header = new StringBuilder(); header.Append($"create or replace package {NomeTabela.TratarNomePackage()} is" + Environment.NewLine + Environment.NewLine); header.Append(" TYPE TP_CURSOR IS REF CURSOR;" + Environment.NewLine + Environment.NewLine); header.Append(AdicionaCabecalho(ParamtersInput.Prefixos.Procedure + "I_" + NomeTabela.TratarNomeTabela(), true, false, false, false, true)); header.Append(AdicionaCabecalho(ParamtersInput.Prefixos.Procedure + "U_" + NomeTabela.TratarNomeTabela(), true)); header.Append(AdicionaCabecalho(ParamtersInput.Prefixos.Procedure + "D_" + NomeTabela.TratarNomeTabela(), true, false, true)); header.Append(AdicionaCabecalho(ParamtersInput.Prefixos.Procedure + "S_" + NomeTabela.TratarNomeTabela(), true, true, true, true)); header.Append(AdicionaCabecalho( ParamtersInput.Prefixos.Procedure + "S_" + NomeTabela.TratarNomeTabela() + "_ID", true, true, true)); header.Append(Environment.NewLine + Environment.NewLine + $"end {NomeTabela.TratarNomePackage()};" + Environment.NewLine); return(header); }
public StringBuilder GerarClasse() { var nomeProcBase = NomeTabela.TratarNomeTabela(); var classe = new StringBuilder(); classe.Append("using System.Net;" + N); classe.Append("using System;" + N + N); classe.Append("namespace MeuProjeto" + N); classe.Append("{" + N); classe.Append($" public class {nomeProcBase.ToLowerInvariant()}RequestRepository : ADORepository" + N); classe.Append(" {" + N + N); classe.Append($" private const string PackageName = \"{NomeTabela.TratarNomePackage()}\";" + N + N); classe.Append(Procedures(nomeProcBase)); classe.Append(GetById(nomeProcBase)); classe.Append(Add(nomeProcBase)); classe.Append(Update(nomeProcBase)); classe.Append(" }" + N); classe.Append("}" + N); return(classe); }
private StringBuilder Delete() { var nameProc = $"{ParamtersInput.Prefixos.Procedure}U_{NomeTabela.TratarNomeTabela().ToUpper()}"; var get = new StringBuilder(); get.Append($" public void Delete(int ID) throws Exception{N}"); get.Append($" {{{N}"); get.Append($" try{{{N}"); get.Append($" BeginNewStatement(Proc.{nameProc}, \"{ParamtersInput.DataBase}\");{N}"); get.Append($" AddParamter(new Paramter(\"P_RESULT\", java.sql.Types.VARCHAR, null,\"OUT\"));{N}{N}"); get.Append($" RequestProc();{N}"); get.Append($" }}{N}"); get.Append($" catch (Exception ex){{{N}"); get.Append($" throw ex;{N}"); get.Append($" }}{N}"); get.Append($" finally {{{N}"); get.Append($" desconecta();{N}"); get.Append($" }}{N}"); get.Append($" }}{N}"); get.Append($"}}{N}"); return(get); }
private StringBuilder GetAll() { var get = new StringBuilder(); get.Append($" getAll: function (callback) {{{N}"); get.Append( $" oracleDb.beginProcedure({ParamtersInput.ConnectionString.TratarNomeBase()}, \"{NomeTabela.TratarNomePackage()}.{ParamtersInput.Prefixos.Procedure + "S_" + NomeTabela.TratarNomeTabela()}\",{N}"); get.Append($" {{{N}"); get.Append( $" P_CURSORSELECT: {{ type: oracleDb.type(\"CURSOR\"), dir: oracleDb.type(\"BIND_OUT\") }}{N}"); get.Append($" }}, \"P_CURSORSELECT\", function (err, result) {{ {N}"); get.Append($" callback(err, result);{N}"); get.Append($" }});{N}"); get.Append($" }},{N}"); return(get); }
private StringBuilder Update() { var get = new StringBuilder(); get.Append($" update: function (body, callback) {{ {N}"); get.Append( $" oracleDb.executeProcedure({ParamtersInput.ConnectionString.TratarNomeBase()}, \"{NomeTabela.TratarNomePackage()}.{ParamtersInput.Prefixos.Procedure + "U_" + NomeTabela.TratarNomeTabela()}\",{N}"); get.Append($" {{{N}"); get.Append( $" P_RESULT: {{ dir: oracleDb.type(\"BIND_OUT\"), type: oracleDb.type(\"STRING\") }}, {N}"); for (var i = 0; i < ListaAtributosTabela.Count; i++) { get.Append( $" P_{ListaAtributosTabela[i].COLUMN_NAME}: body.{ListaAtributosTabela[i].COLUMN_NAME},{N}"); } get.Append($" }}, \"P_RESULT\",{N}"); get.Append($" function (err, result) {{ {N}"); get.Append($" callback(err, result);{N}"); get.Append($" }});{N}"); get.Append($" }},{N}"); return(get); }
private StringBuilder GetAll() { var get = new StringBuilder(); get.Append($" getAll: () => {{{N}"); get.Append($" return Firebird.executeString(`SELECT * FROM {NomeTabela.ToLower()}`);{N}"); get.Append($" }},{N}"); return(get); }
private StringBuilder GetById() { var get = new StringBuilder(); get.Append($" getById: function (id, callback) {{{N}"); get.Append( $" oracleDb.beginProcedureById({ParamtersInput.ConnectionString.TratarNomeBase()}, \"{NomeTabela.TratarNomePackage()}.{ParamtersInput.Prefixos.Procedure + "S_" + NomeTabela.TratarNomeTabela() + "_ID"}\",{N}"); get.Append($" {{{N}"); get.Append( $" P_CURSORSELECT: {{ type: oracleDb.type(\"CURSOR\"), dir: oracleDb.type(\"BIND_OUT\") }},{N}"); get.Append($" P_{ListaAtributosTabela.First().COLUMN_NAME}: id, {N}"); get.Append($" }}, function (err, result) {{ {N}"); get.Append($" callback(err, result);{N}"); get.Append($" }});{N}"); get.Append($" }},{N}"); return(get); }
private StringBuilder Delete() { var get = new StringBuilder(); get.Append($" delete: function (id, callback) {{ {N}"); get.Append( $" oracleDb.executeProcedure({ParamtersInput.ConnectionString.TratarNomeBase()}, \"{NomeTabela.TratarNomePackage()}.{ParamtersInput.Prefixos.Procedure + "D_" + NomeTabela.TratarNomeTabela()}\",{N}"); get.Append($" {{{N}"); get.Append( $" P_RESULT: {{ dir: oracleDb.type(\"BIND_OUT\"), type: oracleDb.type(\"STRING\") }}, {N}"); get.Append($" P_{ListaAtributosTabela.First().COLUMN_NAME}: id,{N}"); get.Append($" }}, \"P_RESULT\",{N}"); get.Append($" function (err, result) {{ {N}"); get.Append($" callback(err, result);{N}"); get.Append($" }});{N}"); get.Append($" }},{N}"); return(get); }