protected function DatabaseSchema_sqlite::createFieldSql in Drupal 7
Create an SQL string for a field to be used in table creation or alteration.
Before passing a field out of a schema definition into this function it has to be processed by db_processField().
Parameters
$name: Name of the field.
$spec: The field specification, as per the schema data structure format.
2 calls to DatabaseSchema_sqlite::createFieldSql()
- DatabaseSchema_sqlite::addField in includes/
database/ sqlite/ schema.inc - Add a new field to a table.
- DatabaseSchema_sqlite::createColumsSql in includes/
database/ sqlite/ schema.inc - Build the SQL expression for creating columns.
File
- includes/
database/ sqlite/ schema.inc, line 147 - Database schema code for SQLite databases.
Class
Code
protected function createFieldSql($name, $spec) {
if (!empty($spec['auto_increment'])) {
$sql = $name . " INTEGER PRIMARY KEY AUTOINCREMENT";
if (!empty($spec['unsigned'])) {
$sql .= ' CHECK (' . $name . '>= 0)';
}
}
else {
$sql = $name . ' ' . $spec['sqlite_type'];
if (in_array($spec['sqlite_type'], array(
'VARCHAR',
'TEXT',
)) && isset($spec['length'])) {
$sql .= '(' . $spec['length'] . ')';
}
if (isset($spec['not null'])) {
if ($spec['not null']) {
$sql .= ' NOT NULL';
}
else {
$sql .= ' NULL';
}
}
if (!empty($spec['unsigned'])) {
$sql .= ' CHECK (' . $name . '>= 0)';
}
if (isset($spec['default'])) {
if (is_string($spec['default'])) {
$spec['default'] = "'" . $spec['default'] . "'";
}
$sql .= ' DEFAULT ' . $spec['default'];
}
if (empty($spec['not null']) && !isset($spec['default'])) {
$sql .= ' DEFAULT NULL';
}
}
return $sql;
}