ParseQL-Swift

Easy way to manage your own MySQL Databases just with Swift.

Installation

1- Add "ParseQL.swift" (in "/SwiftSource/Xcode 7") to your Xcode project.
2- Write your own "PRIVATE_KEY" and "TOKEN" in "ParseQL.swift".
3- Write the same "PRIVATE_KEY" and "TOKEN" in "PHP/parseql/application/controllers/ParseQLController.php".
4- Edit "PHP/parseql/config/database.php" file with your database info (at the bottom on the file).
5- Upload "parseql" folder, to your hosting.
6- Edit BASE_URL in "ParseQL.swift" file, to point to "parseql" folder in your hosting.
7- Ready!

1. Create Row

And we get our first row, in our own database.
Don't worry about create the table and the columns, if they don't exist, ParseQL will create them.

2. Update Row

Here's the change.

3. Delete Row

We'll talk about "where key" later...

Use completions to manage the results. Maybe you want to wait the result of the tasks above. The completions return some useful data too.

4. Create with block

It returns a message by now...

5. Update with block

It returns affected rows as Array of Dictionaries

6. Delete with block

It returns affected rows amount

7. Conditions (We'll use some of these to get data from our database)

WhereKey (equal, greater, less and notEqual)

OrderByAsc and OrderByDesc

Limit

Skip

8. Get

It returns an Array or Dictionaries

9. Cancel

You can cancel any PQL object task you started