Last active
January 4, 2016 21:39
-
-
Save dmzza/8682397 to your computer and use it in GitHub Desktop.
Getting to the sqlite console for the iPhone Simulator
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| cd ~/Library/; cd 'Application Support'; cd 'iPhone Simulator'; cd 7.1-64/Applications; ls -l; | |
| returns this: | |
| drwxr-xr-x@ 6 david staff 204 Jan 26 08:21 1E58656A-CF95-4EB2-B69B-2C278EA3E135 | |
| drwxr-xr-x@ 6 david staff 204 Jan 26 08:21 67742A6D-A627-4854-9901-AB44C7AB6757 | |
| drwxr-xr-x@ 6 david staff 204 Jan 26 08:21 AD33D807-54A2-4CF8-9F18-7BD976E2A5FC | |
| drwxr-xr-x@ 6 david staff 204 Jan 26 08:21 B3880242-ADEF-480B-8114-490FFCA37401 | |
| drwxr-xr-x@ 6 david staff 204 Jan 26 08:21 CC26D5B4-3200-4C0F-97BB-8D485CB4B3A9 | |
| drwxr-xr-x@ 6 david staff 204 Jan 29 00:19 DC73DACE-6141-4D69-9CDC-9B02002F62FB | |
| drwxr-xr-x@ 6 david staff 204 Jan 26 08:21 EE57B12B-DFDE-4AD7-90FE-417689922D0E | |
| search for the one with your .sqlite file using the first characters of each folder in this command: | |
| cd 1E*/Documents; ls -l; cd ../..; | |
| Fastest way is to type "cd 1E" and then paste: */Documents; ls -l; cd ../..; | |
| Once in the directory: | |
| sqlite3 FileName.sqlite | |
| Some usefule sqlite commands: | |
| > .tables | |
| > .headers ON | |
| > SELECT * FROM ZTABLENAME | |
| > PRAGMA main.wal_checkpoint |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment