本文整理汇总了PHP中ADOConnection::MetaTables方法的典型用法代码示例。如果您正苦于以下问题:PHP ADOConnection::MetaTables方法的具体用法?PHP ADOConnection::MetaTables怎么用?PHP ADOConnection::MetaTables使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类ADOConnection
的用法示例。
在下文中一共展示了ADOConnection::MetaTables方法的10个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的PHP代码示例。
示例1: MetaTables
function MetaTables($ttype = false, $showSchema = false, $mask = false)
{
if ($mask) {
$save = $this->metaTablesSQL;
$mask = $this->qstr(strtoupper($mask));
$this->metaTablesSQL .= " AND table_name like {$mask}";
}
$ret = ADOConnection::MetaTables($ttype, $showSchema);
if ($mask) {
$this->metaTablesSQL = $save;
}
return $ret;
}
示例2:
function &MetaTables($ttype = false, $showSchema = false, $mask = false)
{
if ($mask) {
$save = $this->metaTablesSQL;
$mask = $this->qstr($mask);
$this->metaTablesSQL .= " like {$mask}";
}
$ret =& ADOConnection::MetaTables($ttype, $showSchema);
if ($mask) {
$this->metaTablesSQL = $save;
}
return $ret;
}
示例3: MetaTables
function MetaTables($ttype = false, $showSchema = false, $mask = false)
{
$save = $this->metaTablesSQL;
if ($showSchema && is_string($showSchema)) {
$this->metaTablesSQL .= " from {$showSchema}";
}
if ($mask) {
$mask = $this->qstr($mask);
$this->metaTablesSQL .= " like {$mask}";
}
$ret = ADOConnection::MetaTables($ttype, $showSchema);
$this->metaTablesSQL = $save;
return $ret;
}
示例4: MetaTables
function MetaTables($ttype = false, $showSchema = false, $mask = false)
{
$save = $this->metaTablesSQL;
if ($showSchema && is_string($showSchema)) {
$this->metaTablesSQL .= $this->qstr($showSchema);
} else {
$this->metaTablesSQL .= "schema()";
}
if ($mask) {
$mask = $this->qstr($mask);
$this->metaTablesSQL .= " AND table_name LIKE {$mask}";
}
$ret = ADOConnection::MetaTables($ttype, $showSchema);
$this->metaTablesSQL = $save;
return $ret;
}
示例5: MetaTables
function MetaTables($ttype = false, $showSchema = false, $mask = false)
{
$info = $this->ServerInfo();
if ($info['version'] >= 7.3) {
$this->metaTablesSQL = "select tablename,'T' from pg_tables where tablename not like 'pg\\_%'\n\t\t\t and schemaname not in ( 'pg_catalog','information_schema')\n\tunion \n select viewname,'V' from pg_views where viewname not like 'pg\\_%' and schemaname not in ( 'pg_catalog','information_schema') ";
}
if ($mask) {
$save = $this->metaTablesSQL;
$mask = $this->qstr(strtolower($mask));
if ($info['version'] >= 7.3) {
$this->metaTablesSQL = "\nselect tablename,'T' from pg_tables where tablename like {$mask} and schemaname not in ( 'pg_catalog','information_schema') \n union \nselect viewname,'V' from pg_views where viewname like {$mask} and schemaname not in ( 'pg_catalog','information_schema') ";
} else {
$this->metaTablesSQL = "\nselect tablename,'T' from pg_tables where tablename like {$mask} \n union \nselect viewname,'V' from pg_views where viewname like {$mask}";
}
}
$ret = ADOConnection::MetaTables($ttype, $showSchema);
if ($mask) {
$this->metaTablesSQL = $save;
}
return $ret;
}
示例6: getTableNameList
/**
* get table name list
*
* @return array tablename
* @access public
*/
function getTableNameList()
{
return $tableArray = $this->connection->MetaTables("TABLES");
}
示例7: MetaTables
function MetaTables()
{
return ADOConnection::MetaTables();
}
示例8:
function &MetaTables($ttype = false, $showSchema = false, $mask = false)
{
if ($mask) {
$save = $this->metaTablesSQL;
$mask = $this->qstr(strtolower($mask));
$this->metaTablesSQL = "\nselect tablename,'T' from pg_tables where tablename like {$mask} union \nselect viewname,'V' from pg_views where viewname like {$mask}";
}
$ret =& ADOConnection::MetaTables($ttype, $showSchema);
if ($mask) {
$this->metaTablesSQL = $save;
}
return $ret;
}
示例9: MetaTables
function MetaTables($ttype=false,$showSchema=false,$mask=false)
{
if ($mask) {$this->debug=1;
$save = $this->metaTablesSQL;
$mask = $this->qstr($mask);
$this->metaTablesSQL .= " AND name like $mask";
}
$ret = ADOConnection::MetaTables($ttype,$showSchema);
if ($mask) {
$this->metaTablesSQL = $save;
}
return $ret;
}
示例10: MetaTables
function MetaTables($ttype = false, $showSchema = false, $mask = false)
{
// OVERWRITE 3: Insert
global $CFG;
$schema = $CFG->current_app->getShortName();
// END OVERWRITE 3
$info = $this->ServerInfo();
if ($info['version'] >= 7.3) {
// OVERWRITE 4: replacement, changed from:
//$this->metaTablesSQL = "select tablename,'T' from pg_tables where tablename not like 'pg\_%'
//and schemaname not in ( 'pg_catalog','information_schema')
//union
// select viewname,'V' from pg_views where viewname not like 'pg\_%' and schemaname not in ( 'pg_catalog','information_schema') ";
// to:
$this->metaTablesSQL = "select tablename,'T' from pg_tables where tablename not like 'pg\\_%'\n\t\t\t and schemaname = '{$schema}'\n\tunion\n select viewname,'V' from pg_views where viewname not like 'pg\\_%' and schemaname = '{$schema}'";
// END OVERWRITE 4
}
if ($mask) {
$save = $this->metaTablesSQL;
$mask = $this->qstr(strtolower($mask));
if ($info['version'] >= 7.3) {
// OVERWRITE 5: replacement, changed from:
//$this->metaTablesSQL = "
//select tablename,'T' from pg_tables where tablename like $mask and schemaname not in ( 'pg_catalog','information_schema')
// union
//select viewname,'V' from pg_views where viewname like $mask and schemaname not in ( 'pg_catalog','information_schema') ";
// to:
$this->metaTablesSQL = "\nselect tablename,'T' from pg_tables where tablename like {$mask} and schemaname = '{$schema}'\n union\nselect viewname,'V' from pg_views where viewname like {$mask} and schemaname = '{$schema}'";
} else {
$this->metaTablesSQL = "\nselect tablename,'T' from pg_tables where tablename like {$mask}\n union\nselect viewname,'V' from pg_views where viewname like {$mask}";
}
}
$ret = ADOConnection::MetaTables($ttype, $showSchema);
if ($mask) {
$this->metaTablesSQL = $save;
}
return $ret;
}