U++ forum: Welcome to the forum

Search on this site

Search in forums

Home » Developing U++ » U++ Developers corner » evaluate command line (parse line by line processed command to create backup log)

Show: Today's Messages :: Show Polls :: Message Navigator
E-mail to friend

evaluate command line [message #58686]

Thu, 21 July 2022 22:04

BetoValle
Messages: 204
Registered: September 2020
Location: Brasil Valinhos SP

Experienced Member

I found this code below and tested it successfully. But my intention is to evaluate the contents of each line that the mysqldump program generates. How to do this? Could someone help me with an example?
Grateful!


CONSOLE_APP_MAIN  
{
	std::stringstream ss;
	std::string pathOfCommand ="C:\\Program Files (x86)\\MariaDB 10.1\\bin\\mysqldump.exe";
	std::string params=" -u mylogin --password=mypass --verbose --extended-insert=FALSE databaseName > ";
	std::string pathOfInputFile="C:\\TEMP\\file1.sql";

        // some code to set values for paths and solves the filename space problem
	ss << "\"";                             // command opening quote
	ss << "\"" << pathOfCommand   << "\" "; // Quoted binary (could have spaces)
	ss << " " << params << " ";  		// Quoted input (could have spaces)
	ss << "\"" << pathOfInputFile << "\"";  // Quoted input (could have spaces)
	ss << "\"";                             // command closing quote  

        Cout() << "seeing how the command turned out:" << ss.str() << EOL;

        int i;
        i=system( ss.str().c_str() );
        Cout() <<"backup result: " << i << EOL;    
    
}

Report message to a moderator

Re: evaluate command line [message #58687 is a reply to message #58686]

Fri, 22 July 2022 04:19

jjacksonRIAB
Messages: 227
Registered: June 2011

Experienced Member

Try the Sys method instead, you don't need any of that std::string stuff, just String works fine:

#include <Core/Core.h>

using namespace Upp;

CONSOLE_APP_MAIN {
    String output;
    Sys("ls -la", output);
   
    Vector<String> lines = Split(output, "\n");

    int i = 1;
    for(auto& line : lines) {
        Cout() << Format("Line #%d: %s\n", i, line);
        i++;
    }
}

Sys will run the command and store the results in the output variable. Split will create an array of Strings that you can loop through on newline or you can choose an alternative delimiter. If you need anything more complex than that try looking up CParser (https://www.ultimatepp.org/src$Core$CParser_en-us.html), it can help you write a hand parser. Regexps are also available (https://www.ultimatepp.org/reference$RegExp$en-us.html).

I don't have Windows installed but if you replace "ls -la" with "dir" that example should get you going.

Report message to a moderator

Re: evaluate command line [message #58688 is a reply to message #58687]

Fri, 22 July 2022 15:13

BetoValle
Messages: 204
Registered: September 2020
Location: Brasil Valinhos SP

Experienced Member

Hi, thanks but

I think there must be some additional parameter in the case of windows 10 (my case). Wouldn't you have to pass the folder? I did a quick test with only sys("dir",output) following your example and it didn't return anything!

Report message to a moderator

Re: evaluate command line [message #58689 is a reply to message #58688]

Fri, 22 July 2022 18:21

BetoValle
Messages: 204
Registered: September 2020
Location: Brasil Valinhos SP

Experienced Member

Hi, again ...

with the command "dir" in windows 10 and I really couldn't!

I tested with the parameters below and finally I was successful!
important to point out that I had to modify a parameter in the backup command: replace the ">" with "--result-file="

With ">" Sys was not interpreting correctly and displayed message charging "a table".

I understand that the Sys routine is welcome for the purpose of creating a log file. On the other hand, creating a progress bar probably won't work given the processing delay.

    String output;

    String fdump="C:\\Program Files (x86)\\MariaDB 10.1\\bin\\mysqldump.exe";

    String xparams="  -u mylogin --password=mypass--verbose --extended-insert=FALSE databaseName";

    String tofile=" --result-file=C:\\TEMP\\file1.sql";

    String s;

      s << fdump;

      s << xparams;

      s << tofile;

    Sys(s,output);

    Vector<String> lines = Split(output, "\n");

    String x;

    int i = 1;

    for(auto& line : lines) {

        x << Format("Line #%d: %s\n", i, line);

        i++;

    }

    Led.SetData(x); // Led is LineEdit!

Thanks jjackson!

Report message to a moderator

Re: evaluate command line [message #58690 is a reply to message #58689]

Fri, 22 July 2022 21:48

jjacksonRIAB
Messages: 227
Registered: June 2011

Experienced Member

Yeah dir might not work if you're in an empty directory or the delimiter is not a newline (I think it is even under Windows though). There's a function called

ChangeCurrentDirectory("whatever");

There are also several functions for reading in environment variables that could prove useful to you in certain contexts. Ex.

Cout() << GetEnv("PATH");

Will print out a PATH environment variable in a unix-like or DOS. There's also GetHomeDirectory(), GetProgramsFolder(), GetProgramsFolderX86(), GetTempDirectory() and a few others - I believe all of those call GetEnv with known environment variables.

I don't know anything about MariaDB but it may be preferable to find some kind of environment variable or registry key to locate where mysqldump.exe so your don't have to hardcode anything (knowing Windows it could be installed in one of several places or even on a different drive). Sometimes that can't be helped though... and if it's just for personal use who cares, I guess... but if, for example, someone put their Programs Folder on the D: or E: drive instead of C:, some of the functions above can help you clean up your application discovery process.

**EDIT** Looking at Windows, it appears to do things differently. If I use "cmd /c dir" it will print out and split everything correctly but you might want LocalProcess instead. I don't know offhand how to create this process without creating a Window because I just remembered that dir is not actually a separate program under Windows, it's a built-in shell command. There's probably some argument that be passed to hide the window.

https://www.ultimatepp.org/src$Core$AProcess$en-us.html

[Updated on: Fri, 22 July 2022 23:43]

Report message to a moderator

Re: evaluate command line [message #58691 is a reply to message #58690]

Fri, 22 July 2022 22:51

BetoValle
Messages: 204
Registered: September 2020
Location: Brasil Valinhos SP

Experienced Member

the only way that i found to use "dir" is below
but disadvantage is that the console window opens

   const char* cmd;

    cmd="dir C:\\temp";

    std::shared_ptr<FILE> pipe(popen(cmd, "r"), pclose);

    char buffer[128];

    std::string result = "";

    while (!feof(pipe.get())) {

        if (fgets(buffer, 128, pipe.get()) != NULL)

            result += buffer;

    }

Report message to a moderator

Re: evaluate command line [message #58692 is a reply to message #58691]

Sat, 23 July 2022 01:09

jjacksonRIAB
Messages: 227
Registered: June 2011

Experienced Member

I don't get an open console window if it's a GUI app and I'm using GUI_APP_MAIN - only if it's a console app:

#include "TestDir.h"

TestDir::TestDir()
{
    CtrlLayout(*this, "Window title");
    
    String output;
    Sys("cmd.exe /c dir c:\\", output);
    
    Vector<String> lines = Split(output, "\n");
   
    String numberedOutput;

    int i = 1;
    for(auto& line : lines) {
        numberedOutput << Format("Line #%d: %s\n", i, line);
        i++;
    }
    
    lineEdit <<= numberedOutput;
}

GUI_APP_MAIN
{
    TestDir().Run();
}

Report message to a moderator

Re: evaluate command line [message #58693 is a reply to message #58692]

Sat, 23 July 2022 01:51

BetoValle
Messages: 204
Registered: September 2020
Location: Brasil Valinhos SP

Experienced Member

ok! very good! now work with command "dir".

"Sys" on windows 10, no console window opens!

CONSOLE_APP_MAIN  
{
    String output;
    Sys("cmd.exe /c dir c:\\temp", output);
    Cout() << "aqui " << output << EOL;   
    Vector<String> lines = Split(output, "\n");

    int i = 1;
    for(auto& line : lines) {
        Cout() << Format("Line #%d: %s\n", i, line);
        i++;
    }
}

Report message to a moderator

Previous Topic:	log file in Oracle8
Next Topic:	Windows 11 toolbar and menu issues

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Sun May 11 01:43:08 CEST 2025

Total time taken to generate the page: 0.03208 seconds