Resolve "Implement Quadkey functions"

Closes #22 (closed)

• Added all functions related to Quadkeys from https://learn.microsoft.com/en-us/bingmaps/articles/bing-maps-tile-system
• Added package quadkeyfunctions, with one function get_quadkey_functions, that reads all SQL files in the directory
• Added function implement_quadkey_functions in the PostGIS Database

\approve @ds @gislars

databaselib/database.py

@@ -23,6 +23,7 @@ import psycopg2
 from packaging import version
 from uuid import uuid4
 
+from quadkeyfunctions import get_quadkey_functions
 
 logger = logging.getLogger()
 
@@ -280,6 +281,19 @@ class PostGISDatabase(AbstractDatabase):
             for result in cursor:
                 yield result
 
+    def implement_quadkey_functions(self):
+        """
+        Get all Quadkey functions from the `quadkeyfunctions` module and implement them in the
+        PostGIS database.
+        """
+
+        if self.connection is None:
+            raise AssertionError("PostGIS database not connected.")
+
+        for sql_function in get_quadkey_functions():
+            logger.info(f"Implementing function:\n{sql_function}")
+            self.cursor.execute(sql_function)
+
     def __copy__(self):
         return PostGISDatabase(
             self.host,