/*
    * junixsocket
    *
    * Copyright 2009-2024 Christian Kohlschütter
    *
    * Licensed under the Apache License, Version 2.0 (the "License");
    * you may not use this file except in compliance with the License.
    * You may obtain a copy of the License at
    *
   *     http://www.apache.org/licenses/LICENSE-2.0
   *
   * Unless required by applicable law or agreed to in writing, software
   * distributed under the License is distributed on an "AS IS" BASIS,
   * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
   * See the License for the specific language governing permissions and
   * limitations under the License.
   */
  package org.newsclub.net.mysql.demo;
  
  import static org.newsclub.net.unix.demo.DemoHelper.addProperty;
  
  import java.sql.Connection;
  import java.sql.DatabaseMetaData;
  import java.sql.DriverManager;
  import java.sql.ResultSet;
  import java.sql.SQLException;
  import java.sql.Statement;
  import java.util.Properties;
  
  import org.newsclub.net.unix.demo.DemoHelper;
  
  /**
   * Demonstrates how to connect to a local MySQL server.
   *
   * @author Christian Kohlschuetter
   */
  public class AFUNIXDatabaseSocketFactoryDemo {
    public static void main(String[] args) throws ClassNotFoundException, SQLException {
      DemoHelper.initJDBCDriverClass("mysqlDriver", "", "com.mysql.jdbc.Driver");
      System.out.println();
  
      final String connectionUrl = "jdbc:mysql://";
      System.out.println("Connection URL=" + connectionUrl);
  
      // Override these properties by specifying JVM properties on the command line.
      // try -DmysqlUser=test -DmysqlPassword=test -DmysqlSocket=/var/lib/mysql.sock
      Properties props = new Properties();
      addProperty(props, "socketFactory", "org.newsclub.net.mysql.AFUNIXDatabaseSocketFactory", //
          "mysqlSocketFactory", "org.newsclub.net.mysql.AFUNIXDatabaseSocketFactoryCJ");
      addProperty(props, "junixsocket.file", "/tmp/mysql.sock", //
          "mysqlSocket", "/var/lib/mysql.sock");
      addProperty(props, "user", "root", //
          "mysqlUser", "test");
      addProperty(props, "password", "", //
          "mysqlPassword", "test");
  
      // Disable SSL with -DsslMode=DISABLED
      // This could make things faster, or break everything.
      // It should be fine, however, since we're not leaving the machine.
      addProperty(props, "sslMode", "PREFERRED", "mysqlSslMode", "DISABLED");
      // NOTE: in older versions of MySQL Connector/J, you need to set "useSSL" instead of "sslMode"
      // addProperty(props, "useSSL", "true", "mysqlUseSSL", "false");
  
      System.out.println();
  
      try (Connection conn = DriverManager.getConnection(connectionUrl, props)) {
        System.out.println("Connection: " + conn);
  
        DatabaseMetaData metadata = conn.getMetaData();
        System.out.println("Database version: " + metadata.getDatabaseProductName() + " " + metadata
            .getDatabaseProductVersion());
  
        String sql = "SHOW DATABASES";
        System.out.println(sql);
        try (Statement stmt = conn.createStatement(); //
            ResultSet rs = stmt.executeQuery(sql)) {
          while (rs.next()) {
            System.out.println("* " + rs.getString(1));
          }
        }
      }
    }
  }