32 lines
1.2 KiB
Bash
Executable File
32 lines
1.2 KiB
Bash
Executable File
#!/bin/bash
|
|
# Usage: db-anpassen <projekt-pfad>
|
|
# Macht eine frisch importierte DB lokal nutzbar:
|
|
# Kunden-Mails bereinigen, Admin team3 anlegen, Mailversand auf Mailpit.
|
|
set -euo pipefail
|
|
|
|
cd "$1"
|
|
|
|
echo "Kunden-Mails bereinigen"
|
|
ddev mysql -e "UPDATE customer SET email = CONCAT('test+customer-', customer_number, '@mitho-media.de');"
|
|
|
|
echo "Admin team3"
|
|
if [ -n "$(ddev mysql -N -e "SELECT 1 FROM user WHERE username = 'team3';")" ]; then
|
|
ddev exec bin/console user:change-password team3 --password='aisool8sahjaeThaiDie'
|
|
else
|
|
ddev exec bin/console user:create team3 --admin --password='aisool8sahjaeThaiDie' \
|
|
--email='team3@mitho-media.de' --firstName='Team3' --lastName='Team3'
|
|
fi
|
|
|
|
echo "Mailversand auf Mailpit"
|
|
ddev exec bin/console system:config:set core.mailerSettings.emailAgent smtp
|
|
ddev exec bin/console system:config:set core.mailerSettings.host 127.0.0.1
|
|
ddev exec bin/console system:config:set core.mailerSettings.port 1025 --json
|
|
ddev exec bin/console system:config:set core.mailerSettings.encryption null --json
|
|
ddev exec bin/console system:config:set core.mailerSettings.username null --json
|
|
ddev exec bin/console system:config:set core.mailerSettings.password null --json
|
|
|
|
ddev exec bin/console cache:clear
|
|
|
|
echo
|
|
echo "Fertig."
|