Add preliminary support for Sql Server

OmniDB · Jan 20, 2022 · 36867e3 · 36867e3
1 parent ac1ae9f
commit 36867e3
Showing 16 changed files with 5,439 additions and 4 deletions.
diff --git a/OmniDB/OmniDB_app/include/OmniDatabase/MsSQL.py b/OmniDB/OmniDB_app/include/OmniDatabase/MsSQL.py
diff --git a/OmniDB/OmniDB_app/include/OmniDatabase/__init__.py b/OmniDB/OmniDB_app/include/OmniDatabase/__init__.py
@@ -28,6 +28,7 @@
 from OmniDB_app.include.OmniDatabase.Oracle import Oracle
 from OmniDB_app.include.OmniDatabase.MariaDB import MariaDB
 from OmniDB_app.include.OmniDatabase.MySQL import MySQL
+from OmniDB_app.include.OmniDatabase.MsSQL import MsSQL
 
 '''
 ------------------------------------------------------------------------
@@ -59,3 +60,5 @@ def InstantiateDatabase(p_db_type,
             return MySQL(p_server, p_port, p_service, p_user, p_password, p_conn_id, p_alias, p_conn_string, p_parse_conn_string)
         if p_db_type == 'sqlite':
             return SQLite(p_service, p_conn_id, p_alias, p_foreignkeys)
+        if p_db_type == 'mssql':
+            return MsSQL(p_server, p_port, p_service, p_user, p_password, p_conn_id, p_alias, p_conn_string, p_parse_conn_string)
diff --git a/OmniDB/OmniDB_app/migrations/0004_3_2_0.py b/OmniDB/OmniDB_app/migrations/0004_3_2_0.py
@@ -0,0 +1,21 @@
+# manually created
+
+from django.db import migrations
+
+
+def populate_technologies(apps, schema_editor):
+    Technology = apps.get_model('OmniDB_app', 'Technology')
+    Technology(name='mssql').save()
+
+
+class Migration(migrations.Migration):
+
+    dependencies = [
+        ('OmniDB_app', '0003_3_1_0'),
+    ]
+
+    operations = [
+        migrations.RunPython(
+            code=populate_technologies,
+        )
+    ]
diff --git a/OmniDB/OmniDB_app/static/OmniDB_app/css/omnidb.min.css b/OmniDB/OmniDB_app/static/OmniDB_app/css/omnidb.min.css
diff --git a/OmniDB/OmniDB_app/static/OmniDB_app/images/mssql.svg b/OmniDB/OmniDB_app/static/OmniDB_app/images/mssql.svg
diff --git a/OmniDB/OmniDB_app/static/OmniDB_app/images/mssql_medium.png b/OmniDB/OmniDB_app/static/OmniDB_app/images/mssql_medium.png
diff --git a/OmniDB/OmniDB_app/static/OmniDB_app/images/oracle.svg b/OmniDB/OmniDB_app/static/OmniDB_app/images/oracle.svg
diff --git a/OmniDB/OmniDB_app/static/OmniDB_app/js/tab_functions/outer_connection_tab.js b/OmniDB/OmniDB_app/static/OmniDB_app/js/tab_functions/outer_connection_tab.js
@@ -71,7 +71,7 @@ var v_createConnTabFunction = function(p_index,p_create_query_tab = true, p_name
     }
 
     let v_icon = '<img src="' + v_url_folder + '/static/OmniDB_app/images/' + v_conn.v_db_type;
-    if (v_conn.v_db_type === 'postgresql' || v_conn.v_db_type === 'oracle'|| v_conn.v_db_type === 'mariadb' || v_conn.v_db_type === 'mysql') {
+    if (v_conn.v_db_type === 'postgresql' || v_conn.v_db_type === 'oracle'|| v_conn.v_db_type === 'mariadb' || v_conn.v_db_type === 'mysql'|| v_conn.v_db_type === 'mssql') {
       v_icon += '.svg"/>';
     }
     else {