Preen uses the library to connect to MySQL databases.
Example Preen Source Configuration
# FILENAME: ~/.preen/sources.yaml
sources:
- name: mysql-example
engine: mysql
connection:
host: localhost
port: 3306
database: mysql
username: ${MYSQL_USER} # You can specify environment variables in the sources.yaml file.
password: ${MYSQL_PASSWORD}
MySQL Models
MySQL models are defined as a YAML file that contains a SQL query.
# FILENAME: ~/.preen/models/users.yaml
name: users # This name needs to be unique
type: sql
query: |
select
users.id,
users.first_name,
users.last_name,
users.birthday
from
users;
MySQL Type Mappings
Code References
A comprehensive list of MySQL type mappings can be found .
