summaryrefslogtreecommitdiff
path: root/databases/sqlite3
diff options
context:
space:
mode:
authortnn <tnn>2010-10-25 07:44:32 +0000
committertnn <tnn>2010-10-25 07:44:32 +0000
commit81f3d67dce17001fc39787f4b81fccb8eced8e7f (patch)
treecc0493ea6afe50944ef287c936b4ce70d59ef07e /databases/sqlite3
parentf9bb4a905f872f4a8de562dd8c0d7bf8d59a3d06 (diff)
downloadpkgsrc-81f3d67dce17001fc39787f4b81fccb8eced8e7f.tar.gz
The amalgamation package now ships it's own manpage, so get rid
of our local copy. PR pkg/44000.
Diffstat (limited to 'databases/sqlite3')
-rw-r--r--databases/sqlite3/Makefile6
-rw-r--r--databases/sqlite3/distinfo3
-rw-r--r--databases/sqlite3/patches/patch-aa234
3 files changed, 2 insertions, 241 deletions
diff --git a/databases/sqlite3/Makefile b/databases/sqlite3/Makefile
index c21e5c7e4e7..5969bf66819 100644
--- a/databases/sqlite3/Makefile
+++ b/databases/sqlite3/Makefile
@@ -1,4 +1,4 @@
-# $NetBSD: Makefile,v 1.33 2010/10/18 07:08:22 adam Exp $
+# $NetBSD: Makefile,v 1.34 2010/10/25 07:44:32 tnn Exp $
DISTNAME= sqlite-amalgamation-3.7.3
PKGNAME= ${DISTNAME:S/sqlite-amalgamation/sqlite3/}
@@ -37,10 +37,6 @@ CFLAGS+= -DSQLITE_ENABLE_UNLOCK_NOTIFY=1
# See http://www.sqlite.org/cvstrac/tktview?tn=3555
LIBS+= ${BUILDLINK_LDADD.dl}
-post-install:
- ${INSTALL_MAN} ${WRKSRC}/sqlite3.1 \
- ${DESTDIR}${PREFIX}/${PKGMANDIR}/man1/sqlite3.1
-
.include "../../devel/readline/buildlink3.mk"
.include "../../mk/dlopen.buildlink3.mk"
.include "../../mk/bsd.pkg.mk"
diff --git a/databases/sqlite3/distinfo b/databases/sqlite3/distinfo
index ccae6ffefdd..a4ec46d1a67 100644
--- a/databases/sqlite3/distinfo
+++ b/databases/sqlite3/distinfo
@@ -1,6 +1,5 @@
-$NetBSD: distinfo,v 1.54 2010/10/18 07:08:22 adam Exp $
+$NetBSD: distinfo,v 1.55 2010/10/25 07:44:32 tnn Exp $
SHA1 (sqlite-amalgamation-3.7.3.tar.gz) = af3740819547f0dba52e096045525329f645c54f
RMD160 (sqlite-amalgamation-3.7.3.tar.gz) = 9a09db08c40226a09a700cb2b6cea79d04a0bab9
Size (sqlite-amalgamation-3.7.3.tar.gz) = 1512409 bytes
-SHA1 (patch-aa) = 033d23ac56e22fc3a4376ab3cedaed13e173d50f
diff --git a/databases/sqlite3/patches/patch-aa b/databases/sqlite3/patches/patch-aa
deleted file mode 100644
index aa1e87bb8eb..00000000000
--- a/databases/sqlite3/patches/patch-aa
+++ /dev/null
@@ -1,234 +0,0 @@
-$NetBSD: patch-aa,v 1.10 2009/11/21 16:58:05 tnn Exp $
-
---- sqlite3.1.orig 2009-11-21 16:56:42.000000000 +0100
-+++ sqlite3.1
-@@ -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>.