[Gravity] Add query syntax support for upserts
Review Request #664 — Created May 22, 2019 and submitted — Latest diff uploaded
| Information | |
|---|---|
| pprkut | |
| Lunr | |
| 21f8f21... | |
| Reviewers | |
| lunr | |
Add query syntax support for upserts
SQLite: https://www.sqlite.org/lang_UPSERT.html
MySQL: https://dev.mysql.com/doc/refman/8.0/en/insert.html
MariaDB: https://mariadb.com/kb/en/library/insert-on-duplicate-key-update/
PostgreSQL: http://www.postgresqltutorial.com/postgresql-upsert/
Unit tests, example queries
Diff Revision 1 (Latest)
| src/Lunr/Gravity/Database/DatabaseDMLQueryBuilder.php |
|---|
| src/Lunr/Gravity/Database/MySQL/MySQLDMLQueryBuilder.php |
|---|
| src/Lunr/Gravity/Database/MySQL/MySQLSimpleDMLQueryBuilder.php |
|---|
| src/Lunr/Gravity/Database/MySQL/Tests/MySQLDMLQueryBuilderInsertTest.php |
|---|
| src/Lunr/Gravity/Database/MySQL/Tests/MySQLSimpleDMLQueryBuilderFluidInterfaceTest.php |
|---|
| src/Lunr/Gravity/Database/MySQL/Tests/MySQLSimpleDMLQueryBuilderWriteTest.php |
|---|
| src/Lunr/Gravity/Database/Tests/DatabaseDMLQueryBuilderBaseTest.php |
|---|
| src/Lunr/Gravity/Database/Tests/DatabaseDMLQueryBuilderGetInsertQueryTest.php |
|---|
| src/Lunr/Gravity/Database/Tests/DatabaseDMLQueryBuilderQueryPartsInsertTest.php |
|---|