github.com/ddev/ddev@v1.23.2-0.20240519125000-d824ffe36ff3/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  if [ "${DDEV_PROJECT_STATUS}" != "running" ] && [ -z "$no_recursion" ]; then
    12    echo "Project ${DDEV_PROJECT} is not running, starting it"
    13    ddev start
    14    start_exit_code=$?
    15    if [ $start_exit_code -ne 0 ]; then
    16      exit $start_exit_code
    17    fi
    18    # run this script again, as the environment is updated after "ddev start"
    19    no_recursion=true ddev "$(basename "$0")" "$@"
    20    exit $?
    21  fi
    22  tmpdir=$(mktemp -d -t sequelpro-XXXXXXXXXX)
    23  templatepath="$tmpdir/sequelpro.spf"
    24  
    25  cat >$templatepath <<END
    26  <?xml version="1.0" encoding="UTF-8"?>
    27  <!DOCTYPE plist PUBLIC "-//Apple//DTD PLIST 1.0//EN" "http://www.apple.com/DTDs/PropertyList-1.0.dtd">
    28  <plist version="1.0">
    29  <dict>
    30      <key>ContentFilters</key>
    31      <dict/>
    32      <key>auto_connect</key>
    33      <true/>
    34      <key>data</key>
    35      <dict>
    36          <key>connection</key>
    37          <dict>
    38              <key>database</key>
    39              <string>db</string>
    40              <key>host</key>
    41              <string>127.0.0.1</string>
    42              <key>name</key>
    43              <string>${DDEV_SITENAME}</string>
    44              <key>password</key>
    45              <string>root</string>
    46              <key>port</key>
    47              <integer>$DDEV_HOST_DB_PORT</integer>
    48              <key>rdbms_type</key>
    49              <string>mysql</string>
    50              <key>sslCACertFileLocation</key>
    51              <string></string>
    52              <key>sslCACertFileLocationEnabled</key>
    53              <integer>0</integer>
    54              <key>sslCertificateFileLocation</key>
    55              <string></string>
    56              <key>sslCertificateFileLocationEnabled</key>
    57              <integer>0</integer>
    58              <key>sslKeyFileLocation</key>
    59              <string></string>
    60              <key>sslKeyFileLocationEnabled</key>
    61              <integer>0</integer>
    62              <key>type</key>
    63              <string>SPTCPIPConnection</string>
    64              <key>useSSL</key>
    65              <integer>0</integer>
    66              <key>user</key>
    67              <string>root</string>
    68          </dict>
    69      </dict>
    70      <key>encrypted</key>
    71      <false/>
    72      <key>format</key>
    73      <string>connection</string>
    74      <key>queryFavorites</key>
    75      <array/>
    76      <key>queryHistory</key>
    77      <array/>
    78      <key>rdbms_type</key>
    79      <string>mysql</string>
    80      <key>rdbms_version</key>
    81      <string>5.5.44</string>
    82      <key>version</key>
    83      <integer>1</integer>
    84  </dict>
    85  </plist>
    86  END
    87  
    88  open  "${templatepath}"