KO | EN

GitLite

Minimalist Open Source Repository Search Engine

gitlite — search

#dsh #dsh-plugin #developer-tools #ai-agent #claude-code #codex #typescript #ai-agents #deepseek-harness #mcp #cli #rust

ParseQL-Swift-To-MySQL

★ 29 Open GitHub ↗

Easy way to communicate your Swift Code directly with your MySQL Database.

// repository documentation

Was this content helpful?

★ 0 (0 ratings)

# 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.<br>
2- Write your own "PRIVATE_KEY" and "TOKEN" in "ParseQL.swift".<br>
3- Write the same "PRIVATE_KEY" and "TOKEN" in "PHP/parseql/application/controllers/ParseQLController.php".<br>
4- Edit "PHP/parseql/config/database.php" file with your database info (at the bottom on the file).<br>
5- Upload "parseql" folder, to your hosting.<br>
6- Edit BASE_URL in "ParseQL.swift" file, to point to "parseql" folder in your hosting.<br>
7- Ready!<br>
<h2>1. Create Row</h2>

![Alt text](https://raw.githubusercontent.com/pablojotaguardiola/ParseQL-Swift-To-MySQL/master/Images/CodeCreate.png)

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.
    
![Alt text](https://raw.githubusercontent.com/pablojotaguardiola/ParseQL-Swift-To-MySQL/master/Images/TestTable1.png)

<br>

<h2>2. Update Row</h2>

![Alt text](https://raw.githubusercontent.com/pablojotaguardiola/ParseQL-Swift-To-MySQL/master/Images/CodeUpdate.png)

Here's the change.

![Alt text](https://raw.githubusercontent.com/pablojotaguardiola/ParseQL-Swift-To-MySQL/master/Images/TestTable2.png)

<br>

<h2>3. Delete Row</h2>

![Alt text](https://raw.githubusercontent.com/pablojotaguardiola/ParseQL-Swift-To-MySQL/master/Images/CodeDelete.png)

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.

<br>

<h2>4. Create with block</h2>

It returns a message by now...

![Alt text](https://raw.githubusercontent.com/pablojotaguardiola/ParseQL-Swift-To-MySQL/master/Images/CodeSaveBlock.png)

<br>

<h2>5. Update with block</h2>

It returns affected rows as Array of Dictionaries

![Alt text](https://raw.githubusercontent.com/pablojotaguardiola/ParseQL-Swift-To-MySQL/master/Images/CodeUpdateBlock.png)

<br>

<h2>6. Delete with block</h2>

It returns affected rows amount

![Alt text](https://raw.githubusercontent.com/pablojotaguardiola/ParseQL-Swift-To-MySQL/master/Images/CodeDeleteBlock.png)

<br>

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

<h4>WhereKey (equal, greater, less and notEqual)</h4>

![Alt text](https://raw.githubusercontent.com/pablojotaguardiola/ParseQL-Swift-To-MySQL/master/Images/CodeWhereKey1.png)
![Alt text](https://raw.githubusercontent.com/pablojotaguardiola/ParseQL-Swift-To-MySQL/master/Images/CodeWhereKey2.png)

<h4>OrderByAsc and OrderByDesc</h4>

![Alt text](https://raw.githubusercontent.com/pablojotaguardiola/ParseQL-Swift-To-MySQL/master/Images/CodeOrderBy.png)

<h4>Limit</h4>

![Alt text](https://raw.githubusercontent.com/pablojotaguardiola/ParseQL-Swift-To-MySQL/master/Images/CodeLimit.png)

![Alt text](https://raw.githubusercontent.com/pablojotaguardiola/ParseQL-Swift-To-MySQL/master/Images/CodeSkip.png)

<br>

It returns an Array or Dictionaries

![Alt text](https://raw.githubusercontent.com/pablojotaguardiola/ParseQL-Swift-To-MySQL/master/Images/CodeGet2.png)

<br>

<h2>9. Cancel</h2>

You can cancel any PQL object task you started

![Alt text](https://raw.githubusercontent.com/pablojotaguardiola/ParseQL-Swift-To-MySQL/master/Images/CodeCancel.png)

ParseQL-Swift-To-MySQL

Explore Similar Repositories

Was this content helpful?

Recent Feedback

Download README