From f309cf79bbb032a0686b7d04feb8fec18e600a84 Mon Sep 17 00:00:00 2001 From: Kitzunu <24550914+Kitzunu@users.noreply.github.com> Date: Sat, 12 Jun 2021 14:50:58 +0200 Subject: chore: file naming standard (#517) * A * file naming standard Fixes #491 * Revert "A" This reverts commit 1c225fed753554098069597a2bbcbe08213b76a1. * rename * Revert "rename" This reverts commit 65fd916faf8530ce258cc2b475c93971468680fe. * Revert "file naming standard" This reverts commit 6ca5a703a9e9d59f9c773029e4c04bfd012b6abb. * bye * Hi * Create the-staging-branch.md * 1 * Delete how-to-create-a-PR.md * Create how-to-create-a-pr.md * werafgt * Update the-modular-structure.md * wef --- docs/How-to-test-DB-only-changes.md | 63 ------------------------------------- 1 file changed, 63 deletions(-) delete mode 100644 docs/How-to-test-DB-only-changes.md (limited to 'docs/How-to-test-DB-only-changes.md') diff --git a/docs/How-to-test-DB-only-changes.md b/docs/How-to-test-DB-only-changes.md deleted file mode 100644 index 3e88294..0000000 --- a/docs/How-to-test-DB-only-changes.md +++ /dev/null @@ -1,63 +0,0 @@ -## Introduction - -The main guide about [How to test a PR](How-to-test-a-PR) will work for all kind of PRs. - -However it is common to have PRs that only make changes to the database (typically the `world` database). - -For those PRs there is a simpler way to test them, which will be explained in this page. - -**Tip**: The complete list of PRs that need to be tested is available [here](https://github.com/azerothcore/azerothcore-wotlk/pulls?q=is%3Apr+is%3Aopen+label%3A%22Waiting+to+be+tested%22). - -## Requirements - -This tutorial assumes that you: - -- have a **recent** version of AzerothCore installed in your system (either using the [traditional setup](Installation) or the [Docker setup](Install-with-Docker)). We recommend using latest `master`. -- have a GitHub account, you can [register one here](https://github.com/join) for free. -- have a database client such as [HeidiSQL](https://www.heidisql.com/), Navicat or similar. - -## Check if a PR has only DB changes - -Open the PR page and click on the "File Changes" tab: - -![File Changes](https://user-images.githubusercontent.com/75517/52176720-ea4da900-27b6-11e9-8459-d58adf7fd50c.png) - -- If you see `*.cpp`, `*.h` file changes, then follow [this guide](How-to-test-a-PR) instead. - -- If you only see `*.sql` changes, keep reading. - -## Import the changes to your Database - -The PR will have some sql files (typically only one) inside the folders `pending_db_xxxxx` where `xxxxx` is the name of the database (typically `world`). - -Basically you just need to import those changes to the corresponding database (typically `acore_world`). - -To do that, click on the button "View file" under the "File changes" tab of the PR page. You can either download the whole file or just manually copy all the SQL code. - -Then open your database client (for example HeidiSQL), select the right database (e.g. `acore_world`) and execute the SQL code. - -For example, on HeidiSQL **first select** the database from the left column, then open the "Query" tab, paste the SQL code there and press F9 to execute it: - -![HeidiSQL import example](https://user-images.githubusercontent.com/75517/52532889-e4624580-2d2b-11e9-8325-aa587c2d080d.png) - -## Reflect the changes in game - -A quick way to make your server loading the new changes is just by restarting the `worldserver` process. - -**Tip**: If you are using AC with Docker, you can simply restart your database container using `docker-compose restart ac-worldserver` - -**Advanced tip**: Sometimes the changes only affect tables that can be reloaded directly in game using the command `.reload tablename` - -Now you can test the changes and post your results as a comment on the github page of the PR! - -## Returning to a clean state - -After you test the changes, you need to return in a clean state (as you were before applying those changes to your DB). - -- On a **traditional setup**, you can delete your `acore_world` database and use the DB assembler to generate a new one - -- On a **docker setup**, you can destroy and recreate your containers using `docker-compose down` and `docker-compose up`. - -## Reports - -For instructions about what needs to be tested, how to report your test results and examples of other reports, please read from [this part](How-to-test-a-PR#what-needs-to-be-tested) of the main PR guide. \ No newline at end of file -- cgit