private StringBuilder Delete() { var get = new StringBuilder(); get.Append($" delete: (id) => {{ {N}"); get.Append( $" return Firebird.executeString(`DELETE FROM {NomeTabela.ToLower()} WHERE {ListaAtributosTabela.First().FIELD_NAME} = ${{id}}`);{N}"); get.Append($" }},{N}"); return(get); }
private StringBuilder Update() { var get = new StringBuilder(); get.Append($" update: (body) => {{ {N}"); get.Append( $" return Firebird.executeObject(`UPDATE {NomeTabela.ToLower()} SET ? WHERE {ListaAtributosTabela.First().FIELD_NAME} = ${{body.{ListaAtributosTabela.First().FIELD_NAME}}}`, {parametrosQuery(true)});{N}"); get.Append($" }},{N}"); return(get); }
private StringBuilder Add() { var get = new StringBuilder(); get.Append($" insert: (body) => {{ {N}"); get.Append( $" return Firebird.executeObject(`INSERT INTO {NomeTabela.ToLower()} SET ?`, {parametrosQuery(false)});{N}"); get.Append($" }},{N}"); return(get); }
private StringBuilder GetAll() { var get = new StringBuilder(); get.Append($" getAll: () => {{{N}"); get.Append($" return new Promise((resolve, reject) => {{{N}"); get.Append($" mysql.executeString({baseDb}, \"SELECT * FROM {NomeTabela.ToLower()} \",{N}"); get.Append($" (err, result) => err ? reject(err) : resolve(result));{N}"); get.Append($" }});{N}"); get.Append($" }},{N}"); return(get); }
private StringBuilder Delete() { var get = new StringBuilder(); get.Append($" delete: (id) => {{ {N}"); get.Append($" return new Promise((resolve, reject) => {{{N}"); get.Append( $" mysql.executeString({baseDb}, \"DELETE FROM {NomeTabela.ToLower()} WHERE {ListaAtributosTabela.First().COLUMN_NAME} =\" + id,{N}"); get.Append($" (err, result) => err ? reject(err) : resolve(result));{N}"); get.Append($" }});{N}"); get.Append($" }},{N}"); return(get); }
private StringBuilder Update() { var get = new StringBuilder(); get.Append($" update: (body) => {{ {N}"); get.Append($" return new Promise((resolve, reject) => {{{N}"); get.Append( $" mysql.execute({baseDb}, \"UPDATE {NomeTabela.ToLower()} SET ? WHERE {ListaAtributosTabela.First().COLUMN_NAME} =\" + body.{ListaAtributosTabela.First().COLUMN_NAME}, {parametrosQuery(true)},{N}"); get.Append($" (err, result) => err ? reject(err) : resolve(result));{N}"); get.Append($" }});{N}"); get.Append($" }},{N}"); return(get); }
private StringBuilder Add() { var get = new StringBuilder(); get.Append($" insert: (body) => {{ {N}"); get.Append($" return new Promise((resolve, reject) => {{{N}"); get.Append( $" mysql.execute({baseDb}, \"INSERT INTO {NomeTabela.ToLower()} SET ?\", {parametrosQuery(false)},{N}"); get.Append($" (err, result) => err ? reject(err) : resolve(result));{N}"); get.Append($" }});{N}"); get.Append($" }},{N}"); return(get); }
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, NomeTabela.ToLower(), parametrosQuery(false), parametrosQuery(false), ListaAtributosTabela.First().COLUMN_NAME); return(p); }
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); }