blob: 5c144330d85bd3873cdee30e3064f36c89bf0a10 [file] [log] [blame]
Andrey Andreevc0664812012-03-20 16:07:59 +02001<?php if ( ! defined('BASEPATH')) exit('No direct script access allowed');
Derek Allard2067d1a2008-11-13 22:59:24 +00002/**
3 * CodeIgniter
4 *
Phil Sturgeon07c1ac82012-03-09 17:03:37 +00005 * An open source application development framework for PHP 5.2.4 or newer
Derek Allard2067d1a2008-11-13 22:59:24 +00006 *
Derek Jonesf4a4bd82011-10-20 12:18:42 -05007 * NOTICE OF LICENSE
Andrey Andreevc0664812012-03-20 16:07:59 +02008 *
Derek Jonesf4a4bd82011-10-20 12:18:42 -05009 * Licensed under the Open Software License version 3.0
Andrey Andreevc0664812012-03-20 16:07:59 +020010 *
Derek Jonesf4a4bd82011-10-20 12:18:42 -050011 * This source file is subject to the Open Software License (OSL 3.0) that is
12 * bundled with this package in the files license.txt / license.rst. It is
13 * also available through the world wide web at this URL:
14 * http://opensource.org/licenses/OSL-3.0
15 * If you did not receive a copy of the license and are unable to obtain it
16 * through the world wide web, please send an email to
17 * licensing@ellislab.com so we can send you a copy immediately.
18 *
Derek Allard2067d1a2008-11-13 22:59:24 +000019 * @package CodeIgniter
Derek Jonesf4a4bd82011-10-20 12:18:42 -050020 * @author EllisLab Dev Team
Greg Aker0defe5d2012-01-01 18:46:41 -060021 * @copyright Copyright (c) 2008 - 2012, EllisLab, Inc. (http://ellislab.com/)
Derek Jonesf4a4bd82011-10-20 12:18:42 -050022 * @license http://opensource.org/licenses/OSL-3.0 Open Software License (OSL 3.0)
Derek Allard2067d1a2008-11-13 22:59:24 +000023 * @link http://codeigniter.com
24 * @since Version 1.0
25 * @filesource
26 */
27
Derek Allard2067d1a2008-11-13 22:59:24 +000028/**
29 * MS SQL Utility Class
30 *
31 * @category Database
Derek Jonesf4a4bd82011-10-20 12:18:42 -050032 * @author EllisLab Dev Team
Derek Allard2067d1a2008-11-13 22:59:24 +000033 * @link http://codeigniter.com/user_guide/database/
34 */
35class CI_DB_mssql_utility extends CI_DB_utility {
36
37 /**
38 * List databases
39 *
Andrey Andreevc0664812012-03-20 16:07:59 +020040 * @return string
Derek Allard2067d1a2008-11-13 22:59:24 +000041 */
Andrey Andreevc0664812012-03-20 16:07:59 +020042 public function _list_databases()
Derek Allard2067d1a2008-11-13 22:59:24 +000043 {
44 return "EXEC sp_helpdb"; // Can also be: EXEC sp_databases
45 }
46
47 // --------------------------------------------------------------------
48
49 /**
50 * Optimize table query
51 *
52 * Generates a platform-specific query so that a table can be optimized
53 *
Derek Allard2067d1a2008-11-13 22:59:24 +000054 * @param string the table name
Andrey Andreevc0664812012-03-20 16:07:59 +020055 * @return bool
Derek Allard2067d1a2008-11-13 22:59:24 +000056 */
Andrey Andreevc0664812012-03-20 16:07:59 +020057 public function _optimize_table($table)
Derek Allard2067d1a2008-11-13 22:59:24 +000058 {
59 return FALSE; // Is this supported in MS SQL?
60 }
61
62 // --------------------------------------------------------------------
Barry Mienydd671972010-10-04 16:33:58 +020063
Derek Allard2067d1a2008-11-13 22:59:24 +000064 /**
65 * Repair table query
66 *
67 * Generates a platform-specific query so that a table can be repaired
68 *
Derek Allard2067d1a2008-11-13 22:59:24 +000069 * @param string the table name
Andrey Andreevc0664812012-03-20 16:07:59 +020070 * @return bool
Derek Allard2067d1a2008-11-13 22:59:24 +000071 */
Andrey Andreevc0664812012-03-20 16:07:59 +020072 public function _repair_table($table)
Derek Allard2067d1a2008-11-13 22:59:24 +000073 {
74 return FALSE; // Is this supported in MS SQL?
75 }
76
77 // --------------------------------------------------------------------
78
79 /**
80 * MSSQL Export
81 *
Derek Allard2067d1a2008-11-13 22:59:24 +000082 * @param array Preferences
83 * @return mixed
84 */
Andrey Andreevc0664812012-03-20 16:07:59 +020085 public function _backup($params = array())
Derek Allard2067d1a2008-11-13 22:59:24 +000086 {
87 // Currently unsupported
88 return $this->db->display_error('db_unsuported_feature');
89 }
90
Derek Allard2067d1a2008-11-13 22:59:24 +000091}
92
Derek Allard2067d1a2008-11-13 22:59:24 +000093/* End of file mssql_utility.php */
Derek Jonesa3ffbbb2008-05-11 18:18:29 +000094/* Location: ./system/database/drivers/mssql/mssql_utility.php */