Package DE_EPAGES::Object::API::SQLCompare
This module compare sql files. There are two main functions to check if two sql are equal and to get information about missing or too much tables, columns, foreign keys, indices and changed values, etc. ... .
@EXPORT_OK |
Functions
CompareSQL
Looks if all tables indices and constraints from reference file are placed in the control file. Print all missing and too much tables, foreign keys, columns etc. if printmessage is set in options.
Syntax |
$SQLFilesEqual = CompareSQL( $OldFileName, $NewFileName, $$hOptions ); |
Example |
$SQLFilesEqual = CompareSQL( 'test1.sql', 'test2.sql', {'printmessage'} => '1' ); |
Input |
|
Return |
|
GetDiff
returns the diff informations that exists between two sql files return a list of all missing/ too much tables, columns, indices, foreign keys etc.
Syntax |
$hDiff = GetDiff( $OldSQLFile, $NewSQLFile ); |
Example |
$hDiff = GetDiff( 'test(old).sql', 'test(new).sql'); |
Input |
|
Return |
|