Querydb: Difference between revisions
WikiSysopdi (talk | contribs) (Created page with "'''Syntax''' : For SQL/MySQL/PostgreSQL: querydb "<SQL QUERY>" <ENTER> For CSV: querydb "<CSV FILE NAME>" <ENTER> For Xero: querydb <ENTITY> <FILTER> <ENTER> For Files: querydb<PATTERN> <ENTER> Eg: For SQL/ MySQL / PostgreSQL: eg.querydb "select top 10 comp_name from company" For CSV: eg.querydb "test.csv" For Xero: eg.querydb contacts firstname = 'CRM' AND UpdatedDateUTC > DateTime(2022, 03, 24) FILES For Files: eg.querydb "*.csv" Description : Executes the gi...") |
WikiSysopdi (talk | contribs) No edit summary |
||
| (2 intermediate revisions by the same user not shown) | |||
| Line 20: | Line 20: | ||
Description : Executes the given query on the currently connected local Server (marked with a *) and gets the response in tabular form. For files provider, user can get the file list using a pattern. For xero provider with Invoices entity, user can give last parameter as FILES as optional which means user wants to get PDF resource instead of tabular data and later user can upload those PDF resources to S3 with using push command. | Description : Executes the given query on the currently connected local Server (marked with a *) and gets the response in tabular form. For files provider, user can get the file list using a pattern. For xero provider with Invoices entity, user can give last parameter as FILES as optional which means user wants to get PDF resource instead of tabular data and later user can upload those PDF resources to S3 with using push command. | ||
----Files | |||
The syntax is | |||
>querydb "*PATTERN" "DAYS" "maxsize" | |||
so if you wannted to query all pdf's with a name starting with "v" created in the last day you would use | |||
.querydb "v*.pdf" "-1" "3mb" | |||
----Files Size | |||
As of 15 Feb 2024 there is a limit of 5mb for files being uploaded. | |||
Latest revision as of 15:15, 6 March 2024
Syntax :
For SQL/MySQL/PostgreSQL: querydb "<SQL QUERY>" <ENTER>
For CSV: querydb "<CSV FILE NAME>" <ENTER>
For Xero: querydb <ENTITY> <FILTER> <ENTER>
For Files: querydb<PATTERN> <ENTER>
Eg:
For SQL/ MySQL / PostgreSQL: eg.querydb "select top 10 comp_name from company"
For CSV: eg.querydb "test.csv"
For Xero: eg.querydb contacts firstname = 'CRM' AND UpdatedDateUTC > DateTime(2022, 03, 24) FILES
For Files: eg.querydb "*.csv"
Description : Executes the given query on the currently connected local Server (marked with a *) and gets the response in tabular form. For files provider, user can get the file list using a pattern. For xero provider with Invoices entity, user can give last parameter as FILES as optional which means user wants to get PDF resource instead of tabular data and later user can upload those PDF resources to S3 with using push command.
Files
The syntax is
>querydb "*PATTERN" "DAYS" "maxsize"
so if you wannted to query all pdf's with a name starting with "v" created in the last day you would use
.querydb "v*.pdf" "-1" "3mb"
Files Size
As of 15 Feb 2024 there is a limit of 5mb for files being uploaded.
