/** * 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; }