Details

    Description

      Good afternoon, Connect Engine the coolest thing! It allowed the local file to be turned into a table! And also many other things allow. Thank you very much for this addition!

      Please tell me, does Connect Engine support connection to various web API (REST requests)? For example there is a API from Openweathermap:
      https://samples.openweathermap.org/data/2.5/forecast?q=London,us&mode=xml&appid=b6907d289e10d714a6e88b30761fae22
      Can output to a table to turn, and the parameters which takes the API was converted from filters WHERE

      Attachments

        1. Readme.txt
          2 kB
        2. MyClient.chm
          37 kB
        3. MyClient.exe
          413 kB
        4. ha_connect.lib
          844 kB
        5. Rest.dll
          967 kB
        6. ha_connect.dll
          1.35 MB
        7. cpprest_2_10.dll
          1.78 MB
        8. cpprest_2_10.lib
          195 kB
        9. cpprest_2_10.zip
          5.37 MB

        Activity

          I use Windows 10.
          And can I just use your DLL file, ie how do I understand just copy it to a specific folder MariaDB, or should I do some more preparatory work?
          I would just test on the example of Apache Solr

          Looking ahead, Apache Solr has the ability of BASIC AUTHENTICATION, specifically its anyway have to use, at least to protect from an outside of the index, is it possible your method is also to use it. I all these details REST authorization not know, in your example,or rather from Open Weather there is issued a TOKEN, and Apache Solr, I do not remember such possibility, there's just a pair of USERNAME/PASSWORD

          strelkovandreyvalerievich Strelkov Andrey added a comment - I use Windows 10. And can I just use your DLL file, ie how do I understand just copy it to a specific folder MariaDB, or should I do some more preparatory work? I would just test on the example of Apache Solr Looking ahead, Apache Solr has the ability of BASIC AUTHENTICATION, specifically its anyway have to use, at least to protect from an outside of the index, is it possible your method is also to use it. I all these details REST authorization not know, in your example,or rather from Open Weather there is issued a TOKEN, and Apache Solr, I do not remember such possibility, there's just a pair of USERNAME/PASSWORD
          bertrandop Olivier Bertrand added a comment - - edited

          I also use Windows 10 however, it's not so simple:

          You must install the Microsoft Casablanca support that my OEM module uses. This is described in https://github.com/Microsoft/cpprestsdk and for Windows do:

          vcpkg install cpprestsdk cpprestsdk:x64-windows
          

          (assuming you have a 64 bits machine)

          When I tried it I realized that I did not have vcpkg and I had to install it from https://github.com/Microsoft/vcpkg
          These sites explain how to get and install the packages. When installing cpprestsdk (Casablanca) one step install a lot of boost utilities and this can last almost half an hour.

          In addition, I had to add the path of where the Casablanca DLLs have been loaded in the PATH environment variable and restart my system.

          Then you must compile the EOM module. I cannot just send you mine because it was compiled and linked against my own version of CONNECT. By the way I was obliged to fix a few bug in CONNECT to have discovery working. But with another version, it should work but without discovery, meaning you would have to define manually the table columns. This can be done with Visual Studio if you know how to use it. The issue is that the compilation and link is done against the ha_connect.lib library that is now distributed with MariaDB and should be found in the Plugin directory.

          Perhaps I can do this for you if you upload and attach here your ha_connect.lib file of your present distribution (by the way tell me what version of MariaDB you are using) If so, I will be able to send you the pre-compiled EOM module (DLL)

          bertrandop Olivier Bertrand added a comment - - edited I also use Windows 10 however, it's not so simple: You must install the Microsoft Casablanca support that my OEM module uses. This is described in https://github.com/Microsoft/cpprestsdk and for Windows do: vcpkg install cpprestsdk cpprestsdk:x64-windows (assuming you have a 64 bits machine) When I tried it I realized that I did not have vcpkg and I had to install it from https://github.com/Microsoft/vcpkg These sites explain how to get and install the packages. When installing cpprestsdk (Casablanca) one step install a lot of boost utilities and this can last almost half an hour. In addition, I had to add the path of where the Casablanca DLLs have been loaded in the PATH environment variable and restart my system. Then you must compile the EOM module. I cannot just send you mine because it was compiled and linked against my own version of CONNECT. By the way I was obliged to fix a few bug in CONNECT to have discovery working. But with another version, it should work but without discovery, meaning you would have to define manually the table columns. This can be done with Visual Studio if you know how to use it. The issue is that the compilation and link is done against the ha_connect.lib library that is now distributed with MariaDB and should be found in the Plugin directory. Perhaps I can do this for you if you upload and attach here your ha_connect.lib file of your present distribution (by the way tell me what version of MariaDB you are using) If so, I will be able to send you the pre-compiled EOM module (DLL)
          strelkovandreyvalerievich Strelkov Andrey added a comment - - edited

          Good day, Olivier!
          I tried at myself to make all this (to establish, compile, etc.) but unfortunately nothing turned out. Can I ask you to compile=) I have version 10.3.9

          strelkovandreyvalerievich Strelkov Andrey added a comment - - edited Good day, Olivier! I tried at myself to make all this (to establish, compile, etc.) but unfortunately nothing turned out. Can I ask you to compile=) I have version 10.3.9

          Of course you cannot compile, you do not have the source code of the OEM module!

          So I have installed MariaDB 10.3.9 and compiled the module. I have uploaded it here and a Readme.txt file explaining how to use it.

          Let me know about failure or success!

          bertrandop Olivier Bertrand added a comment - Of course you cannot compile, you do not have the source code of the OEM module! So I have installed MariaDB 10.3.9 and compiled the module. I have uploaded it here and a Readme.txt file explaining how to use it. Let me know about failure or success!

          bertrandop told me that:

          The REST requests are now implemented in CONNECT and allow you to create tables based on web APIs, without even describing the columns.

          julien.fritsch Julien Fritsch added a comment - bertrandop told me that: The REST requests are now implemented in CONNECT and allow you to create tables based on web APIs, without even describing the columns.

          People

            bertrandop Olivier Bertrand
            strelkovandreyvalerievich Strelkov Andrey
            Votes:
            2 Vote for this issue
            Watchers:
            5 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.