te')); return $arr; } /* 遍历用户所有主题 * @param $uid 用户ID * @param int $page 页数 * @param int $pagesize 每页记录条数 * @param bool $desc 排序方式 TRUE降序 FALSE升序 * @param string $key 返回的数组用那一列的值作为 key * @param array $col 查询哪些列 */ function thread_tid_find_by_uid($uid, $page = 1, $pagesize = 1000, $desc = TRUE, $key = 'tid', $col = array()) { if (empty($uid)) return array(); $orderby = TRUE == $desc ? -1 : 1; $arr = thread_tid__find($cond = array('uid' => $uid), array('tid' => $orderby), $page, $pagesize, $key, $col); return $arr; } // 遍历栏目下tid 支持数组 $fid = array(1,2,3) function thread_tid_find_by_fid($fid, $page = 1, $pagesize = 1000, $desc = TRUE) { if (empty($fid)) return array(); $orderby = TRUE == $desc ? -1 : 1; $arr = thread_tid__find($cond = array('fid' => $fid), array('tid' => $orderby), $page, $pagesize, 'tid', array('tid', 'verify_date')); return $arr; } function thread_tid_delete($tid) { if (empty($tid)) return FALSE; $r = thread_tid__delete(array('tid' => $tid)); return $r; } function thread_tid_count() { $n = thread_tid__count(); return $n; } // 统计用户主题数 大数量下严谨使用非主键统计 function thread_uid_count($uid) { $n = thread_tid__count(array('uid' => $uid)); return $n; } // 统计栏目主题数 大数量下严谨使用非主键统计 function thread_fid_count($fid) { $n = thread_tid__count(array('fid' => $fid)); return $n; } ?>javascript - IndexedDB: how to reseedreset auto-increment key to 0 (or 1) - Stack Overflow

科技改变生活-雨落星辰 - 所有的伟大,都源于一个勇敢的开始

    最新消息：雨落星辰是一个专注网站SEO优化、网站SEO诊断、搜索引擎研究、网络营销推广、网站策划运营及站长类的自媒体原创博客
    你的位置： 首页>programmer>javascript - IndexedDB: how to reseedreset auto-increment key to 0 (or 1) - Stack Overflow

    javascript - IndexedDB: how to reseedreset auto-increment key to 0 (or 1) - Stack Overflow

    programmeradmin4浏览0评论

    Simple question, but I haven't been able to find an answer.

    How can I reset an object store in IndexedDB so the auto-increment key starts at 0 (or 1) again?

    I am using IDBWrapper currently, but could use an alternative library if it is easier. I am using in-line keys.

    From here:

    If you need to clear the store from all stored entries, you can use the clear method. Note that this won’t reset Chrome’s autoIncrement counter.

    If I manually clear the object store in Chrome Developer tools, this does not reset the key to 0 (or 1).

    I did find this rejected bug: .cgi?id=635551 and from there, this outline of key generation:

    Presumably I could write my own logic to remember when the store was last cleared and then alter the code where records are inserted to manually override the key to be 0 (or 1), but is this really necessary?

    Simple question, but I haven't been able to find an answer.

    How can I reset an object store in IndexedDB so the auto-increment key starts at 0 (or 1) again?

    I am using IDBWrapper currently, but could use an alternative library if it is easier. I am using in-line keys.

    From here: http://jensarps.de/2011/11/25/working-with-idbwrapper-part-1

    If you need to clear the store from all stored entries, you can use the clear method. Note that this won’t reset Chrome’s autoIncrement counter.

    If I manually clear the object store in Chrome Developer tools, this does not reset the key to 0 (or 1).

    I did find this rejected bug: https://bugzilla.mozilla/show_bug.cgi?id=635551 and from there, this outline of key generation: http://www.w3/TR/2012/WD-IndexedDB-20120524/#key-generator-concept

    Presumably I could write my own logic to remember when the store was last cleared and then alter the code where records are inserted to manually override the key to be 0 (or 1), but is this really necessary?

    • javascript
    • indexeddb
    Share Improve this question edited Sep 6, 2013 at 8:21 Adam Marshall asked Sep 6, 2013 at 8:15 Adam MarshallAdam Marshall 3,0099 gold badges47 silver badges82 bronze badges
    Add a ment  | 

    3 Answers 3

    Reset to default 11

    You can't reset the generator, without deleting and recreating the object store.

    As noted in https://w3c.github.io/IndexedDB/#key-generator-construct the maximum generated key is 9007199254740992 and:

    If you generate a new key 1000 times per second day and night, you won’t run into this limit for over 285000 years.

    According to spec, generated key value can be anything depending on browser implementation. Your code should not rely on it.

    You can't reset the generator, without deleting and recreating the object store. https://github./Tesfaye-Eshetie/reusable-ment-ponent/blob/store-ments-IndexedDB/js/idb/indexedDB.js

    与本文相关的文章

    发布评论

    评论列表(0)

    1. 暂无评论