sql.reader(data.file, filename, variable.name)
Example 1 type: mysql user: sample_user password: sample_password host: localhost dbname: sample_database table: sample_table
Example 2 type: sqlite dbname: /path/to/sample_database table: sample_table
Example 3 type: sqlite dbname: /path/to/sample_database query: SELECT * FROM users WHERE user_active == 1
Example 4 type: sqlite dbname: /path/to/sample_database table: *
Example 5 type: postgres user: sample_user password: sample_password host: localhost dbname: sample_database table: sample_table
Example 6 type: odbc dsn: sample_dsn user: sample_user password: sample_password dbname: sample_database query: SELECT * FROM sample_table
library('ProjectTemplate')
sql.reader('example.sql', 'data/example.sql', 'example')
Run the code above in your browser using DataLab