[ Index ]

PHP Cross Reference of Joomla 2.5.4 DE

title

Body

[close]

/libraries/cms/schema/ -> changeitemsqlsrv.php (summary)

(no description)

Copyright: Copyright (C) 2005 - 2012 Open Source Matters, Inc. All rights reserved.
License: GNU General Public License version 2 or later; see LICENSE
File Size: 150 lines (6 kb)
Included or required:0 times
Referenced: 0 times
Includes or requires: 0 files

Defines 1 class

JSchemaChangeitemsqlsrv:: (3 methods):
  buildCheckQuery()
  fixInteger()
  fixQuote()


Class: JSchemaChangeitemsqlsrv  - X-Ref

Checks the database schema against one MySQL DDL query to see if it has been run.

buildCheckQuery()   X-Ref
Checks a DDL query to see if it is a known type
If yes, build a check query to see if the DDL has been run on the database.
If successful, the $msgElements, $queryType, $checkStatus and $checkQuery fields are populated.
The $msgElements contains the text to create the user message.
The $checkQuery contains the SQL query to check whether the schema change has
been run against the current database. The $queryType contains the type of
DDL query that was run (for example, CREATE_TABLE, ADD_COLUMN, CHANGE_COLUMN_TYPE, ADD_INDEX).
The $checkStatus field is set to zero if the query is created

If not successful, $checkQuery is empty and , and $checkStatus is -1.
For example, this will happen if the current line is a non-DDL statement.

return: void

fixInteger($type1, $type2)   X-Ref
Fix up integer. Fixes problem with MySQL integer descriptions.
If you change a column to "integer unsigned" it shows
as "int(10) unsigned" in the check query.

param: string  $type1  the column type
param: string  $type2  the column attributes
return: string  The original or changed column type.

fixQuote($string)   X-Ref
Fixes up a string for inclusion in a query.
Replaces name quote character with normal quote for literal.
Drops trailing semi-colon. Injects the database prefix.

param: string  $string  The input string to be cleaned up.
return: string  The modified string.



Generated: Tue Apr 3 11:40:28 2012 Cross-referenced by PHPXref 0.7.1