开发者

How to import google app engine sqlite datafile?

开发者 https://www.devze.com 2023-03-10 19:38 出处:网络
I have downloaded one of my entities from Google App Engine using the remote API and their appcfg.py script.Now I have a file that looks to be a mix of binary and text.(That is, I recognize words like

I have downloaded one of my entities from Google App Engine using the remote API and their appcfg.py script. Now I have a file that looks to be a mix of binary and text. (That is, I recognize words like create table and my field names, but the file is about 50% un开发者_运维问答printable characters.)

Now I would like to import that file (users.sqlite) into an sqlite database on my computer (Mac OSX), but I can't quite seem to figure out how to do so.

Sample (failed) transcript follows:

sqlite> .import users.sqlite users
Error: no such table: users
sqlite> .import users.sqlite
Error: unknown command or invalid arguments:  "import". Enter ".help" for help
sqlite> .restore users users.sqlite
Error: cannot open "users.sqlite"
sqlite> 

I've attached a screenshot of the first portion of my datafile (displayed in TextMate with "show invisibles" on) to show what I mean about mixed text & binary.

Any hints?

Thanks!


users.sqlite is an SQLite database. Your data is stored in it as entities - serialized Protocol Buffers in App Engine's internal format - however. If you need to access your data directly, you're better off downloading it as CSV.

0

精彩评论

暂无评论...
验证码 换一张
取 消