From bfefe8fe492324518e5b1d964f07924353ac4dfa Mon Sep 17 00:00:00 2001
From: "Karl O. Pinc kop@karlpinc.com" <kop@karlpinc.com>
Date: Sat, 7 Oct 2023 01:18:03 +0000
Subject: [PATCH] Account for empty db/schemas/*/create/ directories

---
 db/schemas/gen_comments.py | 47 ++++++++++++++++++++++----------------
 1 file changed, 27 insertions(+), 20 deletions(-)

diff --git a/db/schemas/gen_comments.py b/db/schemas/gen_comments.py
index 3fb3b71..b81fd03 100755
--- a/db/schemas/gen_comments.py
+++ b/db/schemas/gen_comments.py
@@ -205,27 +205,34 @@ def find_schemas_objects(schema, cf, db_objs):
     sdir = pathlib.Path(schema)
     for child in sdir.iterdir():
         if child.name in OBJ_TYPES and child.is_dir():
-            for file in (child / "create").iterdir():
-                file_name = str(file.name)
-                if file.is_file() and file_name[-3:] == ".m4":
-                    objname = file_name.lower()[:-3]
-                    if objname in db_objs:
-                        # Multiple functions with the same name can exist.
-                        # No reason they have to be in the same file.
-                        old = db_objs[objname].typepath
-                        old_schema = old.split("/")[0]
-                        if old_schema != schema:
-                            sys.exit(
-                                DuplicateError(
-                                    "Cannot write comments:"
-                                    f" db object {objname} in {child}"
-                                    f" is duplicated in {old}"
+            try:
+                for file in (child / "create").iterdir():
+                    file_name = str(file.name)
+                    if file.is_file() and file_name[-3:] == ".m4":
+                        objname = file_name.lower()[:-3]
+                        if objname in db_objs:
+                            # Multiple functions with the same name can exist.
+                            # No reason they have to be in the same file.
+                            old = db_objs[objname].typepath
+                            old_schema = old.split("/")[0]
+                            if old_schema != schema:
+                                sys.exit(
+                                    DuplicateError(
+                                        "Cannot write comments:"
+                                        f" db object {objname} in {child}"
+                                        f" is duplicated in {old}"
+                                    )
                                 )
-                            )
-                    else:
-                        db_obj = DBObj()
-                        db_obj.build(objname, child, cf)
-                        db_objs[objname] = db_obj
+                        else:
+                            db_obj = DBObj()
+                            db_obj.build(objname, child, cf)
+                            db_objs[objname] = db_obj
+            except FileNotFoundError:
+                # Normally this will not happen.  But it does when
+                # we're developing and have not yet created any of
+                # the OBJ_TYPE being examined.  (Git will not store
+                # an empty directory.)
+                pass
 
 
 def find_objects(schemas):
-- 
2.34.1