private StringBuilder GetAll() { var get = new StringBuilder(); get.Append($" public List<{NomeTabela}> GetAll(int id) 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(Package, Proc.S, \"SOURCE\");{N}"); get.Append($" AddParamter(new Parameter(\"ID\", PostgreTypes.NUMBER, ID));{N}{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.COLUMN_NAME}(rs.get{JavaTypesPostgre.GetTypeAtribute(att)}(\"{att.COLUMN_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 Add() { var get = new StringBuilder(); get.Append($" public void Add({NomeTabela} entidade) throws Exception{N}"); get.Append($" {{{N}"); get.Append($" try{{{N}"); get.Append( $" PreparedStatement conn = BeginNewStatement(\"INSERT INTO {NomeTabela} ({string.Join(", ", ListaAtributosTabela.Where(e => e.COLUMN_NAME != ListaAtributosTabela.First().COLUMN_NAME).Select(e => e.COLUMN_NAME))}) values ({string.Join(", ", ListaAtributosTabela.Where(e => e.COLUMN_NAME != ListaAtributosTabela.First().COLUMN_NAME).Select(q => "?"))})\");{N}"); for (var index = 1; index < ListaAtributosTabela.Count; index++) { var att = ListaAtributosTabela[index]; get.Append( $" conn.set{JavaTypesPostgre.GetTypeAtribute(att).ToFirstCharToUpper()}({index}, entidade.get{att.COLUMN_NAME.ToFirstCharToUpper()}());{N}"); } get.Append($" conn.execute();{N}"); get.Append($" commit();{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 GetAll() { 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($" PreparedStatement conn = BeginNewStatement(\"SELECT * FROM {NomeTabela}\");{N}"); get.Append($" ResultSet rs = conn.executeQuery();{N}"); get.Append($" while(rs.next()){{{N}"); get.Append($" {NomeTabela} resposta = new {NomeTabela}();{N}"); foreach (var att in ListaAtributosTabela) { get.Append( $" resposta.set{att.COLUMN_NAME.ToFirstCharToUpper()}(rs.get{JavaTypesPostgre.GetTypeAtribute(att).ToFirstCharToUpper()}(\"{att.COLUMN_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 GetById() { var get = new StringBuilder(); get.Append($" public {NomeTabela} GetById(int ID) throws Exception{N}"); get.Append($" {{{N}"); get.Append($" try{{{N}"); get.Append( $" PreparedStatement conn = BeginNewStatement(\"SELECT * FROM {NomeTabela} WHERE {ListaAtributosTabela.First().COLUMN_NAME} =\"+ ID);{N}"); get.Append($" ResultSet rs = conn.executeQuery();{N}"); get.Append($" if(rs.next()){{{N}"); get.Append($" {NomeTabela} resposta = new {NomeTabela}();{N}"); foreach (var att in ListaAtributosTabela) { get.Append( $" resposta.set{att.COLUMN_NAME.ToFirstCharToUpper()}(rs.get{JavaTypesPostgre.GetTypeAtribute(att).ToFirstCharToUpper()}(\"{att.COLUMN_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 AtributosBody(List <PostgreEntidadeTabela> entidadeTabela) { var atributoBody = new StringBuilder(); foreach (var att in entidadeTabela) { atributoBody.Append($" /** {N}"); atributoBody.Append($" * {N}"); atributoBody.Append($" * @return {N}"); atributoBody.Append($" * @Descrição {att.COLUMN_COMMENT} {N}"); atributoBody.Append($" */{N}"); atributoBody.Append( $" public {JavaTypesPostgre.GetTypeAtribute(att)} get{att.COLUMN_NAME.ToFirstCharToUpper()}() {{{N}"); atributoBody.Append($" return {att.COLUMN_NAME};{N}"); atributoBody.Append($" }}{N}"); atributoBody.Append($"{N}"); atributoBody.Append( $" public void set{att.COLUMN_NAME.ToFirstCharToUpper()}({JavaTypesPostgre.GetTypeAtribute(att)} {att.COLUMN_NAME}) {{{N}"); atributoBody.Append($" this.{att.COLUMN_NAME} = {att.COLUMN_NAME};{N}"); atributoBody.Append($" }}{N}"); atributoBody.Append($"{N}"); } return(atributoBody); }
private StringBuilder AtributosHeader(List <PostgreEntidadeTabela> entidadeTabela) { var atributosHeader = new StringBuilder(); foreach (var att in entidadeTabela) { atributosHeader.Append($" private {JavaTypesPostgre.GetTypeAtribute(att)} {att.COLUMN_NAME};{N}"); } atributosHeader.Append($"{N}"); return(atributosHeader); }
private StringBuilder Add() { var get = new StringBuilder(); get.Append($" public RequestMessageLite<String> Add({NomeTabela} entidade) throws Exception{N}"); get.Append($" {{{N}"); get.Append($" try{{{N}"); get.Append($" BeginNewStatement(Package, Proc.I, \"SOURCE\");{N}"); get.Append($" AddParamter(new Parameter(\"P_RESULT\", PostgreTypes.VARCHAR, null,\"OUT\"));{N}{N}"); foreach (var att in ListaAtributosTabela) { get.Append( $" AddParamter(new Parameter(\"P_{att.COLUMN_NAME}\", PostgreTypes.{JavaTypesPostgre.GetTypeAtribute(att)}, entidade.get{att.COLUMN_NAME}()));{N}"); } get.Append($" return 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); }