appveyor.yml 4.0 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126
  1. image: Visual Studio 2015
  2. # This is the default location, but we put it here for safety reasons, since we use it in our test script
  3. clone_folder: c:\projects\rathena
  4. # We do not need the git history for our integration tests
  5. clone_depth: 50
  6. version: '{branch}-{build}'
  7. pull_requests:
  8. do_not_increment_build_number: true
  9. environment:
  10. matrix:
  11. - VisualStudioVersion: 10.0
  12. Solution: rAthena-10.sln
  13. Defines: "\"BUILDBOT\""
  14. - VisualStudioVersion: 11.0
  15. Solution: rAthena-12.sln
  16. Defines: "\"BUILDBOT\""
  17. - VisualStudioVersion: 12.0
  18. Solution: rAthena-13.sln
  19. Defines: "\"BUILDBOT\""
  20. - VisualStudioVersion: 14.0
  21. Solution: rAthena-14.sln
  22. Defines: "\"BUILDBOT\""
  23. - VisualStudioVersion: 10.0
  24. Solution: rAthena-10.sln
  25. Defines: "\"BUILDBOT;PRERE\""
  26. - VisualStudioVersion: 11.0
  27. Solution: rAthena-12.sln
  28. Defines: "\"BUILDBOT;PRERE\""
  29. - VisualStudioVersion: 12.0
  30. Solution: rAthena-13.sln
  31. Defines: "\"BUILDBOT;PRERE\""
  32. - VisualStudioVersion: 14.0
  33. Solution: rAthena-14.sln
  34. Defines: "\"BUILDBOT;PRERE\""
  35. platform:
  36. - Win32
  37. configuration:
  38. - Debug
  39. # Disable Release for now, since do not want to have any optimization and have access to debug infos on crash
  40. # - Release
  41. matrix:
  42. fast_finish: true
  43. build_script:
  44. - cmd: msbuild %Solution% /p:DefineConstants=%Defines%
  45. services: mysql
  46. test_script:
  47. - cmd: >-
  48. rem Set up the environment variables we need
  49. set DB_HOST=127.0.0.1
  50. set DB_ROOT=root
  51. set DB_ROOTPW=Password12!
  52. set DB_USER=ragnarok
  53. set DB_USERPW=ragnarok
  54. set DB_NAME=ragnarok
  55. set MYSQL="C:\Program Files\MySql\MySQL Server 5.7\bin\mysql.exe"
  56. rem Setting creation
  57. cd C:\projects\rathena
  58. echo map_server_ip: %DB_HOST%>> conf\import\inter_conf.txt
  59. echo map_server_id: %DB_USER%>> conf\import\inter_conf.txt
  60. echo map_server_pw: %DB_PASS%>> conf\import\inter_conf.txt
  61. echo map_server_db: %DB_NAME%>> conf\import\inter_conf.txt
  62. echo log_db_ip: %DB_HOST%>> conf\import\inter_conf.txt
  63. echo log_db_id: %DB_USER%>> conf\import\inter_conf.txt
  64. echo log_db_pw: %DB_USERPW%>> conf\import\inter_conf.txt
  65. echo log_db_db: %DB_NAME%>> conf\import\inter_conf.txt
  66. rem MySQL database setup
  67. %MYSQL% -u %DB_ROOT% -p%DB_ROOTPW% -e "CREATE DATABASE %DB_NAME%;"
  68. %MYSQL% -u %DB_ROOT% -p%DB_ROOTPW% %DB_NAME% -e "source sql-files\main.sql"
  69. %MYSQL% -u %DB_ROOT% -p%DB_ROOTPW% %DB_NAME% -e "source sql-files\logs.sql"
  70. %MYSQL% -u %DB_ROOT% -p%DB_ROOTPW% %DB_NAME% -e "source sql-files\item_cash_db.sql"
  71. %MYSQL% -u %DB_ROOT% -p%DB_ROOTPW% %DB_NAME% -e "source sql-files\item_cash_db2.sql"
  72. %MYSQL% -u %DB_ROOT% -p%DB_ROOTPW% %DB_NAME% -e "source sql-files\item_db.sql"
  73. %MYSQL% -u %DB_ROOT% -p%DB_ROOTPW% %DB_NAME% -e "source sql-files\item_db2.sql"
  74. %MYSQL% -u %DB_ROOT% -p%DB_ROOTPW% %DB_NAME% -e "source sql-files\item_db_re.sql"
  75. %MYSQL% -u %DB_ROOT% -p%DB_ROOTPW% %DB_NAME% -e "source sql-files\item_db2_re.sql"
  76. %MYSQL% -u %DB_ROOT% -p%DB_ROOTPW% %DB_NAME% -e "source sql-files\mob_db.sql"
  77. %MYSQL% -u %DB_ROOT% -p%DB_ROOTPW% %DB_NAME% -e "source sql-files\mob_db2.sql"
  78. %MYSQL% -u %DB_ROOT% -p%DB_ROOTPW% %DB_NAME% -e "source sql-files\mob_db_re.sql"
  79. %MYSQL% -u %DB_ROOT% -p%DB_ROOTPW% %DB_NAME% -e "source sql-files\mob_db2_re.sql"
  80. %MYSQL% -u %DB_ROOT% -p%DB_ROOTPW% %DB_NAME% -e "source sql-files\mob_skill_db.sql"
  81. %MYSQL% -u %DB_ROOT% -p%DB_ROOTPW% %DB_NAME% -e "source sql-files\mob_skill_db2.sql"
  82. %MYSQL% -u %DB_ROOT% -p%DB_ROOTPW% %DB_NAME% -e "source sql-files\mob_skill_db_re.sql"
  83. %MYSQL% -u %DB_ROOT% -p%DB_ROOTPW% %DB_NAME% -e "source sql-files\mob_skill_db2_re.sql"
  84. %MYSQL% -u %DB_ROOT% -p%DB_ROOTPW% %DB_NAME% -e "source sql-files\roulette_default_data.sql"
  85. %MYSQL% -u %DB_ROOT% -p%DB_ROOTPW% -e "GRANT ALL ON *.* TO '%DB_USER%'@'%DB_HOST%' IDENTIFIED BY '%DB_USERPW%';"
  86. rem Start the map server
  87. map-server.exe --run-once