![]() ![]() ![]() I’ve database enable the AppDelegate class and added the SQLite engine in the project’s Frameworks folder. – (NSMutableArray *)fetchPhotosByAlbum:(int)albumId- (NSMutableArray *)fetchAlbums- (NSMutableArray *)joinQuery- (NSArray *)fetchVideoByTitle:(NSString *)title – (NSString *)docPath- (void)openDatabase- (void)closeDatabase- (NSMutableArray *)fetchAllVideos They are for interacting with the application’s database file. I’ve set up these methods in the AppDelegate class files. In this workshop, we’ll fetch records only from the photos and and albums table.įigure 1: Tables in the vintageDatabase.sqlite Use Finder to replace the sandbox’s database file with the one you downloaded. The database file contain tables shown in Figure 1 below. Now, run the SqliteJoinQuery application in the simulator. You’ll have to download and unzip this file. When you run the application for the first time, it will create a an empty database in the application’s sandbox’s Documents fold. Upon completion, the SqliteJoinQuery application will automatically rotate photos in the view’s Image View control for the category name you select from the Picker View control. I used Xcode’s Single View Application to create the application. Overview of The SqliteJoinQuery Application In last week’s workshop, you learned about three JOIN queries supported by the SQLite engine and they are: INNER JOIN, LEFT OUTER JOIN, and CROSS JOIN. In this workshop, you will learn how to perform an INNER JOIN in an Xcode project I’ve created for this workshop. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |