Git Code Merge Request #56: Add batch mode (merged)

Allow command line to work non interactively.

console.sh <accessdb-file> [password] [command]</accessdb-file>

For example you can do:

console.sh mydatabase.accdb export -t users users.csv

See password is only used if is needed (I think a proper command line would be better but I prefer to start small)

About:

console.sh mydatabase.accdb

It allows to start console without first user input (which seems pretty convenient). Again I would look for the file in current workdir, but prefer to ask for review before continue

[albfan]

I pushed another commits to MR.

• modifications to accept command line arguments in console.sh
• Simplification of SingleValue object output. So columns with array of this shows as: [1, 2] instead of [ SingleValue [value=1], SingleValue [value=2]]

I'm turning the csv to json to import into mongodb, and just need to process the result with:

csvjson data.csv | jq . > data,json
sed 's/"[]"/null/g' data.json > data_sin_empty_array.json
sed 's/"([.*])"/\1/g' data_sin_empty_array.json > data_array.json

to have a json formatted, with empty arrays turn into null, and strings "[1,2]" turn into [1,2] (real arrays in json.

I would add json if that is interesting

About this SingleValue multi array columns, I cannot see the relation (it is a foreign key with other tables) in the console.sh output, is there any missing feature to show that? Right now I'm guessing the relationship by the column name and tables. column users_id should be related with users (etc...)

[albfan]

I pushed another commits to MR.

• modifications to accept command line arguments in console.sh
• Simplification of SingleValue object output. So columns with array of this shows as: [1, 2] instead of [ SingleValue [value=1], SingleValue [value=2]]

I'm turning the csv to json to import into mongodb, and just need to process the result with:

csvjson data.csv | jq . > data,json
sed 's/"[]"/null/g' data.json > data_sin_empty_array.json
sed 's/"([.*])"/\1/g' data_sin_empty_array.json > data_array.json

to have a json formatted, with empty arrays turn into null, and strings "[1,2]" turn into [1,2] (real arrays in json.

I would add json if that is interesting

About this SingleValue multi array columns, I cannot see the relation (it is a foreign key with other tables) in the console.sh output, is there any missing feature to show that? Right now I'm guessing the relationship by the column name and tables. column users_id should be related with users (etc...)

[albfan]

Just added relatie paths, to avoid absolute paths to locate a file