Database Connections

[karthikshashi]

Wonderful work that you have done. Could you please add a Database functionality as well in your upcoming release. Also some text file options to trim / parse text will be of great help.

[saucepleez]

Hello,

We can look at adding Trim text. What do you mean by parse text? Also how do you imagine the database functionality working?

[humbertoanascimento]

Hi,

Could I participate this discussion? I work with some RPA tools.

The database could be compatible with generic driver connections, like DBeaver: you define the driver path the program and set others generals and specific configurarions. Thus is possible to use any desired driver.

Besides DB connection, is need some exception treatment that could be more generic, like a try-catch. This way is possible to define the behavior of automation when this case occur.

[saucepleez]

Hi,

Sure. So to do this we can look at implementing 4 commands (off the top):

• Connect
• Execute Stored Procedire
• Execute Query
• Disconnect

In terms of try-catch, we can look at implementing that for all commands, that should probably be a separate work item.

[shiddugmail]

This is a good news Thank you, Regards, Shiddu Mageppa

…

On 18-Jul-2019, at 6:31 PM, saucepleez ***@***.***> wrote: Hi, Sure. So to do this we can look at implementing 4 commands (off the top): Connect Execute Stored Procedire Execute Query Disconnect In terms of try-catch, we can look at implementing that for all commands, that should probably be a separate work item. — You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub, or mute the thread.

[karthikshashi]

Hi,

Sure. So to do this we can look at implementing 4 commands (off the top):

• Connect
• Execute Stored Procedire
• Execute Query
• Disconnect

In terms of try-catch, we can look at implementing that for all commands, that should probably be a separate work item.

• For the Connect action, it will be good to have information collected in different fields and then join them to create a connection string at real time. The password field can then be invisible / encrypted.
• In the Execute Stored Procedure, the connection name will need to be available to specify which DB stored connection to run the query on.
• Execute query action could be similar to Execute Stored Procedure and will be good to subscribe input from the output of a previously run object / action in the workflow.
• Disconnect - Once a query is completed, session generally terminates.

Compatibility : SQL first and My SQL later?

This will be too good a functionality to have and thanks a ton.

[saucepleez]

@karthikshashi

Agreed. I think for the connect command we can use the data link builder:

This way we can support compatibility for most databases -- users will simply need to install the providers onto their machine. I started work on this but ran into a few bumps

[saucepleez]

Ok @karthikshashi, I have added the define connection and initial query commands using OLEDB.

Here is sample SQL Data Source:

Here is sample command to retrieve data:

Here is the result:

[saucepleez]

@karthikshashi @humbertoanascimento I have added database commands as well as try/catch/finally/end try. Please open new issues if you need help or encounter any problems, thanks.

[karthikshashi]

As fast as lightening !!! Can't be thankful enough Sir. And I will download the latest release. Thank you so much.

…

On Tue, Jul 30, 2019, 4:00 AM saucepleez ***@***.***> wrote: Ok @karthikshashi <https://github.com/karthikshashi>, I have added the define connection and initial query commands using OLEDB. Here is sample SQL Data Source: [image: image] <https://user-images.githubusercontent.com/5113950/62087137-b1a2ff80-b22e-11e9-908b-f6b41c6e998c.png> Here is sample command to retrieve data: [image: image] <https://user-images.githubusercontent.com/5113950/62087126-a2bc4d00-b22e-11e9-834c-2e56a4641c39.png> Here is the result: [image: image] <https://user-images.githubusercontent.com/5113950/62087204-ef078d00-b22e-11e9-8363-57bf6cefca4a.png> — You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub <#138?email_source=notifications&email_token=AKQEUG2NYRJJPGLPILDLHILQB5VR3A5CNFSM4IDVOP52YY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGOD3CGFWI#issuecomment-516186841>, or mute the thread <https://github.com/notifications/unsubscribe-auth/AKQEUGYDALRAEHRY3XCSOXDQB5VR3ANCNFSM4IDVOP5Q> .

[karthikshashi]

Sir could you please also let me know how I can get a copy of the latest version. Thanks.

…

On Tue, Jul 30, 2019, 4:00 AM saucepleez ***@***.***> wrote: Ok @karthikshashi <https://github.com/karthikshashi>, I have added the define connection and initial query commands using OLEDB. Here is sample SQL Data Source: [image: image] <https://user-images.githubusercontent.com/5113950/62087137-b1a2ff80-b22e-11e9-908b-f6b41c6e998c.png> Here is sample command to retrieve data: [image: image] <https://user-images.githubusercontent.com/5113950/62087126-a2bc4d00-b22e-11e9-834c-2e56a4641c39.png> Here is the result: [image: image] <https://user-images.githubusercontent.com/5113950/62087204-ef078d00-b22e-11e9-8363-57bf6cefca4a.png> — You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub <#138?email_source=notifications&email_token=AKQEUG2NYRJJPGLPILDLHILQB5VR3A5CNFSM4IDVOP52YY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGOD3CGFWI#issuecomment-516186841>, or mute the thread <https://github.com/notifications/unsubscribe-auth/AKQEUGYDALRAEHRY3XCSOXDQB5VR3ANCNFSM4IDVOP5Q> .

[humbertoanascimento]

@saucepleez Its stunning your agility and fast answers! I will try the latest version tonight. Very thanks for these new features!

[saucepleez]

@humbertoanascimento @karthikshashi Are you building from source code? If not, I will further test and release a compiled binary. The changes are active in the DEV branch as of now. I can create a test build, I generally release Friday - Sunday.

[karthikshashi]

Sir I'm not touching source code yet. If it doesn't hurt you too much a compile will be awesome.

…

On Wed, Jul 31, 2019, 7:09 PM saucepleez ***@***.***> wrote: @humbertoanascimento <https://github.com/humbertoanascimento> @karthikshashi <https://github.com/karthikshashi> Are you building from source code? If not, I will further test and release a compiled binary. — You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub <#138?email_source=notifications&email_token=AKQEUG7DPH3Q7HRRZHFBYUTQCGIYPA5CNFSM4IDVOP52YY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGOD3HI3GI#issuecomment-516853145>, or mute the thread <https://github.com/notifications/unsubscribe-auth/AKQEUG5V6PHT7ACZDYIDRADQCGIYPANCNFSM4IDVOP5Q> .

[saucepleez]

@karthikshashi I will build a 3.1.0.0 binary tonight EST.

[saucepleez]

@karthikshashi Please see latest release preview

[karthikshashi]

Thank you sir. I got a Symantec security warning when I downloaded the file though.

…

On Thu, Aug 1, 2019, 9:23 AM saucepleez ***@***.***> wrote: @karthikshashi <https://github.com/karthikshashi> Please see latest release preview — You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub <#138?email_source=notifications&email_token=AKQEUG4RZTHML4DA6FTPBLTQCJM4FA5CNFSM4IDVOP52YY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGOD3JHEMA#issuecomment-517108272>, or mute the thread <https://github.com/notifications/unsubscribe-auth/AKQEUGYLN6SJELOMZGZNYWTQCJM4FANCNFSM4IDVOP5Q> .

[saucepleez]

@karthikshashi

What was the issue Symantec gave? This was the first build through Azure Pipelines. Binary should be signed.

[atotalnoob]

@saucepleez test the binary in a vm

[saucepleez]

@atotalnoob There is no issue with the binary, the issue is with Symantec probably because it has not seen this file "in the wild" yet. Symantec does not offer whitelisting for developers so the only course of action will be for @karthikshashi to manually build the project until Symantec begins to trust the zip file.