SUBDIR += emacsql

PORTNAME=	emacsql

DISTVERSION=	3.0.0-14

DISTVERSIONSUFFIX=	-g6d8cd93

CATEGORIES=	databases elisp

PKGNAMESUFFIX=	${EMACS_PKGNAMESUFFIX}

MAINTAINER=	yasu@utahime.org

COMMENT=	High-level Emacs Lisp RDBMS front-end

LICENSE=	UNLICENSE

LICENSE_FILE=	${WRKSRC}/UNLICENSE

BUILD_DEPENDS=	pg.el${EMACS_PKGNAMESUFFIX}>=0.13:databases/pg.el@${EMACS_FLAVOR}

LIB_DEPENDS=	libsqlite3.so:databases/sqlite3

RUN_DEPENDS=	pg.el${EMACS_PKGNAMESUFFIX}>=0.13:databases/pg.el@${EMACS_FLAVOR}

USES=		emacs localbase:ldflags

USE_GITHUB=	yes

GH_ACCOUNT=	skeeto

MAKE_ENV+=	LOAD_PATH="-L ${PREFIX}/${EMACS_SITE_LISPDIR} -L ${PREFIX}/${EMACS_VERSION_SITE_LISPDIR}"

ALL_TARGET=	binary compile

TEST_TARGET=	check

PORTDOCS=	README.md

OPTIONS_DEFINE=	DOCS

post-patch:

	${RM} ${WRKSRC}/sqlite/sqlite3.[ch]

	${REINPLACE_CMD} 's,%%PREFIX%%,${PREFIX},g' ${WRKSRC}/emacsql-sqlite.el

do-install:

	@${MKDIR} ${STAGEDIR}${PREFIX}/bin \

		${STAGEDIR}${PREFIX}/${EMACS_VERSION_SITE_LISPDIR}/${PORTNAME}

	${INSTALL_PROGRAM} ${WRKSRC}/sqlite/emacsql-sqlite \

		${STAGEDIR}${PREFIX}/bin

	${INSTALL_DATA} ${WRKSRC}/*.el ${WRKSRC}/*.elc \

		${STAGEDIR}${PREFIX}/${EMACS_VERSION_SITE_LISPDIR}/${PORTNAME}

do-install-DOCS-on:

	@${MKDIR} ${STAGEDIR}${DOCSDIR}

	${INSTALL_DATA} ${WRKSRC}/README.md ${STAGEDIR}${DOCSDIR}

.include <bsd.port.mk>

TIMESTAMP = 1621275191

SHA256 (skeeto-emacsql-3.0.0-14-g6d8cd93_GH0.tar.gz) = 820258612e19c137a2ab3f5c1eb3c292f28358aa4410eb211ce509bb5693e8ee

SIZE (skeeto-emacsql-3.0.0-14-g6d8cd93_GH0.tar.gz) = 2057085

--- Makefile.orig	2021-05-17 18:22:23 UTC

+++ Makefile

@@ -7,8 +7,7 @@

 .POSIX:

 .SUFFIXES: .el .elc

 EMACS   = emacs

-LDFLAGS = -L ../pg

-BATCH   = $(EMACS) -batch -Q -L . -L tests $(LDFLAGS)

+BATCH   = $(EMACS) -batch -Q -L . -L tests $(LOAD_PATH)

 EL = emacsql-compiler.el \

      emacsql.el \

--- emacsql-sqlite.el.orig	2020-07-14 00:28:59 UTC

+++ emacsql-sqlite.el

@@ -33,16 +33,7 @@

     "sqlite/emacsql-sqlite")

   "Relative path to emacsql executable.")

-(defvar emacsql-sqlite-executable

-  (expand-file-name emacsql-sqlite-executable-path

-                    (if (or (file-writable-p emacsql-sqlite-data-root)

-                            (file-exists-p (expand-file-name

-                                            emacsql-sqlite-executable-path

-                                            emacsql-sqlite-data-root)))

-                        emacsql-sqlite-data-root

-                      (expand-file-name

-                       (concat "emacsql/" emacsql-version)

-                       user-emacs-directory)))

+(defvar emacsql-sqlite-executable "%%PREFIX%%/bin/emacsql-sqlite"

   "Path to the EmacSQL backend (this is not the sqlite3 shell).")

 (defvar emacsql-sqlite-reserved

@@ -100,6 +91,7 @@ used.")

     (emacsql-wait connection)

     (emacsql connection [:pragma (= busy-timeout $s1)]

              (/ (* emacsql-global-timeout 1000) 2))

+    (emacsql connection [:pragma (= foreign_keys 1)])

     (emacsql-register connection)))

 (cl-defun emacsql-sqlite (file &key debug)

@@ -163,12 +155,11 @@ If called with non-nil ASYNC the return value is meani

                       if path return it))

          (src (expand-file-name "sqlite" emacsql-sqlite-data-root))

          (files (mapcar (lambda (f) (expand-file-name f src))

-                        '("sqlite3.c" "emacsql.c")))

+                        '("emacsql.c")))

          (cflags (list (format "-I%s" src) (format "-O%d" (or o-level 2))))

          (ldlibs (cl-case system-type

                    (windows-nt (list))

-                   (berkeley-unix (list "-lm"))

-                   (otherwise (list "-lm" "-ldl"))))

+                   (otherwise (list "-lsqlite3"))))

          (options (emacsql-sqlite-compile-switches))

          (output (list "-o" emacsql-sqlite-executable))

          (arguments (nconc cflags options files ldlibs output)))

--- sqlite/Makefile.orig	2020-07-14 00:28:59 UTC

+++ sqlite/Makefile

@@ -1,6 +1,6 @@

 .POSIX:

-LDLIBS = -ldl -lm

-CFLAGS = -O2 -Wall -Wextra \

+LDLIBS = -lsqlite3

+CFLAGS += \

     -DSQLITE_THREADSAFE=0 \

     -DSQLITE_DEFAULT_FOREIGN_KEYS=1 \

     -DSQLITE_ENABLE_FTS5 \

@@ -10,8 +10,8 @@ CFLAGS = -O2 -Wall -Wextra \

     -DSQLITE_ENABLE_JSON1 \

     -DSQLITE_SOUNDEX

-emacsql-sqlite: emacsql.c sqlite3.c

-	$(CC) $(CFLAGS) $(LDFLAGS) -o $@ emacsql.c sqlite3.c $(LDLIBS)

+emacsql-sqlite: emacsql.c

+	$(CC) $(CFLAGS) $(LDFLAGS) -o $@ emacsql.c $(LDLIBS)

 clean:

 	rm -f emacsql-sqlite

--- sqlite/emacsql.c.orig	2020-07-14 00:28:59 UTC

+++ sqlite/emacsql.c

@@ -1,7 +1,7 @@

 #include <stdio.h>

 #include <stdlib.h>

 #include <string.h>

-#include "sqlite3.h"

+#include <sqlite3.h>

 #define TRUE 1

 #define FALSE 0

EmacSQL is a high-level Emacs Lisp front-end for SQLite (primarily),

PostgreSQL, MySQL, and potentially other SQL databases.

It works by maintaining a inferior process running (a "connection")

for interacting with the back-end database. Connections are

automatically cleaned up if they are garbage collected. All requests

are synchronous.

Any readable lisp value can be stored as a value in EmacSQL, including

numbers, strings, symbols, lists, vectors, and closures. EmacSQL has

no concept of "TEXT" values; it's all just lisp objects. The lisp

object nil corresponds 1:1 with NULL in the database.

WWW: https://github.com/skeeto/emacsql