package org.opengroupware.jope.eoaccess.mysql;

import java.sql.Connection;

import org.opengroupware.jope.eoaccess.EOAdaptor;
import org.opengroupware.jope.eoaccess.EOAdaptorChannel;
import org.opengroupware.jope.eoaccess.EOModel;

public class EOMySQLAdaptor extends EOAdaptor {

  public EOMySQLAdaptor(String _url, EOModel _model, int maxSize) {
    super(_url, _model, maxSize);
  }
  
  /* JDBC driver */

  protected boolean loadDriver() {
    try {
      // The newInstance() call is a work around for some
      // broken Java implementations
      Class.forName("com.mysql.jdbc.Driver").newInstance();
      return true;
    }
    catch (Exception e) {
      return false;
    }
  }
  
  /* adaptor specific objects */

  protected EOAdaptorChannel primaryCreateChannelForConnection(Connection _c) {
    /* can be overridden by subclasses to provide specific channels */
    return new EOMySQLChannel(this, _c);
  }
  
  /* quoting SQL expressions */

  public Class defaultExpressionClass() {
    return EOMySQLExpression.class;
  }
  
  public String stringByQuotingIdentifier(String _id) {
    /* MySQL uses back-quotes for quoting identifiers */
    if (_id == null) return null;
    return "`" + escape(_id, '`') + "`";
  }
}