Fix T68243: Python sqlite module not working on macOS

Referenced by issue blender/blender-addons#68243, Python misconfiguration in Mac build

build_files/build_environment/cmake/sqlite.cmake

@@ -19,8 +19,10 @@
 set(SQLITE_CONFIGURE_ENV echo .)
 set(SQLITE_CONFIGURATION_ARGS)
 
-if(UNIX AND NOT APPLE)
-  set(SQLITE_LDFLAGS -Wl,--as-needed)
+if(UNIX)
+  if(NOT APPLE)
+    set(SQLITE_LDFLAGS -Wl,--as-needed)
+  endif()
   set(SQLITE_CFLAGS
     "-DSQLITE_SECURE_DELETE -DSQLITE_ENABLE_COLUMN_METADATA \
     -DSQLITE_ENABLE_FTS3 -DSQLITE_ENABLE_FTS3_PARENTHESIS \

tests/python/CMakeLists.txt

@@ -79,6 +79,11 @@ add_blender_test(
   --python ${CMAKE_CURRENT_LIST_DIR}/bl_load_py_modules.py
 )
 
+add_blender_test(
+  script_bundled_modules
+  --python ${CMAKE_CURRENT_LIST_DIR}/bl_bundled_modules.py
+)
+
 # test running operators doesn't segfault under various conditions
 if(USE_EXPERIMENTAL_TESTS)
   add_blender_test(

tests/python/bl_bundled_modules.py

@@ -0,0 +1,30 @@
+# ##### BEGIN GPL LICENSE BLOCK #####
+#
+#  This program is free software; you can redistribute it and/or
+#  modify it under the terms of the GNU General Public License
+#  as published by the Free Software Foundation; either version 2
+#  of the License, or (at your option) any later version.
+#
+#  This program is distributed in the hope that it will be useful,
+#  but WITHOUT ANY WARRANTY; without even the implied warranty of
+#  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
+#  GNU General Public License for more details.
+#
+#  You should have received a copy of the GNU General Public License
+#  along with this program; if not, write to the Free Software Foundation,
+#  Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301, USA.
+#
+# ##### END GPL LICENSE BLOCK #####
+
+# <pep8 compliant>
+
+# Test that modules we ship with our Python installation are available
+
+import bz2
+import cffi
+import lzma
+import numpy
+import sqlite3
+import ssl
+import zlib
+