p32929/androideasysql-library

An Easier & Lazier approach to SQL database for Android

-> My portfolio

https://p32929.github.io/

-> My Github Stats

-> My Gists

https://gist.github.com/p32929/

-> Share My Profile

Share this profile with your friends in just a click

-> Share My Portfolio

Share my portfolio ( https://p32929.github.io/ ) with your friends in just a click

-> Support

If you like my works and want to support me/my works, feel free to support. My payment details can be found here:

-> Thanks

Thanks everyone for visiting my profile. If you are enjoying any of my works, whether it be a library or a template or anything, feel free to let me know. All my contact details can be found here: https://p32929.github.io/

androideasysql-library's Issues

Not working

I am getting this error please help e with this

Is there any need of these SDKs in this lib?

Due to this, the APK size is increased. Should I remove these dependencies?

implementation 'com.android.support:appcompat-v7:26.1.0'
testImplementation 'junit:junit:4.12'
androidTestImplementation 'com.android.support.test:runner:1.0.2'
androidTestImplementation 'com.android.support.test.espresso:espresso-core:3.0.2'

Update not working

Update result always return false...

issue in inserting data

No method for overriding duplicate data

getting an error Exception not an error (code 0 SQLITE_OK)

Hello , i would like to thank you for this great library , i'm using it in my project but i'm facing an issue while trying to save data ,
basically when i try to save the data it throws an error , i tried to fix it but found nothing to fix , if you can help , i'd appreciate it , thank you

• This is the error

E/SQLiteLog: (21) API called with NULL prepared statement
(21) misuse at line 78396 of [0c55d17973]
D/TAG: Exception not an error (code 0 SQLITE_OK)

• This is the code

val easyDB = EasyDB.init(this,"ITEMS_DB")
.setTableName("CART_TABLE")
.addColumn(Column("item_id", *arrayOf("text","unique")))
.addColumn(Column("item_title", *arrayOf("text","not null")))
.addColumn(Column("item_category", *arrayOf("text","not null")))
.addColumn(Column("item_price_each", *arrayOf("text","not null")))
.addColumn(Column("item_price", *arrayOf("text","not null")))
.addColumn(Column("item_quantity", *arrayOf("text","not null")))
.addColumn(Column("product_delivery_fee", *arrayOf("text", "not null")))
.addColumn(Column("country", *arrayOf("text", "not null")))
.addColumn(Column("city", *arrayOf("text", "not null")))
.addColumn(Column("address", *arrayOf("text", "not null")))
.addColumn(Column("state", *arrayOf("text", "not null")))

        val isAdded = easyDB
                .addData("item_id",1)
                .addData("item_title",model.productName)
                .addData("item_category",model.productCategory)
                .addData("item_price_each",model.productPrice)
                .addData("item_price",totalPrice.toString())
                .addData("item_quantity",itemIndex.toString())
                .addData("product_delivery_fee",model.productDeliveryFee)
                .addData("country",country)
                .addData("city",city)
                .addData("address",address)
                .addData("state",state)
                .doneDataAdding()

• I have also tried to seek help on SO , if you would like to take a look

https://stackoverflow.com/questions/67978444/android-sql-database-not-saving-data?noredirect=1#comment120152438_67978444

How I can execute 'where' condition

Like I have a situation where I want to select rows based on one flag (column) .
like typical sql query. select * from table where age=21
how can I do the same in this?