From a3d359e1cc4f40328f898653a5cc3b9711a522e6 Mon Sep 17 00:00:00 2001 From: Yehonal Date: Sun, 17 Feb 2019 21:34:28 +0100 Subject: Import all wiki page from old wiki (links to fix) --- docs/Dealing-with-SQL-files.md | 35 +++++++++++++++++++++++++++++++++++ 1 file changed, 35 insertions(+) create mode 100644 docs/Dealing-with-SQL-files.md (limited to 'docs/Dealing-with-SQL-files.md') diff --git a/docs/Dealing-with-SQL-files.md b/docs/Dealing-with-SQL-files.md new file mode 100644 index 0000000..8efef40 --- /dev/null +++ b/docs/Dealing-with-SQL-files.md @@ -0,0 +1,35 @@ +## SQL Format + +If you are not confident with the SQL language, we suggest to read [this tutorial](http://www.w3schools.com/sql/default.asp) before starting. + +Also remember to: + +- always use [UPDATE](http://www.w3schools.com/sql/sql_update.asp) in order to change the value of fields of **existing rows** + +- use [INSERT](http://www.w3schools.com/sql/sql_insert.asp) in order to insert **new rows only**, but be sure to avoid import errors using [DELETE](http://www.w3schools.com/sql/sql_delete.asp) before INSERT + +- surround any table or field name with `backticks`, and string values with `single quotes`, example: + +``UPDATE `table_name` SET `field_I_want_to_change` = 'new string value' WHERE `entry` = 10 ;`` + +## How to create an sql update file + +This kind of procedure is pretty simple and allow any kind of dev, but also testers, to avoid multiple import of the same queries. + +We can proceed by steps: + +1. Go into **data/sql/updates** and choose the **pending** folder corresponding to the database you apply your SQL to (pending_db_auth or pending_db_characters or pending_db_world). + +2. Run the create_sql.sh script with your bash console. On **Windows**: Use `git bash` (right click on the file). On **Unix/Linux/OSX**: run it from the terminal directly or with "bash create_sql.sh" or execute it with a double click. + +3. Now you'll have a file called **rev_[a_long_number].sql** , you can open it and add your queries into. + +4. Commit with Git and push to github. Follow our tutorial to create a Pull Request. + + +-------- +This feature grants you ( dev / tester / user ) to: + +- create PR without going crazy with the alter table header, but avoiding multiple imports +- avoid wrong order of updates +- avoid data inconsistency if an sql generates an error \ No newline at end of file -- cgit