Update oracle_lib.py

wolfmoritz · wolfmoritz · commit 6be7cc79a263 · 2013-07-03T14:04:27.000-07:00
The capturing groups were only finding the schema name not the object name if one uses schema prefixes on objects. This prevented compilation errors from being displayed. Also added `TYPE` to the list of objects.
diff --git a/oracle_lib.py b/oracle_lib.py
@@ -6,7 +6,7 @@ def find_entities(view):
     Return all 'create or replace' type and name in the script.
     """
     results = []
-    positions = view.find_all(r'(?im)create\s+(?:or\s+replace\s+)?(?:force\s+)?(package(?:\s+body)?|procedure|function|trigger|view)\s+(\w+)', 0, "$1 $2", results)
+    positions = view.find_all(r'(?im)create\s+(?:or\s+replace\s+)?(?:force\s+)?(package(?:\s+body)?|procedure|function|trigger|view|type)\s+(\w+\.)?(\w+)', 0, "$1 $3", results)
     return dict((val.upper(), view.rowcol(pos.begin())[0]) for (pos, val) in zip(positions, results))
 
 
