File: ob-sql.el.html

Org-Babel support for evaluating sql source code.

(see also ob-sqlite.el)

SQL is somewhat unique in that there are many different engines for the evaluation of sql (Mysql, PostgreSQL, etc...), so much of this file will have to be implemented engine by engine.

Also SQL evaluation generally takes place inside of a database.

Header args used:
- engine
- cmdline
- dbhost
- dbport
- dbuser
- dbpassword
- dbconnection (to reference connections in sql-connection-alist)
- dbinstance (currently only used by SAP HANA)
- database
- colnames (default, nil, means "yes")
- result-params
- out-file

The following are used but not really implemented for SQL:
- colname-names
- rownames
- rowname-names

Engines supported:
- mysql
- dbi
- mssql
- sqsh
- postgresql (postgres)
- oracle
- vertica
- saphana

TODO:

- support for sessions
- support for more engines
- what's a reasonable way to drop table data into SQL?

Defined variables (1)

org-babel-header-args:sqlSQL-specific header arguments.

Defined functions (14)

org-babel-edit-prep:sql(INFO)
org-babel-execute:sql(BODY PARAMS)
org-babel-expand-body:sql(BODY PARAMS)
org-babel-find-db-connection-param(PARAMS NAME)
org-babel-prep-session:sql(SESSION PARAMS)
org-babel-sql-convert-standard-filename(FILE)
org-babel-sql-dbstring-mssql(HOST USER PASSWORD DATABASE)
org-babel-sql-dbstring-mysql(HOST PORT USER PASSWORD DATABASE)
org-babel-sql-dbstring-oracle(HOST PORT USER PASSWORD DATABASE)
org-babel-sql-dbstring-postgresql(HOST PORT USER DATABASE)
org-babel-sql-dbstring-saphana(HOST PORT INSTANCE USER PASSWORD DATABASE)
org-babel-sql-dbstring-sqsh(HOST USER PASSWORD DATABASE)
org-babel-sql-dbstring-vertica(HOST PORT USER PASSWORD DATABASE)
org-babel-sql-expand-vars(BODY VARS &optional SQLITE)

Defined faces (0)