forked from cmangos/tbc-db
/
appveyor.yml
108 lines (98 loc) · 6.03 KB
/
appveyor.yml
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
# Specify version format
version: "1.7.{build}"
# specify custom environment variables
environment:
SNAPSHOT_TAG : "$(APPVEYOR_PROJECT_NAME)_PreBuild"
CORE_URL : "https://github.com/cmangos/mangos-tbc.git"
COMMIT_URL : "https://github.com/cmangos/mangos-tbc/commit/"
FINAL_SQL_NAME : "TBC-DB.zip"
CORE_HASH : "Not Set"
SEC_ACCESS_TOKEN :
secure: GXsXxwHSSt1y+ae3C6A0csN+dCQxPW8w98SGwl8cqzqPDhKKbvFJ37eJCCDeNIm2
services:
- mysql
# scripts that are called at very beginning, before repo cloning
init:
# This script will delete already existing tag with its release when it already exist.
# This should be done to correctly update tag details and to avoid mixed release under same tag (if one fail).
# The principle is to delete the tag and release whenever we found it and the commit hash is different than current.
# Do not modify this script for security reason
- ps: >-
function Delete-Github-Release($gitHubRepository, $releaseVersion, $commitHash, $token){
$baseReleaseUrl = "https://api.github.com/repos/$gitHubRepository/releases";
$ref_endpoint = "https://api.github.com/repos/$gitHubRepository/git/refs/tags"
$getReleaseId = @{Uri = "$baseReleaseUrl" + "?access_token=$token"; Method = "GET";}
$wr_error = 'True'; try {$result = Invoke-WebRequest @getReleaseId;} catch {$wr_error = 'False';}
if ($result.StatusCode -ne 200 -or $wr_error -eq 'False') {Write-Host "No release found so nothing to delete." -f Yellow; return;}
$releasesData = ConvertFrom-Json $result.Content; $releaseInfos = $null;
if ($releasesData -is [system.array] -and $releasesData.Count -ge "1") {foreach ($releaseItr in $releasesData) {if ($releaseItr.name -eq $releaseVersion) { $releaseInfos = $releaseItr; break;}}}
if ($releaseInfos -eq $null) {Write-Host "Release $releaseVersion is not found, nothing to delete." -f Yellow; return;}
if ($releaseInfos.target_commitish -ne $commitHash){
$id = $releaseInfos.id; $delBaseReleaseUrl = "$baseReleaseUrl/$id" + "?access_token=$token"
Write-Host "Deleting release $releaseVersion..." -f Yellow;
$delReleaseParams = @{Uri = $delBaseReleaseUrl; Method = "DELETE";}
$wr_error = 'True'; try { $delRelResult = Invoke-WebRequest @delReleaseParams; } catch { $wr_error = 'False'; }
if ($wr_error -eq 'False' -or $delRelResult.StatusCode -eq 204) {Write-Host "$releaseVersion release is deleted" -f Green;} else {Write-Host "ERROR cannot delete $releaseVersion" -f Red;}
Write-Host "Deleting release tag $releaseVersion..." -f Yellow;
$delTagBaseUrl = "$ref_endpoint/$releaseVersion" + "?access_token=$token";
$delTagParams = @{Uri = $delTagBaseUrl; Method = "DELETE";}
$wr_error = 'True'; try {$delTagResult = Invoke-WebRequest @delTagParams;} catch {$wr_error = 'False';}
if ($wr_error -eq 'False' -or $delTagResult.StatusCode -eq 204) {Write-Host "$releaseVersion tag is deleted" -f Green;} else {Write-Host "ERROR cannot delete $releaseVersion" -f Red;}}
else {Write-Host "Skipping tag delete because its same commit!" -f Yellow;}}
# clone directory
clone_folder: C:\projects\database
clone_depth: 1
# scripts to run before build
test_script:
- ps: >-
if (!(Test-Path "C:\projects\database\$env:FINAL_SQL_NAME")) {
Write-Host "Cloning core repository ..." -f Yellow;
git clone --depth 1 -q $env:CORE_URL C:\projects\core;
cd C:\projects\core;
$env:CORE_HASH = git rev-parse --short HEAD;
$env:CORE_HASH = $env:COMMIT_URL + $env:CORE_HASH;
$env:Path += ";C:\Program Files\MySql\MySQL Server 5.7\bin";
Write-Host "Creating tbcmangos DATABASE ..." -f Yellow;
$env:MYSQL_PWD="Password12!";
cmd /c 'mysql -u root < C:\projects\core\sql\create\db_create_mysql.sql';
cmd /c 'mysql -u root -Dtbcmangos < C:\projects\core\sql\base\mangos.sql';
cd C:\projects\database;
$EOF = "`n";
$configs = 'DB_HOST="localhost"' + $EOF + 'DATABASE="tbcmangos"' + $EOF;
$configs += 'USERNAME="mangos"' + $EOF + 'PASSWORD="mangos"' + $EOF;
$configs += 'CORE_PATH="C:/projects/core"' + $EOF;
$configs += 'MYSQL="mysql"' + $EOF + 'DEV_UPDATES="NO"' + $EOF;
$configs += 'FORCE_WAIT="NO"' + $EOF;
[System.IO.File]::WriteAllText("C:\projects\database\InstallFullDB.config", $configs);
Write-Host "Launching database install script ..." -f Yellow;
bash InstallFullDB.sh;
$env:MYSQL_PWD="Password12!";
if ($LastExitCode) { Write-Host "InstallFullDB.sh failed!"; throw "Build failed!"; }
Write-Host "Dumping database ..." -f Yellow;
cmd /c 'mysqldump -u root tbcmangos > C:\projects\database\mangos.sql';
Write-Host "Packing dump into a zip file ..." -f Yellow;
7z a C:\projects\database\$env:FINAL_SQL_NAME C:\projects\database\mangos.sql;
}
# Do not build on tags (GitHub only)
skip_tags: true
# Build settings
build: off
artifacts:
- path: $(FINAL_SQL_NAME)
name: FullDB
type: zip
# scripts to run before deployment
before_deploy:
- ps: Delete-Github-Release $env:APPVEYOR_REPO_NAME $env:SNAPSHOT_TAG $env:APPVEYOR_REPO_COMMIT "$env:SEC_ACCESS_TOKEN";
# deploy settings
deploy:
- provider: GitHub
auth_token: $(SEC_ACCESS_TOKEN)
release: $(SNAPSHOT_TAG) # name of the tag used
description: '# Snapshot v$(APPVEYOR_BUILD_VERSION)\n\nSQL file contains all the latest database updates and all core updates up to and including -> $(CORE_HASH)\n\n## Last $(APPVEYOR_PROJECT_NAME) commit message:\n$(APPVEYOR_REPO_COMMIT)\n> $(APPVEYOR_REPO_COMMIT_MESSAGE)'
artifact: FullDB
draft: false
prerelease: true
on:
branch: master # release from master branch only
appveyor_repo_tag: false # deploy on tag push only