Skip to content

A Pandoc filter to execute and collect results of a SQL query

Notifications You must be signed in to change notification settings

barskern/pandoc-filter-runsql

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

12 Commits
 
 
 
 
 
 
 
 
 
 

Repository files navigation

RunSQL - A Pandoc filter to execute SQL queries

A pandoc filter to execute and collect the results of SQL queries.

Syntax

Regular queries where you expect it to return a table should be formatted as such:

~~~runsql
SELECT * FROM table;
~~~

If wish to update, delete or perform other operations that does not return a table, you need to specify that there are no results.

~~~runsql
no_result: True
---
DELETE FROM table;
~~~

Usage

If runsql.py is in the same folder:

pandoc --filter ./runsql.py test.md -o test.pdf

If runsql.py is installed to a directory in $PATH:

pandoc --filter runsql.py test.md -o test.pdf

Configuration

The filter fetches it's configuration from the environment through:

  • MYSQL_HOST: Hostname to the SQL server (default localhost)
  • MYSQL_USER: Username of the SQL user (default root)
  • MYSQL_PASSWORD: Password of the SQL user (default secret)
  • MYSQL_DATABASE: Database to perform queries to (default trlog)

Example

See test.md and the generated test.pdf files for an example.

About

A Pandoc filter to execute and collect results of a SQL query

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages