mtangoo / wxdatabase Goto Github PK

• Supported backends
• Installing with different backends
• Simple Example (with commandline compile)

README.md states that documentation can be found online:

wxDatabase documentation is built with Doxygen. Download the latest version and follow the procedure in the next paragraph to build API documentation. You can view documentation on line at mtangoo.github.io.

However, that page simply says Hello World and nothing more.

PQconnectdb Makes a new connection to the database server.
PGconn *PQconnectdb(const char *conninfo);

This function opens a new database connection using the parameters taken from the string conninfo.
The passed string can be empty to use all default parameters, or it can contain one or more parameter settings separated by whitespace, or it can contain a URI. See Section 31.1.1 for details.
PQsetdbLogin Makes a new connection to the database server.

PGconn *PQsetdbLogin(const char *pghost,
                     const char *pgport,
                     const char *pgoptions,
                     const char *pgtty,
                     const char *dbName,
                     const char *login,
                     const char *pwd);

This is the predecessor of PQconnectdb with a fixed set of parameters. It has the same functionality except that the missing parameters will always take on default values. Write NULL or an empty string for any one of the fixed parameters that is to be defaulted.
If the dbName contains an = sign or has a valid connection URI prefix, it is taken as a conninfo string in exactly the same way as if it had been passed to PQconnectdb, and the remaining parameters are then applied as specified for PQconnectdbParams.

Add ODBC to CMake Build

On Windows 10 (64-bit):

The CMake FindMySQL.cmake module only looks in C:\Program Files and not C:\Program Files (x86) for the MySQL libraries.

In wxWidgets coding guidelines exceptions are discouraged. This ticket aim at removing all exceptions in the library.

The idea I have is to have a class similar to QT SQLError. For function that can return bool (like Commit) will do so and for the rest, checking the error it will be something like

wxDatabase *pDatabase =  new wxMysqlDatabase(strServer, strDatabase, strUser, strPassword);
wxSQLError *error = pDatabase->GetLastError();
if(error->GetCode() == 0)
{
    //success
}
else
{
    //unsuccesful
    error->GetText();
    error->GetCode();
}

What do you think @patlkli @manyleaves and whoever reads this ;) ?

I have installed wxWidgets 3.0.2 and Code Blocks 13.12 on my pc successfully.
How should I install wxDatabase library on my pc?
Thanks.

I'm trying to build wxDatabase for the MinGW compiler. Below is the build log with an error. what am I doing wrong? Thank you all in advance for your help!
c:\Library\wxDatabase\build>mingw32-make -f makefile WX_SHARED=1 WX_MONOLITHIC=1 WX_UNICODE=1 WX_DEBUG=0 WX_DIR="c:\Library\wxwidgets" [ 5%] Building CXX object CMakeFiles/wxdatabase.dir/src/base/dbconf.cpp.obj [ 10%] Building CXX object CMakeFiles/wxdatabase.dir/src/base/wxprec.cpp.obj [ 15%] Building CXX object CMakeFiles/wxdatabase.dir/src/base/xmlconf.cpp.obj [ 21%] Building CXX object CMakeFiles/wxdatabase.dir/src/database/database.cpp.obj [ 26%] Building CXX object CMakeFiles/wxdatabase.dir/src/database/error_reporter.cpp.obj [ 31%] Building CXX object CMakeFiles/wxdatabase.dir/src/database/prepared_statement.cpp.obj [ 36%] Building CXX object CMakeFiles/wxdatabase.dir/src/database/query_parser.cpp.obj [ 42%] Building CXX object CMakeFiles/wxdatabase.dir/src/database/resultset.cpp.obj [ 47%] Building CXX object CMakeFiles/wxdatabase.dir/src/database/string_converter.cpp.obj [ 52%] Building CXX object CMakeFiles/wxdatabase.dir/src/database/wxprec.cpp.obj [ 57%] Building CXX object CMakeFiles/wxdatabase.dir/src/database/odbc/odbc_database.cpp.obj [ 63%] Building CXX object CMakeFiles/wxdatabase.dir/src/database/odbc/odbc_inteface.cpp.obj [ 68%] Building CXX object CMakeFiles/wxdatabase.dir/src/database/odbc/odbc_param.cpp.obj C:\Library\wxDatabase\src\database\odbc\odbc_param.cpp: In member function 'SQLLEN* wxOdbcParameter::GetParameterLengthPtr()': C:\Library\wxDatabase\src\database\odbc\odbc_param.cpp:255:11: error: cannot convert 'long int*' to 'SQLLEN*' {aka 'long long int*'} in return return &m_nBufferLength; ^~~~~~~~~~~~~~~ mingw32-make[2]: *** [CMakeFiles\wxdatabase.dir\build.make:256: CMakeFiles/wxdatabase.dir/src/database/odbc/odbc_param.cpp.obj] Error 1 mingw32-make[1]: *** [CMakeFiles\Makefile2:84: CMakeFiles/wxdatabase.dir/all] Error 2 mingw32-make: *** [makefile:135: all] Error 2

