New port: databases/py-PySQLite

	The goal of the PySQLite project is to develop a Python
	extension for SQLite that conforms to the Python Database
	API Specification 2.0. SQLite is a powerful embedded
	relational database management system in a compact C library.
	It offers support for a large subset of SQL92, multiple
	tables, indices, transactions and triggers.

PR:		ports/43571
Submitted by:	Gerhard Häring <gerhard.haering@gmx.de>

49 files changed, 761 insertions, 0 deletions

diff --git a/databases/Makefile b/databases/Makefile
index fa1c21efd6ac..f11ed51e53df 100644
--- a/databases/Makefile
+++ b/databases/Makefile
@@ -138,6 +138,7 @@
     SUBDIR += py-MySQL
     SUBDIR += py-MySQLdb
     SUBDIR += py-PyGreSQL
+    SUBDIR += py-PySQLite
     SUBDIR += py-SQLDict
     SUBDIR += py-bsddb3
     SUBDIR += py-cdb
diff --git a/databases/py-PySQLite/Makefile b/databases/py-PySQLite/Makefile
new file mode 100644
index 000000000000..4dfef1b4d430
--- /dev/null
+++ b/databases/py-PySQLite/Makefile
@@ -0,0 +1,46 @@
+# New ports collection makefile for:   py-PySQLite
+# Date created:                        02 Oct 2002
+# Whom:                                Gerhard Haering <gerhard.haering@gmx.de>
+#
+# $FreeBSD$
+#
+
+PORTNAME=	PySQLite
+PORTVERSION=	0.3.0
+CATEGORIES=	databases python
+MASTER_SITES=	${MASTER_SITE_SOURCEFORGE}
+MASTER_SITE_SUBDIR=	pysqlite
+PKGNAMEPREFIX=	py-
+DISTNAME=	pysqlite-${PORTVERSION}
+
+MAINTAINER=	gerhard.haering@gmx.de
+
+RUN_DEPENDS=	${DATETIME_DEP}:${PORTSDIR}/lang/py-mx-base
+LIB_DEPENDS=	sqlite.2:${PORTSDIR}/databases/sqlite
+
+WRKSRC=		${WRKDIR}/pysqlite-${PORTVERSION}
+USE_PYTHON=	yes
+USE_REINPLACE=	yes
+USE_PYDISTUTILS=	yes
+
+DOCS=		README
+
+PLIST_SUB+=	PYTHON_SITELIBDIR=${PYTHON_SITELIBDIR:S/^${LOCALBASE}\///g}
+
+DATETIME_DEP=	${PYTHON_SITELIBDIR}/mx/DateTime/__init__.py
+
+DOCSDIR=	${PREFIX}/share/doc/${PKGNAMEPREFIX}${PORTNAME}
+
+post-patch:
+	${REINPLACE_CMD} -e 's^/usr/local/include/sqlite^${LOCALBASE}/include^g' ${WRKSRC}/setup.py
+	${REINPLACE_CMD} -e 's^/usr/local/lib^${LOCALBASE}/lib^g' ${WRKSRC}/setup.py
+
+.if !defined(NOPORTDOCS)
+post-install:
+	@${MKDIR} ${DOCSDIR}
+.for file in ${DOCS}
+	@${INSTALL_DATA} ${WRKSRC}/${file} ${DOCSDIR}
+.endfor
+.endif
+
+.include <bsd.port.mk>
diff --git a/databases/py-PySQLite/distinfo b/databases/py-PySQLite/distinfo
new file mode 100644
index 000000000000..e76dac890a85
--- /dev/null
+++ b/databases/py-PySQLite/distinfo
@@ -0,0 +1 @@
+MD5 (pysqlite-0.3.0.tar.gz) = c207d45ab958dabeba30162fca27a675
diff --git a/databases/py-PySQLite/files/patch-setup.py b/databases/py-PySQLite/files/patch-setup.py
new file mode 100644
index 000000000000..2e15106b95e9
--- /dev/null
+++ b/databases/py-PySQLite/files/patch-setup.py
@@ -0,0 +1,11 @@
+--- setup.py.orig	Wed Feb  5 16:17:16 2003
++++ setup.py	Wed Feb  5 16:17:26 2003
+@@ -14,7 +14,7 @@
+     libraries = [sqlite]
+     runtime_library_dirs = []
+     extra_objects = []
+-elif sys.platform in ("freebsd4", "openbsd2"): 
++elif sys.platform in ("freebsd4", "freebsd5", "openbsd2"): 
+     include_dirs = ['/usr/local/include/sqlite']
+     library_dirs = ['/usr/local/lib/']
+     libraries = [sqlite]
diff --git a/databases/py-PySQLite/pkg-comment b/databases/py-PySQLite/pkg-comment
new file mode 100644
index 000000000000..b3658d2496f8
--- /dev/null
+++ b/databases/py-PySQLite/pkg-comment
@@ -0,0 +1 @@
+A DB-API v2 Python library for the SQLite embedded SQL engine
diff --git a/databases/py-PySQLite/pkg-descr b/databases/py-PySQLite/pkg-descr
new file mode 100644
index 000000000000..b5df121b1e58
--- /dev/null
+++ b/databases/py-PySQLite/pkg-descr
@@ -0,0 +1,10 @@
+The goal of the PySQLite project is to develop a Python extension for SQLite
+that conforms to the Python Database API Specification 2.0. SQLite is a
+powerful embedded relational database management system in a compact C library.
+It offers support for a large subset of SQL92, multiple tables, indices,
+transactions and triggers.
+
+WWW: http://pysqlite.sourceforge.net/
+developed by Gerhard Haering and Michael Owens
+
+- Gerhard Haering <gerhard.haering@gmx.de>
diff --git a/databases/py-PySQLite/pkg-plist b/databases/py-PySQLite/pkg-plist
new file mode 100644
index 000000000000..05dad03d30ca
--- /dev/null
+++ b/databases/py-PySQLite/pkg-plist
@@ -0,0 +1,26 @@
+%%PYTHON_SITELIBDIR%%/pysqlite_exceptions.py
+%%PYTHON_SITELIBDIR%%/pysqlite_exceptions.pyc
+%%PYTHON_SITELIBDIR%%/pysqlite_exceptions.pyo
+%%PYTHON_SITELIBDIR%%/sqlite/__init__.py
+%%PYTHON_SITELIBDIR%%/sqlite/__init__.pyc
+%%PYTHON_SITELIBDIR%%/sqlite/__init__.pyo
+%%PYTHON_SITELIBDIR%%/sqlite/main.py
+%%PYTHON_SITELIBDIR%%/sqlite/main.pyc
+%%PYTHON_SITELIBDIR%%/sqlite/main.pyo
+%%PYTHON_SITELIBDIR%%/sqlite/threadutils.py
+%%PYTHON_SITELIBDIR%%/sqlite/threadutils.pyc
+%%PYTHON_SITELIBDIR%%/sqlite/threadutils.pyo
+%%PYTHON_SITELIBDIR%%/sqlite/constants/__init__.py
+%%PYTHON_SITELIBDIR%%/sqlite/constants/__init__.pyc
+%%PYTHON_SITELIBDIR%%/sqlite/constants/__init__.pyo
+%%PYTHON_SITELIBDIR%%/sqlite/constants/FIELD_TYPE.py
+%%PYTHON_SITELIBDIR%%/sqlite/constants/FIELD_TYPE.pyc
+%%PYTHON_SITELIBDIR%%/sqlite/constants/FIELD_TYPE.pyo
+%%PYTHON_SITELIBDIR%%/sqlite/py22features.py
+%%PYTHON_SITELIBDIR%%/sqlite/py22features.pyc
+%%PYTHON_SITELIBDIR%%/sqlite/py22features.pyo
+%%PYTHON_SITELIBDIR%%/_sqlite.so
+@dirrm %%PYTHON_SITELIBDIR%%/sqlite/constants
+@dirrm %%PYTHON_SITELIBDIR%%/sqlite
+%%PORTDOCS%%share/doc/py-PySQLite/README
+%%PORTDOCS%%@dirrm share/doc/py-PySQLite
diff --git a/databases/py-PySQLite10/Makefile b/databases/py-PySQLite10/Makefile
new file mode 100644
index 000000000000..4dfef1b4d430
--- /dev/null
+++ b/databases/py-PySQLite10/Makefile
@@ -0,0 +1,46 @@
+# New ports collection makefile for:   py-PySQLite
+# Date created:                        02 Oct 2002
+# Whom:                                Gerhard Haering <gerhard.haering@gmx.de>
+#
+# $FreeBSD$
+#
+
+PORTNAME=	PySQLite
+PORTVERSION=	0.3.0
+CATEGORIES=	databases python
+MASTER_SITES=	${MASTER_SITE_SOURCEFORGE}
+MASTER_SITE_SUBDIR=	pysqlite
+PKGNAMEPREFIX=	py-
+DISTNAME=	pysqlite-${PORTVERSION}
+
+MAINTAINER=	gerhard.haering@gmx.de
+
+RUN_DEPENDS=	${DATETIME_DEP}:${PORTSDIR}/lang/py-mx-base
+LIB_DEPENDS=	sqlite.2:${PORTSDIR}/databases/sqlite
+
+WRKSRC=		${WRKDIR}/pysqlite-${PORTVERSION}
+USE_PYTHON=	yes
+USE_REINPLACE=	yes
+USE_PYDISTUTILS=	yes
+
+DOCS=		README
+
+PLIST_SUB+=	PYTHON_SITELIBDIR=${PYTHON_SITELIBDIR:S/^${LOCALBASE}\///g}
+
+DATETIME_DEP=	${PYTHON_SITELIBDIR}/mx/DateTime/__init__.py
+
+DOCSDIR=	${PREFIX}/share/doc/${PKGNAMEPREFIX}${PORTNAME}
+
+post-patch:
+	${REINPLACE_CMD} -e 's^/usr/local/include/sqlite^${LOCALBASE}/include^g' ${WRKSRC}/setup.py
+	${REINPLACE_CMD} -e 's^/usr/local/lib^${LOCALBASE}/lib^g' ${WRKSRC}/setup.py
+
+.if !defined(NOPORTDOCS)
+post-install:
+	@${MKDIR} ${DOCSDIR}
+.for file in ${DOCS}
+	@${INSTALL_DATA} ${WRKSRC}/${file} ${DOCSDIR}
+.endfor
+.endif
+
+.include <bsd.port.mk>
diff --git a/databases/py-PySQLite10/distinfo b/databases/py-PySQLite10/distinfo
new file mode 100644
index 000000000000..e76dac890a85
--- /dev/null
+++ b/databases/py-PySQLite10/distinfo
@@ -0,0 +1 @@
+MD5 (pysqlite-0.3.0.tar.gz) = c207d45ab958dabeba30162fca27a675
diff --git a/databases/py-PySQLite10/files/patch-setup.py b/databases/py-PySQLite10/files/patch-setup.py
new file mode 100644
index 000000000000..2e15106b95e9
--- /dev/null
+++ b/databases/py-PySQLite10/files/patch-setup.py
@@ -0,0 +1,11 @@
+--- setup.py.orig	Wed Feb  5 16:17:16 2003
++++ setup.py	Wed Feb  5 16:17:26 2003
+@@ -14,7 +14,7 @@
+     libraries = [sqlite]
+     runtime_library_dirs = []
+     extra_objects = []
+-elif sys.platform in ("freebsd4", "openbsd2"): 
++elif sys.platform in ("freebsd4", "freebsd5", "openbsd2"): 
+     include_dirs = ['/usr/local/include/sqlite']
+     library_dirs = ['/usr/local/lib/']
+     libraries = [sqlite]
diff --git a/databases/py-PySQLite10/pkg-comment b/databases/py-PySQLite10/pkg-comment
new file mode 100644
index 000000000000..b3658d2496f8
--- /dev/null
+++ b/databases/py-PySQLite10/pkg-comment
@@ -0,0 +1 @@
+A DB-API v2 Python library for the SQLite embedded SQL engine
diff --git a/databases/py-PySQLite10/pkg-descr b/databases/py-PySQLite10/pkg-descr
new file mode 100644
index 000000000000..b5df121b1e58
--- /dev/null
+++ b/databases/py-PySQLite10/pkg-descr
@@ -0,0 +1,10 @@
+The goal of the PySQLite project is to develop a Python extension for SQLite
+that conforms to the Python Database API Specification 2.0. SQLite is a
+powerful embedded relational database management system in a compact C library.
+It offers support for a large subset of SQL92, multiple tables, indices,
+transactions and triggers.
+
+WWW: http://pysqlite.sourceforge.net/
+developed by Gerhard Haering and Michael Owens
+
+- Gerhard Haering <gerhard.haering@gmx.de>
diff --git a/databases/py-PySQLite10/pkg-plist b/databases/py-PySQLite10/pkg-plist
new file mode 100644
index 000000000000..05dad03d30ca
--- /dev/null
+++ b/databases/py-PySQLite10/pkg-plist
@@ -0,0 +1,26 @@
+%%PYTHON_SITELIBDIR%%/pysqlite_exceptions.py
+%%PYTHON_SITELIBDIR%%/pysqlite_exceptions.pyc
+%%PYTHON_SITELIBDIR%%/pysqlite_exceptions.pyo
+%%PYTHON_SITELIBDIR%%/sqlite/__init__.py
+%%PYTHON_SITELIBDIR%%/sqlite/__init__.pyc
+%%PYTHON_SITELIBDIR%%/sqlite/__init__.pyo
+%%PYTHON_SITELIBDIR%%/sqlite/main.py
+%%PYTHON_SITELIBDIR%%/sqlite/main.pyc
+%%PYTHON_SITELIBDIR%%/sqlite/main.pyo
+%%PYTHON_SITELIBDIR%%/sqlite/threadutils.py
+%%PYTHON_SITELIBDIR%%/sqlite/threadutils.pyc
+%%PYTHON_SITELIBDIR%%/sqlite/threadutils.pyo
+%%PYTHON_SITELIBDIR%%/sqlite/constants/__init__.py
+%%PYTHON_SITELIBDIR%%/sqlite/constants/__init__.pyc
+%%PYTHON_SITELIBDIR%%/sqlite/constants/__init__.pyo
+%%PYTHON_SITELIBDIR%%/sqlite/constants/FIELD_TYPE.py
+%%PYTHON_SITELIBDIR%%/sqlite/constants/FIELD_TYPE.pyc
+%%PYTHON_SITELIBDIR%%/sqlite/constants/FIELD_TYPE.pyo
+%%PYTHON_SITELIBDIR%%/sqlite/py22features.py
+%%PYTHON_SITELIBDIR%%/sqlite/py22features.pyc
+%%PYTHON_SITELIBDIR%%/sqlite/py22features.pyo
+%%PYTHON_SITELIBDIR%%/_sqlite.so
+@dirrm %%PYTHON_SITELIBDIR%%/sqlite/constants
+@dirrm %%PYTHON_SITELIBDIR%%/sqlite
+%%PORTDOCS%%share/doc/py-PySQLite/README
+%%PORTDOCS%%@dirrm share/doc/py-PySQLite
diff --git a/databases/py-PySQLite11/Makefile b/databases/py-PySQLite11/Makefile
new file mode 100644
index 000000000000..4dfef1b4d430
--- /dev/null
+++ b/databases/py-PySQLite11/Makefile
@@ -0,0 +1,46 @@
+# New ports collection makefile for:   py-PySQLite
+# Date created:                        02 Oct 2002
+# Whom:                                Gerhard Haering <gerhard.haering@gmx.de>
+#
+# $FreeBSD$
+#
+
+PORTNAME=	PySQLite
+PORTVERSION=	0.3.0
+CATEGORIES=	databases python
+MASTER_SITES=	${MASTER_SITE_SOURCEFORGE}
+MASTER_SITE_SUBDIR=	pysqlite
+PKGNAMEPREFIX=	py-
+DISTNAME=	pysqlite-${PORTVERSION}
+
+MAINTAINER=	gerhard.haering@gmx.de
+
+RUN_DEPENDS=	${DATETIME_DEP}:${PORTSDIR}/lang/py-mx-base
+LIB_DEPENDS=	sqlite.2:${PORTSDIR}/databases/sqlite
+
+WRKSRC=		${WRKDIR}/pysqlite-${PORTVERSION}
+USE_PYTHON=	yes
+USE_REINPLACE=	yes
+USE_PYDISTUTILS=	yes
+
+DOCS=		README
+
+PLIST_SUB+=	PYTHON_SITELIBDIR=${PYTHON_SITELIBDIR:S/^${LOCALBASE}\///g}
+
+DATETIME_DEP=	${PYTHON_SITELIBDIR}/mx/DateTime/__init__.py
+
+DOCSDIR=	${PREFIX}/share/doc/${PKGNAMEPREFIX}${PORTNAME}
+
+post-patch:
+	${REINPLACE_CMD} -e 's^/usr/local/include/sqlite^${LOCALBASE}/include^g' ${WRKSRC}/setup.py
+	${REINPLACE_CMD} -e 's^/usr/local/lib^${LOCALBASE}/lib^g' ${WRKSRC}/setup.py
+
+.if !defined(NOPORTDOCS)
+post-install:
+	@${MKDIR} ${DOCSDIR}
+.for file in ${DOCS}
+	@${INSTALL_DATA} ${WRKSRC}/${file} ${DOCSDIR}
+.endfor
+.endif
+
+.include <bsd.port.mk>
diff --git a/databases/py-PySQLite11/distinfo b/databases/py-PySQLite11/distinfo
new file mode 100644
index 000000000000..e76dac890a85
--- /dev/null
+++ b/databases/py-PySQLite11/distinfo
@@ -0,0 +1 @@
+MD5 (pysqlite-0.3.0.tar.gz) = c207d45ab958dabeba30162fca27a675
diff --git a/databases/py-PySQLite11/files/patch-setup.py b/databases/py-PySQLite11/files/patch-setup.py
new file mode 100644
index 000000000000..2e15106b95e9
--- /dev/null
+++ b/databases/py-PySQLite11/files/patch-setup.py
@@ -0,0 +1,11 @@
+--- setup.py.orig	Wed Feb  5 16:17:16 2003
++++ setup.py	Wed Feb  5 16:17:26 2003
+@@ -14,7 +14,7 @@
+     libraries = [sqlite]
+     runtime_library_dirs = []
+     extra_objects = []
+-elif sys.platform in ("freebsd4", "openbsd2"): 
++elif sys.platform in ("freebsd4", "freebsd5", "openbsd2"): 
+     include_dirs = ['/usr/local/include/sqlite']
+     library_dirs = ['/usr/local/lib/']
+     libraries = [sqlite]
diff --git a/databases/py-PySQLite11/pkg-comment b/databases/py-PySQLite11/pkg-comment
new file mode 100644
index 000000000000..b3658d2496f8
--- /dev/null
+++ b/databases/py-PySQLite11/pkg-comment
@@ -0,0 +1 @@
+A DB-API v2 Python library for the SQLite embedded SQL engine
diff --git a/databases/py-PySQLite11/pkg-descr b/databases/py-PySQLite11/pkg-descr
new file mode 100644
index 000000000000..b5df121b1e58
--- /dev/null
+++ b/databases/py-PySQLite11/pkg-descr
@@ -0,0 +1,10 @@
+The goal of the PySQLite project is to develop a Python extension for SQLite
+that conforms to the Python Database API Specification 2.0. SQLite is a
+powerful embedded relational database management system in a compact C library.
+It offers support for a large subset of SQL92, multiple tables, indices,
+transactions and triggers.
+
+WWW: http://pysqlite.sourceforge.net/
+developed by Gerhard Haering and Michael Owens
+
+- Gerhard Haering <gerhard.haering@gmx.de>
diff --git a/databases/py-PySQLite11/pkg-plist b/databases/py-PySQLite11/pkg-plist
new file mode 100644
index 000000000000..05dad03d30ca
--- /dev/null
+++ b/databases/py-PySQLite11/pkg-plist
@@ -0,0 +1,26 @@
+%%PYTHON_SITELIBDIR%%/pysqlite_exceptions.py
+%%PYTHON_SITELIBDIR%%/pysqlite_exceptions.pyc
+%%PYTHON_SITELIBDIR%%/pysqlite_exceptions.pyo
+%%PYTHON_SITELIBDIR%%/sqlite/__init__.py
+%%PYTHON_SITELIBDIR%%/sqlite/__init__.pyc
+%%PYTHON_SITELIBDIR%%/sqlite/__init__.pyo
+%%PYTHON_SITELIBDIR%%/sqlite/main.py
+%%PYTHON_SITELIBDIR%%/sqlite/main.pyc
+%%PYTHON_SITELIBDIR%%/sqlite/main.pyo
+%%PYTHON_SITELIBDIR%%/sqlite/threadutils.py
+%%PYTHON_SITELIBDIR%%/sqlite/threadutils.pyc
+%%PYTHON_SITELIBDIR%%/sqlite/threadutils.pyo
+%%PYTHON_SITELIBDIR%%/sqlite/constants/__init__.py
+%%PYTHON_SITELIBDIR%%/sqlite/constants/__init__.pyc
+%%PYTHON_SITELIBDIR%%/sqlite/constants/__init__.pyo
+%%PYTHON_SITELIBDIR%%/sqlite/constants/FIELD_TYPE.py
+%%PYTHON_SITELIBDIR%%/sqlite/constants/FIELD_TYPE.pyc
+%%PYTHON_SITELIBDIR%%/sqlite/constants/FIELD_TYPE.pyo
+%%PYTHON_SITELIBDIR%%/sqlite/py22features.py
+%%PYTHON_SITELIBDIR%%/sqlite/py22features.pyc
+%%PYTHON_SITELIBDIR%%/sqlite/py22features.pyo
+%%PYTHON_SITELIBDIR%%/_sqlite.so
+@dirrm %%PYTHON_SITELIBDIR%%/sqlite/constants
+@dirrm %%PYTHON_SITELIBDIR%%/sqlite
+%%PORTDOCS%%share/doc/py-PySQLite/README
+%%PORTDOCS%%@dirrm share/doc/py-PySQLite
diff --git a/databases/py-PySQLite2/Makefile b/databases/py-PySQLite2/Makefile
new file mode 100644
index 000000000000..4dfef1b4d430
--- /dev/null
+++ b/databases/py-PySQLite2/Makefile
@@ -0,0 +1,46 @@
+# New ports collection makefile for:   py-PySQLite
+# Date created:                        02 Oct 2002
+# Whom:                                Gerhard Haering <gerhard.haering@gmx.de>
+#
+# $FreeBSD$
+#
+
+PORTNAME=	PySQLite
+PORTVERSION=	0.3.0
+CATEGORIES=	databases python
+MASTER_SITES=	${MASTER_SITE_SOURCEFORGE}
+MASTER_SITE_SUBDIR=	pysqlite
+PKGNAMEPREFIX=	py-
+DISTNAME=	pysqlite-${PORTVERSION}
+
+MAINTAINER=	gerhard.haering@gmx.de
+
+RUN_DEPENDS=	${DATETIME_DEP}:${PORTSDIR}/lang/py-mx-base
+LIB_DEPENDS=	sqlite.2:${PORTSDIR}/databases/sqlite
+
+WRKSRC=		${WRKDIR}/pysqlite-${PORTVERSION}
+USE_PYTHON=	yes
+USE_REINPLACE=	yes
+USE_PYDISTUTILS=	yes
+
+DOCS=		README
+
+PLIST_SUB+=	PYTHON_SITELIBDIR=${PYTHON_SITELIBDIR:S/^${LOCALBASE}\///g}
+
+DATETIME_DEP=	${PYTHON_SITELIBDIR}/mx/DateTime/__init__.py
+
+DOCSDIR=	${PREFIX}/share/doc/${PKGNAMEPREFIX}${PORTNAME}
+
+post-patch:
+	${REINPLACE_CMD} -e 's^/usr/local/include/sqlite^${LOCALBASE}/include^g' ${WRKSRC}/setup.py
+	${REINPLACE_CMD} -e 's^/usr/local/lib^${LOCALBASE}/lib^g' ${WRKSRC}/setup.py
+
+.if !defined(NOPORTDOCS)
+post-install:
+	@${MKDIR} ${DOCSDIR}
+.for file in ${DOCS}
+	@${INSTALL_DATA} ${WRKSRC}/${file} ${DOCSDIR}
+.endfor
+.endif
+
+.include <bsd.port.mk>
diff --git a/databases/py-PySQLite2/distinfo b/databases/py-PySQLite2/distinfo
new file mode 100644
index 000000000000..e76dac890a85
--- /dev/null
+++ b/databases/py-PySQLite2/distinfo
@@ -0,0 +1 @@
+MD5 (pysqlite-0.3.0.tar.gz) = c207d45ab958dabeba30162fca27a675
diff --git a/databases/py-PySQLite2/files/patch-setup.py b/databases/py-PySQLite2/files/patch-setup.py
new file mode 100644
index 000000000000..2e15106b95e9
--- /dev/null
+++ b/databases/py-PySQLite2/files/patch-setup.py
@@ -0,0 +1,11 @@
+--- setup.py.orig	Wed Feb  5 16:17:16 2003
++++ setup.py	Wed Feb  5 16:17:26 2003
+@@ -14,7 +14,7 @@
+     libraries = [sqlite]
+     runtime_library_dirs = []
+     extra_objects = []
+-elif sys.platform in ("freebsd4", "openbsd2"): 
++elif sys.platform in ("freebsd4", "freebsd5", "openbsd2"): 
+     include_dirs = ['/usr/local/include/sqlite']
+     library_dirs = ['/usr/local/lib/']
+     libraries = [sqlite]
diff --git a/databases/py-PySQLite2/pkg-comment b/databases/py-PySQLite2/pkg-comment
new file mode 100644
index 000000000000..b3658d2496f8
--- /dev/null
+++ b/databases/py-PySQLite2/pkg-comment
@@ -0,0 +1 @@
+A DB-API v2 Python library for the SQLite embedded SQL engine
diff --git a/databases/py-PySQLite2/pkg-descr b/databases/py-PySQLite2/pkg-descr
new file mode 100644
index 000000000000..b5df121b1e58
--- /dev/null
+++ b/databases/py-PySQLite2/pkg-descr
@@ -0,0 +1,10 @@
+The goal of the PySQLite project is to develop a Python extension for SQLite
+that conforms to the Python Database API Specification 2.0. SQLite is a
+powerful embedded relational database management system in a compact C library.
+It offers support for a large subset of SQL92, multiple tables, indices,
+transactions and triggers.
+
+WWW: http://pysqlite.sourceforge.net/
+developed by Gerhard Haering and Michael Owens
+
+- Gerhard Haering <gerhard.haering@gmx.de>
diff --git a/databases/py-PySQLite2/pkg-plist b/databases/py-PySQLite2/pkg-plist
new file mode 100644
index 000000000000..05dad03d30ca
--- /dev/null
+++ b/databases/py-PySQLite2/pkg-plist
@@ -0,0 +1,26 @@
+%%PYTHON_SITELIBDIR%%/pysqlite_exceptions.py
+%%PYTHON_SITELIBDIR%%/pysqlite_exceptions.pyc
+%%PYTHON_SITELIBDIR%%/pysqlite_exceptions.pyo
+%%PYTHON_SITELIBDIR%%/sqlite/__init__.py
+%%PYTHON_SITELIBDIR%%/sqlite/__init__.pyc
+%%PYTHON_SITELIBDIR%%/sqlite/__init__.pyo
+%%PYTHON_SITELIBDIR%%/sqlite/main.py
+%%PYTHON_SITELIBDIR%%/sqlite/main.pyc
+%%PYTHON_SITELIBDIR%%/sqlite/main.pyo
+%%PYTHON_SITELIBDIR%%/sqlite/threadutils.py
+%%PYTHON_SITELIBDIR%%/sqlite/threadutils.pyc
+%%PYTHON_SITELIBDIR%%/sqlite/threadutils.pyo
+%%PYTHON_SITELIBDIR%%/sqlite/constants/__init__.py
+%%PYTHON_SITELIBDIR%%/sqlite/constants/__init__.pyc
+%%PYTHON_SITELIBDIR%%/sqlite/constants/__init__.pyo
+%%PYTHON_SITELIBDIR%%/sqlite/constants/FIELD_TYPE.py
+%%PYTHON_SITELIBDIR%%/sqlite/constants/FIELD_TYPE.pyc
+%%PYTHON_SITELIBDIR%%/sqlite/constants/FIELD_TYPE.pyo
+%%PYTHON_SITELIBDIR%%/sqlite/py22features.py
+%%PYTHON_SITELIBDIR%%/sqlite/py22features.pyc
+%%PYTHON_SITELIBDIR%%/sqlite/py22features.pyo
+%%PYTHON_SITELIBDIR%%/_sqlite.so
+@dirrm %%PYTHON_SITELIBDIR%%/sqlite/constants
+@dirrm %%PYTHON_SITELIBDIR%%/sqlite
+%%PORTDOCS%%share/doc/py-PySQLite/README
+%%PORTDOCS%%@dirrm share/doc/py-PySQLite
diff --git a/databases/py-pysqlite20/Makefile b/databases/py-pysqlite20/Makefile
new file mode 100644
index 000000000000..4dfef1b4d430
--- /dev/null
+++ b/databases/py-pysqlite20/Makefile
@@ -0,0 +1,46 @@
+# New ports collection makefile for:   py-PySQLite
+# Date created:                        02 Oct 2002
+# Whom:                                Gerhard Haering <gerhard.haering@gmx.de>
+#
+# $FreeBSD$
+#
+
+PORTNAME=	PySQLite
+PORTVERSION=	0.3.0
+CATEGORIES=	databases python
+MASTER_SITES=	${MASTER_SITE_SOURCEFORGE}
+MASTER_SITE_SUBDIR=	pysqlite
+PKGNAMEPREFIX=	py-
+DISTNAME=	pysqlite-${PORTVERSION}
+
+MAINTAINER=	gerhard.haering@gmx.de
+
+RUN_DEPENDS=	${DATETIME_DEP}:${PORTSDIR}/lang/py-mx-base
+LIB_DEPENDS=	sqlite.2:${PORTSDIR}/databases/sqlite
+
+WRKSRC=		${WRKDIR}/pysqlite-${PORTVERSION}
+USE_PYTHON=	yes
+USE_REINPLACE=	yes
+USE_PYDISTUTILS=	yes
+
+DOCS=		README
+
+PLIST_SUB+=	PYTHON_SITELIBDIR=${PYTHON_SITELIBDIR:S/^${LOCALBASE}\///g}
+
+DATETIME_DEP=	${PYTHON_SITELIBDIR}/mx/DateTime/__init__.py
+
+DOCSDIR=	${PREFIX}/share/doc/${PKGNAMEPREFIX}${PORTNAME}
+
+post-patch:
+	${REINPLACE_CMD} -e 's^/usr/local/include/sqlite^${LOCALBASE}/include^g' ${WRKSRC}/setup.py
+	${REINPLACE_CMD} -e 's^/usr/local/lib^${LOCALBASE}/lib^g' ${WRKSRC}/setup.py
+
+.if !defined(NOPORTDOCS)
+post-install:
+	@${MKDIR} ${DOCSDIR}
+.for file in ${DOCS}
+	@${INSTALL_DATA} ${WRKSRC}/${file} ${DOCSDIR}
+.endfor
+.endif
+
+.include <bsd.port.mk>
diff --git a/databases/py-pysqlite20/distinfo b/databases/py-pysqlite20/distinfo
new file mode 100644
index 000000000000..e76dac890a85
--- /dev/null
+++ b/databases/py-pysqlite20/distinfo
@@ -0,0 +1 @@
+MD5 (pysqlite-0.3.0.tar.gz) = c207d45ab958dabeba30162fca27a675
diff --git a/databases/py-pysqlite20/files/patch-setup.py b/databases/py-pysqlite20/files/patch-setup.py
new file mode 100644
index 000000000000..2e15106b95e9
--- /dev/null
+++ b/databases/py-pysqlite20/files/patch-setup.py
@@ -0,0 +1,11 @@
+--- setup.py.orig	Wed Feb  5 16:17:16 2003
++++ setup.py	Wed Feb  5 16:17:26 2003
+@@ -14,7 +14,7 @@
+     libraries = [sqlite]
+     runtime_library_dirs = []
+     extra_objects = []
+-elif sys.platform in ("freebsd4", "openbsd2"): 
++elif sys.platform in ("freebsd4", "freebsd5", "openbsd2"): 
+     include_dirs = ['/usr/local/include/sqlite']
+     library_dirs = ['/usr/local/lib/']
+     libraries = [sqlite]
diff --git a/databases/py-pysqlite20/pkg-comment b/databases/py-pysqlite20/pkg-comment
new file mode 100644
index 000000000000..b3658d2496f8
--- /dev/null
+++ b/databases/py-pysqlite20/pkg-comment
@@ -0,0 +1 @@
+A DB-API v2 Python library for the SQLite embedded SQL engine
diff --git a/databases/py-pysqlite20/pkg-descr b/databases/py-pysqlite20/pkg-descr
new file mode 100644
index 000000000000..b5df121b1e58
--- /dev/null
+++ b/databases/py-pysqlite20/pkg-descr
@@ -0,0 +1,10 @@
+The goal of the PySQLite project is to develop a Python extension for SQLite
+that conforms to the Python Database API Specification 2.0. SQLite is a
+powerful embedded relational database management system in a compact C library.
+It offers support for a large subset of SQL92, multiple tables, indices,
+transactions and triggers.
+
+WWW: http://pysqlite.sourceforge.net/
+developed by Gerhard Haering and Michael Owens
+
+- Gerhard Haering <gerhard.haering@gmx.de>
diff --git a/databases/py-pysqlite20/pkg-plist b/databases/py-pysqlite20/pkg-plist
new file mode 100644
index 000000000000..05dad03d30ca
--- /dev/null
+++ b/databases/py-pysqlite20/pkg-plist
@@ -0,0 +1,26 @@
+%%PYTHON_SITELIBDIR%%/pysqlite_exceptions.py
+%%PYTHON_SITELIBDIR%%/pysqlite_exceptions.pyc
+%%PYTHON_SITELIBDIR%%/pysqlite_exceptions.pyo
+%%PYTHON_SITELIBDIR%%/sqlite/__init__.py
+%%PYTHON_SITELIBDIR%%/sqlite/__init__.pyc
+%%PYTHON_SITELIBDIR%%/sqlite/__init__.pyo
+%%PYTHON_SITELIBDIR%%/sqlite/main.py
+%%PYTHON_SITELIBDIR%%/sqlite/main.pyc
+%%PYTHON_SITELIBDIR%%/sqlite/main.pyo
+%%PYTHON_SITELIBDIR%%/sqlite/threadutils.py
+%%PYTHON_SITELIBDIR%%/sqlite/threadutils.pyc
+%%PYTHON_SITELIBDIR%%/sqlite/threadutils.pyo
+%%PYTHON_SITELIBDIR%%/sqlite/constants/__init__.py
+%%PYTHON_SITELIBDIR%%/sqlite/constants/__init__.pyc
+%%PYTHON_SITELIBDIR%%/sqlite/constants/__init__.pyo
+%%PYTHON_SITELIBDIR%%/sqlite/constants/FIELD_TYPE.py
+%%PYTHON_SITELIBDIR%%/sqlite/constants/FIELD_TYPE.pyc
+%%PYTHON_SITELIBDIR%%/sqlite/constants/FIELD_TYPE.pyo
+%%PYTHON_SITELIBDIR%%/sqlite/py22features.py
+%%PYTHON_SITELIBDIR%%/sqlite/py22features.pyc
+%%PYTHON_SITELIBDIR%%/sqlite/py22features.pyo
+%%PYTHON_SITELIBDIR%%/_sqlite.so
+@dirrm %%PYTHON_SITELIBDIR%%/sqlite/constants
+@dirrm %%PYTHON_SITELIBDIR%%/sqlite
+%%PORTDOCS%%share/doc/py-PySQLite/README
+%%PORTDOCS%%@dirrm share/doc/py-PySQLite
diff --git a/databases/py-pysqlite21/Makefile b/databases/py-pysqlite21/Makefile
new file mode 100644
index 000000000000..4dfef1b4d430
--- /dev/null
+++ b/databases/py-pysqlite21/Makefile
@@ -0,0 +1,46 @@
+# New ports collection makefile for:   py-PySQLite
+# Date created:                        02 Oct 2002
+# Whom:                                Gerhard Haering <gerhard.haering@gmx.de>
+#
+# $FreeBSD$
+#
+
+PORTNAME=	PySQLite
+PORTVERSION=	0.3.0
+CATEGORIES=	databases python
+MASTER_SITES=	${MASTER_SITE_SOURCEFORGE}
+MASTER_SITE_SUBDIR=	pysqlite
+PKGNAMEPREFIX=	py-
+DISTNAME=	pysqlite-${PORTVERSION}
+
+MAINTAINER=	gerhard.haering@gmx.de
+
+RUN_DEPENDS=	${DATETIME_DEP}:${PORTSDIR}/lang/py-mx-base
+LIB_DEPENDS=	sqlite.2:${PORTSDIR}/databases/sqlite
+
+WRKSRC=		${WRKDIR}/pysqlite-${PORTVERSION}
+USE_PYTHON=	yes
+USE_REINPLACE=	yes
+USE_PYDISTUTILS=	yes
+
+DOCS=		README
+
+PLIST_SUB+=	PYTHON_SITELIBDIR=${PYTHON_SITELIBDIR:S/^${LOCALBASE}\///g}
+
+DATETIME_DEP=	${PYTHON_SITELIBDIR}/mx/DateTime/__init__.py
+
+DOCSDIR=	${PREFIX}/share/doc/${PKGNAMEPREFIX}${PORTNAME}
+
+post-patch:
+	${REINPLACE_CMD} -e 's^/usr/local/include/sqlite^${LOCALBASE}/include^g' ${WRKSRC}/setup.py
+	${REINPLACE_CMD} -e 's^/usr/local/lib^${LOCALBASE}/lib^g' ${WRKSRC}/setup.py
+
+.if !defined(NOPORTDOCS)
+post-install:
+	@${MKDIR} ${DOCSDIR}
+.for file in ${DOCS}
+	@${INSTALL_DATA} ${WRKSRC}/${file} ${DOCSDIR}
+.endfor
+.endif
+
+.include <bsd.port.mk>
diff --git a/databases/py-pysqlite21/distinfo b/databases/py-pysqlite21/distinfo
new file mode 100644
index 000000000000..e76dac890a85
--- /dev/null
+++ b/databases/py-pysqlite21/distinfo
@@ -0,0 +1 @@
+MD5 (pysqlite-0.3.0.tar.gz) = c207d45ab958dabeba30162fca27a675
diff --git a/databases/py-pysqlite21/files/patch-setup.py b/databases/py-pysqlite21/files/patch-setup.py
new file mode 100644
index 000000000000..2e15106b95e9
--- /dev/null
+++ b/databases/py-pysqlite21/files/patch-setup.py
@@ -0,0 +1,11 @@
+--- setup.py.orig	Wed Feb  5 16:17:16 2003
++++ setup.py	Wed Feb  5 16:17:26 2003
+@@ -14,7 +14,7 @@
+     libraries = [sqlite]
+     runtime_library_dirs = []
+     extra_objects = []
+-elif sys.platform in ("freebsd4", "openbsd2"): 
++elif sys.platform in ("freebsd4", "freebsd5", "openbsd2"): 
+     include_dirs = ['/usr/local/include/sqlite']
+     library_dirs = ['/usr/local/lib/']
+     libraries = [sqlite]
diff --git a/databases/py-pysqlite21/pkg-comment b/databases/py-pysqlite21/pkg-comment
new file mode 100644
index 000000000000..b3658d2496f8
--- /dev/null
+++ b/databases/py-pysqlite21/pkg-comment
@@ -0,0 +1 @@
+A DB-API v2 Python library for the SQLite embedded SQL engine
diff --git a/databases/py-pysqlite21/pkg-descr b/databases/py-pysqlite21/pkg-descr
new file mode 100644
index 000000000000..b5df121b1e58
--- /dev/null
+++ b/databases/py-pysqlite21/pkg-descr
@@ -0,0 +1,10 @@
+The goal of the PySQLite project is to develop a Python extension for SQLite
+that conforms to the Python Database API Specification 2.0. SQLite is a
+powerful embedded relational database management system in a compact C library.
+It offers support for a large subset of SQL92, multiple tables, indices,
+transactions and triggers.
+
+WWW: http://pysqlite.sourceforge.net/
+developed by Gerhard Haering and Michael Owens
+
+- Gerhard Haering <gerhard.haering@gmx.de>
diff --git a/databases/py-pysqlite21/pkg-plist b/databases/py-pysqlite21/pkg-plist
new file mode 100644
index 000000000000..05dad03d30ca
--- /dev/null
+++ b/databases/py-pysqlite21/pkg-plist
@@ -0,0 +1,26 @@
+%%PYTHON_SITELIBDIR%%/pysqlite_exceptions.py
+%%PYTHON_SITELIBDIR%%/pysqlite_exceptions.pyc
+%%PYTHON_SITELIBDIR%%/pysqlite_exceptions.pyo
+%%PYTHON_SITELIBDIR%%/sqlite/__init__.py
+%%PYTHON_SITELIBDIR%%/sqlite/__init__.pyc
+%%PYTHON_SITELIBDIR%%/sqlite/__init__.pyo
+%%PYTHON_SITELIBDIR%%/sqlite/main.py
+%%PYTHON_SITELIBDIR%%/sqlite/main.pyc
+%%PYTHON_SITELIBDIR%%/sqlite/main.pyo
+%%PYTHON_SITELIBDIR%%/sqlite/threadutils.py
+%%PYTHON_SITELIBDIR%%/sqlite/threadutils.pyc
+%%PYTHON_SITELIBDIR%%/sqlite/threadutils.pyo
+%%PYTHON_SITELIBDIR%%/sqlite/constants/__init__.py
+%%PYTHON_SITELIBDIR%%/sqlite/constants/__init__.pyc
+%%PYTHON_SITELIBDIR%%/sqlite/constants/__init__.pyo
+%%PYTHON_SITELIBDIR%%/sqlite/constants/FIELD_TYPE.py
+%%PYTHON_SITELIBDIR%%/sqlite/constants/FIELD_TYPE.pyc
+%%PYTHON_SITELIBDIR%%/sqlite/constants/FIELD_TYPE.pyo
+%%PYTHON_SITELIBDIR%%/sqlite/py22features.py
+%%PYTHON_SITELIBDIR%%/sqlite/py22features.pyc
+%%PYTHON_SITELIBDIR%%/sqlite/py22features.pyo
+%%PYTHON_SITELIBDIR%%/_sqlite.so
+@dirrm %%PYTHON_SITELIBDIR%%/sqlite/constants
+@dirrm %%PYTHON_SITELIBDIR%%/sqlite
+%%PORTDOCS%%share/doc/py-PySQLite/README
+%%PORTDOCS%%@dirrm share/doc/py-PySQLite
diff --git a/databases/py-pysqlite22/Makefile b/databases/py-pysqlite22/Makefile
new file mode 100644
index 000000000000..4dfef1b4d430
--- /dev/null
+++ b/databases/py-pysqlite22/Makefile
@@ -0,0 +1,46 @@
+# New ports collection makefile for:   py-PySQLite
+# Date created:                        02 Oct 2002
+# Whom:                                Gerhard Haering <gerhard.haering@gmx.de>
+#
+# $FreeBSD$
+#
+
+PORTNAME=	PySQLite
+PORTVERSION=	0.3.0
+CATEGORIES=	databases python
+MASTER_SITES=	${MASTER_SITE_SOURCEFORGE}
+MASTER_SITE_SUBDIR=	pysqlite
+PKGNAMEPREFIX=	py-
+DISTNAME=	pysqlite-${PORTVERSION}
+
+MAINTAINER=	gerhard.haering@gmx.de
+
+RUN_DEPENDS=	${DATETIME_DEP}:${PORTSDIR}/lang/py-mx-base
+LIB_DEPENDS=	sqlite.2:${PORTSDIR}/databases/sqlite
+
+WRKSRC=		${WRKDIR}/pysqlite-${PORTVERSION}
+USE_PYTHON=	yes
+USE_REINPLACE=	yes
+USE_PYDISTUTILS=	yes
+
+DOCS=		README
+
+PLIST_SUB+=	PYTHON_SITELIBDIR=${PYTHON_SITELIBDIR:S/^${LOCALBASE}\///g}
+
+DATETIME_DEP=	${PYTHON_SITELIBDIR}/mx/DateTime/__init__.py
+
+DOCSDIR=	${PREFIX}/share/doc/${PKGNAMEPREFIX}${PORTNAME}
+
+post-patch:
+	${REINPLACE_CMD} -e 's^/usr/local/include/sqlite^${LOCALBASE}/include^g' ${WRKSRC}/setup.py
+	${REINPLACE_CMD} -e 's^/usr/local/lib^${LOCALBASE}/lib^g' ${WRKSRC}/setup.py
+
+.if !defined(NOPORTDOCS)
+post-install:
+	@${MKDIR} ${DOCSDIR}
+.for file in ${DOCS}
+	@${INSTALL_DATA} ${WRKSRC}/${file} ${DOCSDIR}
+.endfor
+.endif
+
+.include <bsd.port.mk>
diff --git a/databases/py-pysqlite22/distinfo b/databases/py-pysqlite22/distinfo
new file mode 100644
index 000000000000..e76dac890a85
--- /dev/null
+++ b/databases/py-pysqlite22/distinfo
@@ -0,0 +1 @@
+MD5 (pysqlite-0.3.0.tar.gz) = c207d45ab958dabeba30162fca27a675
diff --git a/databases/py-pysqlite22/files/patch-setup.py b/databases/py-pysqlite22/files/patch-setup.py
new file mode 100644
index 000000000000..2e15106b95e9
--- /dev/null
+++ b/databases/py-pysqlite22/files/patch-setup.py
@@ -0,0 +1,11 @@
+--- setup.py.orig	Wed Feb  5 16:17:16 2003
++++ setup.py	Wed Feb  5 16:17:26 2003
+@@ -14,7 +14,7 @@
+     libraries = [sqlite]
+     runtime_library_dirs = []
+     extra_objects = []
+-elif sys.platform in ("freebsd4", "openbsd2"): 
++elif sys.platform in ("freebsd4", "freebsd5", "openbsd2"): 
+     include_dirs = ['/usr/local/include/sqlite']
+     library_dirs = ['/usr/local/lib/']
+     libraries = [sqlite]
diff --git a/databases/py-pysqlite22/pkg-comment b/databases/py-pysqlite22/pkg-comment
new file mode 100644
index 000000000000..b3658d2496f8
--- /dev/null
+++ b/databases/py-pysqlite22/pkg-comment
@@ -0,0 +1 @@
+A DB-API v2 Python library for the SQLite embedded SQL engine
diff --git a/databases/py-pysqlite22/pkg-descr b/databases/py-pysqlite22/pkg-descr
new file mode 100644
index 000000000000..b5df121b1e58
--- /dev/null
+++ b/databases/py-pysqlite22/pkg-descr
@@ -0,0 +1,10 @@
+The goal of the PySQLite project is to develop a Python extension for SQLite
+that conforms to the Python Database API Specification 2.0. SQLite is a
+powerful embedded relational database management system in a compact C library.
+It offers support for a large subset of SQL92, multiple tables, indices,
+transactions and triggers.
+
+WWW: http://pysqlite.sourceforge.net/
+developed by Gerhard Haering and Michael Owens
+
+- Gerhard Haering <gerhard.haering@gmx.de>
diff --git a/databases/py-pysqlite22/pkg-plist b/databases/py-pysqlite22/pkg-plist
new file mode 100644
index 000000000000..05dad03d30ca
--- /dev/null
+++ b/databases/py-pysqlite22/pkg-plist
@@ -0,0 +1,26 @@
+%%PYTHON_SITELIBDIR%%/pysqlite_exceptions.py
+%%PYTHON_SITELIBDIR%%/pysqlite_exceptions.pyc
+%%PYTHON_SITELIBDIR%%/pysqlite_exceptions.pyo
+%%PYTHON_SITELIBDIR%%/sqlite/__init__.py
+%%PYTHON_SITELIBDIR%%/sqlite/__init__.pyc
+%%PYTHON_SITELIBDIR%%/sqlite/__init__.pyo
+%%PYTHON_SITELIBDIR%%/sqlite/main.py
+%%PYTHON_SITELIBDIR%%/sqlite/main.pyc
+%%PYTHON_SITELIBDIR%%/sqlite/main.pyo
+%%PYTHON_SITELIBDIR%%/sqlite/threadutils.py
+%%PYTHON_SITELIBDIR%%/sqlite/threadutils.pyc
+%%PYTHON_SITELIBDIR%%/sqlite/threadutils.pyo
+%%PYTHON_SITELIBDIR%%/sqlite/constants/__init__.py
+%%PYTHON_SITELIBDIR%%/sqlite/constants/__init__.pyc
+%%PYTHON_SITELIBDIR%%/sqlite/constants/__init__.pyo
+%%PYTHON_SITELIBDIR%%/sqlite/constants/FIELD_TYPE.py
+%%PYTHON_SITELIBDIR%%/sqlite/constants/FIELD_TYPE.pyc
+%%PYTHON_SITELIBDIR%%/sqlite/constants/FIELD_TYPE.pyo
+%%PYTHON_SITELIBDIR%%/sqlite/py22features.py
+%%PYTHON_SITELIBDIR%%/sqlite/py22features.pyc
+%%PYTHON_SITELIBDIR%%/sqlite/py22features.pyo
+%%PYTHON_SITELIBDIR%%/_sqlite.so
+@dirrm %%PYTHON_SITELIBDIR%%/sqlite/constants
+@dirrm %%PYTHON_SITELIBDIR%%/sqlite
+%%PORTDOCS%%share/doc/py-PySQLite/README
+%%PORTDOCS%%@dirrm share/doc/py-PySQLite
diff --git a/databases/py-pysqlite23/Makefile b/databases/py-pysqlite23/Makefile
new file mode 100644
index 000000000000..4dfef1b4d430
--- /dev/null
+++ b/databases/py-pysqlite23/Makefile
@@ -0,0 +1,46 @@
+# New ports collection makefile for:   py-PySQLite
+# Date created:                        02 Oct 2002
+# Whom:                                Gerhard Haering <gerhard.haering@gmx.de>
+#
+# $FreeBSD$
+#
+
+PORTNAME=	PySQLite
+PORTVERSION=	0.3.0
+CATEGORIES=	databases python
+MASTER_SITES=	${MASTER_SITE_SOURCEFORGE}
+MASTER_SITE_SUBDIR=	pysqlite
+PKGNAMEPREFIX=	py-
+DISTNAME=	pysqlite-${PORTVERSION}
+
+MAINTAINER=	gerhard.haering@gmx.de
+
+RUN_DEPENDS=	${DATETIME_DEP}:${PORTSDIR}/lang/py-mx-base
+LIB_DEPENDS=	sqlite.2:${PORTSDIR}/databases/sqlite
+
+WRKSRC=		${WRKDIR}/pysqlite-${PORTVERSION}
+USE_PYTHON=	yes
+USE_REINPLACE=	yes
+USE_PYDISTUTILS=	yes
+
+DOCS=		README
+
+PLIST_SUB+=	PYTHON_SITELIBDIR=${PYTHON_SITELIBDIR:S/^${LOCALBASE}\///g}
+
+DATETIME_DEP=	${PYTHON_SITELIBDIR}/mx/DateTime/__init__.py
+
+DOCSDIR=	${PREFIX}/share/doc/${PKGNAMEPREFIX}${PORTNAME}
+
+post-patch:
+	${REINPLACE_CMD} -e 's^/usr/local/include/sqlite^${LOCALBASE}/include^g' ${WRKSRC}/setup.py
+	${REINPLACE_CMD} -e 's^/usr/local/lib^${LOCALBASE}/lib^g' ${WRKSRC}/setup.py
+
+.if !defined(NOPORTDOCS)
+post-install:
+	@${MKDIR} ${DOCSDIR}
+.for file in ${DOCS}
+	@${INSTALL_DATA} ${WRKSRC}/${file} ${DOCSDIR}
+.endfor
+.endif
+
+.include <bsd.port.mk>
diff --git a/databases/py-pysqlite23/distinfo b/databases/py-pysqlite23/distinfo
new file mode 100644
index 000000000000..e76dac890a85
--- /dev/null
+++ b/databases/py-pysqlite23/distinfo
@@ -0,0 +1 @@
+MD5 (pysqlite-0.3.0.tar.gz) = c207d45ab958dabeba30162fca27a675
diff --git a/databases/py-pysqlite23/files/patch-setup.py b/databases/py-pysqlite23/files/patch-setup.py
new file mode 100644
index 000000000000..2e15106b95e9
--- /dev/null
+++ b/databases/py-pysqlite23/files/patch-setup.py
@@ -0,0 +1,11 @@
+--- setup.py.orig	Wed Feb  5 16:17:16 2003
++++ setup.py	Wed Feb  5 16:17:26 2003
+@@ -14,7 +14,7 @@
+     libraries = [sqlite]
+     runtime_library_dirs = []
+     extra_objects = []
+-elif sys.platform in ("freebsd4", "openbsd2"): 
++elif sys.platform in ("freebsd4", "freebsd5", "openbsd2"): 
+     include_dirs = ['/usr/local/include/sqlite']
+     library_dirs = ['/usr/local/lib/']
+     libraries = [sqlite]
diff --git a/databases/py-pysqlite23/pkg-comment b/databases/py-pysqlite23/pkg-comment
new file mode 100644
index 000000000000..b3658d2496f8
--- /dev/null
+++ b/databases/py-pysqlite23/pkg-comment
@@ -0,0 +1 @@
+A DB-API v2 Python library for the SQLite embedded SQL engine
diff --git a/databases/py-pysqlite23/pkg-descr b/databases/py-pysqlite23/pkg-descr
new file mode 100644
index 000000000000..b5df121b1e58
--- /dev/null
+++ b/databases/py-pysqlite23/pkg-descr
@@ -0,0 +1,10 @@
+The goal of the PySQLite project is to develop a Python extension for SQLite
+that conforms to the Python Database API Specification 2.0. SQLite is a
+powerful embedded relational database management system in a compact C library.
+It offers support for a large subset of SQL92, multiple tables, indices,
+transactions and triggers.
+
+WWW: http://pysqlite.sourceforge.net/
+developed by Gerhard Haering and Michael Owens
+
+- Gerhard Haering <gerhard.haering@gmx.de>
diff --git a/databases/py-pysqlite23/pkg-plist b/databases/py-pysqlite23/pkg-plist
new file mode 100644
index 000000000000..05dad03d30ca
--- /dev/null
+++ b/databases/py-pysqlite23/pkg-plist
@@ -0,0 +1,26 @@
+%%PYTHON_SITELIBDIR%%/pysqlite_exceptions.py
+%%PYTHON_SITELIBDIR%%/pysqlite_exceptions.pyc
+%%PYTHON_SITELIBDIR%%/pysqlite_exceptions.pyo
+%%PYTHON_SITELIBDIR%%/sqlite/__init__.py
+%%PYTHON_SITELIBDIR%%/sqlite/__init__.pyc
+%%PYTHON_SITELIBDIR%%/sqlite/__init__.pyo
+%%PYTHON_SITELIBDIR%%/sqlite/main.py
+%%PYTHON_SITELIBDIR%%/sqlite/main.pyc
+%%PYTHON_SITELIBDIR%%/sqlite/main.pyo
+%%PYTHON_SITELIBDIR%%/sqlite/threadutils.py
+%%PYTHON_SITELIBDIR%%/sqlite/threadutils.pyc
+%%PYTHON_SITELIBDIR%%/sqlite/threadutils.pyo
+%%PYTHON_SITELIBDIR%%/sqlite/constants/__init__.py
+%%PYTHON_SITELIBDIR%%/sqlite/constants/__init__.pyc
+%%PYTHON_SITELIBDIR%%/sqlite/constants/__init__.pyo
+%%PYTHON_SITELIBDIR%%/sqlite/constants/FIELD_TYPE.py
+%%PYTHON_SITELIBDIR%%/sqlite/constants/FIELD_TYPE.pyc
+%%PYTHON_SITELIBDIR%%/sqlite/constants/FIELD_TYPE.pyo
+%%PYTHON_SITELIBDIR%%/sqlite/py22features.py
+%%PYTHON_SITELIBDIR%%/sqlite/py22features.pyc
+%%PYTHON_SITELIBDIR%%/sqlite/py22features.pyo
+%%PYTHON_SITELIBDIR%%/_sqlite.so
+@dirrm %%PYTHON_SITELIBDIR%%/sqlite/constants
+@dirrm %%PYTHON_SITELIBDIR%%/sqlite
+%%PORTDOCS%%share/doc/py-PySQLite/README
+%%PORTDOCS%%@dirrm share/doc/py-PySQLite