blob: efb4bca0257b9e44cab5ccfa394e4ba36a16f49e [file] [log] [blame]
Andrey Andreev24abcb92012-01-05 20:40:15 +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 Andreev24abcb92012-01-05 20:40:15 +02008 *
Derek Jonesf4a4bd82011-10-20 12:18:42 -05009 * Licensed under the Open Software License version 3.0
Andrey Andreev24abcb92012-01-05 20:40:15 +020010 *
Derek Jonesf4a4bd82011-10-20 12:18:42 -050011 * This source file is subject to the Open Software License (OSL 3.0) that is
Andrey Andreev342a4662012-01-24 15:24:00 +020012 * bundled with this package in the files license.txt / license.rst. It is
Derek Jonesf4a4bd82011-10-20 12:18:42 -050013 * 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 * Oracle 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_oci8_utility extends CI_DB_utility {
36
37 /**
38 * List databases
39 *
Andrey Andreev24abcb92012-01-05 20:40:15 +020040 * Generates a platform-specific query so that we get a list of schemas
41 * Those are actually usernames in Oracle.
42 *
43 * @return string
Derek Allard2067d1a2008-11-13 22:59:24 +000044 */
Andrey Andreev24abcb92012-01-05 20:40:15 +020045 public function _list_databases()
Derek Allard2067d1a2008-11-13 22:59:24 +000046 {
Andrey Andreev24abcb92012-01-05 20:40:15 +020047 return 'SELECT username FROM dba_users';
Derek Allard2067d1a2008-11-13 22:59:24 +000048 }
49
50 // --------------------------------------------------------------------
51
52 /**
53 * Optimize table query
54 *
55 * Generates a platform-specific query so that a table can be optimized
56 *
Derek Allard2067d1a2008-11-13 22:59:24 +000057 * @param string the table name
Andrey Andreev24abcb92012-01-05 20:40:15 +020058 * @return bool
Derek Allard2067d1a2008-11-13 22:59:24 +000059 */
Andrey Andreev24abcb92012-01-05 20:40:15 +020060 public function _optimize_table($table)
Derek Allard2067d1a2008-11-13 22:59:24 +000061 {
Andrey Andreev24abcb92012-01-05 20:40:15 +020062 return FALSE; // Not supported in Oracle
Derek Allard2067d1a2008-11-13 22:59:24 +000063 }
64
65 // --------------------------------------------------------------------
66
67 /**
68 * Repair table query
69 *
70 * Generates a platform-specific query so that a table can be repaired
71 *
Derek Allard2067d1a2008-11-13 22:59:24 +000072 * @param string the table name
Andrey Andreev24abcb92012-01-05 20:40:15 +020073 * @return bool
Derek Allard2067d1a2008-11-13 22:59:24 +000074 */
Andrey Andreev24abcb92012-01-05 20:40:15 +020075 public function _repair_table($table)
Derek Allard2067d1a2008-11-13 22:59:24 +000076 {
Andrey Andreev24abcb92012-01-05 20:40:15 +020077 return FALSE; // Not supported in Oracle
Derek Allard2067d1a2008-11-13 22:59:24 +000078 }
79
80 // --------------------------------------------------------------------
81
82 /**
83 * Oracle Export
84 *
Derek Allard2067d1a2008-11-13 22:59:24 +000085 * @param array Preferences
86 * @return mixed
87 */
Andrey Andreev24abcb92012-01-05 20:40:15 +020088 public function _backup($params = array())
Derek Allard2067d1a2008-11-13 22:59:24 +000089 {
90 // Currently unsupported
91 return $this->db->display_error('db_unsuported_feature');
92 }
Andrey Andreev24abcb92012-01-05 20:40:15 +020093
Derek Allard2067d1a2008-11-13 22:59:24 +000094}
95
96/* End of file oci8_utility.php */
Derek Jonesa3ffbbb2008-05-11 18:18:29 +000097/* Location: ./system/database/drivers/oci8/oci8_utility.php */