from builtins import range
from builtins import object
import logging
import os
import sys

from desktop.lib.i18n import force_unicode, smart_str
from notebook.conf import DBPROXY_EXTRA_CLASSPATH
from notebook.connectors.base import AuthenticationRequired

LOG = logging.getLogger(__name__)

try:
  from py4j.java_gateway import JavaGateway, JavaObject
except:
  LOG.warning('Failed to import py4j')


def query_and_fetch(db, statement, n=None):
  data = None
  try:
    db.connect()
    curs = db.cursor()

    try:
      if curs.execute(statement):
        data = curs.fetchmany(n)
      meta = curs.description
      return data, meta
    finally:
      curs.close()
  except Exception as e:
    message = force_unicode(smart_str(e))
    if 'Access denied' in message:
      raise AuthenticationRequired()
    raise
  finally:
    db.close()


class Jdbc(object):

  def __init__(self, driver_name, url, username, password, impersonation_property=None, impersonation_user=None):
    if 'py4j' not in sys.modules:
      raise Exception('Required py4j module is not imported.')

    os.environ["PATH"] = os.environ["PATH"] + ':/usr/java/default/bin' # TODO: more generic
    classpath = os.environ.get('CLASSPATH', '')
    if DBPROXY_EXTRA_CLASSPATH.get():
      classpath = '%s:%s' % (DBPROXY_EXTRA_CLASSPATH.get(), classpath)

    self.gateway = JavaGateway.launch_gateway(classpath=classpath)

    self.jdbc_driver = driver_name
    self.db_url = url
    self.username = username
    self.password = password

    if impersonation_property and impersonation_user:
      self.db_url += ";{}={};".format(impersonation_property, impersonation_user)

    self.conn = None

  def test_connection(self, throw_exception=True):
    try:
      self.connect()
      return True
    except Exception as e:
      message = force_unicode(smart_str(e))
      if throw_exception:
        if 'Access denied' in message:
          raise AuthenticationRequired()
        raise
      else:
        return False
    finally:
      self.close()

  def connect(self):
    if self.conn is None:
      self.gateway.jvm.Class.forName(self.jdbc_driver)
      self.conn = self.gateway.jvm.java.sql.DriverManager.getConnection(self.db_url, self.username, self.password)

  def cursor(self):
    return Cursor(self.conn)

  def close(self):
    if self.conn is not None:
      self.conn.close()
      self.conn = None


class Cursor(object):
  """Similar to DB-API 2.0 Cursor interface"""

  def __init__(self, conn):
    self.conn = conn
    self.stmt = None
    self.rs = None
    self._meta = None

  def execute(self, statement):
    self.stmt = self.conn.createStatement()
    has_rs = self.stmt.execute(statement)

    if has_rs:
      self.rs = self.stmt.getResultSet()
      self._meta = self.rs.getMetaData()
    else:
      self._meta = self.stmt.getUpdateCount()

    return has_rs

  def fetchmany(self, n=None):
    res = []

    while self.rs.next() and (n is None or n > 0):
      row = []
      for c in range(self._meta.getColumnCount()):
        cell = self.rs.getObject(c + 1)

        if isinstance(cell, JavaObject):
          cell = str(cell) # DATETIME
        row.append(cell)

      res.append(row)
      if n is not None:
        n -= 1

    return res

  def fetchall(self, n=None):
    return self.fetchmany()

  @property
  def description(self):
    if not self.rs:
      return self._meta
    else:
      return [[
        self._meta.getColumnName(i),
        self._meta.getColumnTypeName(i) + '_TYPE',
        self._meta.getColumnDisplaySize(i),
        self._meta.getColumnDisplaySize(i),
        self._meta.getPrecision(i),
        self._meta.getScale(i),
        self._meta.isNullable(i),
      ] for i in range(1, self._meta.getColumnCount() + 1)]

  def close(self):
    self._meta = None

    if self.rs is not None:
      self.rs.close()
      self.rs = None

    if self.stmt is not None:
      self.stmt.close()
      self.stmt = None
