5 * THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS
6 * "AS IS" AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT
7 * LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR
8 * A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT
9 * OWNER OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL,
10 * SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT
11 * LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE,
12 * DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY
13 * THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT
14 * (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE
15 * OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
17 * This software consists of voluntary contributions made by many individuals
18 * and is licensed under the MIT license. For more information, see
19 * <http://www.doctrine-project.org>.
22 namespace Doctrine\DBAL\Schema;
24 use Doctrine\DBAL\Schema\Visitor\Visitor;
25 use Doctrine\DBAL\Platforms\AbstractPlatform;
27 class ForeignKeyConstraint extends AbstractAsset implements Constraint
32 protected $_localTable;
37 protected $_localColumnNames;
42 protected $_foreignTableName;
47 protected $_foreignColumnNames;
52 protected $_cascade = '';
61 * @param array $localColumnNames
62 * @param string $foreignTableName
63 * @param array $foreignColumnNames
64 * @param string $cascade
65 * @param string|null $name
67 public function __construct(array $localColumnNames, $foreignTableName, array $foreignColumnNames, $name=null, array $options=array())
69 $this->_setName($name);
70 $this->_localColumnNames = $localColumnNames;
71 $this->_foreignTableName = $foreignTableName;
72 $this->_foreignColumnNames = $foreignColumnNames;
73 $this->_options = $options;
79 public function getLocalTableName()
81 return $this->_localTable->getName();
87 public function setLocalTable(Table $table)
89 $this->_localTable = $table;
95 public function getLocalColumns()
97 return $this->_localColumnNames;
100 public function getColumns()
102 return $this->_localColumnNames;
108 public function getForeignTableName()
110 return $this->_foreignTableName;
114 * Get the quoted representation of this asset but only if it was defined with one. Otherwise
115 * return the plain unquoted value as inserted.
117 * @param AbstractPlatform $platform
120 public function getQuotedForeignTableName(AbstractPlatform $platform)
122 $keywords = $platform->getReservedKeywordsList();
123 $parts = explode(".", $this->getForeignTableName());
124 foreach ($parts AS $k => $v) {
125 $parts[$k] = ($this->_quoted || $keywords->isKeyword($v)) ? $platform->quoteIdentifier($v) : $v;
128 return implode(".", $parts);
134 public function getForeignColumns()
136 return $this->_foreignColumnNames;
139 public function hasOption($name)
141 return isset($this->_options[$name]);
144 public function getOption($name)
146 return $this->_options[$name];
150 * Gets the options associated with this constraint
154 public function getOptions()
156 return $this->_options;
160 * Foreign Key onUpdate status
162 * @return string|null
164 public function onUpdate()
166 return $this->_onEvent('onUpdate');
170 * Foreign Key onDelete status
172 * @return string|null
174 public function onDelete()
176 return $this->_onEvent('onDelete');
180 * @param string $event
181 * @return string|null
183 private function _onEvent($event)
185 if (isset($this->_options[$event])) {
186 $onEvent = strtoupper($this->_options[$event]);
187 if (!in_array($onEvent, array('NO ACTION', 'RESTRICT'))) {