$q = trim($q);
$q = preg_replace('/\s+/', ' ', $q);
+ if (preg_match("/^INSERT INTO /", $q)) continue ;
+
if (preg_match('/^COMMENT/', $q)) continue;
if (preg_match('/^SET/', $q)) continue;
if (preg_match('/^\\\connect/', $q)) continue;
+ if (preg_match('/^SELECT pg_catalog.setval/', $q)) continue;
+
+ $ignored_insert_tables = array('artifact_extra_field_elements',
+ 'artifact_extra_field_list',
+ 'database_changes',
+ 'doc_groups',
+ 'database_startpoint',
+ 'group_plugin',
+ 'groups',
+ 'mail_group_list',
+ 'nss_groups',
+ 'plugins',
+ 'pfo_role',
+ 'pfo_user_role',
+ 'pfo_role_setting',
+ 'project_task',
+ 'role',
+ 'role_project_refs',
+ 'role_setting',
+ 'user_group',
+ 'users',
+ 'user_session',
+ 'themes',
+ '[a-z]*_idx',
+ );
+ foreach ($ignored_insert_tables as $i) {
+ if (preg_match("/INSERT INTO \"$i\" /", $q)) continue 2;
+ }
$queries[] = $q;
}