public void insertPlaneta(Planeta planeta)
{
string sql = "INSERT INTO planeta (nombre, gravedad) VALUES(?,?)";
using (var statement = con.Prepare(sql)) {
statement.Bind(1, planeta.Nombre);
statement.Bind(2, planeta.Gravity);
statement.Step();
}
}
public void updatePlaneta(Planeta planeta)
{
string sql = "UPDATE planeta SET nombre=?, gravedad = ? WHERE id=?";
using (var statement = con.Prepare(sql))
{
statement.Bind(1, planeta.Nombre);
statement.Bind(2, planeta.Gravity);
statement.Bind(3, planeta.Id);
statement.Step();
}
}
private Planeta getPlanetaWithStatement(ISQLiteStatement statement)
{
Planeta planeta = new Planeta();
planeta.Id = (long)statement[0];
planeta.Nombre = (string)statement[1];
planeta.Gravity = (float)statement[2];
return planeta;
}