CODEWITHSUNDEEP
androidsqliteandroid-sqliteandroid-room
Vijayendra
Vijayendra

Reputation: 1949

Android room inserting with a query

I know inserting data into SQlite room library can be done through @Insert annotation, but I (out of curiosity) tried inserting values through SQL statement but Android studio showed me error stating column names can't be resolved. Is it a way of forcing developer to use @Insert annotation or if I am doing something wrong here? Thanks!

Please review following screenshot - enter image description here

Upvotes: 7

Views: 18267

Answers (3)

Paul Aigbokhai Olukayode
Paul Aigbokhai Olukayode

Reputation: 27

@Entity
data class ModulesRoom(
    @PrimaryKey(autoGenerate = false)
    var id: Int = 0,
    var nav: String = "",
    var name: String = "",
    var imageurl: String = ""
)
for List Object
@Insert(onConflict = OnConflictStrategy.REPLACE)
fun saveEmployees(modules: List<ModulesRoom>)

for single obbjet
@Insert(onConflict = OnConflictStrategy.REPLACE)
fun saveEmployees(modules: ModulesRoom)

Ussage 
val mModules = Modules() 
mModules.id = values
mModules.nav = values 
saveEmployees(mModules)

Upvotes: 0

David
David

Reputation: 1

What I am doing is calling getOpenHelper().getWritableDatabase() on the RoomDatabase.

Then you get the SupportSQLiteDatabase object that is essentially the non-Room way.

From that you can call execSQL() or use insert() with table name and ContentValues.

Upvotes: 0

MikeT
MikeT

Reputation: 56938

If you omit the column list that is being highlighted and thus provide values for all columns e.g. :-

@Query("INSERT INTO TestTable VALUES(null,:a,:b)")
List<TestTable> getall(String a, String b, String columna, String columnb);

Android Studio doesn't complain but then you get a compiler error of :-

error: INSERT query type is not supported yet. You can use:SELECT, DELETE, UPDATE

So perhaps better sooner than later.

Upvotes: 3

Related Questions