PRADO Component Framework for PHP 5
  • Home
  • About
  • Testimonials
  • Demos
  • Download
  • Documentation
  • Forum
  • Development
  • Tutorials
  • Class Docs
  • API Manual
  • Wiki

Packages

  • None
  • System
    • Caching
    • Collections
    • Data
      • ActiveRecord
        • Relations
        • Scaffold
          • InputBuilder
      • Commom
        • Sqlite
      • Common
        • Mssql
        • Mysql
        • Oracle
        • Pgsql
        • Sqlite
      • DataGateway
      • SqlMap
        • Configuration
        • Statements
    • Exceptions
    • I18N
    • IO
    • Security
    • Util
    • Web
      • Javascripts
      • Services
      • UI
        • ActiveControls
        • WebControls
    • Xml
  • Wsat
    • pages
  • Overview
  • Package
  • Class
  • Tree
  • Deprecated
  • Todo

Class TSqliteMetaData

TSqliteMetaData loads SQLite database table and column information.

TComponent
Extended by TDbMetaData
Extended by TSqliteMetaData
Package: System\Data\Commom\Sqlite
Copyright: Copyright © 2005-2014 PradoSoft
License: http://www.pradosoft.com/license/
Author: Wei Zhuo <weizho[at]gmail[dot]com>
Since: 3.1
Located at Data/Common/Sqlite/TSqliteMetaData.php
Methods summary
protected string
# getTableInfoClass( )

Returns

string
TDbTableInfo class name.

Overrides

TDbMetaData::getTableInfoClass()
public string
# quoteTableName( string $name )

Quotes a table name for use in a query.

Quotes a table name for use in a query.

Parameters

$name
string
$name table name

Returns

string
the properly quoted table name

Overrides

TDbMetaData::quoteTableName()
public string
# quoteColumnName( string $name )

Quotes a column name for use in a query.

Quotes a column name for use in a query.

Parameters

$name
string
$name column name

Returns

string
the properly quoted column name

Overrides

TDbMetaData::quoteColumnName()
public string
# quoteColumnAlias( string $name )

Quotes a column alias for use in a query.

Quotes a column alias for use in a query.

Parameters

$name
string
$name column alias

Returns

string
the properly quoted column alias

Overrides

TDbMetaData::quoteColumnAlias()
protected TPgsqlTableInfo
# createTableInfo( string $tableName )

Get the column definitions for given table.

Get the column definitions for given table.

Parameters

$tableName
string
table name.

Returns

TPgsqlTableInfo
table information.
protected boolean
# getIsView( string $tableName )

Parameters

$tableName
string
table name.

Returns

boolean
true if the table is a view.
protected TSqliteTableColumn
# processColumn( array $col, array $foreign )

Parameters

$col
array
column information.
$foreign
array
foreign key details.

Returns

TSqliteTableColumn
column details.
protected array
# getForeignKeys( string $table )

Parameters

$table
string
quoted table name.

Returns

array
foreign key details.
protected boolean
# isForeignKeyColumn( string $columnId, array $foreign )

Parameters

$columnId
string
column name.
$foreign
array
foreign key column names.

Returns

boolean
true if column is a foreign key.
public array
# findTableNames( string $schema = '' )

Returns all table names in the database.

Returns all table names in the database.

Parameters

$schema
string
$schema the schema of the tables. This is not used for sqlite database.

Returns

array
all table names in the database.
Methods inherited from TDbMetaData
__construct(), createCommandBuilder(), getDbConnection(), getInstance(), getTableInfo()
Methods inherited from TComponent
__call(), __destruct(), __get(), __isset(), __set(), __sleep(), __unset(), __wakeup(), addParsedObject(), asa(), attachBehavior(), attachBehaviors(), attachClassBehavior(), attachEventHandler(), canGetProperty(), canSetProperty(), clearBehaviors(), createdOnTemplate(), detachBehavior(), detachBehaviors(), detachClassBehavior(), detachEventHandler(), disableBehavior(), disableBehaviors(), enableBehavior(), enableBehaviors(), evaluateExpression(), evaluateStatements(), fxAttachClassBehavior(), fxDetachClassBehavior(), getAutoGlobalListen(), getBehaviorsEnabled(), getClassHierarchy(), getEventHandlers(), getListeningToGlobalEvents(), getSubProperty(), hasEvent(), hasEventHandler(), hasProperty(), isa(), listen(), raiseEvent(), setSubProperty(), unlisten()
Constants inherited from TComponent
GLOBAL_RAISE_EVENT_LISTENER
Properties inherited from TDbMetaData
$delimiterIdentifier
Terms of Service | Contact Us
PRADO v3.2.4 API Manual API documentation generated by ApiGen 2.8.0
Copyright © 2006-2014 by the PRADO Group.
Powered by PRADO