/halogy/database/drivers/mssql/mssql_utility.php

  1<?php  if ( ! defined('BASEPATH')) exit('No direct script access allowed');
  2/**
  3 * CodeIgniter
  4 *
  5 * An open source application development framework for PHP 4.3.2 or newer
  6 *
  7 * @package		CodeIgniter
  8 * @author		ExpressionEngine Dev Team
  9 * @copyright	Copyright (c) 2008 - 2009, EllisLab, Inc.
 10 * @license		http://codeigniter.com/user_guide/license.html
 11 * @link		http://codeigniter.com
 12 * @since		Version 1.0
 13 * @filesource
 14 */
 15
 16// ------------------------------------------------------------------------
 17
 18/**
 19 * MS SQL Utility Class
 20 *
 21 * @category	Database
 22 * @author		ExpressionEngine Dev Team
 23 * @link		http://codeigniter.com/user_guide/database/
 24 */
 25class CI_DB_mssql_utility extends CI_DB_utility {
 26
 27	/**
 28	 * List databases
 29	 *
 30	 * @access	private
 31	 * @return	bool
 32	 */
 33	function _list_databases()
 34	{
 35		return "EXEC sp_helpdb"; // Can also be: EXEC sp_databases
 36	}
 37
 38	// --------------------------------------------------------------------
 39
 40	/**
 41	 * Optimize table query
 42	 *
 43	 * Generates a platform-specific query so that a table can be optimized
 44	 *
 45	 * @access	private
 46	 * @param	string	the table name
 47	 * @return	object
 48	 */
 49	function _optimize_table($table)
 50	{
 51		return FALSE; // Is this supported in MS SQL?
 52	}
 53
 54	// --------------------------------------------------------------------
 55	
 56	/**
 57	 * Repair table query
 58	 *
 59	 * Generates a platform-specific query so that a table can be repaired
 60	 *
 61	 * @access	private
 62	 * @param	string	the table name
 63	 * @return	object
 64	 */
 65	function _repair_table($table)
 66	{
 67		return FALSE; // Is this supported in MS SQL?
 68	}
 69
 70	// --------------------------------------------------------------------
 71
 72	/**
 73	 * MSSQL Export
 74	 *
 75	 * @access	private
 76	 * @param	array	Preferences
 77	 * @return	mixed
 78	 */
 79	function _backup($params = array())
 80	{
 81		// Currently unsupported
 82		return $this->db->display_error('db_unsuported_feature');
 83	}
 84
 85	/**
 86	 *
 87	 * The functions below have been deprecated as of 1.6, and are only here for backwards
 88	 * compatibility.  They now reside in dbforge().  The use of dbutils for database manipulation
 89	 * is STRONGLY discouraged in favour if using dbforge.
 90	 *
 91	 */
 92
 93	/**
 94	 * Create database
 95	 *
 96	 * @access	private
 97	 * @param	string	the database name
 98	 * @return	bool
 99	 */
100	function _create_database($name)
101	{
102		return "CREATE DATABASE ".$name;
103	}
104
105	// --------------------------------------------------------------------
106
107	/**
108	 * Drop database
109	 *
110	 * @access	private
111	 * @param	string	the database name
112	 * @return	bool
113	 */
114	function _drop_database($name)
115	{
116		return "DROP DATABASE ".$name;
117	}
118
119}
120
121
122/* End of file mssql_utility.php */
123/* Location: ./system/database/drivers/mssql/mssql_utility.php */