Attachment #226343 for bug #256646




TEA=	yes
MASTERDIR=	${.CURDIR}/../sqlite3
CATEGORIES=	databases tcl
MASTER_SITES=	https://www.sqlite.org/2021/ \
		https://www2.sqlite.org/2021/ \
		https://www3.sqlite.org/2021/
PKGNAMEPREFIX=	tcl-
DISTNAME=	sqlite-autoconf-${PORTVERSION:C/\.([[:digit:]])[[:>:]]/0\1/g:S/.//g}00

.include "${MASTERDIR}/Makefile"
COMMENT=	SQLite extension for Tcl using the Tcl Extension Architecture (TEA)

LICENSE=	PD

LIB_DEPENDS=	libsqlite3.so:databases/sqlite3

USES=		pkgconfig tcl:tea
USE_LDCONFIG=	yes

CONFIGURE_ARGS=	--with-system-sqlite

CFLAGS+=	`pkg-config --cflags sqlite3`
LDFLAGS+=	`pkg-config --libs sqlite3`

SUB_FILES=	example.tcl
SUB_LIST=	"TCLSH=${TCLSH}"

WRKSRC=		${WRKDIR}/${DISTNAME}/tea

PLIST_FILES=	lib/${PORTNAME}/libsqlite${PORTVERSION}.so \
		lib/${PORTNAME}/pkgIndex.tcl \
		man/mann/sqlite3.n.gz
PORTEXAMPLES=	*

OPTIONS_DEFINE=		EXAMPLES THREADS
OPTIONS_DEFAULT=	THREADS

THREADS_CONFIGURE_ENABLE=	threads

post-patch:
	@${REINPLACE_CMD} -E 's/^(.*\$$\(PACKAGE_NAME\))\$$\(PACKAGE_VERSION\).*$$/\1${PORTVERSION:C/[^[:digit:]]*([[:digit:]]+).*/\1/}/' ${WRKSRC}/Makefile.in

post-install:
	@${STRIP_CMD} ${STAGEDIR}${PREFIX}/lib/${PORTNAME}/libsqlite${PORTVERSION}.so
	@${MKDIR} ${STAGEDIR}${EXAMPLESDIR}
	${INSTALL_SCRIPT} ${WRKDIR}/${SUB_FILES} ${STAGEDIR}${EXAMPLESDIR}

.include <bsd.port.mk>

Lines 1-3 Link Here

(-)databases/tcl-sqlite3/distinfo (-3 lines)
1	TIMESTAMP = 1611470952
2	SHA256 (sqlite-autoconf-3340100.tar.gz) = 2a3bca581117b3b88e5361d0ef3803ba6d8da604b1c1a47d902ef785c1b53e89
3	SIZE (sqlite-autoconf-3340100.tar.gz) = 2930089




#!%%TCLSH%%

package require sqlite3

if {$argc!=2} {
  puts stderr "Usage: $argv0 DATABASE SQL-STATEMENT"
  exit 1
}
sqlite3 db [lindex $argv 0]
db eval [lindex $argv 1] x {
  foreach v $x(*) {
    puts "$v = $x($v)"
  }
  puts ""
}
db close

Lines 1-4 Link Here

(-)databases/tcl-sqlite3/pkg-descr (-4 lines)
1	This is the SQLite extension for Tcl using the Tcl Extension
2	Architecture (TEA).
3
4	WWW: https://www.sqlite.org/

Return to bug 256646

Lines 1-48 Link Here

(-)databases/tcl-sqlite3/Makefile (-47 / +3 lines)
1	PORTNAME= sqlite3	1	TEA= yes
2	PORTVERSION= 3.34.1	2	MASTERDIR= ${.CURDIR}/../sqlite3
3	CATEGORIES= databases tcl
4	MASTER_SITES= https://www.sqlite.org/2021/ \
5	https://www2.sqlite.org/2021/ \
6	https://www3.sqlite.org/2021/
7	PKGNAMEPREFIX= tcl-
8	DISTNAME= sqlite-autoconf-${PORTVERSION:C/\.([[:digit:]])[[:>:]]/0\1/g:S/.//g}00
9		3
10	MAINTAINER= pavelivolkov@gmail.com	4	.include "${MASTERDIR}/Makefile"
11	COMMENT= SQLite extension for Tcl using the Tcl Extension Architecture (TEA)
12
13	LICENSE= PD
14
15	LIB_DEPENDS= libsqlite3.so:databases/sqlite3
16
17	USES= pkgconfig tcl:tea
18	USE_LDCONFIG= yes
19
20	CONFIGURE_ARGS= --with-system-sqlite
21
22	CFLAGS+= `pkg-config --cflags sqlite3`
23	LDFLAGS+= `pkg-config --libs sqlite3`
24
25	SUB_FILES= example.tcl
26	SUB_LIST= "TCLSH=${TCLSH}"
27
28	WRKSRC= ${WRKDIR}/${DISTNAME}/tea
29
30	PLIST_FILES= lib/${PORTNAME}/libsqlite${PORTVERSION}.so \
31	lib/${PORTNAME}/pkgIndex.tcl \
32	man/mann/sqlite3.n.gz
33	PORTEXAMPLES= *
34
35	OPTIONS_DEFINE= EXAMPLES THREADS
36	OPTIONS_DEFAULT= THREADS
37
38	THREADS_CONFIGURE_ENABLE= threads
39
40	post-patch:
41	@${REINPLACE_CMD} -E 's/^(.\$$\(PACKAGE_NAME\))\$$\(PACKAGE_VERSION\).$$/\1${PORTVERSION:C/[^[:digit:]]([[:digit:]]+)./\1/}/' ${WRKSRC}/Makefile.in
42
43	post-install:
44	@${STRIP_CMD} ${STAGEDIR}${PREFIX}/lib/${PORTNAME}/libsqlite${PORTVERSION}.so
45	@${MKDIR} ${STAGEDIR}${EXAMPLESDIR}
46	${INSTALL_SCRIPT} ${WRKDIR}/${SUB_FILES} ${STAGEDIR}${EXAMPLESDIR}
47
48	.include <bsd.port.mk>

Lines 1-16 Link Here

(-)databases/tcl-sqlite3/files/example.tcl.in (-16 lines)
1	#!%%TCLSH%%
2
3	package require sqlite3
4
5	if {$argc!=2} {
6	puts stderr "Usage: $argv0 DATABASE SQL-STATEMENT"
7	exit 1
8	}
9	sqlite3 db [lindex $argv 0]
10	db eval [lindex $argv 1] x {
11	foreach v $x(*) {
12	puts "$v = $x($v)"
13	}
14	puts ""
15	}
16	db close