Index

A

  1. ANALYZE statement

  2. attachDatabase function

  3. ATTACH DATABASE statement

  4. ATTACH SQLite functionality

B

  1. Backup API

    1. BackupBridge file

    2. bridge interface

    3. FileManager

    4. in-memory databases

    5. on-disk operation

    6. sqlite library

    7. Swift Compiler Build settings

    8. UI building

    9. View Application project

    10. ViewController

C

  1. cellForRowAt

  2. Chinook_SQLite.sqlite database

  3. Collation sequences

    1. BINARY collation

    2. NoCase collation

    3. RTRIM type

    4. sqlite3_create_collation function

  4. Controllers

    1. buildSchema

    2. FirstViewController

    3. init function

    4. insertWineRecord function

    5. insertWineryRecord function

    6. photo capture function

      1. imagePickerController function

      2. insertRecordAction

      3. UISlider

      4. viewDidLoad function

      5. wineRating function

    7. SecondViewController

    8. WineryDAO class

  5. copyDatabaseIntoDocuments function

  6. createDatabase function

  7. createOrOpenDatabase function

  8. CROSS JOIN

D

  1. Data model

    1. database schema

    2. wineries database

      1. documentDirectory

      2. SearchPathDirectory

      3. types

  2. DbMgrDAO controller

    1. contentsOfDirectoryAtURL method

    2. COpaquePointer

    3. DetailViewController

    4. executeQuery function

    5. initViewIndex function

    6. NSFileManager class

    7. NSFileManager.defaultManage classr

    8. openSQliteDatabase function

    9. populateIndexView function

    10. preparedStatement

    11. sqlite3_column_text method

    12. stringByReplacingOccurencesOfString

    13. TableView

    14. viewDidLoad function

  3. Db Swift class

    1. CREATE TABLE statement

    2. Enums class

    3. executeQuery method

    4. insert statement

    5. selectDbSchemaListByType method

    6. selectDbSchemaStructure method

    7. tableDef

  4. db_to_attach_path variable

  5. DELETE function

    1. collation sequences

    2. DELETE statement

    3. indices

    4. LIMITS clause

    5. sampleDelete function

    6. tables

    7. TRIGGER

    8. views

    9. WHERE clause

    10. Winery app

      1. Cellar TableView

      2. commitEditingStyle

      3. deleteRowsAtIndexPaths

      4. deleteWineRecord

      5. Edit mode

      6. UITableView

      7. UITableViewCellEditingStyle

      8. ViewControllers

      9. viewDidLoad method

      10. Wineries TableView

      11. WineryDAO Class

      12. WineryListTableController

  6. dequeueReusableCellWithIdentifier

  7. detachDatabase function

  8. DETACH SQLite functionality

  9. DETACH statement

  10. DetailViewController

    1. createDbButton

    2. dbStatusMsg

    3. detailSQLiteQueryField method

    4. @IBAction Buttons

    5. openSQLiteDatabase method

    6. prepareForSeque

    7. viewDidLoad function

    8. viewWillAppear function

E

  1. executeQuery function

F

  1. FileManager

G, H

  1. getDatabasePath function

I, J, K

  1. IBAction

  2. IBOutlets

  3. Index

    1. DROP INDEX

    2. UNIQUE INDEX

  4. INNER JOIN

  5. INSERT statement

    1. ABORT clause

    2. blobs

    3. data-binding functions

    4. DocumentDirectory

    5. IGNORE clause

    6. last clause

    7. NSFileManager

    8. NSSearchPathDirectory

    9. NSSearchPathForDirectoriesInDomains

    10. records

    11. REPLACE statements

    12. rollback

  6. iOS app

    1. Create Bridge interface

    2. database creation

    3. project creation

    4. SQLiteSearchBridge

    5. UISearchBar

    6. ViewController

    7. project creation

      1. AppDelegate application

      2. bundle

      3. database

      4. didFinishLaunchWithOption

      5. documents directory

      6. finder

      7. Master-Detail template

      8. resources

L

  1. LIMITS clause

M

  1. MasterViewController

    1. cellForRowAtIndexPath

    2. numberOfRowsInSection

    3. schemaDetailsItems

    4. segue

    5. titleForHeaderInSection

    6. UITableView component

    7. unWindFromSegue function

    8. viewDidLoad function

N

  1. NSObject + SQLiteSearchBridge

  2. numberOfRowsInSection

O

  1. OUTER JOIN

P, Q

  1. PRAGMA database

  2. Pragma statements

    1. automatic_index

    2. auto-vacuum

    3. busy timeout

    4. foreign_key_check

    5. Foreign_key_list

    6. integrity_check

    7. shrink_memory

  3. Prototype

R

  1. REPLACE statements

  2. RTRIM type

S

  1. searchBarCancelButtonClicked method

  2. searchBarSearchButtonClicked method

  3. searchDatabase function

  4. searchResultCellTableViewCell

  5. SELECT statement

    1. cross join

    2. data-type binding functions

    3. display images

    4. IBOutlets

    5. inner join

    6. list of records

    7. MPMoviePlayerController

    8. navigation controllers

    9. outer join

    10. playback audio records

    11. selectWineList function

    12. selectWineriesList function

    13. SelectWineries UIPicker

    14. selectWineryByName function

    15. SQLITE_ROW constant

    16. TableViewControllers

    17. UIPickerView function

    18. UITableViewController

    19. using sub query

    20. ViewController function

    21. WHERE clause

    22. WineListTableViewController

    23. Wineries UIPickerView

    24. WineryListTableViewController

  6. setDbPath function

  7. sqldiff

  8. SQLite functions

    1. corrupt

    2. JSON functions

    3. limits

    4. sqlite3_analyzer

    5. sqlite3_enable_load_extension

    6. sqlite3_exec function

    7. sqlite3_load_extension

    8. using Swift

      1. build phases

      2. compile sources

      3. header File

      4. sizeconverter

      5. sqlite3_user_data() function

      6. values

  9. SQLite library

  10. SQLITE_LIMIT_ATTACHED

  11. SQLite Manager

  12. SQLite Manager, firefox

    1. Db Settings

    2. directory selector

    3. index

      1. definition

      2. sqlite_autoindex_book

    4. menu option

    5. Sqlite_master

      1. browse & search

      2. schema

    6. sqlite_sequence

      1. ATTACH command

      2. AUTOINCREMENT property

      3. DETACH command

      4. ROWINDEX

    7. tables and columns

      1. definition

      2. dropping

      3. INSERT/UPDATE

      4. primary key

      5. re-indexing

      6. table name

    8. terminal

    9. tools menu

    10. trigger

    11. view

      1. CREATE VIEW

      2. select statement

    12. windows command

  13. SQLiteSearch-Bridging-Header

  14. SQLITE_TRANSIENT

  15. Storyboard

  16. Swift iOS application

    1. add SQLite 3 library

    2. bridge

      1. header file

      2. Swift compiler

    3. DetailViewController

    4. MasterViewController

    5. wrapper functions

      1. DbMgrDAO class

      2. executeQuery function

      3. init function

T

  1. Tables, modification

    1. add columns

    2. ALTER command

    3. DROP command

    4. foreign keys

    5. REINDEX command

    6. RENAME command

    7. UPDATE command

  2. Triggers

U

  1. UIButtons

    1. Assistant Editor

    2. Attributes inspector

    3. detailSQLiteQueryField

    4. @IBActions

    5. Interface Builder

    6. repeat process

  2. UIPickerView

  3. UITableViewCell

  4. umberOfSectionsInTableView

  5. UPDATE statement

    1. ABORT option

    2. CityTemperature table

    3. FAIL option

    4. FirstViewController

    5. IBOutlets

    6. IGNORE option

    7. JOIN

    8. Lamartine wine

    9. ON CONFLICT

    10. OR clauses

    11. Pl/SQL/T-SQL

    12. REPLACE option

    13. ROLLBACK

    14. SQLITE_DONE

    15. SQLITE_OK

    16. sub-query

    17. Swift String constant

    18. UI fields

    19. updateRecords method

    20. WHERE clause

    21. wineries

    22. wines list

    23. wineyDAO class

      1. columns updation

      2. segue.destinationViewController

      3. showWineDetail segue

      4. WineListTableViewController

      5. WineryListTableViewController

V

  1. viewDidLoad function

  2. Views, modification

W, X, Y, Z

  1. Winery application

    1. add bridge

    2. constraints

    3. creation

    4. data model

    5. imageView

    6. UI components

    7. view controller

  2. Winery database

    1. CRUD operations

      1. createDbButton function

      2. detailSQLiteQueryField

    2. openSQLiteDatabase

    3. table creation

    4. view creation

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset