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);
}
