Create an ERD from a sqlite database using schemaspy

Makefile

db-name=database
path-to-db=./data
db-ext=sqlite
output-directory=./docs/diagrams
output-file=diagram.png
db-diagram:
	schemaspy -dp /usr/share/java/sqlite-jdbc/ \
		-t sqlite-xerial \
		-cat ${db-name} -s ${db-name} -db ${path-to-db}/${db-name}.${db-ext} \
		-sso -o /tmp/schemaspy/ && \
		mkdir --parents $(output-directory); mv /tmp/schemaspy/diagrams/summary/relationships.real.large.png ${output-directory}/${output-file}