1 files changed, 45 insertions, 0 deletions
diff --git a/library/X509/DbTool.php b/library/X509/DbTool.php
new file mode 100644
index 0000000..4049c5a
--- /dev/null
+++ b/library/X509/DbTool.php
@@ -0,0 +1,45 @@
+<?php
+
+// Icinga Web 2 X.509 Module | (c) 2020 Icinga GmbH | GPLv2
+
+namespace Icinga\Module\X509;
+
+use ipl\Sql\Connection;
+
+class DbTool
+{
+    protected $pgsql = false;
+
+    public function __construct(Connection $db)
+    {
+        $this->pgsql = $db->getConfig()->db === 'pgsql';
+    }
+
+    /**
+     * @param string $binary
+     *
+     * @return string
+     */
+    public function marshalBinary($binary)
+    {
+        if ($this->pgsql) {
+            return sprintf('\\x%s', bin2hex(static::unmarshalBinary($binary)));
+        }
+
+        return $binary;
+    }
+
+    /**
+     * @param resource|string $binary
+     *
+     * @return string
+     */
+    public static function unmarshalBinary($binary)
+    {
+        if (is_resource($binary)) {
+            return stream_get_contents($binary);
+        }
+
+        return $binary;
+    }
+}