oc-server3/init.sh at development · hxdimpf/oc-server3 · GitHub

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
#!/usr/bin/env bash
#DESCRIPTION: initialisation process to start developing

cd htdocs && composer install --optimize-autoloader

cd /var/www/html
cd htdocs_symfony && composer install --optimize-autoloader

cd /var/www/html
mysql -uroot -proot -hdb db < sql/dump_v158.sql

# run database and cache updates
php bin/dbupdate.php

# Install OKAPI
curl https://opencaching.ddev.site/okapi/update?install=true

# "updating database structures ..."
php bin/dbsv-update.php
php bin/db-import-static.php
cd sql/stored-proc && php maintain.php
cd /var/www/html

cat ./sql/static-data/*.sql | mysql -u root -hdb -proot db

chmod 755 ./htdocs/bin/console
chmod -R 777 ./htdocs/var
./htdocs/bin/console doctrine:migrations:migrate -n
./htdocs_symfony/bin/console doctrine:migrations:migrate -n


php bin/okapi-update.php|grep -i -e current -e mutation

cd htdocs
curl -o translations.zip "https://www.opencaching.de/translations.zip"
unzip -o translations.zip
rm translations.zip

cd /var/www/html

./htdocs/bin/console translation:update de --force
./htdocs/bin/console translation:update el --force
./htdocs/bin/console translation:update en --force
./htdocs/bin/console translation:update es --force
./htdocs/bin/console translation:update fr --force
./htdocs/bin/console translation:update it --force
./htdocs/bin/console translation:update nl --force
./htdocs/bin/console translation:update pl --force
./htdocs/bin/console translation:update ru --force
./htdocs/bin/console translation:import-legacy-translation

mysql -uroot -proot -hdb -e 'INSERT INTO user_roles SET user_id = 107469, role_id = 14' db
mysql -uroot -proot -hdb db < sql/user_content_sample.sql


cd htdocs_symfony
npx update-browserslist-db@latest -y
yarn install
yarn dev