From 9237328fb09b2c18365bb5fcef1c4596d77973a9 Mon Sep 17 00:00:00 2001
From: Martin Fischer <martin@push-f.com>
Date: Sat, 17 Oct 2026 11:14:02 +0200
Subject: refactor: make server packages buildable via packages.*

---
 nixos/profiles/server/prometheus-sql-exporter.nix | 39 +++++++++++++++++++++++
 1 file changed, 39 insertions(+)
 create mode 100644 nixos/profiles/server/prometheus-sql-exporter.nix

(limited to 'nixos/profiles/server/prometheus-sql-exporter.nix')

diff --git a/nixos/profiles/server/prometheus-sql-exporter.nix b/nixos/profiles/server/prometheus-sql-exporter.nix
new file mode 100644
index 0000000..fe2ef7b
--- /dev/null
+++ b/nixos/profiles/server/prometheus-sql-exporter.nix
@@ -0,0 +1,39 @@
+# TODO: submit burningalchemist's sql_exporter to nixpkgs
+{ config, lib, pkgs, sources, ... }:
+
+let
+  sqlExporter = pkgs.callPackage ./pkgs/prometheus-sql-exporter.nix { inherit sources; };
+  cfg = config.services.prometheus-sql-exporter;
+  configFile = builtins.toFile "config.yaml" (builtins.toJSON cfg.config);
+  validateConfig = file:
+    pkgs.runCommand "validate-config"
+      {
+        nativeBuildInputs = [sqlExporter];
+      }
+      ''
+        sql_exporter -config.check -config.file "${file}"
+        ln -s "${file}" "$out"
+      '';
+in
+{
+  options.services.prometheus-sql-exporter = {
+    enable = lib.mkEnableOption "sql-exporter";
+    port = lib.mkOption {
+      type = lib.types.int;
+    };
+    config = lib.mkOption {
+      type = (pkgs.formats.json {}).type;
+    };
+  };
+
+  config = lib.mkIf cfg.enable {
+    systemd.services.prometheus-sql-exporter = {
+      serviceConfig = {
+        ExecStart = "${sqlExporter}/bin/sql_exporter -config.file ${validateConfig configFile} -web.listen-address :${toString cfg.port}";
+        DynamicUser = "true";
+        User = "prometheus-sql-exporter";
+      };
+      wantedBy = ["multi-user.target"];
+    };
+  };
+}
-- 
cgit v1.3.1