mssql_utility.php

Go to the documentation of this file.

<?php  if ( ! defined('BASEPATH')) exit('No direct script access allowed');
/**
 * CodeIgniter
 *
 * An open source application development framework for PHP 4.3.2 or newer
 *
 * @package             CodeIgniter
 * @author              ExpressionEngine Dev Team
 * @copyright   Copyright (c) 2008, EllisLab, Inc.
 * @license             http://codeigniter.com/user_guide/license.html
 * @link                http://codeigniter.com
 * @since               Version 1.0
 * @filesource
 */

// ------------------------------------------------------------------------

/**
 * MS SQL Utility Class
 *
 * @category    Database
 * @author              ExpressionEngine Dev Team
 * @link                http://codeigniter.com/user_guide/database/
 */
class CI_DB_mssql_utility extends CI_DB_utility {

        /**
         * List databases
         *
         * @access      private
         * @return      bool
         */
        function _list_databases()
        {
                return "EXEC sp_helpdb"; // Can also be: EXEC sp_databases
        }

        // --------------------------------------------------------------------

        /**
         * Optimize table query
         *
         * Generates a platform-specific query so that a table can be optimized
         *
         * @access      private
         * @param       string  the table name
         * @return      object
         */
        function _optimize_table($table)
        {
                return FALSE; // Is this supported in MS SQL?
        }

        // --------------------------------------------------------------------
        
        /**
         * Repair table query
         *
         * Generates a platform-specific query so that a table can be repaired
         *
         * @access      private
         * @param       string  the table name
         * @return      object
         */
        function _repair_table($table)
        {
                return FALSE; // Is this supported in MS SQL?
        }

        // --------------------------------------------------------------------

        /**
         * MSSQL Export
         *
         * @access      private
         * @param       array   Preferences
         * @return      mixed
         */
        function _backup($params = array())
        {
                // Currently unsupported
                return $this->db->display_error('db_unsuported_feature');
        }

        /**
         *
         * The functions below have been deprecated as of 1.6, and are only here for backwards
         * compatibility.  They now reside in dbforge().  The use of dbutils for database manipulation
         * is STRONGLY discouraged in favour if using dbforge.
         *
         */

        /**
         * Create database
         *
         * @access      private
         * @param       string  the database name
         * @return      bool
         */
        function _create_database($name)
        {
                return "CREATE DATABASE ".$name;
        }

        // --------------------------------------------------------------------

        /**
         * Drop database
         *
         * @access      private
         * @param       string  the database name
         * @return      bool
         */
        function _drop_database($name)
        {
                return "DROP DATABASE ".$name;
        }

}


/* End of file mssql_utility.php */
/* Location: ./system/database/drivers/mssql/mssql_utility.php */