Accepting request 25281 from server:database
Copy from server:database/sqlite3 based on submit request 25281 from user rmax OBS-URL: https://build.opensuse.org/request/show/25281 OBS-URL: https://build.opensuse.org/package/show/openSUSE:Factory/sqlite3?expand=0&rev=20
This commit is contained in:
OBS User autobuild
Git OBS Bridge
parent
a6ff9d50a2
commit
bd93fe53c6
@ -1,3 +0,0 @@
|
|||||||
version https://git-lfs.github.com/spec/v1
|
|
||||||
oid sha256:4cc7dfbafeff694d96fe33c962fb06572cee3519c1656980af2b58668806deae
|
|
||||||
size 2208872
|
|
||||||
3
sqlite-amalgamation-3.6.20.tar.bz2
Normal file
3
sqlite-amalgamation-3.6.20.tar.bz2
Normal file
@ -0,0 +1,3 @@
|
|||||||
|
version https://git-lfs.github.com/spec/v1
|
||||||
|
oid sha256:6b1733b1062ac6849cda51e1f5d8adcd0d89aa102522d9a4d44b8a8588d6f528
|
||||||
|
size 1049205
|
||||||
30
sqlite-tcl.patch
Normal file
30
sqlite-tcl.patch
Normal file
@ -0,0 +1,30 @@
|
|||||||
|
--- sqlite-tcl/configure.in
|
||||||
|
+++ sqlite-tcl/configure.in
|
||||||
|
@@ -73,8 +73,8 @@
|
||||||
|
|
||||||
|
TEA_ADD_SOURCES([tclsqlite3.c])
|
||||||
|
TEA_ADD_HEADERS([])
|
||||||
|
-TEA_ADD_INCLUDES([-I\"`\${CYGPATH} \${srcdir}/generic`\"])
|
||||||
|
-TEA_ADD_LIBS([])
|
||||||
|
+TEA_ADD_INCLUDES([-I\"`\${CYGPATH} \${srcdir}/generic`\" -I\"`\${CYGPATH} \${srcdir}/..`\"])
|
||||||
|
+TEA_ADD_LIBS([-L\"`\${CYGPATH} \${srcdir}/../.libs`\" -lsqlite3])
|
||||||
|
TEA_ADD_CFLAGS([-DSQLITE_ENABLE_FTS3=1])
|
||||||
|
TEA_ADD_STUB_SOURCES([])
|
||||||
|
TEA_ADD_TCL_SOURCES([])
|
||||||
|
diff '--exclude=configure' -ruBb sqlite-3_6_20-tea/generic/tclsqlite3.c sqlite-3.6.20-amalgamation/tcl/generic/tclsqlite3.c
|
||||||
|
--- sqlite-tcl/generic/tclsqlite3.c
|
||||||
|
+++ sqlite-tcl/generic/tclsqlite3.c
|
||||||
|
@@ -33,10 +33,12 @@
|
||||||
|
** appended to the amalgamation.
|
||||||
|
*/
|
||||||
|
#ifndef SQLITE_AMALGAMATION
|
||||||
|
-# include "sqliteInt.h"
|
||||||
|
+# include "sqlite3.h"
|
||||||
|
# include <stdlib.h>
|
||||||
|
# include <string.h>
|
||||||
|
# include <assert.h>
|
||||||
|
+# include <stdint.h>
|
||||||
|
+ typedef uint8_t u8;
|
||||||
|
#endif
|
||||||
|
#include <ctype.h>
|
||||||
|
|
||||||
3
sqlite-tcl.tar.bz2
Normal file
3
sqlite-tcl.tar.bz2
Normal file
@ -0,0 +1,3 @@
|
|||||||
|
version https://git-lfs.github.com/spec/v1
|
||||||
|
oid sha256:187f24767ef919616c79700aa281ec053f04071bba7d94b5230dc60b35d0df00
|
||||||
|
size 131425
|
||||||
@ -1,4 +0,0 @@
|
|||||||
[Desktop Entry]
|
|
||||||
Name=SQLite
|
|
||||||
DocPath=/usr/share/doc/packages/sqlite-devel/index.html
|
|
||||||
X-DOC-SearchMethod=htdig
|
|
||||||
229
sqlite3.1
Normal file
229
sqlite3.1
Normal file
@ -0,0 +1,229 @@
|
|||||||
|
.\" Hey, EMACS: -*- nroff -*-
|
||||||
|
.\" First parameter, NAME, should be all caps
|
||||||
|
.\" Second parameter, SECTION, should be 1-8, maybe w/ subsection
|
||||||
|
.\" other parameters are allowed: see man(7), man(1)
|
||||||
|
.TH SQLITE3 1 "Mon Apr 15 23:49:17 2002"
|
||||||
|
.\" Please adjust this date whenever revising the manpage.
|
||||||
|
.\"
|
||||||
|
.\" Some roff macros, for reference:
|
||||||
|
.\" .nh disable hyphenation
|
||||||
|
.\" .hy enable hyphenation
|
||||||
|
.\" .ad l left justify
|
||||||
|
.\" .ad b justify to both left and right margins
|
||||||
|
.\" .nf disable filling
|
||||||
|
.\" .fi enable filling
|
||||||
|
.\" .br insert line break
|
||||||
|
.\" .sp <n> insert n+1 empty lines
|
||||||
|
.\" for manpage-specific macros, see man(7)
|
||||||
|
.SH NAME
|
||||||
|
.B sqlite3
|
||||||
|
\- A command line interface for SQLite version 3
|
||||||
|
|
||||||
|
.SH SYNOPSIS
|
||||||
|
.B sqlite3
|
||||||
|
.RI [ options ]
|
||||||
|
.RI [ databasefile ]
|
||||||
|
.RI [ SQL ]
|
||||||
|
|
||||||
|
.SH SUMMARY
|
||||||
|
.PP
|
||||||
|
.B sqlite3
|
||||||
|
is a terminal-based front-end to the SQLite library that can evaluate
|
||||||
|
queries interactively and display the results in multiple formats.
|
||||||
|
.B sqlite3
|
||||||
|
can also be used within shell scripts and other applications to provide
|
||||||
|
batch processing features.
|
||||||
|
|
||||||
|
.SH DESCRIPTION
|
||||||
|
To start a
|
||||||
|
.B sqlite3
|
||||||
|
interactive session, invoke the
|
||||||
|
.B sqlite3
|
||||||
|
command and optionally provide the name of a database file. If the
|
||||||
|
database file does not exist, it will be created. If the database file
|
||||||
|
does exist, it will be opened.
|
||||||
|
|
||||||
|
For example, to create a new database file named "mydata.db", create
|
||||||
|
a table named "memos" and insert a couple of records into that table:
|
||||||
|
.sp
|
||||||
|
$
|
||||||
|
.B sqlite3 mydata.db
|
||||||
|
.br
|
||||||
|
SQLite version 3.1.3
|
||||||
|
.br
|
||||||
|
Enter ".help" for instructions
|
||||||
|
.br
|
||||||
|
sqlite>
|
||||||
|
.B create table memos(text, priority INTEGER);
|
||||||
|
.br
|
||||||
|
sqlite>
|
||||||
|
.B insert into memos values('deliver project description', 10);
|
||||||
|
.br
|
||||||
|
sqlite>
|
||||||
|
.B insert into memos values('lunch with Christine', 100);
|
||||||
|
.br
|
||||||
|
sqlite>
|
||||||
|
.B select * from memos;
|
||||||
|
.br
|
||||||
|
deliver project description|10
|
||||||
|
.br
|
||||||
|
lunch with Christine|100
|
||||||
|
.br
|
||||||
|
sqlite>
|
||||||
|
.sp
|
||||||
|
|
||||||
|
If no database name is supplied, the ATTACH sql command can be used
|
||||||
|
to attach to existing or create new database files. ATTACH can also
|
||||||
|
be used to attach to multiple databases within the same interactive
|
||||||
|
session. This is useful for migrating data between databases,
|
||||||
|
possibly changing the schema along the way.
|
||||||
|
|
||||||
|
Optionally, a SQL statement or set of SQL statements can be supplied as
|
||||||
|
a single argument. Multiple statements should be separated by
|
||||||
|
semi-colons.
|
||||||
|
|
||||||
|
For example:
|
||||||
|
.sp
|
||||||
|
$
|
||||||
|
.B sqlite3 -line mydata.db 'select * from memos where priority > 20;'
|
||||||
|
.br
|
||||||
|
text = lunch with Christine
|
||||||
|
.br
|
||||||
|
priority = 100
|
||||||
|
.br
|
||||||
|
.sp
|
||||||
|
|
||||||
|
.SS SQLITE META-COMMANDS
|
||||||
|
.PP
|
||||||
|
The interactive interpreter offers a set of meta-commands that can be
|
||||||
|
used to control the output format, examine the currently attached
|
||||||
|
database files, or perform administrative operations upon the
|
||||||
|
attached databases (such as rebuilding indices). Meta-commands are
|
||||||
|
always prefixed with a dot (.).
|
||||||
|
|
||||||
|
A list of available meta-commands can be viewed at any time by issuing
|
||||||
|
the '.help' command. For example:
|
||||||
|
.sp
|
||||||
|
sqlite>
|
||||||
|
.B .help
|
||||||
|
.nf
|
||||||
|
.cc |
|
||||||
|
.databases List names and files of attached databases
|
||||||
|
.dump ?TABLE? ... Dump the database in an SQL text format
|
||||||
|
.echo ON|OFF Turn command echo on or off
|
||||||
|
.exit Exit this program
|
||||||
|
.explain ON|OFF Turn output mode suitable for EXPLAIN on or off.
|
||||||
|
.header(s) ON|OFF Turn display of headers on or off
|
||||||
|
.help Show this message
|
||||||
|
.import FILE TABLE Import data from FILE into TABLE
|
||||||
|
.indices TABLE Show names of all indices on TABLE
|
||||||
|
.mode MODE ?TABLE? Set output mode where MODE is one of:
|
||||||
|
csv Comma-separated values
|
||||||
|
column Left-aligned columns. (See .width)
|
||||||
|
html HTML <table> code
|
||||||
|
insert SQL insert statements for TABLE
|
||||||
|
line One value per line
|
||||||
|
list Values delimited by .separator string
|
||||||
|
tabs Tab-separated values
|
||||||
|
tcl TCL list elements
|
||||||
|
.nullvalue STRING Print STRING in place of NULL values
|
||||||
|
.output FILENAME Send output to FILENAME
|
||||||
|
.output stdout Send output to the screen
|
||||||
|
.prompt MAIN CONTINUE Replace the standard prompts
|
||||||
|
.quit Exit this program
|
||||||
|
.read FILENAME Execute SQL in FILENAME
|
||||||
|
.schema ?TABLE? Show the CREATE statements
|
||||||
|
.separator STRING Change separator used by output mode and .import
|
||||||
|
.show Show the current values for various settings
|
||||||
|
.tables ?PATTERN? List names of tables matching a LIKE pattern
|
||||||
|
.timeout MS Try opening locked tables for MS milliseconds
|
||||||
|
.width NUM NUM ... Set column widths for "column" mode
|
||||||
|
sqlite>
|
||||||
|
|cc .
|
||||||
|
.sp
|
||||||
|
.fi
|
||||||
|
|
||||||
|
.SH OPTIONS
|
||||||
|
.B sqlite3
|
||||||
|
has the following options:
|
||||||
|
.TP
|
||||||
|
.BI \-init\ file
|
||||||
|
Read and execute commands from
|
||||||
|
.I file
|
||||||
|
, which can contain a mix of SQL statements and meta-commands.
|
||||||
|
.TP
|
||||||
|
.B \-echo
|
||||||
|
Print commands before execution.
|
||||||
|
.TP
|
||||||
|
.B \-[no]header
|
||||||
|
Turn headers on or off.
|
||||||
|
.TP
|
||||||
|
.B \-column
|
||||||
|
Query results will be displayed in a table like form, using
|
||||||
|
whitespace characters to separate the columns and align the
|
||||||
|
output.
|
||||||
|
.TP
|
||||||
|
.B \-html
|
||||||
|
Query results will be output as simple HTML tables.
|
||||||
|
.TP
|
||||||
|
.B \-line
|
||||||
|
Query results will be displayed with one value per line, rows
|
||||||
|
separated by a blank line. Designed to be easily parsed by
|
||||||
|
scripts or other programs
|
||||||
|
.TP
|
||||||
|
.B \-list
|
||||||
|
Query results will be displayed with the separator (|, by default)
|
||||||
|
character between each field value. The default.
|
||||||
|
.TP
|
||||||
|
.BI \-separator\ separator
|
||||||
|
Set output field separator. Default is '|'.
|
||||||
|
.TP
|
||||||
|
.BI \-nullvalue\ string
|
||||||
|
Set string used to represent NULL values. Default is ''
|
||||||
|
(empty string).
|
||||||
|
.TP
|
||||||
|
.B \-version
|
||||||
|
Show SQLite version.
|
||||||
|
.TP
|
||||||
|
.B \-help
|
||||||
|
Show help on options and exit.
|
||||||
|
|
||||||
|
|
||||||
|
.SH INIT FILE
|
||||||
|
.B sqlite3
|
||||||
|
reads an initialization file to set the configuration of the
|
||||||
|
interactive environment. Throughout initialization, any previously
|
||||||
|
specified setting can be overridden. The sequence of initialization is
|
||||||
|
as follows:
|
||||||
|
|
||||||
|
o The default configuration is established as follows:
|
||||||
|
|
||||||
|
.sp
|
||||||
|
.nf
|
||||||
|
.cc |
|
||||||
|
mode = LIST
|
||||||
|
separator = "|"
|
||||||
|
main prompt = "sqlite> "
|
||||||
|
continue prompt = " ...> "
|
||||||
|
|cc .
|
||||||
|
.sp
|
||||||
|
.fi
|
||||||
|
|
||||||
|
o If the file
|
||||||
|
.B ~/.sqliterc
|
||||||
|
exists, it is processed first.
|
||||||
|
can be found in the user's home directory, it is
|
||||||
|
read and processed. It should generally only contain meta-commands.
|
||||||
|
|
||||||
|
o If the -init option is present, the specified file is processed.
|
||||||
|
|
||||||
|
o All other command line options are processed.
|
||||||
|
|
||||||
|
.SH SEE ALSO
|
||||||
|
http://www.sqlite.org/
|
||||||
|
.br
|
||||||
|
The sqlite-doc package
|
||||||
|
.SH AUTHOR
|
||||||
|
This manual page was originally written by Andreas Rottmann
|
||||||
|
<rotty@debian.org>, for the Debian GNU/Linux system (but may be used
|
||||||
|
by others). It was subsequently revised by Bill Bumgarner <bbum@mac.com>.
|
||||||
@ -1,3 +1,12 @@
|
|||||||
|
-------------------------------------------------------------------
|
||||||
|
Mon Nov 30 18:24:34 CET 2009 - max@suse.de
|
||||||
|
|
||||||
|
- New version: 3.6.20.
|
||||||
|
- Reworked package to use the "amalgamation" source distribution
|
||||||
|
as recommended by the author and to fix the following bugs:
|
||||||
|
* bnc#555845: sqlite3 should link libdl
|
||||||
|
* bnc#470371: system sqlite should be built with fts3
|
||||||
|
|
||||||
-------------------------------------------------------------------
|
-------------------------------------------------------------------
|
||||||
Thu Oct 22 21:39:13 UTC 2009 - andrea@opensuse.org
|
Thu Oct 22 21:39:13 UTC 2009 - andrea@opensuse.org
|
||||||
|
|
||||||
|
|||||||
63
sqlite3.spec
63
sqlite3.spec
@ -1,5 +1,5 @@
|
|||||||
#
|
#
|
||||||
# spec file for package sqlite3 (Version 3.6.16)
|
# spec file for package sqlite3 (Version 3.6.20)
|
||||||
#
|
#
|
||||||
# Copyright (c) 2009 SUSE LINUX Products GmbH, Nuernberg, Germany.
|
# Copyright (c) 2009 SUSE LINUX Products GmbH, Nuernberg, Germany.
|
||||||
#
|
#
|
||||||
@ -30,7 +30,7 @@
|
|||||||
%endif
|
%endif
|
||||||
|
|
||||||
Name: sqlite3
|
Name: sqlite3
|
||||||
BuildRequires: gcc-c++ readline-devel tcl-devel
|
BuildRequires: readline-devel tcl-devel
|
||||||
%if %{?suse_version:1}%{?!suse_version:0}
|
%if %{?suse_version:1}%{?!suse_version:0}
|
||||||
BuildRequires: update-desktop-files
|
BuildRequires: update-desktop-files
|
||||||
%endif
|
%endif
|
||||||
@ -38,8 +38,8 @@ License: Public Domain, Freeware
|
|||||||
Group: Productivity/Databases/Servers
|
Group: Productivity/Databases/Servers
|
||||||
Summary: Embeddable SQL Database Engine
|
Summary: Embeddable SQL Database Engine
|
||||||
Url: http://www.sqlite.org/
|
Url: http://www.sqlite.org/
|
||||||
Version: 3.6.16
|
Version: 3.6.20
|
||||||
Release: 2
|
Release: 1
|
||||||
# bug437293
|
# bug437293
|
||||||
%ifarch ppc64
|
%ifarch ppc64
|
||||||
Obsoletes: sqlite-64bit
|
Obsoletes: sqlite-64bit
|
||||||
@ -50,8 +50,10 @@ Requires: libsqlite3-0 = %version
|
|||||||
%endif
|
%endif
|
||||||
Provides: sqlite = %version
|
Provides: sqlite = %version
|
||||||
Obsoletes: sqlite < %version
|
Obsoletes: sqlite < %version
|
||||||
Source0: http://www.sqlite.org/sqlite-%version.tar.bz2
|
Source0: http://www.sqlite.org/sqlite-amalgamation-%version.tar.bz2
|
||||||
Source1: sqlite.desktop
|
Source1: sqlite-tcl.tar.bz2
|
||||||
|
Source2: sqlite3.1
|
||||||
|
Patch0: sqlite-tcl.patch
|
||||||
BuildRoot: %{_tmppath}/%{name}-%{version}-build
|
BuildRoot: %{_tmppath}/%{name}-%{version}-build
|
||||||
|
|
||||||
%description
|
%description
|
||||||
@ -150,44 +152,28 @@ Authors:
|
|||||||
D. Richard Hipp <drh@hwaci.com>
|
D. Richard Hipp <drh@hwaci.com>
|
||||||
|
|
||||||
%prep
|
%prep
|
||||||
%setup -q -n sqlite-%version
|
%setup -q -a 1 -q -n sqlite-%version
|
||||||
# does not work due to our ulimits in our build system
|
%patch0
|
||||||
rm test/bigfile.test
|
|
||||||
|
|
||||||
%build
|
%build
|
||||||
autoreconf -f -i
|
%configure --disable-static
|
||||||
export CFLAGS="$RPM_OPT_FLAGS -DNDEBUG=1 -O3 -DSQLITE_ENABLE_COLUMN_METADATA=1 -DSQLITE_SERVER=1"
|
make
|
||||||
export CXXFLAGS="$CFLAGS"
|
cd sqlite-tcl
|
||||||
mkdir build
|
autoconf
|
||||||
cd build
|
%configure --with-tcl=%_libdir
|
||||||
cp ../VERSION .
|
make
|
||||||
../configure \
|
|
||||||
--prefix=/usr \
|
|
||||||
--libdir=%_libdir \
|
|
||||||
--mandir=%_mandir \
|
|
||||||
--enable-threadsafe \
|
|
||||||
--enable-load-extension \
|
|
||||||
--disable-releasemode \
|
|
||||||
--enable-tempstore=yes \
|
|
||||||
--sysconfdir=/etc/ \
|
|
||||||
--disable-static \
|
|
||||||
--with-pic
|
|
||||||
make %{?jobs:-j%jobs} \
|
|
||||||
TCLLIBDIR=%tcl_archdir/%name
|
|
||||||
|
|
||||||
%install
|
%install
|
||||||
cd build
|
make install DESTDIR=%buildroot
|
||||||
make install \
|
rm %buildroot/%_libdir/*.la
|
||||||
DESTDIR="$RPM_BUILD_ROOT" \
|
install -d %buildroot%_mandir/man1/
|
||||||
TCLLIBDIR=%tcl_archdir/%name
|
install -m 0644 %{S:2} %buildroot%_mandir/man1/
|
||||||
echo 'package ifneeded sqlite3 %version [list load $dir/libtclsqlite3.so sqlite3]' \
|
cd sqlite-tcl
|
||||||
> %buildroot%tcl_archdir/%name/pkgIndex.tcl
|
make install DESTDIR=%buildroot libdir=%tcl_archdir
|
||||||
install -d $RPM_BUILD_ROOT%_mandir/man1/
|
cd ..
|
||||||
install -m 0644 ../sqlite3.1 $RPM_BUILD_ROOT%_mandir/man1/
|
|
||||||
rm -f %buildroot%_libdir/*.la
|
|
||||||
|
|
||||||
%clean
|
%clean
|
||||||
rm -rf $RPM_BUILD_ROOT
|
rm -rf %buildroot
|
||||||
#
|
#
|
||||||
%if %newscheme
|
%if %newscheme
|
||||||
|
|
||||||
@ -216,6 +202,7 @@ make %{?jobs:-j%jobs} \
|
|||||||
%files tcl
|
%files tcl
|
||||||
%defattr(-,root,root)
|
%defattr(-,root,root)
|
||||||
%tcl_archdir
|
%tcl_archdir
|
||||||
|
%doc %_mandir/mann/*
|
||||||
|
|
||||||
%files devel
|
%files devel
|
||||||
%defattr(-,root,root)
|
%defattr(-,root,root)
|
||||||
|
|||||||
Loading…
x
Reference in New Issue
Block a user