• 홈
• BcSqlite

PHP 클래스 BcSqlite

파일 보기 프로젝트 열기: baserproject/basercms

공개 프로퍼티들

프로퍼티	타입	설명
$columns	array	SQLite3 column definition
$description	string	..
$endQuote	string	..
$last_error
$pdo_statement
$row_count
$rows
$startQuote	string	..

보호된 프로퍼티들

프로퍼티	타입	설명
$_baseConfig	array	Base configuration settings for SQLite3 driver

공개 메소드들

메소드	설명
alterSchema ( array $compare, $table = null ) : array	Generate a MySQL Alter Table syntax for the given Schema comparison
alterTable ( array $options ) : boolean	テーブル構造を変更する
begin ( ) : boolean	Begin a transaction TODO データベースがロックされてしまい正常に処理が実行されないのでとりあえず未実装とする ロックに関する原因については未解析
buildColumn ( array $column ) : string	Generate a database-native column schema string
buildIndex ( array $indexes, string $table = null ) : string	Removes redundant primary key indexes, as they are handled in the column def of the key.
buildRenameTable ( string $sourceName, string $targetName ) : string	テーブル名のリネームステートメントを生成
column ( string $real ) : string	Converts database-layer column types to basic types
commit ( ) : boolean	Commit a transaction TODO データベースがロックされてしまい正常に処理が実行されないのでとりあえず未実装とする ロックに関する原因については未解析
connect ( ) : mixed	Connects to the database using config['database'] as a filename.
describe ( $model ) : array	Returns an array of the fields in given table name.
disconnect ( ) : boolean	Disconnects from database.
dropColumn ( array $options ) : boolean	カラムを削除する
fetchResult ( ) : unknown	Fetches the next row from the current result set
hasResult ( )	PDO deals in objects, not resources, so overload accordingly.
index ( string $model ) : array	Overrides DboSource::index to handle SQLite indexe introspection Returns an array of the indexes in given table name.
lastAffected ( $source = null ) : integer	Returns number of affected rows in previous database operation. If no previous operation exists, this returns false.
lastError ( PDOStatement $query = null ) : string	Returns a formatted error message from previous database operation.
lastInsertId ( $source = null ) : integer	Returns the ID generated from the previous INSERT operation.
lastNumRows ( $source = null ) : integer	Returns number of rows in previous resultset. If no previous resultset exists, this returns false.
limit ( integer $limit, integer $offset = null ) : string	Returns a limit statement in the correct format for the particular database.
listSources ( $data = null ) : array	Returns an array of tables in the database. If there are no tables, an error is raised and the application exits.
renameColumn ( array $options ) : boolean	カラムを変更する
renderStatement ( string $type, array $data ) : string	Overrides DboSource::renderStatement to handle schema generation with SQLite3-style indexes
resultSet ( mixed $results ) : void	Generate ResultSet
rollback ( ) : boolean	Rollback a transaction TODO データベースがロックされてしまい正常に処理が実行されないのでとりあえず未実装とする ロックに関する原因については未解析
update ( Model $model, array $fields = null, array $values = null, mixed $conditions = null ) : array	Generates and executes an SQL UPDATE statement for given model, fields, and values.
value ( string $data, string $column = null, integer $safe = false ) : string	Returns a quoted and escaped string of $data for use in an SQL statement.

보호된 메소드들

메소드	설명
_alterIndexes ( string $table, $indexes ) : array	Generate index alteration statements for a table.
_convertCsvFieldsFromSchema ( array $schema ) : string	スキーマ情報よりCSV形式のフィールドリストを取得する
_execute ( string $sql, $params = [], $prepareOptions = [] ) : resource	Executes given SQL statement.
_moveData ( string $sourceTableName, string $targetTableName, array $schema ) : booelan	テーブルからテーブルへデータを移動する

비공개 메소드들

메소드	설명
__describe ( Model $model ) : mixed	Returns a Model description (metadata) or null if none found.

메소드 상세

프로퍼티 상세