package fun-sql

Helper to construct SQL query strings using placeholders.

migrate db dir applies the SQL migration scripts in dir on the given database db, keeping track of those that have already been applied.

To apply the migrations in the correct order, the migration scripts must be given filenames that are sorted in lexicographical order of the desired migration order, e.g. 0000_0001_init.sql will be applied before 0000_0002_sec.sql, and so on.

Note that this uses exec_script internally, which means the migration scripts must not have trailing semicolons either.

Any files with extensions other than .sql are ignored.

• raises Bad_migration

  an error occurs during applying the migrations.

transaction db f runs f () inside a transaction in the db. If the operation succeeds, it commits the transaction and returns its result. If it fails with an exception, it rolls back the transaction and re-raises the exception.

Thrown if we are expecting at most one result but get more.

only seq is the first and only element of seq. This is a convenience function because all queries return seqs but sometimes we want only a single item, otherwise it should be an error.

Use this in preference to calculating the length of the seq, which would force the entire data structure.

• raises Not_found

  if seq has 0 items.

• raises More_than_one

  if seq has more than 1 item.

optional seq is Some a if a is the first and only element of seq, or None if seq is empty.

• raises More_than_one

  if seq has more than 1 item.