Class DbCache
A cache service that stored data in databases
- Wei\Base
- Wei\BaseCache
- Wei\DbCache
public
|
|
public
|
|
public
mixed
|
|
public
boolean
|
|
public
boolean
|
|
public
boolean
|
|
public
boolean
|
|
public
boolean
|
|
public
integer|false
|
|
public
boolean
|
__invoke(),
decr(),
getFileContent(),
getMulti(),
getNamespace(),
processGetResult(),
setMulti(),
setNamespace()
|
__call(),
__get(),
getOption(),
setOption()
|
protected
string
|
$table
The cache table name |
#
'cache'
|
protected
boolean
|
$checkTable
Whether check if table is exists or not |
#
true
|
protected
array
|
$checkTableSqls
The SQL to check if table exists |
#
array(
'mysql' => "SHOW TABLES LIKE '%s'",
'sqlite' => "SELECT name FROM sqlite_master WHERE type='table' AND name='%s'",
'pgsql' => "SELECT true FROM pg_tables WHERE tablename = '%s'"
)
|
protected
array
|
$createTableSqls
The SQL to create cache table |
#
array(
'mysql' => "CREATE TABLE %s (id VARCHAR(255) NOT NULL, value LONGTEXT NOT NULL, expire DATETIME NOT NULL, lastModified DATETIME NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB",
'sqlite' => "CREATE TABLE %s (id VARCHAR(255) NOT NULL, value CLOB NOT NULL, expire DATETIME NOT NULL, lastModified DATETIME NOT NULL, PRIMARY KEY(id))",
'pgsql' => "CREATE TABLE %s (id VARCHAR(255) NOT NULL, value TEXT NOT NULL, expire TIMESTAMP(0) WITHOUT TIME ZONE NOT NULL, lastModified TIMESTAMP(0) WITHOUT TIME ZONE NOT NULL, PRIMARY KEY(id))",
)
|
$namespace
|
$providers,
$wei
|
public
|
$db
A database service |