package shakuhachi

  1. Overview
  2. Docs
A music collection manager

Install 

dune-project
 Dependency

codeberg.org Readme Changelog Edit opam file Versions (5)

Authors

  1. E
    EruEri <nayinayu@mailo.com>

Maintainers

  1. E
    EruEri <nayinayu@mailo.com>

Sources

0.3.2.tar.gz
sha256=c72807d303de137441b643fec1c7630c930ebc792b576783c7961b237c2114db
sha512=770f878bbdac8033d90e904ce8e9c84fc75331c7ff9b35e2204fafe3746f432f2664296dac91942a788b82a2da07478d91b76ed85cd880758d2def8a55144840

doc/src/shakuhachi.database/database.ml.html

Source file database.ml

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
(*****************************************************************************)
(*                                                                           *)
(*  Copyright (C) 2026 Yves Ndiaye                                           *)
(*                                                                           *)
(* This Source Code Form is subject to the terms of the Mozilla Public       *)
(* License, v. 2.0. If a copy of the MPL was not distributed with this       *)
(* file, You can obtain one at https://mozilla.org/MPL/2.0/.                 *)
(*                                                                           *)
(*****************************************************************************)

type t = Sqlite3.db

let transaction database f =
  let _ = Sqlite3.exec database "BEGIN TRANSACTION;" in
  match f database with
  | Ok _ as r ->
      let _ = Sqlite3.exec database "COMMIT;" in
      r
  | Error _ as e ->
      let _ = Sqlite3.exec database "ROLLBACK;" in
      e

let open' ?mode ?uri ?memory ?mutex ?cache ?vfs path =
  let db = Sqlite3.db_open ?mode ?uri ?memory ?mutex ?cache ?vfs path in
  let statement = Sqlite3.prepare db "PRAGMA foreign_keys = ON;" in
  let _ = Sqlite3.step statement in
  let _ = Sqlite3.finalize statement in
  db

let create_tables db =
  let sql =
    Printf.sprintf "BEGIN TRANSACTION; %s %s %s %s %s %s %s %s COMMIT;"
      Album.sql_table Artist.sql_table Playlist.sql_table MusicFile.sql_table
      AlbumParticipant.sql_table MusicParticipant.sql_table
      MusicProperty.sql_table PlaylistMusics.sql_table
  in
  Sqlite3.exec db sql

let close db = Sqlite3.db_close db
let errmsg database = Sqlite3.errmsg database
let sqlite3 db = db