1. interface
  2. Windwalker
  3. Query
  4. QueryGrammarInterface

QueryGrammarInterface

interface QueryGrammarInterface (View source)

QueryGrammar interface

Methods

static string
listDatabases()

showDatabases

static string
createDatabase(string $name)

createDatabase

static string
dropDatabase(string $name)

dropTable

static string
showTableColumns(string $table)

showTableColumn

static string
showDbTables(string $dbname)

showDbTables

static string
createTable(string $name, array $columns)

createTable

static string
dropTable(string $table)

dropTable

static string
addColumn(string $table, string $column, string $type = 'text')

Add column

static string
changeColumn(string $table, string $oldColumn, string $newColumn, string $type = 'text')

changeColumn

static string
dropColumn(string $table, string $column)

dropColumn

static string
addIndex(string $table, string $type, array $columns, string $name)

addIndex

static string
build()

build

static Query
getQuery(bool $new = false)

getQuery

Details

at line line 23
static string listDatabases()

showDatabases

Return Value

string

at line line 32
static string createDatabase(string $name)

createDatabase

Parameters

string $name

Return Value

string

at line line 41
static string dropDatabase(string $name)

dropTable

Parameters

string $name

Return Value

string

at line line 50
static string showTableColumns(string $table)

showTableColumn

Parameters

string $table

Return Value

string

at line line 59
static string showDbTables(string $dbname)

showDbTables

Parameters

string $dbname

Return Value

string

at line line 69
static string createTable(string $name, array $columns)

createTable

Parameters

string $name
array $columns

Return Value

string

at line line 78
static string dropTable(string $table)

dropTable

Parameters

string $table

Return Value

string

at line line 89
static string addColumn(string $table, string $column, string $type = 'text')

Add column

Parameters

string $table
string $column
string $type

Return Value

string

at line line 101
static string changeColumn(string $table, string $oldColumn, string $newColumn, string $type = 'text')

changeColumn

Parameters

string $table
string $oldColumn
string $newColumn
string $type

Return Value

string

at line line 111
static string dropColumn(string $table, string $column)

dropColumn

Parameters

string $table
string $column

Return Value

string

at line line 123
static string addIndex(string $table, string $type, array $columns, string $name)

addIndex

Parameters

string $table
string $type
array $columns
string $name

Return Value

string

at line line 130
static string build()

build

Return Value

string

at line line 139
static Query getQuery(bool $new = false)

getQuery

Parameters

bool $new

Return Value

Query