private StringBuilder GetAll() { var nameProc = $"{ParamtersInput.Prefixos.Procedure}S_{NomeTabela.TratarNomeTabela().ToUpper()}"; var get = new StringBuilder(); get.Append($" public List<{NomeTabela}> GetAll() throws Exception{N}"); get.Append($" {{{N}"); get.Append($" try{{{N}"); get.Append($" List<{NomeTabela}> lista = new java.util.ArrayList<{NomeTabela}>();{N}{N}"); get.Append($" BeginNewStatement(Proc.{nameProc}, \"{ParamtersInput.DataBase}\");{N}"); get.Append($" ResultSet rs = super.ExecuteReader();{N}{N}"); get.Append($" while(rs.next()){{{N}"); get.Append($" {NomeTabela} resposta = new {NomeTabela}();{N}"); foreach (var att in ListaAtributosTabela) { get.Append( $" resposta.set{att.FIELD_NAME}(rs.get{JavaTypesFirebird.GetTypeAtribute(att)}(\"{att.FIELD_NAME}\"));{N}"); } get.Append($" lista.add(resposta);{N}"); get.Append($" }};{N}"); get.Append($" return lista;{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}"); return(get); }
private StringBuilder Update() { var nameProc = $"{ParamtersInput.Prefixos.Procedure}U_{NomeTabela.TratarNomeTabela().ToUpper()}"; var get = new StringBuilder(); get.Append($" public void Update({NomeTabela} entidade) 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}"); foreach (var att in ListaAtributosTabela) { get.Append( $" AddParamter(new Paramter(\"P_{att.FIELD_NAME}\", java.sql.Types.{JavaTypesFirebird.GetTypeAtribute(att)}, entidade.get{att.FIELD_NAME}()));{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}"); return(get); }
private StringBuilder GetById() { var nameProc = $"{ParamtersInput.Prefixos.Procedure}S_{NomeTabela.TratarNomeTabela().ToUpper()}_ID"; var get = new StringBuilder(); get.Append($" public {NomeTabela} GetById(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_{ListaAtributosTabela.First().FIELD_NAME}\", java.sql.Types.NUMERIC, id));{N}{N}"); get.Append($" ResultSet rs = super.ExecuteReader();{N}{N}"); get.Append($" if(rs.next()){{{N}"); get.Append($" {NomeTabela} resposta = new {NomeTabela}();{N}"); foreach (var att in ListaAtributosTabela) { get.Append( $" resposta.set{att.FIELD_NAME}(rs.get{JavaTypesFirebird.GetTypeAtribute(att)}(\"{att.FIELD_NAME}\"));{N}"); } get.Append($" return resposta;{N}"); get.Append($" }};{N}"); get.Append($" return null;{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}"); return(get); }
private StringBuilder BodyDelete() { var body = new StringBuilder(); body.Append(Environment.NewLine); var nomeProc = ParamtersInput.Prefixos.Procedure + "D_" + NomeTabela.TratarNomeTabela(); body.Append(AdicionaCabecalho(nomeProc, false, false, true)); body.Append(DeleteBodyInside()); body.Append($"END {nomeProc};" + Environment.NewLine); body.Append(Environment.NewLine); return(body); }
private StringBuilder BodySelect(bool Isall = false) { var body = new StringBuilder(); body.Append(Environment.NewLine); var nomeProc = ParamtersInput.Prefixos.Procedure + "S_" + NomeTabela.TratarNomeTabela() + (Isall ? "" : "_ID"); body.Append(AdicionaCabecalho(nomeProc, false, true, true, Isall)); body.Append(SelectBodyInside(Isall)); body.Append($"END {nomeProc};" + Environment.NewLine); body.Append(Environment.NewLine); return(body); }
private StringBuilder ProceduresNames() { var baseProc = NomeTabela.TratarNomeTabela().ToUpper(); var proc = new StringBuilder(); proc.Append($" private enum Proc{N}"); proc.Append($" {{{N}"); proc.Append($" {baseProc.TratarNomeProcedure(OperationProcedure.Search)},{N}"); proc.Append($" {baseProc.TratarNomeProcedure(OperationProcedure.List)},{N}"); proc.Append($" {baseProc.TratarNomeProcedure(OperationProcedure.Insert)},{N}"); proc.Append($" {baseProc.TratarNomeProcedure(OperationProcedure.Update)},{N}"); proc.Append($" {baseProc.TratarNomeProcedure(OperationProcedure.Delete)}{N}"); proc.Append($" }}{N}"); return(proc); }
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 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 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 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 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: 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 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); }