PageRenderTime 42ms CodeModel.GetById 16ms RepoModel.GetById 1ms app.codeStats 0ms

/vendor/phalcon/devtools/ide/2.0.5/Phalcon/db/dialect/Oracle.php

https://gitlab.com/habracoder/advertising
PHP | 257 lines | 31 code | 30 blank | 196 comment | 0 complexity | 3b23aefd13418c1354c93c9fd26c15c3 MD5 | raw file
  1. <?php
  2. namespace Phalcon\Db\Dialect;
  3. /**
  4. * Phalcon\Db\Dialect\Oracle
  5. * Generates database specific SQL for the Oracle RDBMS
  6. */
  7. class Oracle extends \Phalcon\Db\Dialect
  8. {
  9. protected $_escapeChar = "";
  10. /**
  11. * Generates the SQL for LIMIT clause
  12. *
  13. * @param string $sqlQuery
  14. * @param mixed $number
  15. * @return string
  16. */
  17. public function limit($sqlQuery, $number) {}
  18. /**
  19. * Gets the column name in Oracle
  20. *
  21. * @param mixed $column
  22. * @return string
  23. */
  24. public function getColumnDefinition(\Phalcon\Db\ColumnInterface $column) {}
  25. /**
  26. * Generates SQL to add a column to a table
  27. *
  28. * @param string $tableName
  29. * @param string $schemaName
  30. * @param mixed $column
  31. * @return string
  32. */
  33. public function addColumn($tableName, $schemaName, \Phalcon\Db\ColumnInterface $column) {}
  34. /**
  35. * Generates SQL to modify a column in a table
  36. *
  37. * @param string $tableName
  38. * @param string $schemaName
  39. * @param mixed $column
  40. * @param mixed $currentColumn
  41. * @return string
  42. */
  43. public function modifyColumn($tableName, $schemaName, \Phalcon\Db\ColumnInterface $column, \Phalcon\Db\ColumnInterface $currentColumn = null) {}
  44. /**
  45. * Generates SQL to delete a column from a table
  46. *
  47. * @param string $tableName
  48. * @param string $schemaName
  49. * @param string $columnName
  50. * @return string
  51. */
  52. public function dropColumn($tableName, $schemaName, $columnName) {}
  53. /**
  54. * Generates SQL to add an index to a table
  55. *
  56. * @param string $tableName
  57. * @param string $schemaName
  58. * @param mixed $index
  59. * @return string
  60. */
  61. public function addIndex($tableName, $schemaName, \Phalcon\Db\IndexInterface $index) {}
  62. /**
  63. * /
  64. * Generates SQL to delete an index from a table
  65. *
  66. * @param string $tableName
  67. * @param string $schemaName
  68. * @param string $indexName
  69. * @return string
  70. */
  71. public function dropIndex($tableName, $schemaName, $indexName) {}
  72. /**
  73. * Generates SQL to add the primary key to a table
  74. *
  75. * @param string $tableName
  76. * @param string $schemaName
  77. * @param mixed $index
  78. * @return string
  79. */
  80. public function addPrimaryKey($tableName, $schemaName, \Phalcon\Db\IndexInterface $index) {}
  81. /**
  82. * Generates SQL to delete primary key from a table
  83. *
  84. * @param string $tableName
  85. * @param string $schemaName
  86. * @return string
  87. */
  88. public function dropPrimaryKey($tableName, $schemaName) {}
  89. /**
  90. * Generates SQL to add an index to a table
  91. *
  92. * @param string $tableName
  93. * @param string $schemaName
  94. * @param mixed $reference
  95. * @return string
  96. */
  97. public function addForeignKey($tableName, $schemaName, \Phalcon\Db\ReferenceInterface $reference) {}
  98. /**
  99. * Generates SQL to delete a foreign key from a table
  100. *
  101. * @param string $tableName
  102. * @param string $schemaName
  103. * @param string $referenceName
  104. * @return string
  105. */
  106. public function dropForeignKey($tableName, $schemaName, $referenceName) {}
  107. /**
  108. * Generates SQL to create a table in Oracle
  109. *
  110. * @param string $tableName
  111. * @param string $schemaName
  112. * @param array $definition
  113. * @return string
  114. */
  115. public function createTable($tableName, $schemaName, $definition) {}
  116. /**
  117. * Generates SQL to drop a table
  118. *
  119. * @param string $tableName
  120. * @param string $schemaName
  121. * @param bool $ifExists
  122. * @return string
  123. */
  124. public function dropTable($tableName, $schemaName, $ifExists = true) {}
  125. /**
  126. * Generates SQL to create a view
  127. *
  128. * @param string $viewName
  129. * @param array $definition
  130. * @param string $schemaName
  131. * @return string
  132. */
  133. public function createView($viewName, $definition, $schemaName = null) {}
  134. /**
  135. * Generates SQL to drop a view
  136. *
  137. * @param string $viewName
  138. * @param string $schemaName
  139. * @param bool $ifExists
  140. * @return string
  141. */
  142. public function dropView($viewName, $schemaName = null, $ifExists = true) {}
  143. /**
  144. * Generates SQL checking for the existence of a schema.view
  145. *
  146. * @param string $viewName
  147. * @param string $schemaName
  148. * @return string
  149. */
  150. public function viewExists($viewName, $schemaName = null) {}
  151. /**
  152. * Generates the SQL to list all views of a schema or user
  153. *
  154. * @param string $schemaName
  155. * @return string
  156. */
  157. public function listViews($schemaName = null) {}
  158. /**
  159. * Generates SQL checking for the existence of a schema.table
  160. * <code>
  161. * echo $dialect->tableExists("posts", "blog");
  162. * echo $dialect->tableExists("posts");
  163. * </code>
  164. *
  165. * @param string $tableName
  166. * @param string $schemaName
  167. * @return string
  168. */
  169. public function tableExists($tableName, $schemaName = null) {}
  170. /**
  171. * Generates SQL describing a table
  172. * <code>
  173. * print_r($dialect->describeColumns("posts"));
  174. * </code>
  175. *
  176. * @param string $table
  177. * @param string $schema
  178. * @return string
  179. */
  180. public function describeColumns($table, $schema = null) {}
  181. /**
  182. * List all tables in database
  183. * <code>
  184. * print_r($dialect->listTables("blog"))
  185. * </code>
  186. *
  187. * @param string $schemaName
  188. * @return string
  189. */
  190. public function listTables($schemaName = null) {}
  191. /**
  192. * Generates SQL to query indexes on a table
  193. *
  194. * @param string $table
  195. * @param string $schema
  196. * @return string
  197. */
  198. public function describeIndexes($table, $schema = null) {}
  199. /**
  200. * Generates SQL to query foreign keys on a table
  201. *
  202. * @param string $table
  203. * @param string $schema
  204. * @return string
  205. */
  206. public function describeReferences($table, $schema = null) {}
  207. /**
  208. * Generates the SQL to describe the table creation options
  209. *
  210. * @param string $table
  211. * @param string $schema
  212. * @return string
  213. */
  214. public function tableOptions($table, $schema = null) {}
  215. /**
  216. * Checks whether the platform supports savepoints
  217. *
  218. * @return bool
  219. */
  220. public function supportsSavepoints() {}
  221. /**
  222. * Checks whether the platform supports releasing savepoints.
  223. *
  224. * @return bool
  225. */
  226. public function supportsReleaseSavepoints() {}
  227. }