<NME> sqlite_lib.py
<BEF> #!/usr/bin/env python
# Licensed to Cloudera, Inc. under one
# or more contributor license agreements.  See the NOTICE file
# distributed with this work for additional information
# regarding copyright ownership.  Cloudera, Inc. licenses this file
# to you 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.

import logging

try:
  try:
    from pysqlite2 import dbapi2 as Database
  except ImportError, e1:
    from sqlite3 import dbapi2 as Database
except ImportError, exc:
  from django.core.exceptions import ImproperlyConfigured
  raise ImproperlyConfigured("Error loading either pysqlite2 or sqlite3 modules (tried in that order): %s" % exc)

from librdbms.server.rdbms_base_lib import BaseRDBMSDataTable, BaseRDBMSResult, BaseRDMSClient


LOG = logging.getLogger(__name__)


class DataTable(BaseRDBMSDataTable): pass


class Result(BaseRDBMSResult): pass


class SQLiteClient(BaseRDMSClient):
  """Same API as Beeswax"""

  data_table_cls = DataTable
  result_cls = Result

  def __init__(self, *args, **kwargs):
    super(SQLiteClient, self).__init__(*args, **kwargs)
    self.connection = Database.connect(**self._conn_params)


  @property
  def _conn_params(self):
    params = {
      'database': self.query_server['name'],
      'detect_types': Database.PARSE_DECLTYPES | Database.PARSE_COLNAMES,
    }

    if self.query_server['options']:
      params.update(self.query_server['options'])

    # Make sure connection is shareable.
    params['check_same_thread'] = False

    return params


  def use(self, database):
    # Do nothing because SQLite has one database per path.
    pass


  def execute_statement(self, statement):
    cursor = self.connection.cursor()
    cursor.execute(statement)
    self.connection.commit()
    if cursor.description:
      columns = [column[0] for column in cursor.description]
    else:
      columns = []
    return self.data_table_cls(cursor, columns)


  def get_databases(self):
    return [self._conn_params['database']]


  def get_tables(self, database, table_names=[]):
    # Doesn't use database and only retrieves tables for database currently in use.
    cursor = self.connection.cursor()
    query = "SELECT name FROM sqlite_master WHERE type='table'"
    if table_names:
      clause = ' OR '.join(["tablename LIKE '%%%(table)s%%'" % {'table': table} for table in table_names])
      query += ' AND (%s)' % clause
    cursor.execute(query)
    self.connection.commit()
    return [row[0] for row in cursor.fetchall()]


  def get_columns(self, database, table, names_only=True):
    cursor = self.connection.cursor()
    cursor.execute("PRAGMA table_info(%s)" % table)
    self.connection.commit()
    if names_only:
      columns = [row[1] for row in cursor.fetchall()]
    else:
      columns = [dict(name=row[1], type=row[2], comment='') for row in cursor.fetchall()]
    return columns

  def get_sample_data(self, database, table, column=None, limit=100):
    column = '`%s`' % column if column else '*'
    statement = 'SELECT %s FROM `%s` LIMIT %d' % (column, table, limit)
    return self.execute_statement(statement)

<MSG> HUE-8737 [core] Futurize desktop/libs/librdbms for Python 3.5

<DFF> @@ -20,9 +20,9 @@ import logging
 try:
   try:
     from pysqlite2 import dbapi2 as Database
-  except ImportError, e1:
+  except ImportError as e1:
     from sqlite3 import dbapi2 as Database
-except ImportError, exc:
+except ImportError as exc:
   from django.core.exceptions import ImproperlyConfigured
   raise ImproperlyConfigured("Error loading either pysqlite2 or sqlite3 modules (tried in that order): %s" % exc)
 

{'addition_count': 2, 'commit_subject': 'HUE-8737 [core] Futurize desktop/libs/librdbms for Python 3.5', 'deletion_count': 2, 'file_extension': '.py', 'lang': 'py', 'license': 'apache-2.0', 'repo_name': 'cloudera/hue'}