From ba6f21caeb405c7e8512a09941fefbc97286e45f Mon Sep 17 00:00:00 2001
From: Aleksander Machniak <alec@alec.pl>
Date: Wed, 21 Nov 2012 19:52:03 +0100
Subject: Framework files moved to lib/Roundcube

---
 program/include/rcube_db_sqlite.php | 179 ------------------------------------
 1 file changed, 179 deletions(-)
 delete mode 100644 program/include/rcube_db_sqlite.php

(limited to 'program/include/rcube_db_sqlite.php')

diff --git a/program/include/rcube_db_sqlite.php b/program/include/rcube_db_sqlite.php
deleted file mode 100644
index 9aa67d0fd..000000000
--- a/program/include/rcube_db_sqlite.php
+++ /dev/null
@@ -1,179 +0,0 @@
-<?php
-
-/**
- +-----------------------------------------------------------------------+
- | program/include/rcube_db_sqlite.php                                   |
- |                                                                       |
- | This file is part of the Roundcube Webmail client                     |
- | Copyright (C) 2005-2012, The Roundcube Dev Team                       |
- |                                                                       |
- | Licensed under the GNU General Public License version 3 or            |
- | any later version with exceptions for skins & plugins.                |
- | See the README file for a full license statement.                     |
- |                                                                       |
- | PURPOSE:                                                              |
- |   Database wrapper class that implements PHP PDO functions            |
- |   for SQLite database                                                 |
- |                                                                       |
- +-----------------------------------------------------------------------+
- | Author: Aleksander Machniak <alec@alec.pl>                            |
- +-----------------------------------------------------------------------+
-*/
-
-
-/**
- * Database independent query interface
- * This is a wrapper for the PHP PDO
- *
- * @package    Framework
- * @subpackage Database
- */
-class rcube_db_sqlite extends rcube_db
-{
-    public $db_provider = 'sqlite';
-
-    /**
-     * Database character set
-     */
-    protected function set_charset($charset)
-    {
-    }
-
-    /**
-     * Prepare connection
-     */
-    protected function conn_prepare($dsn)
-    {
-        // Create database file, required by PDO to exist on connection
-        if (!empty($dsn['database']) && !file_exists($dsn['database'])) {
-            $created = touch($dsn['database']);
-
-            // File mode setting, for compat. with MDB2
-            if (!empty($dsn['mode']) && $created) {
-                chmod($dsn['database'], octdec($dsn['mode']));
-            }
-        }
-    }
-
-    /**
-     * Configure connection, create database if not exists
-     */
-    protected function conn_configure($dsn, $dbh)
-    {
-        // we emulate via callback some missing functions
-        $dbh->sqliteCreateFunction('unix_timestamp', array('rcube_db_sqlite', 'sqlite_unix_timestamp'), 1);
-        $dbh->sqliteCreateFunction('now', array('rcube_db_sqlite', 'sqlite_now'), 0);
-
-        // Initialize database structure in file is empty
-        if (!empty($dsn['database']) && !filesize($dsn['database'])) {
-            $data = file_get_contents(INSTALL_PATH . 'SQL/sqlite.initial.sql');
-
-            if (strlen($data)) {
-                $this->debug('INITIALIZE DATABASE');
-
-                $q = $dbh->exec($data);
-
-                if ($q === false) {
-                    $error = $dbh->errorInfo();
-                    $this->db_error = true;
-                    $this->db_error_msg = sprintf('[%s] %s', $error[1], $error[2]);
-
-                    rcube::raise_error(array('code' => 500, 'type' => 'db',
-                        'line' => __LINE__, 'file' => __FILE__,
-                        'message' => $this->db_error_msg), true, false);
-                }
-            }
-        }
-    }
-
-    /**
-     * Callback for sqlite: unix_timestamp()
-     */
-    public static function sqlite_unix_timestamp($timestamp = '')
-    {
-        $timestamp = trim($timestamp);
-        if (!$timestamp) {
-            $ret = time();
-        }
-        else if (!preg_match('/^[0-9]+$/s', $timestamp)) {
-            $ret = strtotime($timestamp);
-        }
-        else {
-            $ret = $timestamp;
-        }
-
-        return $ret;
-    }
-
-    /**
-     * Callback for sqlite: now()
-     */
-    public static function sqlite_now()
-    {
-        return date("Y-m-d H:i:s");
-    }
-
-    /**
-     * Returns list of tables in database
-     *
-     * @return array List of all tables of the current database
-     */
-    public function list_tables()
-    {
-        if ($this->tables === null) {
-            $q = $this->query('SELECT name FROM sqlite_master'
-                .' WHERE type = \'table\' ORDER BY name');
-
-            if ($res = $this->_get_result($q)) {
-                $this->tables = $res->fetchAll(PDO::FETCH_COLUMN, 0);
-            }
-            else {
-                $this->tables = array();
-            }
-        }
-
-        return $this->tables;
-    }
-
-    /**
-     * Returns list of columns in database table
-     *
-     * @param string $table Table name
-     *
-     * @return array List of table cols
-     */
-    public function list_cols($table)
-    {
-        $q = $this->query('SELECT sql FROM sqlite_master WHERE type = ? AND name = ?',
-            array('table', $table));
-
-        $columns = array();
-
-        if ($sql = $this->fetch_array($q)) {
-            $sql       = $sql[0];
-            $start_pos = strpos($sql, '(');
-            $end_pos   = strrpos($sql, ')');
-            $sql       = substr($sql, $start_pos+1, $end_pos-$start_pos-1);
-            $lines     = explode(',', $sql);
-
-            foreach ($lines as $line) {
-                $line = explode(' ', trim($line));
-
-                if ($line[0] && strpos($line[0], '--') !== 0) {
-                    $column = $line[0];
-                    $columns[] = trim($column, '"');
-                }
-            }
-        }
-
-        return $columns;
-    }
-
-    /**
-     * Build DSN string for PDO constructor
-     */
-    protected function dsn_string($dsn)
-    {
-        return $dsn['phptype'] . ':' . $dsn['database'];
-    }
-}
-- 
cgit v1.2.3