From 0efd8854c4b32ec0b011efbf6b3a1990fe684e32 Mon Sep 17 00:00:00 2001
From: =?UTF-8?q?Fredrik=20=C3=85lund?= <fredrik.alund@mimer.com>
Date: Thu, 15 Sep 2022 22:04:23 +0200
Subject: A QtSql driver for Mimer SQL

The QtSql for Mimer SQL sqldriver makes it possible to work with the
Mimer SQL database on different plattforms. There are drivers for
several other databases in QtSql and a driver for Mimer SQL will
benefit many users.
To build the Mimer SQL driver, download Mimer SQL from
https://developer.mimer.com

[ChangeLog][QtSql]
Added a QtSql plugin to work with the Mimer SQL database

Fixes: QTBUG-111219
Change-Id: Id6ba5de4de01189d0516ffbfa89efcb0d013115f
Reviewed-by: Qt CI Bot <qt_ci_bot@qt-project.org>
Reviewed-by: Volker Hilsheimer <volker.hilsheimer@qt.io>
---
 src/sql/doc/snippets/code/doc_src_sql-driver.cpp  | 13 +++++++++++
 src/sql/doc/snippets/code/doc_src_sql-driver.qdoc | 28 +++++++++++++++++++++++
 2 files changed, 41 insertions(+)

(limited to 'src/sql/doc/snippets/code')

diff --git a/src/sql/doc/snippets/code/doc_src_sql-driver.cpp b/src/sql/doc/snippets/code/doc_src_sql-driver.cpp
index 21f4fe5942f..92c1281aa93 100644
--- a/src/sql/doc/snippets/code/doc_src_sql-driver.cpp
+++ b/src/sql/doc/snippets/code/doc_src_sql-driver.cpp
@@ -79,3 +79,16 @@ while (query1.next()) {
 }
 //! [37]
 }
+
+void callOutProc()
+{
+//! [40]
+    QSqlDatabase db;
+    QSqlQuery query;
+    int i1 = 10, i2 = 0;
+    query.prepare("call qtestproc(?, ?)");
+    query.bindValue(0, i1, QSql::InOut);
+    query.bindValue(1, i2, QSql::Out);
+    query.exec();
+//! [40]
+}
diff --git a/src/sql/doc/snippets/code/doc_src_sql-driver.qdoc b/src/sql/doc/snippets/code/doc_src_sql-driver.qdoc
index 5a7775ccc45..9c329aa2a4d 100644
--- a/src/sql/doc/snippets/code/doc_src_sql-driver.qdoc
+++ b/src/sql/doc/snippets/code/doc_src_sql-driver.qdoc
@@ -173,6 +173,23 @@ cmake --build .
 cmake --install .
 //! [30]
 
+//! [31]
+mkdir build-sqldrivers
+cd build-sqldrivers
+
+qt-cmake -G Ninja <qt_installation_path>\Src\qtbase\src\plugins\sqldrivers -DCMAKE_INSTALL_PREFIX=<qt_installation_path>\<platform> -DMimer_INCLUDE_DIR="/usr/include" -DMimer_LIBRARIES="/usr/lib/libmimer.so"
+cmake --build .
+cmake --install .
+//! [31]
+
+//! [32]
+mkdir build-sqldrivers
+cd build-sqldrivers
+
+qt-cmake -G Ninja <qt_installation_path>\Src\qtbase\src\plugins\sqldrivers -DCMAKE_INSTALL_PREFIX=<qt_installation_path>\<platform> -DMimer_INCLUDE_DIR="C:\Program Files\Mimer SQL Experience 11.0\dev\include" -DMimer_LIBRARIES="C:\Program Files\Mimer SQL Experience 11.0\dev\lib\amd64\mimapi64.lib|C:\Program Files\Mimer SQL Experience 11.0\dev\lib\x86\mimapi32.lib"
+cmake --build .
+cmake --install .
+//! [32]
 
 //! [35]
 QSqlDatabase: QPSQL driver not loaded
@@ -205,6 +222,7 @@ Configure summary:
 Qt Sql Drivers:
   DB2 (IBM) .............................. no
   InterBase .............................. no
+  Mimer SQL .............................. yes
   MySql .................................. yes
   OCI (Oracle) ........................... no
   ODBC ................................... yes
@@ -225,6 +243,7 @@ Configure summary:
 Qt Sql Drivers:
   DB2 (IBM) .............................. no
   InterBase .............................. no
+  Mimer SQL .............................. yes
   MySql .................................. yes
   OCI (Oracle) ........................... no
   ODBC ................................... yes
@@ -242,6 +261,7 @@ Configure summary:
 Qt Sql Drivers:
   DB2 (IBM) .............................. no
   InterBase .............................. no
+  Mimer SQL .............................. yes
   MySql .................................. yes
   OCI (Oracle) ........................... no
   ODBC ................................... yes
@@ -250,3 +270,11 @@ Qt Sql Drivers:
     Using system provided SQLite ......... no
 ...
 //! [43]
+
+//! [44]
+create procedure inout_proc (INOUT param1 INT, OUT param2 INT)
+BEGIN
+    set param1 = param1 * 2;
+    set param2 = param1 * param1;
+END
+//! [44]
-- 
cgit v1.2.3