From cf92e248c65548643821005929ebbb842b52cd95 Mon Sep 17 00:00:00 2001
From: Alejandro Soto <alejandro@34project.org>
Date: Wed, 1 Jun 2022 04:40:29 -0600
Subject: shenvs/tabas: add mssql-tools

---
 shenvs/tabas.nix | 16 +++++++++++++++-
 1 file changed, 15 insertions(+), 1 deletion(-)

(limited to 'shenvs/tabas.nix')

diff --git a/shenvs/tabas.nix b/shenvs/tabas.nix
index a5d5fb3..f55d7d4 100644
--- a/shenvs/tabas.nix
+++ b/shenvs/tabas.nix
@@ -1,15 +1,29 @@
-pkgs: {
+pkgs: let
+  odbcinst =
+    { lib, writeTextDir, unixODBCDrivers }:
+    with lib; let
+      driver = unixODBCDrivers.msodbcsql17;
+      odbcinst."${driver.fancyName}" = {
+        Description = driver.meta.description;
+        Driver = "${driver}/${driver.driver}";
+      };
+    in writeTextDir "odbcinst.ini" (generators.toINI {} odbcinst);
+in {
   paths = with pkgs; [
     dotnet-sdk
     nodejs
     nodePackages.npm
     postgresql_14
     sqlite
+    local.mssql-tools
   ];
 
   enter = ''
     export PGDATA=$HOME/vtmp/psql
     export DOTNET_ROOT=${pkgs.dotnet-sdk}
+    export ODBCSYSINI=${pkgs.callPackage odbcinst {}}
     export PATH="$PATH:$HOME/.dotnet/tools:$HOME/.npm-packages/bin";
+
+    alias straviasql='sqlcmd -S itcr.database.windows.net -U pmaestro -d straviatec'
   '';
 }
-- 
cgit v1.2.3