What really confused me, was I changed the to in my prepared statements. I tried tons of solutions for my code, and no matter what, the output seemed to show the in SQLPro, even though each time I deleted the SQLite file completely, and closed both my application and SQLPro. Sure enough, my prepared statements didn't work originally, and so things like were in the data when viewed in SQLPro. Hope the blog was easy to understand and implement.įeel free to comment if you face any problems or have any suggestions for improvement.I was writing an app using SQLite, and intended to use SQLPro for SQLite to check my work. Now, in the SQLPro window above you will see an another option called Data, situated just beside Schema.Ĭlicking on this option will let you see the data that has been stored in the database, till now. In our case those fields are ZDATE for ZDATE model and ZLATITUDE, ZLONGITUDE and ZLOCATIONFORDATE for ZLOCATION model. What we really need to care about are the fields that we have already been working on. The fields with name Z_PK, Z_ENT, Z_OPT are ones that we will not be emphasizing on for now. If you click on any of the core data models you will get to see their various fields. Z_PRIMARYKEY : Primary key in a database refers to the unique column that has different values for each row and is never null.For more detailed information refer to this link. It is used to define different characteristics of data like type, name, source, access, etc. Z_METADATA : It refers to information about the data or we can say data about the data.In the tables section you will see 4 options : sqlite file and you will see SQLPro window like in below image(in case you are running my sample project) Press enter and you will be redirected to your sqlite file. You will get a path which you need to paste in the field. After that go to ‘finder’ window and press Cmd+Shift+G and in the Go field. Now click on “Open Other” option on SQLPro window. After you open it you will see something like thisīasically, it prompts you to open the sqlite file whose data you want to view.įor finding the file, open ‘terminal’ and type in the following command find ~ -name YourProject.sqliteĪs soon as you press enter, it will print the path for required file, in a matter of seconds. Now download the SQLPro for SQLite Read-Only from app store. Open your Xcode project and run it on your simulator(at least once) so that some data gets stored in the database. If you don’t have one, you can download this sample project. sqlite file.īefore starting, you are going to need a project that has core data implemented in it. In this blog we will show you how to check the data that is being stored in a. It will cost you a few of those hard earned bucks □ For editing purposes you can also refer to SQLPro for SQLite. This can be done easily by SQLPro for SQLite Read-Only, a sqlite database reader in iOS that is available in the iTunes store for free. But there are times when you want to actually see the data that has been stored. Being an essential storage mechanism for sensitive data, everyone needs to know how to work with it, whether it comes to storing, filtering, searching or deleting the information. When it comes to iOS development, almost everyone is familiar with the term Core Data.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |