1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
<?php
/**
* Zend Framework (http://framework.zend.com/)
*
* @link http://github.com/zendframework/zf2 for the canonical source repository
* @copyright Copyright (c) 2005-2016 Zend Technologies USA Inc. (http://www.zend.com)
* @license http://framework.zend.com/license/new-bsd New BSD License
*/
namespace Zend\Db\Sql\Ddl\Index;
class Index extends AbstractIndex
{
/**
* @var string
*/
protected $specification = 'INDEX %s(...)';
/**
* @var array
*/
protected $lengths;
/**
* @param string|array|null $columns
* @param null|string $name
* @param array $lengths
*/
public function __construct($columns, $name = null, array $lengths = [])
{
$this->setColumns($columns);
$this->name = null === $name ? null : (string) $name;
$this->lengths = $lengths;
}
/**
*
* @return array of array|string should return an array in the format:
*
* array (
* // a sprintf formatted string
* string $specification,
*
* // the values for the above sprintf formatted string
* array $values,
*
* // an array of equal length of the $values array, with either TYPE_IDENTIFIER or TYPE_VALUE for each value
* array $types,
* )
*
*/
public function getExpressionData()
{
$colCount = count($this->columns);
$values = [];
$values[] = $this->name ?: '';
$newSpecTypes = [self::TYPE_IDENTIFIER];
$newSpecParts = [];
for ($i = 0; $i < $colCount; $i++) {
$specPart = '%s';
if (isset($this->lengths[$i])) {
$specPart .= "({$this->lengths[$i]})";
}
$newSpecParts[] = $specPart;
$newSpecTypes[] = self::TYPE_IDENTIFIER;
}
$newSpec = str_replace('...', implode(', ', $newSpecParts), $this->specification);
return [[
$newSpec,
array_merge($values, $this->columns),
$newSpecTypes,
]];
}
}