1: <?php
2:
3: 4: 5: 6:
7:
8: namespace Nette\Database\Drivers;
9:
10: use Nette;
11:
12:
13: 14: 15: 16: 17:
18: class OdbcDriver extends Nette\Object implements Nette\Database\ISupplementalDriver
19: {
20:
21: private $connection;
22:
23:
24: public function __construct(Nette\Database\Connection $connection, array $options)
25: {
26: $this->connection = $connection;
27: }
28:
29:
30:
31:
32:
33: 34: 35:
36: public function delimite($name)
37: {
38: return '[' . str_replace(array('[', ']'), array('[[', ']]'), $name) . ']';
39: }
40:
41:
42: 43: 44:
45: public function formatBool($value)
46: {
47: return $value ? '1' : '0';
48: }
49:
50:
51: 52: 53:
54: public function formatDateTime(\DateTime $value)
55: {
56: return $value->format('#m/d/Y H:i:s#');
57: }
58:
59:
60: 61: 62:
63: public function formatLike($value, $pos)
64: {
65: $value = strtr($value, array("'" => "''", '%' => '[%]', '_' => '[_]', '[' => '[[]'));
66: return ($pos <= 0 ? "'%" : "'") . $value . ($pos >= 0 ? "%'" : "'");
67: }
68:
69:
70: 71: 72:
73: public function applyLimit(& $sql, $limit, $offset)
74: {
75: if ($limit >= 0) {
76: $sql = 'SELECT TOP ' . (int) $limit . ' * FROM (' . $sql . ')';
77: }
78:
79: if ($offset) {
80: throw new Nette\InvalidArgumentException('Offset is not implemented in driver odbc.');
81: }
82: }
83:
84:
85: 86: 87:
88: public function normalizeRow($row, $statement)
89: {
90: return $row;
91: }
92:
93:
94:
95:
96:
97: 98: 99:
100: public function getTables()
101: {
102: throw new Nette\NotImplementedException;
103: }
104:
105:
106: 107: 108:
109: public function getColumns($table)
110: {
111: throw new Nette\NotImplementedException;
112: }
113:
114:
115: 116: 117:
118: public function getIndexes($table)
119: {
120: throw new Nette\NotImplementedException;
121: }
122:
123:
124: 125: 126:
127: public function getForeignKeys($table)
128: {
129: throw new Nette\NotImplementedException;
130: }
131:
132:
133: 134: 135:
136: public function isSupported($item)
137: {
138: return $item === self::SUPPORT_COLUMNS_META;
139: }
140:
141: }
142: