/**
* is old_view different than new_view?
*
* @param object $old_view
* @param object $new_view
*
* @return boolean
*/
public static function is_view_modified($old_view, $new_view)
{
if (dbsteward::$always_recreate_views) {
return TRUE;
}
$different = strcasecmp(mssql10_view::get_view_query($old_view), mssql10_view::get_view_query($new_view)) != 0;
return $different;
}
/**
* Creates and returns SQL for creation of the view.
*
* @return string
*/
public static function get_creation_sql($node_schema, $node_view)
{
if (isset($node_view['description']) && strlen($node_view['description']) > 0) {
$ddl = "-- " . dbsteward::string_cast($node_view['description']) . "\n";
}
$ddl = "CREATE VIEW " . mssql10::get_quoted_schema_name($node_schema['name']) . '.' . mssql10::get_quoted_table_name($node_view['name']);
$ddl .= "\n\tAS " . mssql10_view::get_view_query($node_view) . ";\n";
// @IMPLEMENT: $node_view['owner'] ?
return $ddl;
}
