Insert method does not save data

Question

I have an application where the goal (at the moment) is to take the data typed in a form and save in the Database. And the Insert method of my Datasource always returns me false I do not understand why. The process of saving by Controller returns right, but when checking the Insert, it returns false, as in the image below. Everything returns true until I get to that part. I’m more than a week trying to understand why it doesn’t work, I already did, I redid the application, I reviewed source codes to check if everything was okay, nothing seems out of the ordinary (id returns 0 always, data returns certain but not saved). I’ll even send you my gets and sets and the Datamodel.

Gets and sets:

public class Formulario {

    private int id;
    private String titulo;
    private String data;
    private String info;
    private double valor;

    public int getId() {
        return id;
    }

    public void setId(int id) {
        this.id = id;
    }

    public String getTitulo() {
        return titulo;
    }

    public void setTitulo(String titulo) {
        this.titulo = titulo;
    }

    public String getData() {
        return data;
    }

    public void setData(String data) {
        this.data = data;
    }

    public String getInfo() {
        return info;
    }

    public void setInfo(String info) {
        this.info = info;
    }

    public double getValor() {
        return valor;
    }

    public void setValor(double valor) {
        this.valor = valor;
    }
}

Datamodel:

public class FormularioDataModel {

    private final static String TABELA = "financas";

    private final static String id = "id";
    private final static String titulo = "titulo";
    private final static String valor = "valor";
    private final static String data = "data";
    private final static String info = "info";

    private static String queryCriarTabela = "";

    public static String criarTabela() {

        queryCriarTabela = "CREATE TABLE " + TABELA;
        queryCriarTabela += "(";
        queryCriarTabela += id + " INTEGER PRIMARY KEY AUTOINCREMENT, ";
        queryCriarTabela += titulo + " TEXT, ";
        queryCriarTabela += valor + " REAL, ";
        queryCriarTabela += data + " TEXT, ";
        queryCriarTabela += info + " TEXT, ";
        queryCriarTabela += ")";

        return queryCriarTabela;
    }

    public static String getTABELA() {
        return TABELA;
    }

    public static String getId() {
        return id;
    }

    public static String getTitulo() {
        return titulo;
    }

    public static String getValor() {
        return valor;
    }

    public static String getData() {
        return data;
    }

    public static String getInfo() {
        return info;
    }

    public static String getQueryCriarTabela() {
        return queryCriarTabela;
    }

    public static void setQueryCriarTabela(String queryCriarTabela) {
        FormularioDataModel.queryCriarTabela = queryCriarTabela;
    }
}

Datasource:

public class Datasource extends Sqliteopenhelper {

private static final String DB_NAME = "financas.sqlite";
private static final int DB_VERSION = 1;

SQLiteDatabase db;
Cursor cursor;

public DataSource(Context context) {
    super(context, DB_NAME, null, DB_VERSION);

    db = getWritableDatabase();
}

@Override
public void onCreate(SQLiteDatabase db) {

    try{

        db.execSQL(FormularioDataModel.criarTabela());

    }catch (Exception e){
        Log.e("Media", "Log ---> ERRO "+e.getMessage());
    }
}

@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {


}

Answer 1

The error I noticed is in the table creation. The string concatenated (queryCriarTabela) of the method criarTabela() returns this value:

    CREATE TABLE financas (
      id INTEGER PRIMARY KEY AUTOINCREMENT,
      titulo TEXT,
      valor REAL,
      data TEXT,
      info TEXT, // <-- erro
    ); // <-- coloque o ponto e vírgula no final por segurança

This comma at the end does not let the table be created.

REMEMBER

Whenever you make a change to some bank table using the helper, you need to perform one of the actions below:

• Create a drop table if exists from the old table

• Or uninstall and install the application again

I have not found other reasons for failure in table creation. But there may be.

Including, his DataSource in the method onCreate must have caught that exception on this line:

Log.e("Media", "Log ---> ERRO "+e.getMessage());