SQLiteGrammar
Extends
Properties
$modifiers string[]
The possible column modifiers.
$serials string[]
The columns available as serials.
Methods
compileTableExists ( ) : string
Compile the query to determine if a table exists.
compileColumnListing ( $table ) : string
Compile the query to determine the list of columns.
Parameters
- $table string
compileCreate ( Blueprint $blueprint , Fluent $command ) : string
Compile a create table command.
Parameters
addForeignKeys ( Blueprint $blueprint ) : string|null
Get the foreign key syntax for a table creation statement.
Parameters
- $blueprint Blueprint
getForeignKey ( $foreign ) : string
Get the SQL for the foreign key.
Parameters
- $foreign Fluent
addPrimaryKeys ( Blueprint $blueprint ) : string|null
Get the primary key syntax for a table creation statement.
Parameters
- $blueprint Blueprint
compileAdd ( Blueprint $blueprint , Fluent $command ) : array
Compile alter table commands for adding columns.
Parameters
compileUnique ( Blueprint $blueprint , Fluent $command ) : string
Compile a unique key command.
Parameters
compileIndex ( Blueprint $blueprint , Fluent $command ) : string
Compile a plain index key command.
Parameters
compileSpatialIndex ( Blueprint $blueprint , Fluent $command ) : void
Compile a spatial index key command.
Parameters
compileForeign ( Blueprint $blueprint , Fluent $command ) : string
Compile a foreign key command.
Parameters
compileDrop ( Blueprint $blueprint , Fluent $command ) : string
Compile a drop table command.
Parameters
compileDropIfExists ( Blueprint $blueprint , Fluent $command ) : string
Compile a drop table (if exists) command.
Parameters
compileDropAllTables ( ) : string
Compile the SQL needed to drop all tables.
compileDropAllViews ( ) : string
Compile the SQL needed to drop all views.
compileRebuild ( ) : string
Compile the SQL needed to rebuild the database.
compileDropColumn ( Blueprint $blueprint , Fluent $command , Connection $connection ) : array
Compile a drop column command.
Parameters
- $blueprint Blueprint
- $command Fluent
- $connection Connection
compileDropUnique ( Blueprint $blueprint , Fluent $command ) : string
Compile a drop unique key command.
Parameters
compileDropIndex ( Blueprint $blueprint , Fluent $command ) : string
Compile a drop index command.
Parameters
compileDropSpatialIndex ( Blueprint $blueprint , Fluent $command ) : void
Compile a drop spatial index command.
Parameters
compileRename ( Blueprint $blueprint , Fluent $command ) : string
Compile a rename table command.
Parameters
compileRenameIndex ( Blueprint $blueprint , Fluent $command , Connection $connection ) : array
Compile a rename index command.
Parameters
- $blueprint Blueprint
- $command Fluent
- $connection Connection
compileEnableForeignKeyConstraints ( ) : string
Compile the command to enable foreign key constraints.
compileDisableForeignKeyConstraints ( ) : string
Compile the command to disable foreign key constraints.
compileEnableWriteableSchema ( ) : string
Compile the SQL needed to enable a writable schema.
compileDisableWriteableSchema ( ) : string
Compile the SQL needed to disable a writable schema.
typeChar ( Fluent $column ) : string
Create the column definition for a char type.
Parameters
- $column Fluent
typeString ( Fluent $column ) : string
Create the column definition for a string type.
Parameters
- $column Fluent
typeTinyText ( Fluent $column ) : string
Create the column definition for a tiny text type.
Parameters
- $column Fluent
typeText ( Fluent $column ) : string
Create the column definition for a text type.
Parameters
- $column Fluent
typeMediumText ( Fluent $column ) : string
Create the column definition for a medium text type.
Parameters
- $column Fluent
typeLongText ( Fluent $column ) : string
Create the column definition for a long text type.
Parameters
- $column Fluent
typeInteger ( Fluent $column ) : string
Create the column definition for an integer type.
Parameters
- $column Fluent
typeBigInteger ( Fluent $column ) : string
Create the column definition for a big integer type.
Parameters
- $column Fluent
typeMediumInteger ( Fluent $column ) : string
Create the column definition for a medium integer type.
Parameters
- $column Fluent
typeTinyInteger ( Fluent $column ) : string
Create the column definition for a tiny integer type.
Parameters
- $column Fluent
typeSmallInteger ( Fluent $column ) : string
Create the column definition for a small integer type.
Parameters
- $column Fluent
typeFloat ( Fluent $column ) : string
Create the column definition for a float type.
Parameters
- $column Fluent
typeDouble ( Fluent $column ) : string
Create the column definition for a double type.
Parameters
- $column Fluent
typeDecimal ( Fluent $column ) : string
Create the column definition for a decimal type.
Parameters
- $column Fluent
typeBoolean ( Fluent $column ) : string
Create the column definition for a boolean type.
Parameters
- $column Fluent
typeEnum ( Fluent $column ) : string
Create the column definition for an enumeration type.
Parameters
- $column Fluent
typeJson ( Fluent $column ) : string
Create the column definition for a json type.
Parameters
- $column Fluent
typeJsonb ( Fluent $column ) : string
Create the column definition for a jsonb type.
Parameters
- $column Fluent
typeDate ( Fluent $column ) : string
Create the column definition for a date type.
Parameters
- $column Fluent
typeDateTime ( Fluent $column ) : string
Create the column definition for a date-time type.
Parameters
- $column Fluent
typeDateTimeTz ( Fluent $column ) : string
Create the column definition for a date-time (with time zone) type.
Parameters
- $column Fluent
typeTime ( Fluent $column ) : string
Create the column definition for a time type.
Parameters
- $column Fluent
typeTimeTz ( Fluent $column ) : string
Create the column definition for a time (with time zone) type.
Parameters
- $column Fluent
typeTimestamp ( Fluent $column ) : string
Create the column definition for a timestamp type.
Parameters
- $column Fluent
typeTimestampTz ( Fluent $column ) : string
Create the column definition for a timestamp (with time zone) type.
Parameters
- $column Fluent
typeYear ( Fluent $column ) : string
Create the column definition for a year type.
Parameters
- $column Fluent
typeBinary ( Fluent $column ) : string
Create the column definition for a binary type.
Parameters
- $column Fluent
typeUuid ( Fluent $column ) : string
Create the column definition for a uuid type.
Parameters
- $column Fluent
typeIpAddress ( Fluent $column ) : string
Create the column definition for an IP address type.
Parameters
- $column Fluent
typeMacAddress ( Fluent $column ) : string
Create the column definition for a MAC address type.
Parameters
- $column Fluent
typeGeometry ( Fluent $column ) : string
Create the column definition for a spatial Geometry type.
Parameters
- $column Fluent
typePoint ( Fluent $column ) : string
Create the column definition for a spatial Point type.
Parameters
- $column Fluent
typeLineString ( Fluent $column ) : string
Create the column definition for a spatial LineString type.
Parameters
- $column Fluent
typePolygon ( Fluent $column ) : string
Create the column definition for a spatial Polygon type.
Parameters
- $column Fluent
typeGeometryCollection ( Fluent $column ) : string
Create the column definition for a spatial GeometryCollection type.
Parameters
- $column Fluent
typeMultiPoint ( Fluent $column ) : string
Create the column definition for a spatial MultiPoint type.
Parameters
- $column Fluent
typeMultiLineString ( Fluent $column ) : string
Create the column definition for a spatial MultiLineString type.
Parameters
- $column Fluent
typeMultiPolygon ( Fluent $column ) : string
Create the column definition for a spatial MultiPolygon type.
Parameters
- $column Fluent
typeComputed ( Fluent $column ) : void
Create the column definition for a generated, computed column type.
Parameters
- $column Fluent
modifyVirtualAs ( Blueprint $blueprint , Fluent $column ) : string|null
Get the SQL for a generated virtual column modifier.
Parameters
modifyStoredAs ( Blueprint $blueprint , Fluent $column ) : string|null
Get the SQL for a generated stored column modifier.
Parameters
modifyNullable ( Blueprint $blueprint , Fluent $column ) : string|null
Get the SQL for a nullable column modifier.