How to get max _id value of a SQLite table using Anko with Kotlin?
2
DBRecordTable._ID is a INTEGER + PRIMARY_KEY+ AUTOINCREMENT, I hope to get the max _id value of a table, zero will be return if no data row in the table.
I try to write the code select(tableName,DBRecordTable._ID).orderBy(DBRecordTable._ID, Desc).limit(1), but it's not correct, how can I fix it?
Code
class DBRecordHandler(private val mDBHelper: DBRecordHelper =DBRecordHelper.instance,
private val tableName:String =DBRecordTable.TableNAME,
private val idField:String=DBRecordTable._ID
) {
fun getMaxID():Long=mDBHelper.use{
var myList=select(tableName,DBRecordTable._ID).orderBy(DBRecordTable._ID, Desc).limit(1);
}
}
class DBRecordHelper(mContext: Context = UIApp.instance) : ManagedSQLiteOpenHelper(mContext, DB_NAME, null, DB_VERSION) {
companion object {
const val DB_NAME = "record.db"
const val DB_VERSION = 5
val instance by lazy { DBRecordHelper() }
}
override fun onCreate(db: SQLiteDatabase) {
db.createTable( DBRecordTable.TableNAME , true,
DBRecordTable._ID to INTEGER + PRIMARY_KEY+ AUTOINCREMENT,
DBRecordTable.CreatedDate to INTEGER
)
}
}
android kotlin anko asked Nov 18 '18 at 2:44
HelloCWHelloCW
20542896
add a comment |
2
DBRecordTable._ID is a INTEGER + PRIMARY_KEY+ AUTOINCREMENT, I hope to get the max _id value of a table, zero will be return if no data row in the table.
I try to write the code select(tableName,DBRecordTable._ID).orderBy(DBRecordTable._ID, Desc).limit(1), but it's not correct, how can I fix it?
Code
class DBRecordHandler(private val mDBHelper: DBRecordHelper =DBRecordHelper.instance,
private val tableName:String =DBRecordTable.TableNAME,
private val idField:String=DBRecordTable._ID
) {
fun getMaxID():Long=mDBHelper.use{
var myList=select(tableName,DBRecordTable._ID).orderBy(DBRecordTable._ID, Desc).limit(1);
}
}
class DBRecordHelper(mContext: Context = UIApp.instance) : ManagedSQLiteOpenHelper(mContext, DB_NAME, null, DB_VERSION) {
companion object {
const val DB_NAME = "record.db"
const val DB_VERSION = 5
val instance by lazy { DBRecordHelper() }
}
override fun onCreate(db: SQLiteDatabase) {
db.createTable( DBRecordTable.TableNAME , true,
DBRecordTable._ID to INTEGER + PRIMARY_KEY+ AUTOINCREMENT,
DBRecordTable.CreatedDate to INTEGER
)
}
}
asked Nov 18 '18 at 2:44
HelloCWHelloCW
20542896
try this stackoverflow.com/questions/7064279/…
– Lucefer
Nov 18 '18 at 3:10
Thanks, but I hope to do it using Anko.
– HelloCW
Nov 18 '18 at 5:08
can you try with select(tableName,DBRecordTable._ID).whereargs(SELECT MAX(DBRecordTable._ID) FROM tableName)
– Karan Mer
Nov 20 '18 at 5:41
add a comment |
2
2
2
DBRecordTable._ID is a INTEGER + PRIMARY_KEY+ AUTOINCREMENT, I hope to get the max _id value of a table, zero will be return if no data row in the table.
I try to write the code select(tableName,DBRecordTable._ID).orderBy(DBRecordTable._ID, Desc).limit(1), but it's not correct, how can I fix it?
Code
class DBRecordHandler(private val mDBHelper: DBRecordHelper =DBRecordHelper.instance,
private val tableName:String =DBRecordTable.TableNAME,
private val idField:String=DBRecordTable._ID
) {
fun getMaxID():Long=mDBHelper.use{
var myList=select(tableName,DBRecordTable._ID).orderBy(DBRecordTable._ID, Desc).limit(1);
}
}
class DBRecordHelper(mContext: Context = UIApp.instance) : ManagedSQLiteOpenHelper(mContext, DB_NAME, null, DB_VERSION) {
companion object {
const val DB_NAME = "record.db"
const val DB_VERSION = 5
val instance by lazy { DBRecordHelper() }
}
override fun onCreate(db: SQLiteDatabase) {
db.createTable( DBRecordTable.TableNAME , true,
DBRecordTable._ID to INTEGER + PRIMARY_KEY+ AUTOINCREMENT,
DBRecordTable.CreatedDate to INTEGER
)
}
}
asked Nov 18 '18 at 2:44
HelloCWHelloCW
20542896
DBRecordTable._ID is a INTEGER + PRIMARY_KEY+ AUTOINCREMENT, I hope to get the max _id value of a table, zero will be return if no data row in the table.
I try to write the code select(tableName,DBRecordTable._ID).orderBy(DBRecordTable._ID, Desc).limit(1), but it's not correct, how can I fix it?
Code
class DBRecordHandler(private val mDBHelper: DBRecordHelper =DBRecordHelper.instance,
private val tableName:String =DBRecordTable.TableNAME,
private val idField:String=DBRecordTable._ID
) {
fun getMaxID():Long=mDBHelper.use{
var myList=select(tableName,DBRecordTable._ID).orderBy(DBRecordTable._ID, Desc).limit(1);
}
}
class DBRecordHelper(mContext: Context = UIApp.instance) : ManagedSQLiteOpenHelper(mContext, DB_NAME, null, DB_VERSION) {
companion object {
const val DB_NAME = "record.db"
const val DB_VERSION = 5
val instance by lazy { DBRecordHelper() }
}
override fun onCreate(db: SQLiteDatabase) {
db.createTable( DBRecordTable.TableNAME , true,
DBRecordTable._ID to INTEGER + PRIMARY_KEY+ AUTOINCREMENT,
DBRecordTable.CreatedDate to INTEGER
)
}
}
asked Nov 18 '18 at 2:44
HelloCWHelloCW
20542896
asked Nov 18 '18 at 2:44
HelloCWHelloCW
20542896
asked Nov 18 '18 at 2:44
HelloCWHelloCW
20542896
asked Nov 18 '18 at 2:44
HelloCWHelloCW
20542896
asked Nov 18 '18 at 2:44
HelloCWHelloCW
20542896
20542896
try this stackoverflow.com/questions/7064279/…
– Lucefer
Nov 18 '18 at 3:10
Thanks, but I hope to do it using Anko.
– HelloCW
Nov 18 '18 at 5:08
can you try with select(tableName,DBRecordTable._ID).whereargs(SELECT MAX(DBRecordTable._ID) FROM tableName)
– Karan Mer
Nov 20 '18 at 5:41
add a comment |
try this stackoverflow.com/questions/7064279/…
– Lucefer
Nov 18 '18 at 3:10
Thanks, but I hope to do it using Anko.
– HelloCW
Nov 18 '18 at 5:08
can you try with select(tableName,DBRecordTable._ID).whereargs(SELECT MAX(DBRecordTable._ID) FROM tableName)
– Karan Mer
Nov 20 '18 at 5:41
try this stackoverflow.com/questions/7064279/…
– Lucefer
Nov 18 '18 at 3:10
try this stackoverflow.com/questions/7064279/…
– Lucefer
Nov 18 '18 at 3:10
Thanks, but I hope to do it using Anko.
– HelloCW
Nov 18 '18 at 5:08
Thanks, but I hope to do it using Anko.
– HelloCW
Nov 18 '18 at 5:08
can you try with select(tableName,DBRecordTable._ID).whereargs(SELECT MAX(DBRecordTable._ID) FROM tableName)
– Karan Mer
Nov 20 '18 at 5:41
can you try with select(tableName,DBRecordTable._ID).whereargs(SELECT MAX(DBRecordTable._ID) FROM tableName)
– Karan Mer
Nov 20 '18 at 5:41
add a comment |
1 Answer
1
active
oldest
votes
3
+50
You can find maximum id of the table contents using SQL MAX() function:
private fun getMaxID(): Int {
var maxId = 0
mDBHelper?.use {
select(DBRecordTable.TableNAME, "MAX(${DBRecordTable._ID}) as maxId").exec {
moveToNext()
maxId = getInt(getColumnIndex("maxId"))
}
}
return maxId
}
answered Nov 21 '18 at 5:49
aminographyaminography
5,93821131
You're welcome. As you are usingManagedSQLiteOpenHelper, it is possible to replacemDBHelper?.writableDatabase?.applywithmDBHelper?.useas you did in question content. I have searched inankosource codes (github.com/Kotlin/anko/tree/master/anko/library/static/sqlite/…) and found nothing to do this procedure simpler.
– aminography
Nov 22 '18 at 8:04
add a comment |
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53357438%2fhow-to-get-max-id-value-of-a-sqlite-table-using-anko-with-kotlin%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
3
+50
You can find maximum id of the table contents using SQL MAX() function:
private fun getMaxID(): Int {
var maxId = 0
mDBHelper?.use {
select(DBRecordTable.TableNAME, "MAX(${DBRecordTable._ID}) as maxId").exec {
moveToNext()
maxId = getInt(getColumnIndex("maxId"))
}
}
return maxId
}
answered Nov 21 '18 at 5:49
aminographyaminography
5,93821131
You're welcome. As you are usingManagedSQLiteOpenHelper, it is possible to replacemDBHelper?.writableDatabase?.applywithmDBHelper?.useas you did in question content. I have searched inankosource codes (github.com/Kotlin/anko/tree/master/anko/library/static/sqlite/…) and found nothing to do this procedure simpler.
– aminography
Nov 22 '18 at 8:04
add a comment |
3
+50
You can find maximum id of the table contents using SQL MAX() function:
private fun getMaxID(): Int {
var maxId = 0
mDBHelper?.use {
select(DBRecordTable.TableNAME, "MAX(${DBRecordTable._ID}) as maxId").exec {
moveToNext()
maxId = getInt(getColumnIndex("maxId"))
}
}
return maxId
}
answered Nov 21 '18 at 5:49
aminographyaminography
5,93821131
You're welcome. As you are usingManagedSQLiteOpenHelper, it is possible to replacemDBHelper?.writableDatabase?.applywithmDBHelper?.useas you did in question content. I have searched inankosource codes (github.com/Kotlin/anko/tree/master/anko/library/static/sqlite/…) and found nothing to do this procedure simpler.
– aminography
Nov 22 '18 at 8:04
add a comment |
3
+50
3
+50
3
+50
You can find maximum id of the table contents using SQL MAX() function:
private fun getMaxID(): Int {
var maxId = 0
mDBHelper?.use {
select(DBRecordTable.TableNAME, "MAX(${DBRecordTable._ID}) as maxId").exec {
moveToNext()
maxId = getInt(getColumnIndex("maxId"))
}
}
return maxId
}
answered Nov 21 '18 at 5:49
aminographyaminography
5,93821131
You can find maximum id of the table contents using SQL MAX() function:
private fun getMaxID(): Int {
var maxId = 0
mDBHelper?.use {
select(DBRecordTable.TableNAME, "MAX(${DBRecordTable._ID}) as maxId").exec {
moveToNext()
maxId = getInt(getColumnIndex("maxId"))
}
}
return maxId
}
answered Nov 21 '18 at 5:49
aminographyaminography
5,93821131
edited Nov 22 '18 at 7:58
answered Nov 21 '18 at 5:49
aminographyaminography
5,93821131
answered Nov 21 '18 at 5:49
aminographyaminography
5,93821131
answered Nov 21 '18 at 5:49
aminographyaminography
5,93821131
5,93821131
You're welcome. As you are usingManagedSQLiteOpenHelper, it is possible to replacemDBHelper?.writableDatabase?.applywithmDBHelper?.useas you did in question content. I have searched inankosource codes (github.com/Kotlin/anko/tree/master/anko/library/static/sqlite/…) and found nothing to do this procedure simpler.
– aminography
Nov 22 '18 at 8:04
add a comment |
You're welcome. As you are usingManagedSQLiteOpenHelper, it is possible to replacemDBHelper?.writableDatabase?.applywithmDBHelper?.useas you did in question content. I have searched inankosource codes (github.com/Kotlin/anko/tree/master/anko/library/static/sqlite/…) and found nothing to do this procedure simpler.
– aminography
Nov 22 '18 at 8:04
You're welcome. As you are using
ManagedSQLiteOpenHelper, it is possible to replace mDBHelper?.writableDatabase?.apply with mDBHelper?.use as you did in question content. I have searched in anko source codes (github.com/Kotlin/anko/tree/master/anko/library/static/sqlite/…) and found nothing to do this procedure simpler.– aminography
Nov 22 '18 at 8:04
You're welcome. As you are using
ManagedSQLiteOpenHelper, it is possible to replace mDBHelper?.writableDatabase?.apply with mDBHelper?.use as you did in question content. I have searched in anko source codes (github.com/Kotlin/anko/tree/master/anko/library/static/sqlite/…) and found nothing to do this procedure simpler.– aminography
Nov 22 '18 at 8:04
add a comment |
draft saved
draft discarded
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53357438%2fhow-to-get-max-id-value-of-a-sqlite-table-using-anko-with-kotlin%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
try this stackoverflow.com/questions/7064279/…
– Lucefer
Nov 18 '18 at 3:10
Thanks, but I hope to do it using Anko.
– HelloCW
Nov 18 '18 at 5:08
can you try with select(tableName,DBRecordTable._ID).whereargs(SELECT MAX(DBRecordTable._ID) FROM tableName)
– Karan Mer
Nov 20 '18 at 5:41