Print to console db.execSQL on Android

Question

Print to console db.execSQL on Android

Navigation

#1 by (3 votes)

0

How can I get this chain by console? I want to take the console and see if I generate the sentence well. I do not know what parameter to use to load it in the System.out.print

db.execSQL(String.format("CREATE TABLE %s (%s INTEGER PRIMARY KEY AUTOINCREMENT," +
                    "%s TEXT UNIQUE NOT NULL,%s TEXT UNIQUE NOT NULL,%s INTEGER NOT NULL)",
            Tablas.VALOR, MetadatosDB.Valores.ID_VALOR,
            MetadatosDB.Valores.NOMBRE, MetadatosDB.Valores.CODIGO,
            MetadatosDB.Valores.SITUACION));

System.out.println();

android android-sqlite

asked by Eduardo 16.05.2017 в 10:17

source

1 answer

Command to install Symfony 3 on Windows How do I get the context of my table in C # through entity Framework?

score 3 · Accepted Answer

Put the value of the String.format into a variable. So:

String consulta = String.format("CREATE TABLE %s (%s INTEGER PRIMARY KEY AUTOINCREMENT," +
                "%s TEXT UNIQUE NOT NULL,%s TEXT UNIQUE NOT NULL,%s INTEGER NOT NULL)",
        Tablas.VALOR, MetadatosDB.Valores.ID_VALOR,
        MetadatosDB.Valores.NOMBRE, MetadatosDB.Valores.CODIGO,
        MetadatosDB.Valores.SITUACION);

db.execSQL(consulta);
System.out.println(consulta);