So far CMake build have Support for SQLite3, MySQL/MariaDB, and PostGreSQL. I would like to see TDS Suported so that one can connect with MS SQL Server. I'm not TDS guy and so its hard for me to sdo it.

Help is needed

This is not really a wxDatabase issue, but a PostgreSQL / mingw-w64 issue. I am including it here because it prevents wxDatabase from building and there is not much help on Google at the moment.

Basically both PostgreSQL pthread.h and mingw-w64 gthr.h define the struct timespec.

The workaround from a wxDatabase perspective is to include:

    add_definitions(-DHAVE_STRUCT_TIMESPEC)

in the ENABLE_PGS block of CMakeLists.txt.

Good day! Tell me how to use ODBC correctly with MS SQL server? I am using wxWidgets 3.1.5 and wxDatabase. The wxDatabaseApp.cpp example builds fine. I am trying to change it to work with ODBC, but looking at the source code in the CodeBlocks project, I see that the wxUSE_DATABASE_ODBC preprocessor directive is not set. And the code is copied without ODBC support. Also how to properly link the wxDatabase library to the new project? Sorry for the silly questions, not strong enough in C ++ yet.

I am trying to connect to MS SQL server using the following connection string
pDatabase = GetDatabase ("[ODBC] \ nConnection = DRIVER = SQL Server; SERVER = 10.9.1.50; DATABASE = apacs24ms; UID = user; PWD = password;");

Catching std::exception doesn't catch exceptions thrown by wxDatabase. Derive wxDatabaseException from std::exception to resolve.

AFAIK all c'tors require database name. Add C'tor that does not require one a la

wxDatabase(host:port, username, password);

On a standard Debian/Ubuntu, the pg_type.h header from the postgresql-server-dev-* packages aren't found by the FindPostgreSQL.cmake module, because they are in a different directory.

CMake Error at /usr/share/cmake-3.0/Modules/FindPackageHandleStandardArgs.cmake:136 (message):
  Could NOT find PostgreSQL (missing: PostgreSQL_TYPE_INCLUDE_DIR) (found
  version "9.4.5")
Call Stack (most recent call first):
  /usr/share/cmake-3.0/Modules/FindPackageHandleStandardArgs.cmake:343 (_FPHSA_FAILURE_MESSAGE)
  /usr/share/cmake-3.0/Modules/FindPostgreSQL.cmake:159 (find_package_handle_standard_args)
  CMakeLists.txt:104 (find_package)

This commit in CMake fixes this, but the version of CMake in the Debian repositories doesn't include that yet.

I suggest that in the meantime, we simply bundle the new FindPostgreSQL.cmake from that commit in the cmake/Modules directory together with the other find modules.

Let me know what you think, I have the commits ready to go.

In the MySQL sample a new wxMysqlDatabase is instantiated at line 34, but isn't deleted.

This might be my understanding of the MySQL backend code, sorry for wasting time if so.

On the other hand if this is a bug, then perhaps it would be worth thinking about using some of the wxWidgets smart pointers here. Also for result sets because it would avoid having to close them each time, they would simply go out of focus and be deleted.

Create Build System for wxDB

I would like to propose implementing a Firebird backend based on IBPP.

This would make IBPP a sort of dependency, but given it comes as open source .cpp and .h files it can live in /vendors.

If this is approved then it would be a thinish wrapper around IBPP rather than an update of the wxDatabaseLayer Firebird backend. In future IBPP might be replaced by the new Firebird 3 OO API, but we should wait for things to stabilize first.

Good evening, could you add an example of working with ODBC in a graphical interface to the library? As it is not clear, you need to create a wxDatabase object or a wxOdbcDatabase object.
Also, there is still a question about building the library in the Cmake gui, why is it that when specifying the use of odbc, the library is built with the preprocessor directive wxUSE_DATABASE_ODBC off. How should CMakeLists.txt be changed for correct assembly to work through ODBC?

The application from the samples folder builds and runs, but it uses the parent of all database classes. And on the forum https://forums.wxwidgets.org/viewtopic.php?f=34&t=48736&p=209286#p209286 it is advised to use the odbc constructor, not an abstract class.

MySQL libraries are GPLed. MariaDB connectors are LGPLed.
Move off GPL towards LGPL is the goal of this issue.

Investigate this as it does not work. sqlite3_bind_parameter_count
returns always zero

virtual bool ChangeDatabase(const wxString& database) { return false; }

• Migrate all Pointers to smart Pointers.

• Document it

• Update Sample

• Make a release

From PGS Docs page

Note: On Windows, there is a way to improve performance if a single database connection is repeatedly started and shutdown. Internally, libpq calls WSAStartup() and WSACleanup() for connection startup and shutdown, respectively. WSAStartup() increments an internal Windows library reference count which is decremented by WSACleanup(). When the reference count is just one, calling WSACleanup() frees all resources and all DLLs are unloaded. This is an expensive operation. To avoid this, an application can manually call WSAStartup() so resources will not be freed when the last database connection is closed.

Fix this in PGS port