- Remove obsolete configure flags

- Package the Tcl bindings here again so that we only ship one copy
  of SQLite (bsc#1195773).
- Use dynamic linking for the sqlite3 shell.

OBS-URL: https://build.opensuse.org/package/show/server:database/sqlite3?expand=0&rev=278

sqlite3-dynamic-shell.patch

@@ -0,0 +1,14 @@
+--- Makefile.in.orig
++++ Makefile.in
+@@ -655,9 +655,9 @@ libtclsqlite3.la:	tclsqlite.lo libsqlite
+ 		-version-info "8:6:8" \
+ 		-avoid-version
+ 
+-sqlite3$(TEXE):	shell.c sqlite3.c
++sqlite3$(TEXE):	shell.c libsqlite3.la sqlite3.h
+ 	$(LTLINK) $(READLINE_FLAGS) $(SHELL_OPT) -o $@ \
+-		shell.c sqlite3.c \
++		shell.c libsqlite3.la \
+ 		$(LIBREADLINE) $(TLIBS) -rpath "$(libdir)"
+ 
+ sqldiff$(TEXE):	$(TOP)/tool/sqldiff.c sqlite3.lo sqlite3.h

sqlite3.changes

@@ -1,3 +1,11 @@
+-------------------------------------------------------------------
+Wed Mar 16 16:24:45 UTC 2022 - Reinhard Max <max@suse.com>
+
+- Remove obsolete configure flags
+- Package the Tcl bindings here again so that we only ship one copy
+  of SQLite (bsc#1195773).
+- Use dynamic linking for the sqlite3 shell.
+
 -------------------------------------------------------------------
 Sun Mar 13 16:25:42 UTC 2022 - Andreas Stieger <andreas.stieger@gmx.de>
 

sqlite3.spec

@@ -19,6 +19,7 @@
 %define oname sqlite
 %define tarversion 3380100
 %bcond_with icu
+%bcond_without check
 Name:           sqlite3
 Version:        3.38.1
 Release:        0
@@ -30,6 +31,7 @@ Source0:        https://www.sqlite.org/2022/sqlite-src-%{tarversion}.zip
 Source1:        baselibs.conf
 Source2:        https://www.sqlite.org/2022/sqlite-doc-%{tarversion}.zip
 Patch0:         sqlite-src-3380100-atof1.patch
+Patch1:         sqlite3-dynamic-shell.patch
 BuildRequires:  automake
 BuildRequires:  libtool
 BuildRequires:  pkgconfig
@@ -102,6 +104,18 @@ directly to and from the database files on disk.
 SQLite can be used via the sqlite command-line tool or via any
 application which supports the Qt database plug-ins.
 
+%package tcl
+Summary:        Tcl binding for SQLite
+Group:          Development/Libraries/Tcl
+
+%description tcl
+This package contains laguage bindings from the Tcl programming
+language SQLite.
+
+SQLite is a C library that implements an embeddable SQL database
+engine. Programs that link with the SQLite library can have SQL
+database access without running a separate RDBMS process.
+
 %package doc
 Summary:        Documentation for %{name}
 Group:          Documentation/Other
@@ -116,6 +130,7 @@ other documentation found on sqlite.org. The files can be found in
 %prep
 %setup -q -n sqlite-src-%{tarversion} -a2
 %patch0 -p0
+%patch1
 
 rm -v sqlite-doc-%{tarversion}/releaselog/current.html
 ln -sv `echo %{version} | sed "s/\./_/g"`.html sqlite-doc-%{tarversion}/releaselog/current.html
@@ -123,6 +138,7 @@ find -type f -name sqlite.css~ -delete
 cmp sqlite-doc-%{tarversion}/fileformat{,2}.html && ln -sf fileformat.html sqlite-doc-%{tarversion}/fileformat2.html
 
 %build
+export TCLLIBDIR=%tcl_archdir/sqlite%version
 export LIBS="$LIBS -lm %{?with_icu:-licuuc -licui18n}"
 export CFLAGS="%{optflags} \
 	-DSQLITE_ENABLE_API_ARMOR \
@@ -146,27 +162,27 @@ export CFLAGS="%{optflags} \
 	"
 %configure \
   --disable-static \
-  --disable-static-shell \
   --enable-readline \
   --enable-fts3 \
   --enable-fts4 \
   --enable-fts5 \
-  --enable-json1 \
   --enable-update-limit \
   --enable-rtree
 %make_build sqlite3.c
 %make_build
 
+%if %{with check}
 %check
 %make_build test
+%endif
 
 %install
 %make_install
-mkdir -p %{buildroot}/%{_mandir}/man1/
-install -Dpm 0644 sqlite3.1 \
-  %{buildroot}/%{_mandir}/man1/sqlite3.1
+#mkdir -p %{buildroot}/%{_mandir}/man{1,n}/
+install -Dp -m 0644 -t %{buildroot}/%{_mandir}/man1 sqlite3.1
+install -Dp -m 0644 -t %{buildroot}/%{_mandir}/mann autoconf/tea/doc/sqlite3.n
 # tcl bindings are provided by tcl itself
-rm -rf %{buildroot}%{_libdir}/tcl/tcl8.?/sqlite3*
+#rm -rf %{buildroot}%{_libdir}/tcl/tcl8.?/sqlite3*
 find %{buildroot} -type f -name "*.la" -delete -print
 
 %post -n libsqlite3-0 -p /sbin/ldconfig
@@ -185,6 +201,10 @@ find %{buildroot} -type f -name "*.la" -delete -print
 %{_libdir}/libsqlite3.so
 %{_libdir}/pkgconfig/sqlite3.pc
 
+%files tcl
+%tcl_archdir/*
+%doc %_mandir/mann/*
+
 %files doc
 %doc sqlite-doc-%{tarversion}/*