shenvs/tabas: add mssql-tools

1 files changed, 15 insertions, 1 deletions

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'
   '';
 }