Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- #!/bin/bash
- # Requires curl and jq
- # Change the scope IDs for your store in the QUERY variable
- # Requires ngrok to be running
- echo "Fetching host!"
- NGROK_HOST=$(curl -s localhost:4040/api/tunnels | jq '.tunnels[0].public_url' | uniq | cut -d '"' -f 2)
- MYSQL_HOST="localhost"
- MYSQL_USER="root"
- MYSQL_PASSWORD="password"
- MYSQL_DATABASE="magento"
- MYSQL=$(which mysql)
- MYSQL_COMMAND="$MYSQL --user=$MYSQL_USER --password=$MYSQL_PASSWORD --database=$MYSQL_DATABASE --host=$MYSQL_HOST -e "
- QUERY="$MYSQL_COMMAND \" UPDATE core_config_data SET value='$NGROK_HOST' WHERE (path='web/unsecure/base_url' OR path='web/secure/base_url') AND (scope_id = 0 OR scope_id = 2);\""
- QUERY_HOSTS="$MYSQL_COMMAND \" SELECT * FROM core_config_data WHERE path LIKE '%base_url%'; \""
- echo "$QUERY"
- eval "$QUERY"
- echo "$QUERY_HOSTS"
- eval "$QUERY_HOSTS"
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement