Command:/sqlite
This command is added by MQ2SQLite
| Notation | Description |
|---|---|
| Text without brackets or braces | Required items |
| <Text inside angle brackets> | Placeholder for which you must supply a value |
| [Text inside square brackets] | Optional items |
| Vertical bar (|) | Separator for mutually exclusive items; choose one |
| {Text | inside | braces} | Set of required items; choose one |
| Ellipsis (…) | Items that can be repeated |
| Syntax | /sqlite [clear | query | open | advquery | close] |
|---|---|
| Description | The full power of SQLite at your disposal. |
Options
| Option | Description |
|---|---|
| clear <ResultName> | Since the results of the query are stored in memory, this can take up a lot of memory if you use unique query names and do not clear your results from memory. So, don't do that. Be sure to use the /sqlite clear <ResultName> function when you're done accessing the results. |
| query <"Path to Database File"> <QueryName> QUERY | Simple usage. |
| open <ConnectionName> <"Path to Database File"> [FLAGS] | Open the database <ConnectionName> in read write mode with write ahead logging enabled. If no flags are passed then the default flags of <"Path to Database File"> are used. |
| advquery <ConnName> <ResultName> <QUERY> | This performs the query on the connection named <ConnName> and stores the result in <ResultName>. |
| close <ConnName> | When you are done, you will want to close the connection to the database |
Examples
/sqlite query <"Path to Database File"> <QueryName> QUERY
For the above documentation, here's an example command:
/sqlite query C:\Test.db myquery SELECT * FROM Table;
See the plugin page for more usage examples.