{"type":"rich","width":"100%","blog_url":"https://memory-lovers.blog/","provider_name":"Hatena Blog","height":"190","author_name":"wannabe-jellyfish","author_url":"https://blog.hatena.ne.jp/wannabe-jellyfish/","provider_url":"https://hatena.blog","categories":["Android","adb","Sqlite3"],"html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fmemory-lovers.blog%2Fentry%2F2019%2F02%2F26%2F154818\" title=\"Android\u306eEmulator\u306b\u5165\u3063\u3066SQLite3\u3067DB\u306e\u4e2d\u3092\u307f\u3066\u307f\u308b - \u304f\u3089\u3052\u306b\u306a\u308a\u305f\u3044\u3002\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","blog_title":"\u304f\u3089\u3052\u306b\u306a\u308a\u305f\u3044\u3002","title":"Android\u306eEmulator\u306b\u5165\u3063\u3066SQLite3\u3067DB\u306e\u4e2d\u3092\u307f\u3066\u307f\u308b","published":"2019-02-26 15:48:18","url":"https://memory-lovers.blog/entry/2019/02/26/154818","description":"Android\u306eEmulator\u306b\u5165\u3063\u3066SQLite3\u3067DB\u306e\u4e2d\u8eab\u3092\u307f\u308b\u3068\u304d\u306e\u5099\u5fd8\u9332\u3002 \u3072\u3055\u3073\u3055\u306bDB\u306e\u30de\u30a4\u30b0\u30ec\u30fc\u30b7\u30e7\u30f3\u3092\u3059\u308b\u3068\u304d\u306b\u3001\u4eca\u3069\u3046\u3060\u3063\u3051\uff1f\u3092\u898b\u305f\u304b\u3063\u305f\u304c\u3001 \u3084\u308a\u65b9\u5fd8\u308c\u3066\u305f\u306e\u3067\u3001\u305d\u306e\u6642\u306e\u30e1\u30e2 Emulator\u306b\u30ed\u30b0\u30a4\u30f3 $ adb shell \u30a2\u30d7\u30ea\u306e\u6a29\u9650\u306b\u5909\u66f4 $ run-as <package-name> db\u306e\u4e2d\u3092\u898b\u308b $ sqlite3 database/<database-file-name>.db # \u30c6\u30fc\u30d6\u30eb\u540d\u306e\u4e00\u89a7\u3092\u8868\u793a sqlite> .table # \u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e\u60c5\u5831\u3092\u8868\u793a sqlite> .dbinfo ... text encoding: 1 (utf8) u\u2026","image_url":null,"version":"1.0"}