github.com/drud/ddev@v1.21.5-alpha1.0.20230226034409-94fcc4b94453/pkg/ddevapp/global_dotddev_assets/commands/host/sequelpro (about) 1 #!/bin/bash 2 3 #ddev-generated 4 ## Description: Run sequelpro with current project database 5 ## Usage: sequelpro 6 ## Example: "ddev sequelpro" 7 ## OSTypes: darwin 8 ## HostBinaryExists: /Applications/Sequel Pro.app 9 ## DBTypes: mysql,mariadb 10 11 tmpdir=$(mktemp -d -t sequelpro-XXXXXXXXXX) 12 templatepath="$tmpdir/sequelpro.spf" 13 14 cat >$templatepath <<END 15 <?xml version="1.0" encoding="UTF-8"?> 16 <!DOCTYPE plist PUBLIC "-//Apple//DTD PLIST 1.0//EN" "http://www.apple.com/DTDs/PropertyList-1.0.dtd"> 17 <plist version="1.0"> 18 <dict> 19 <key>ContentFilters</key> 20 <dict/> 21 <key>auto_connect</key> 22 <true/> 23 <key>data</key> 24 <dict> 25 <key>connection</key> 26 <dict> 27 <key>database</key> 28 <string>db</string> 29 <key>host</key> 30 <string>127.0.0.1</string> 31 <key>name</key> 32 <string>${DDEV_SITENAME}</string> 33 <key>password</key> 34 <string>root</string> 35 <key>port</key> 36 <integer>$DDEV_HOST_DB_PORT</integer> 37 <key>rdbms_type</key> 38 <string>mysql</string> 39 <key>sslCACertFileLocation</key> 40 <string></string> 41 <key>sslCACertFileLocationEnabled</key> 42 <integer>0</integer> 43 <key>sslCertificateFileLocation</key> 44 <string></string> 45 <key>sslCertificateFileLocationEnabled</key> 46 <integer>0</integer> 47 <key>sslKeyFileLocation</key> 48 <string></string> 49 <key>sslKeyFileLocationEnabled</key> 50 <integer>0</integer> 51 <key>type</key> 52 <string>SPTCPIPConnection</string> 53 <key>useSSL</key> 54 <integer>0</integer> 55 <key>user</key> 56 <string>root</string> 57 </dict> 58 </dict> 59 <key>encrypted</key> 60 <false/> 61 <key>format</key> 62 <string>connection</string> 63 <key>queryFavorites</key> 64 <array/> 65 <key>queryHistory</key> 66 <array/> 67 <key>rdbms_type</key> 68 <string>mysql</string> 69 <key>rdbms_version</key> 70 <string>5.5.44</string> 71 <key>version</key> 72 <integer>1</integer> 73 </dict> 74 </plist> 75 END 76 77 open "${templatepath}" 78