Use of SQLite framework Made By MySelf...

Hello All ,

As we know use of SQLite in App is too much complicated and time consuming to all of us. Creating Files every time, Add Sqlite Framework and do lots of code debug..Bla..Bla..Bla..

For That Purpose I made my Own framework , Which will do all the Sqlite Stuffs easily.

Is it Right ?

Surely It is right. You Have to just add it into your Project and Do Some Basic Steps.And Your App with Sqlite DB is ready to use. No need to maintain Model Class and All.

Step 1 - Download Framework From This Link.

Step 2 - Drag And Drop This Framework to your App. Dont Forget to check it Copy.

Step 3 - Go to Project > General > Linked Framework And Libraries

Step 4 - Select Sqlite Framework And Remove it.

Step 5 - Just Above There is Embeded Binaries Just Click "+" there and Add SQLiteFramework.

Step 6 - As you add it you will see it in Both Boxes.

Step 7 - All is Set Now . Now How To Use it Just Import Framework in your file and Write Code. For Demo I have Written Some Code Below.

In Objective C =>

       

    // Initialize Database With Faile Name
    [[SQLite sharedInstance] createDatabaseWithFileNameWithNoExtension:@"DB"];
    
    // Create Database
    [[SQLite sharedInstance] executeQuery:@"CREATE TABLE PROPERTIES ( PROPERTY_ID INTEGER PRIMARY KEY,PROPERTY_NAME TEXT NOT NULL);"];
    
    //Insert Query
    [[SQLite sharedInstance] executeQuery:@"INSERT INTO PROPERTIES ( PROPERTY_ID,PROPERTY_NAME) VALUES( '1','Sagar')"];
    [[SQLite sharedInstance] executeQuery:@"INSERT INTO PROPERTIES ( PROPERTY_ID,PROPERTY_NAME) VALUES( '2','Chandan')"];
    [[SQLite sharedInstance] executeQuery:@"INSERT INTO PROPERTIES ( PROPERTY_ID,PROPERTY_NAME) VALUES( '3','Vishal')"];
    [[SQLite sharedInstance] executeQuery:@"INSERT INTO PROPERTIES ( PROPERTY_ID,PROPERTY_NAME) VALUES( '4','Akash')"];
    [[SQLite sharedInstance] executeQuery:@"INSERT INTO PROPERTIES ( PROPERTY_ID,PROPERTY_NAME) VALUES( '5','Rushi')"];
    
    // Update Query
    [[SQLite sharedInstance] executeQuery:@"INSERT OR REPLACE INTO PROPERTIES ( PROPERTY_ID,PROPERTY_NAME) VALUES( 'Paa','Rushi')"];
    
    //Delete Query
    [[SQLite sharedInstance] executeQuery:@"DELETE FROM PROPERTIES WHERE PROPERTY_NAME = 'Vishal'"];
    
    
    // Get The data from Database
    NSArray * arr = [[SQLite sharedInstance] getDataFromQuery:@"SELECT * FROM PROPERTIES"];
    

       
 

In Swift 2.0 =>

        // Initialize Database With File Name

        SQLite.sharedInstance().createDatabaseWithFileNameWithNoExtension("sagar")




        // Create Database

        SQLite.sharedInstance().executeQuery("CREATE TABLE PROPERTIES ( PROPERTY_ID INTEGER PRIMARY KEY,PROPERTY_NAME TEXT NOT NULL);")



         //Insert Query


        SQLite.sharedInstance().executeQuery("INSERT INTO PROPERTIES ( PROPERTY_ID,PROPERTY_NAME) VALUES( '1','Sagar')")

        SQLite.sharedInstance().executeQuery("INSERT INTO PROPERTIES ( PROPERTY_ID,PROPERTY_NAME) VALUES( '2','Chandan')")

        SQLite.sharedInstance().executeQuery("INSERT INTO PROPERTIES ( PROPERTY_ID,PROPERTY_NAME) VALUES( '3','Vishal')")

        SQLite.sharedInstance().executeQuery("INSERT INTO PROPERTIES ( PROPERTY_ID,PROPERTY_NAME) VALUES( '4','Akash')")

        SQLite.sharedInstance().executeQuery("INSERT INTO PROPERTIES ( PROPERTY_ID,PROPERTY_NAME) VALUES( '5','Rushi')")



        // Update Query

        SQLite.sharedInstance().executeQuery("INSERT OR REPLACE INTO PROPERTIES ( PROPERTY_ID,PROPERTY_NAME) VALUES( 'Paa','Rushi')")



        //Delete Query

        SQLite.sharedInstance().executeQuery("DELETE FROM PROPERTIES WHERE PROPERTY_NAME = 'Vishal'")



        // Get The data from Database

        let dataArr : NSArray = SQLite.sharedInstance().getDataFromQuery("SELECT * FROM PROPERTIES")

        print(dataArr);