API Documentation
\
Pop
Acl
Assertion
Audit
Adapter
Model
Auth
Http
Cache
Adapter
Code
Generator
Config
Console
Controller
Cookie
Css
Color
Csv
Db
Adapter
Profiler
Gateway
Parser
Record
Relationships
Sql
Migration
Predicate
Schema
Seeder
Debug
Handler
Storage
Dir
Dom
Event
Form
Element
Input
Select
Filter
Ftp
Http
Client
Response
I18n
Format
Image
Adapter
Adjust
Color
Draw
Effect
Filter
Layer
Type
Kettle
Controller
Event
Model
Loader
Log
Writer
Mail
Client
Message
Transport
Smtp
Auth
Stream
Byte
Filter
Model
Module
Nav
Paginator
Pdf
Build
Font
Standard
TrueType
Table
Cmap
Html
Image
PdfObject
Document
Page
Annotation
Color
Field
Text
Router
Match
Service
Session
Validator
View
Template
Stream
Popcorn

\Pop\Db\SqlData

Data parser class

Summary

Methods
Properties
Constants
__construct()
isMysql()
isPgsql()
isSqlsrv()
isSqlite()
db()
getDb()
setIdQuoteType()
setPlaceholder()
getDbType()
getIdQuoteType()
getPlaceholder()
quoteId()
quote()
setDivide()
getDivide()
setTable()
getTable()
getSql()
isSerialized()
serialize()
writeToFile()
streamToFile()
__toString()
No public properties found
MYSQL
PGSQL
SQLITE
SQLSRV
BACKTICK
BRACKET
DOUBLE_QUOTE
NO_QUOTE
No protected methods found
$db
$dbType
$idQuoteType
$placeholder
$table
$divide
$sql
N/A
No private methods found
No private properties found
N/A

Constants

MYSQL

MYSQL

Constants for database types

PGSQL

PGSQL

SQLITE

SQLITE

SQLSRV

SQLSRV

BACKTICK

BACKTICK

Constants for id quote types

BRACKET

BRACKET

DOUBLE_QUOTE

DOUBLE_QUOTE

NO_QUOTE

NO_QUOTE

Properties

$dbType

$dbType : integer

Database type

Type

integer

$idQuoteType

$idQuoteType : string

ID quote type

Type

string

$placeholder

$placeholder : string

SQL placeholder

Type

string

$table

$table : string

Database table

Type

string

$divide

$divide : integer

Divide INSERT groups by # (0 creates one big INSERT statement, 1 creates an INSERT statement per row)

Type

integer

$sql

$sql : string

SQL string

Type

string

Methods

__construct()

__construct(\Pop\Db\Adapter\AbstractAdapter  $db, string  $table = 'pop_db_data', integer  $divide = 1)

Constructor

Instantiate the SQL object

Parameters

\Pop\Db\Adapter\AbstractAdapter $db
string $table
integer $divide

isMysql()

isMysql() : boolean

Determine if the DB type is MySQL

Returns

boolean

isPgsql()

isPgsql() : boolean

Determine if the DB type is PostgreSQL

Returns

boolean

isSqlsrv()

isSqlsrv() : boolean

Determine if the DB type is SQL Server

Returns

boolean

isSqlite()

isSqlite() : boolean

Determine if the DB type is SQLite

Returns

boolean

setIdQuoteType()

setIdQuoteType(string  $type = self::NO_QUOTE) : \Pop\Db\Sql\AbstractSql

Set the quote ID type

Parameters

string $type

Returns

\Pop\Db\Sql\AbstractSql

setPlaceholder()

setPlaceholder(string  $placeholder) : \Pop\Db\Sql\AbstractSql

Set the placeholder

Parameters

string $placeholder

Returns

\Pop\Db\Sql\AbstractSql

getDbType()

getDbType() : integer

Get the current database type

Returns

integer

getIdQuoteType()

getIdQuoteType() : integer

Get the quote ID type

Returns

integer

getPlaceholder()

getPlaceholder() : string

Get the SQL placeholder

Returns

string

quoteId()

quoteId(string  $identifier) : string

Quote the identifier

Parameters

string $identifier

Returns

string

quote()

quote(string  $value) : string

Quote the value (if it is not a numeric value)

Parameters

string $value

Returns

string

setDivide()

setDivide(integer  $divide) : \Pop\Db\Sql\Data

Set the INSERT divide

Parameters

integer $divide

Returns

\Pop\Db\Sql\Data

getDivide()

getDivide() : integer

Get the INSERT divide

Returns

integer

setTable()

setTable(string  $table) : \Pop\Db\Sql\Data

Set the database table

Parameters

string $table

Returns

\Pop\Db\Sql\Data

getTable()

getTable() : string

Get the database table

Returns

string

getSql()

getSql() : string

Get SQL string

Returns

string

isSerialized()

isSerialized() : boolean

Check if data was serialized into SQL

Returns

boolean

serialize()

serialize(array  $data, mixed  $omit = null, boolean  $nullEmpty = false, array  $updateColumns = array()) : string

Serialize the data into INSERT statements

Parameters

array $data
mixed $omit
boolean $nullEmpty
array $updateColumns

Returns

string

writeToFile()

writeToFile(string  $to, string  $header = null, string  $footer = null) : void

Output SQL to a file

Parameters

string $to
string $header
string $footer

streamToFile()

streamToFile(array  $data, string  $to, mixed  $omit = null, boolean  $nullEmpty = false, array  $updateColumns = array(), string  $header = null, string  $footer = null) : void

Serialize the data into INSERT statements

Parameters

array $data
string $to
mixed $omit
boolean $nullEmpty
array $updateColumns
string $header
string $footer

__toString()

__toString() : string

__toString magic method

Returns

string