回复: [Update] databases/py-sqlalchemy-migrate : update to 0.12.0

2019-08-19 Thread wen heping 




发件人: Landry Breuil 
发送时间: 2019年8月20日 2:05
收件人: wen heping 
抄送: ports@openbsd.org 
主题: Re: [Update] databases/py-sqlalchemy-migrate : update to 0.12.0

On Fri, Aug 16, 2019 at 07:37:06AM +, wen heping wrote:
> Hi, ports@:
>
>   Here is a patch for databases/py-sqlalchemy-migrate:
>   i) Update to 0.12.0
>   ii) Fix a typo in PLIST
>
>   It build and run well on amd64-head system.
>   It defined NO_TEST=yes.
>   No other ports depends on it.

Well, buildbot uses it. So other ports depend on it...

You are right, I forgot py-sqlalchemy-migrate's python3 FLAVOR.
Thanks !

$show-reverse-deps databases/py-sqlalchemy-migrate
devel/py-buildbot/buildbot

anyway, here's the update i came up with, with a really updated PLIST.
tested while upgrading buildbot 2.3.1 to 2.4.0.

Landry

Re: [Update] databases/py-sqlalchemy-migrate : update to 0.12.0

2019-08-19 Thread Landry Breuil 
On Fri, Aug 16, 2019 at 07:37:06AM +, wen heping wrote:
> Hi, ports@:
> 
>   Here is a patch for databases/py-sqlalchemy-migrate:
>   i) Update to 0.12.0
>   ii) Fix a typo in PLIST
> 
>   It build and run well on amd64-head system.
>   It defined NO_TEST=yes.
>   No other ports depends on it.

Well, buildbot uses it. So other ports depend on it...

$show-reverse-deps databases/py-sqlalchemy-migrate
devel/py-buildbot/buildbot

anyway, here's the update i came up with, with a really updated PLIST.
tested while upgrading buildbot 2.3.1 to 2.4.0.

Landry
Index: Makefile
===
RCS file: /cvs/ports/databases/py-sqlalchemy-migrate/Makefile,v
retrieving revision 1.12
diff -u -r1.12 Makefile
--- Makefile12 Jul 2019 20:44:00 -  1.12
+++ Makefile19 Aug 2019 18:02:10 -
@@ -2,10 +2,9 @@
 
 COMMENT =  schema migration tools for SQLAlchemy
 
-MODPY_EGG_VERSION =0.11.0
+MODPY_EGG_VERSION =0.12.0
 DISTNAME = sqlalchemy-migrate-${MODPY_EGG_VERSION}
 PKGNAME =  py-${DISTNAME}
-REVISION = 2
 
 CATEGORIES =   databases
 
Index: distinfo
===
RCS file: /cvs/ports/databases/py-sqlalchemy-migrate/distinfo,v
retrieving revision 1.5
diff -u -r1.5 distinfo
--- distinfo19 May 2017 04:50:12 -  1.5
+++ distinfo19 Aug 2019 18:02:10 -
@@ -1,2 +1,2 @@
-SHA256 (sqlalchemy-migrate-0.11.0.tar.gz) = 
5or14+BWH2KdTrI9nQ6nfSZJdH8u/zf9Ka7OdGFcolE=
-SIZE (sqlalchemy-migrate-0.11.0.tar.gz) = 128299
+SHA256 (sqlalchemy-migrate-0.12.0.tar.gz) = 
jPraMLvPeag7Oi0bzWN95+H0PjkNVN4z5PMkn9mqz64=
+SIZE (sqlalchemy-migrate-0.12.0.tar.gz) = 128499
Index: pkg/PLIST
===
RCS file: /cvs/ports/databases/py-sqlalchemy-migrate/pkg/PLIST,v
retrieving revision 1.4
diff -u -r1.4 PLIST
--- pkg/PLIST   23 Jun 2018 21:46:44 -  1.4
+++ pkg/PLIST   19 Aug 2019 18:02:10 -
@@ -5,38 +5,38 @@
 lib/python${MODPY_VERSION}/site-packages/migrate/__init__.py
 
${MODPY_COMMENT}lib/python${MODPY_VERSION}/site-packages/migrate/${MODPY_PYCACHE}/
 
lib/python${MODPY_VERSION}/site-packages/migrate/${MODPY_PYCACHE}__init__.${MODPY_PYC_MAGIC_TAG}pyc
-lib/python${MODPY_VERSION}/site-packages/migrate/${MODPY_PYCACHE}exceptions.${MODPY_PYC_MAGIC_TAG}pyc
 lib/python${MODPY_VERSION}/site-packages/migrate/changeset/
 lib/python${MODPY_VERSION}/site-packages/migrate/changeset/__init__.py
 
${MODPY_COMMENT}lib/python${MODPY_VERSION}/site-packages/migrate/changeset/${MODPY_PYCACHE}/
 
lib/python${MODPY_VERSION}/site-packages/migrate/changeset/${MODPY_PYCACHE}__init__.${MODPY_PYC_MAGIC_TAG}pyc
-lib/python${MODPY_VERSION}/site-packages/migrate/changeset/${MODPY_PYCACHE}ansisql.${MODPY_PYC_MAGIC_TAG}pyc
-lib/python${MODPY_VERSION}/site-packages/migrate/changeset/${MODPY_PYCACHE}constraint.${MODPY_PYC_MAGIC_TAG}pyc
-lib/python${MODPY_VERSION}/site-packages/migrate/changeset/${MODPY_PYCACHE}schema.${MODPY_PYC_MAGIC_TAG}pyc
-lib/python${MODPY_VERSION}/site-packages/migrate/changeset/${MODPY_PYCACHE}util.${MODPY_PYC_MAGIC_TAG}pyc
 lib/python${MODPY_VERSION}/site-packages/migrate/changeset/ansisql.py
+lib/python${MODPY_VERSION}/site-packages/migrate/changeset/${MODPY_PYCACHE}ansisql.${MODPY_PYC_MAGIC_TAG}pyc
 lib/python${MODPY_VERSION}/site-packages/migrate/changeset/constraint.py
+lib/python${MODPY_VERSION}/site-packages/migrate/changeset/${MODPY_PYCACHE}constraint.${MODPY_PYC_MAGIC_TAG}pyc
 lib/python${MODPY_VERSION}/site-packages/migrate/changeset/databases/
 
lib/python${MODPY_VERSION}/site-packages/migrate/changeset/databases/__init__.py
 
${MODPY_COMMENT}lib/python${MODPY_VERSION}/site-packages/migrate/changeset/databases/${MODPY_PYCACHE}/
 
lib/python${MODPY_VERSION}/site-packages/migrate/changeset/databases/${MODPY_PYCACHE}__init__.${MODPY_PYC_MAGIC_TAG}pyc
-lib/python${MODPY_VERSION}/site-packages/migrate/changeset/databases/${MODPY_PYCACHE}firebird.${MODPY_PYC_MAGIC_TAG}pyc
-lib/python${MODPY_VERSION}/site-packages/migrate/changeset/databases/${MODPY_PYCACHE}ibmdb2.${MODPY_PYC_MAGIC_TAG}pyc
-lib/python${MODPY_VERSION}/site-packages/migrate/changeset/databases/${MODPY_PYCACHE}mysql.${MODPY_PYC_MAGIC_TAG}pyc
-lib/python${MODPY_VERSION}/site-packages/migrate/changeset/databases/${MODPY_PYCACHE}oracle.${MODPY_PYC_MAGIC_TAG}pyc
-lib/python${MODPY_VERSION}/site-packages/migrate/changeset/databases/${MODPY_PYCACHE}postgres.${MODPY_PYC_MAGIC_TAG}pyc
-lib/python${MODPY_VERSION}/site-packages/migrate/changeset/databases/${MODPY_PYCACHE}sqlite.${MODPY_PYC_MAGIC_TAG}pyc
-lib/python${MODPY_VERSION}/site-packages/migrate/changeset/databases/${MODPY_PYCACHE}visitor.${MODPY_PYC_MAGIC_TAG}pyc
 
lib/python${MODPY_VERSION}/site-packages/migrate/changeset/databases/firebird.py
+lib/python${MODPY_VERSION}/site-packages/migrate/changeset/databases/${MODPY_PYCACHE}firebird.${MODPY_PYC_MAGIC_TAG}pyc

[Update] databases/py-sqlalchemy-migrate : update to 0.12.0

2019-08-16 Thread wen heping 
Hi, ports@:

  Here is a patch for databases/py-sqlalchemy-migrate:
  i) Update to 0.12.0
  ii) Fix a typo in PLIST

  It build and run well on amd64-head system.
  It defined NO_TEST=yes.
  No other ports depends on it.

Comments? OK?
wen
Index: Makefile
===
RCS file: /cvs/ports/databases/py-sqlalchemy-migrate/Makefile,v
retrieving revision 1.12
diff -u -p -r1.12 Makefile
--- Makefile12 Jul 2019 20:44:00 -  1.12
+++ Makefile16 Aug 2019 07:33:21 -
@@ -2,10 +2,9 @@
 
 COMMENT =  schema migration tools for SQLAlchemy
 
-MODPY_EGG_VERSION =0.11.0
+MODPY_EGG_VERSION =0.12.0
 DISTNAME = sqlalchemy-migrate-${MODPY_EGG_VERSION}
 PKGNAME =  py-${DISTNAME}
-REVISION = 2
 
 CATEGORIES =   databases
 
Index: distinfo
===
RCS file: /cvs/ports/databases/py-sqlalchemy-migrate/distinfo,v
retrieving revision 1.5
diff -u -p -r1.5 distinfo
--- distinfo19 May 2017 04:50:12 -  1.5
+++ distinfo16 Aug 2019 07:33:21 -
@@ -1,2 +1,2 @@
-SHA256 (sqlalchemy-migrate-0.11.0.tar.gz) = 
5or14+BWH2KdTrI9nQ6nfSZJdH8u/zf9Ka7OdGFcolE=
-SIZE (sqlalchemy-migrate-0.11.0.tar.gz) = 128299
+SHA256 (sqlalchemy-migrate-0.12.0.tar.gz) = 
jPraMLvPeag7Oi0bzWN95+H0PjkNVN4z5PMkn9mqz64=
+SIZE (sqlalchemy-migrate-0.12.0.tar.gz) = 128499
Index: pkg/PLIST
===
RCS file: /cvs/ports/databases/py-sqlalchemy-migrate/pkg/PLIST,v
retrieving revision 1.4
diff -u -p -r1.4 PLIST
--- pkg/PLIST   23 Jun 2018 21:46:44 -  1.4
+++ pkg/PLIST   16 Aug 2019 07:33:21 -
@@ -79,7 +79,7 @@ lib/python${MODPY_VERSION}/site-packages
 lib/python${MODPY_VERSION}/site-packages/migrate/tests/integrated/test_docs.py
 lib/python${MODPY_VERSION}/site-packages/migrate/tests/versioning/
 lib/python${MODPY_VERSION}/site-packages/migrate/tests/versioning/__init__.py
-${MOPDY_COMMENT}lib/python${MODPY_VERSION}/site-packages/migrate/tests/versioning/${MODPY_PYCACHE}/
+${MODPY_COMMENT}lib/python${MODPY_VERSION}/site-packages/migrate/tests/versioning/${MODPY_PYCACHE}/
 
lib/python${MODPY_VERSION}/site-packages/migrate/tests/versioning/${MODPY_PYCACHE}__init__.${MODPY_PYC_MAGIC_TAG}pyc
 
lib/python${MODPY_VERSION}/site-packages/migrate/tests/versioning/${MODPY_PYCACHE}test_api.${MODPY_PYC_MAGIC_TAG}pyc
 
lib/python${MODPY_VERSION}/site-packages/migrate/tests/versioning/${MODPY_PYCACHE}test_cfgparse.${MODPY_PYC_MAGIC_TAG}pyc

Re: [UPDATE] databases/py-sqlalchemy

2018-06-23 Thread Landry Breuil 
On Sat, Jun 23, 2018 at 10:34:04PM +0100, Stuart Henderson wrote:
> On 2018/06/19 21:49, Remi Pointel wrote:
> > On 06/19/18 21:40, Elias M. Mariani wrote:
> > > Remi, I think that py3 and py versions still conflict, check this
> > > solution that I sent a while back:
> > > https://marc.info/?l=openbsd-ports=152884055212579=3
> 
> That diff has problems, first two pointed out by landry@:
> 
> - RUN_DEPENDS = databases/py-sqlalchemy,-docs${MODPY_FLAVOR} is wrong for py3
> - missing @pkgpath marker in -main to allow updates to work

I've tweaked those, RUN_DEPENDS should only have
databases/py-sqlalchemy,-docs since this package is flavor-agnostic.

> - missing bumps for dependent ports

done :)

Re: [UPDATE] databases/py-sqlalchemy

2018-06-23 Thread Stuart Henderson 
On 2018/06/19 21:49, Remi Pointel wrote:
> On 06/19/18 21:40, Elias M. Mariani wrote:
> > Remi, I think that py3 and py versions still conflict, check this
> > solution that I sent a while back:
> > https://marc.info/?l=openbsd-ports=152884055212579=3

That diff has problems, first two pointed out by landry@:

- RUN_DEPENDS = databases/py-sqlalchemy,-docs${MODPY_FLAVOR} is wrong for py3
- missing @pkgpath marker in -main to allow updates to work

also

- missing bumps for dependent ports

> > Or just make to folders with py3 and py documentations in different folders.
> 
> Good catch, I forgot this part.
> 
> ok with this diff?

I like this simple approach which is what we do with most of the rest of the 
tree..
OK sthen@

Re: [UPDATE] databases/py-sqlalchemy

2018-06-19 Thread Elias M. Mariani 
The diff looks OK.
I would prefer that ports had docs as an optional, but it doesn't seem
to be the policy.
The project tries to be minimalistic and we end up having duplicate
docs (with the python ports at least) witch most of the time aren't
used.

Cheers.
Elias.

2018-06-19 16:49 GMT-03:00 Remi Pointel :
> On 06/19/18 21:40, Elias M. Mariani wrote:
>>
>> Remi, I think that py3 and py versions still conflict, check this
>> solution that I sent a while back:
>> https://marc.info/?l=openbsd-ports=152884055212579=3
>> Or just make to folders with py3 and py documentations in different
>> folders.
>
>
> Good catch, I forgot this part.
>
> ok with this diff?
>
> Cheers,
>
> Remi.

Re: [UPDATE] databases/py-sqlalchemy

2018-06-19 Thread Remi Pointel 

On 06/19/18 21:40, Elias M. Mariani wrote:

Remi, I think that py3 and py versions still conflict, check this
solution that I sent a while back:
https://marc.info/?l=openbsd-ports=152884055212579=3
Or just make to folders with py3 and py documentations in different folders.


Good catch, I forgot this part.

ok with this diff?

Cheers,

Remi.
Index: Makefile
===
RCS file: /cvs/ports/databases/py-sqlalchemy/Makefile,v
retrieving revision 1.35
diff -u -p -u -p -r1.35 Makefile
--- Makefile	19 Jun 2018 13:59:24 -	1.35
+++ Makefile	19 Jun 2018 19:47:44 -
@@ -5,6 +5,7 @@ COMMENT =		database toolkit for Python
 MODPY_EGG_VERSION =	1.2.8
 DISTNAME =		SQLAlchemy-${MODPY_EGG_VERSION}
 PKGNAME =		py-sqlalchemy-${MODPY_EGG_VERSION:S/p/./}
+REVISION =		0
 
 CATEGORIES =		databases
 
@@ -34,10 +35,10 @@ TEST_DEPENDS +=		databases/py-sqlite2${M
 .endif
 
 post-install:
-	${INSTALL_DATA_DIR} ${PREFIX}/share/doc/py-sqlalchemy
-	${INSTALL_DATA_DIR} ${PREFIX}/share/examples/py-sqlalchemy
-	cd ${WRKSRC}/doc && pax -rw * ${PREFIX}/share/doc/py-sqlalchemy
+	${INSTALL_DATA_DIR} ${PREFIX}/share/doc/${MODPY_PY_PREFIX}sqlalchemy
+	${INSTALL_DATA_DIR} ${PREFIX}/share/examples/${MODPY_PY_PREFIX}sqlalchemy
+	cd ${WRKSRC}/doc && pax -rw * ${PREFIX}/share/doc/${MODPY_PY_PREFIX}sqlalchemy
 	cd ${WRKSRC}/examples && \
-		pax -rw * ${PREFIX}/share/examples/py-sqlalchemy
+		pax -rw * ${PREFIX}/share/examples/${MODPY_PY_PREFIX}sqlalchemy
 
 .include 
Index: pkg/PLIST
===
RCS file: /cvs/ports/databases/py-sqlalchemy/pkg/PLIST,v
retrieving revision 1.14
diff -u -p -u -p -r1.14 PLIST
--- pkg/PLIST	19 Jun 2018 13:59:24 -	1.14
+++ pkg/PLIST	19 Jun 2018 19:47:45 -
@@ -430,495 +430,495 @@ lib/python${MODPY_VERSION}/site-packages
 lib/python${MODPY_VERSION}/site-packages/sqlalchemy/util/langhelpers.py
 lib/python${MODPY_VERSION}/site-packages/sqlalchemy/util/queue.py
 lib/python${MODPY_VERSION}/site-packages/sqlalchemy/util/topological.py
-share/doc/py-sqlalchemy/
-share/doc/py-sqlalchemy/_images/
-share/doc/py-sqlalchemy/_images/sqla_arch_small.png
-share/doc/py-sqlalchemy/_images/sqla_engine_arch.png
-share/doc/py-sqlalchemy/_modules/
-share/doc/py-sqlalchemy/_modules/examples/
-share/doc/py-sqlalchemy/_modules/examples/adjacency_list/
-share/doc/py-sqlalchemy/_modules/examples/adjacency_list/adjacency_list.html
-share/doc/py-sqlalchemy/_modules/examples/association/
-share/doc/py-sqlalchemy/_modules/examples/association/basic_association.html
-share/doc/py-sqlalchemy/_modules/examples/association/dict_of_sets_with_default.html
-share/doc/py-sqlalchemy/_modules/examples/association/proxied_association.html
-share/doc/py-sqlalchemy/_modules/examples/custom_attributes/
-share/doc/py-sqlalchemy/_modules/examples/custom_attributes/active_column_defaults.html
-share/doc/py-sqlalchemy/_modules/examples/custom_attributes/custom_management.html
-share/doc/py-sqlalchemy/_modules/examples/custom_attributes/listen_for_events.html
-share/doc/py-sqlalchemy/_modules/examples/dogpile_caching/
-share/doc/py-sqlalchemy/_modules/examples/dogpile_caching/advanced.html
-share/doc/py-sqlalchemy/_modules/examples/dogpile_caching/caching_query.html
-share/doc/py-sqlalchemy/_modules/examples/dogpile_caching/environment.html
-share/doc/py-sqlalchemy/_modules/examples/dogpile_caching/fixture_data.html
-share/doc/py-sqlalchemy/_modules/examples/dogpile_caching/helloworld.html
-share/doc/py-sqlalchemy/_modules/examples/dogpile_caching/local_session_caching.html
-share/doc/py-sqlalchemy/_modules/examples/dogpile_caching/model.html
-share/doc/py-sqlalchemy/_modules/examples/dogpile_caching/relationship_caching.html
-share/doc/py-sqlalchemy/_modules/examples/dynamic_dict/
-share/doc/py-sqlalchemy/_modules/examples/dynamic_dict/dynamic_dict.html
-share/doc/py-sqlalchemy/_modules/examples/elementtree/
-share/doc/py-sqlalchemy/_modules/examples/elementtree/adjacency_list.html
-share/doc/py-sqlalchemy/_modules/examples/elementtree/optimized_al.html
-share/doc/py-sqlalchemy/_modules/examples/elementtree/pickle.html
-share/doc/py-sqlalchemy/_modules/examples/generic_associations/
-share/doc/py-sqlalchemy/_modules/examples/generic_associations/discriminator_on_association.html
-share/doc/py-sqlalchemy/_modules/examples/generic_associations/generic_fk.html
-share/doc/py-sqlalchemy/_modules/examples/generic_associations/table_per_association.html
-share/doc/py-sqlalchemy/_modules/examples/generic_associations/table_per_related.html
-share/doc/py-sqlalchemy/_modules/examples/graphs/
-share/doc/py-sqlalchemy/_modules/examples/graphs/directed_graph.html
-share/doc/py-sqlalchemy/_modules/examples/inheritance/
-share/doc/py-sqlalchemy/_modules/examples/inheritance/concrete.html
-share/doc/py-sqlalchemy/_modules/examples/inheritance/joined.html
-share/doc/py-sqlalchemy/_modules/examples/inheritance/single.html

Re: [UPDATE] databases/py-sqlalchemy

2018-06-19 Thread Elias M. Mariani 
Remi, I think that py3 and py versions still conflict, check this
solution that I sent a while back:
https://marc.info/?l=openbsd-ports=152884055212579=3
Or just make to folders with py3 and py documentations in different folders.

Cheers.
Elias,

2018-06-19 8:05 GMT-03:00 Remi Pointel :
> Hi,
>
> attached is the diff to update to latest release.
>
> Ok?
>
> Cheers,
>
> Remi.

[UPDATE] databases/py-sqlalchemy

2018-06-19 Thread Remi Pointel 

Hi,

attached is the diff to update to latest release.

Ok?

Cheers,

Remi.
Index: Makefile
===
RCS file: /cvs/ports/databases/py-sqlalchemy/Makefile,v
retrieving revision 1.34
diff -u -p -u -p -r1.34 Makefile
--- Makefile	26 May 2018 14:07:11 -	1.34
+++ Makefile	19 Jun 2018 11:03:32 -
@@ -2,7 +2,7 @@
 
 COMMENT =		database toolkit for Python
 
-MODPY_EGG_VERSION =	1.2.7
+MODPY_EGG_VERSION =	1.2.8
 DISTNAME =		SQLAlchemy-${MODPY_EGG_VERSION}
 PKGNAME =		py-sqlalchemy-${MODPY_EGG_VERSION:S/p/./}
 
@@ -39,8 +39,5 @@ post-install:
 	cd ${WRKSRC}/doc && pax -rw * ${PREFIX}/share/doc/py-sqlalchemy
 	cd ${WRKSRC}/examples && \
 		pax -rw * ${PREFIX}/share/examples/py-sqlalchemy
-
-do-test:
-	@cd ${WRKSRC} && ${MODPY_BIN} setup.py test
 
 .include 
Index: distinfo
===
RCS file: /cvs/ports/databases/py-sqlalchemy/distinfo,v
retrieving revision 1.20
diff -u -p -u -p -r1.20 distinfo
--- distinfo	26 May 2018 10:38:32 -	1.20
+++ distinfo	19 Jun 2018 11:03:32 -
@@ -1,2 +1,2 @@
-SHA256 (SQLAlchemy-1.2.7.tar.gz) = 1s2gOwGH1u15b/cOh8mn3OLCyWUKe8PAIs0zFBaFPDE=
-SIZE (SQLAlchemy-1.2.7.tar.gz) = 5571719
+SHA256 (SQLAlchemy-1.2.8.tar.gz) = LV8I9xSohqE4LBi+UB5hS85Q02I4TcCJR0AZzgdoFRw=
+SIZE (SQLAlchemy-1.2.8.tar.gz) = 5586724
Index: pkg/PLIST
===
RCS file: /cvs/ports/databases/py-sqlalchemy/pkg/PLIST,v
retrieving revision 1.13
diff -u -p -u -p -r1.13 PLIST
--- pkg/PLIST	26 May 2018 10:38:32 -	1.13
+++ pkg/PLIST	19 Jun 2018 11:03:32 -
@@ -498,6 +498,7 @@ share/doc/py-sqlalchemy/_modules/example
 share/doc/py-sqlalchemy/_modules/examples/versioned_rows/
 share/doc/py-sqlalchemy/_modules/examples/versioned_rows/versioned_map.html
 share/doc/py-sqlalchemy/_modules/examples/versioned_rows/versioned_rows.html
+share/doc/py-sqlalchemy/_modules/examples/versioned_rows/versioned_rows_w_versionid.html
 share/doc/py-sqlalchemy/_modules/examples/vertical/
 share/doc/py-sqlalchemy/_modules/examples/vertical/dictlike-polymorphic.html
 share/doc/py-sqlalchemy/_modules/examples/vertical/dictlike.html
@@ -916,6 +917,7 @@ share/examples/py-sqlalchemy/versioned_r
 share/examples/py-sqlalchemy/versioned_rows/__init__.py
 share/examples/py-sqlalchemy/versioned_rows/versioned_map.py
 share/examples/py-sqlalchemy/versioned_rows/versioned_rows.py
+share/examples/py-sqlalchemy/versioned_rows/versioned_rows_w_versionid.py
 share/examples/py-sqlalchemy/vertical/
 share/examples/py-sqlalchemy/vertical/__init__.py
 share/examples/py-sqlalchemy/vertical/dictlike-polymorphic.py

Re: UPDATE: databases/py-sqlalchemy

2016-09-01 Thread Landry Breuil 
On Thu, Sep 01, 2016 at 04:27:19PM +0100, Edd Barrett wrote:
> On Thu, Sep 01, 2016 at 04:41:57PM +0200, Landry Breuil wrote:
> > edd, ok for both ?
> 
> Starting with py-sqlparse:
> 
> > # MIBSD
> > PERMIT_PACKAGE_CDROM =  Yes
> 
> Is MIBSD that a typo?

Yeah i wanted BSD only, typo.

> For new Python ports, I tend to add a Python3 FLAVOR, but I can do that
> as a later change if you want.
> 
> There is a py.test test suite which 'make test' does not currently run.
> Add a TEST_DEPEND, and a do-test target which does:
> 
> cd ${WRKSRC} && ${MODPY_BIN} -m pytest tests/

Ah, indeed. Fixed locally.

> You will need to check if the test suite needs the package installed,
> and if it does, add a self-TEST_DEPEND.
> 
> Are you sure tox is needed?

That's what README.md and Makefile says..

Landry

Re: UPDATE: databases/py-sqlalchemy

2016-09-01 Thread Edd Barrett 
On Thu, Sep 01, 2016 at 04:41:57PM +0200, Landry Breuil wrote:
> edd, ok for both ?

Starting with py-sqlparse:

> # MIBSD
> PERMIT_PACKAGE_CDROM =Yes

Is MIBSD that a typo?

For new Python ports, I tend to add a Python3 FLAVOR, but I can do that
as a later change if you want.

There is a py.test test suite which 'make test' does not currently run.
Add a TEST_DEPEND, and a do-test target which does:

cd ${WRKSRC} && ${MODPY_BIN} -m pytest tests/

You will need to check if the test suite needs the package installed,
and if it does, add a self-TEST_DEPEND.

Are you sure tox is needed?

-- 
Best Regards
Edd Barrett

http://www.theunixzoo.co.uk

Re: UPDATE: databases/py-sqlalchemy

2016-09-01 Thread Landry Breuil 
On Thu, Sep 01, 2016 at 12:45:46AM +0200, frantisek holop wrote:
> sqlalchemy-migrate is dead-ish,
> IIRC alembic is the "official" sqlalchemy migration
> tool (by the author of sqlalchemy)

sqlalchemy-migrate isnt dead, since it's still a requirement for
buildbot 0.8.x - it was just forked to pypi.

That said, here's an sqlachemy-migrate update to 0.10.0, including new
py-sqlparse port as a dependency. With all this and sqlachemy 1.0.x,
buildbot starts and runs fine.

edd, ok for both ? After that, that leaves fookebox and childsplay to
test.

Landry
Index: Makefile
===
RCS file: /cvs/ports/databases/py-sqlalchemy-migrate/Makefile,v
retrieving revision 1.5
diff -u -r1.5 Makefile
--- Makefile29 Sep 2015 10:51:15 -  1.5
+++ Makefile1 Sep 2016 14:37:09 -
@@ -2,25 +2,24 @@
 
 COMMENT =  schema migration tools for SQLAlchemy
 
-MODPY_EGG_VERSION =0.7.2
+MODPY_EGG_VERSION =0.10.0
 DISTNAME = sqlalchemy-migrate-${MODPY_EGG_VERSION}
 PKGNAME =  py-${DISTNAME}
-REVISION = 0
 
 CATEGORIES =   databases
 
-HOMEPAGE = https://code.google.com/p/sqlalchemy-migrate/
-
 # MIT
 PERMIT_PACKAGE_CDROM = Yes
 
-MASTER_SITES = https://sqlalchemy-migrate.googlecode.com/files/
-
 MODULES =  lang/python
 MODPY_SETUPTOOLS = Yes
+MODPY_PI = Yes
 
 RUN_DEPENDS =  databases/py-sqlalchemy \
+   databases/py-sqlparse \
+   devel/py-pbr \
devel/py-decorator \
+   devel/py-six \
www/py-tempita
 
 # test needs unported py-cfgparse & py-scripttest
Index: distinfo
===
RCS file: /cvs/ports/databases/py-sqlalchemy-migrate/distinfo,v
retrieving revision 1.3
diff -u -r1.3 distinfo
--- distinfo19 Jul 2015 19:23:26 -  1.3
+++ distinfo1 Sep 2016 14:37:09 -
@@ -1,2 +1,2 @@
-SHA256 (sqlalchemy-migrate-0.7.2.tar.gz) = 
f1XHaO4m8UP+2xGzZaTFfDu9tSEeBJx/BLiugQfCgzM=
-SIZE (sqlalchemy-migrate-0.7.2.tar.gz) = 105862
+SHA256 (sqlalchemy-migrate-0.10.0.tar.gz) = 
+DxczpwJ5cBVJyebf+FWWzLlNTNC/zCyT1lPouWn4AM=
+SIZE (sqlalchemy-migrate-0.10.0.tar.gz) = 127356
Index: pkg/PLIST
===
RCS file: /cvs/ports/databases/py-sqlalchemy-migrate/pkg/PLIST,v
retrieving revision 1.2
diff -u -r1.2 PLIST
--- pkg/PLIST   19 Jul 2015 19:23:26 -  1.2
+++ pkg/PLIST   1 Sep 2016 14:37:09 -
@@ -16,6 +16,8 @@
 
lib/python${MODPY_VERSION}/site-packages/migrate/changeset/databases/__init__.pyc
 
lib/python${MODPY_VERSION}/site-packages/migrate/changeset/databases/firebird.py
 
lib/python${MODPY_VERSION}/site-packages/migrate/changeset/databases/firebird.pyc
+lib/python${MODPY_VERSION}/site-packages/migrate/changeset/databases/ibmdb2.py
+lib/python${MODPY_VERSION}/site-packages/migrate/changeset/databases/ibmdb2.pyc
 lib/python${MODPY_VERSION}/site-packages/migrate/changeset/databases/mysql.py
 lib/python${MODPY_VERSION}/site-packages/migrate/changeset/databases/mysql.pyc
 lib/python${MODPY_VERSION}/site-packages/migrate/changeset/databases/oracle.py
@@ -28,6 +30,8 @@
 
lib/python${MODPY_VERSION}/site-packages/migrate/changeset/databases/visitor.pyc
 lib/python${MODPY_VERSION}/site-packages/migrate/changeset/schema.py
 lib/python${MODPY_VERSION}/site-packages/migrate/changeset/schema.pyc
+lib/python${MODPY_VERSION}/site-packages/migrate/changeset/util.py
+lib/python${MODPY_VERSION}/site-packages/migrate/changeset/util.pyc
 lib/python${MODPY_VERSION}/site-packages/migrate/exceptions.py
 lib/python${MODPY_VERSION}/site-packages/migrate/exceptions.pyc
 lib/python${MODPY_VERSION}/site-packages/migrate/tests/
@@ -36,6 +40,11 @@
 lib/python${MODPY_VERSION}/site-packages/migrate/tests/changeset/
 lib/python${MODPY_VERSION}/site-packages/migrate/tests/changeset/__init__.py
 lib/python${MODPY_VERSION}/site-packages/migrate/tests/changeset/__init__.pyc
+lib/python${MODPY_VERSION}/site-packages/migrate/tests/changeset/databases/
+lib/python${MODPY_VERSION}/site-packages/migrate/tests/changeset/databases/__init__.py
+lib/python${MODPY_VERSION}/site-packages/migrate/tests/changeset/databases/__init__.pyc
+lib/python${MODPY_VERSION}/site-packages/migrate/tests/changeset/databases/test_ibmdb2.py
+lib/python${MODPY_VERSION}/site-packages/migrate/tests/changeset/databases/test_ibmdb2.pyc
 
lib/python${MODPY_VERSION}/site-packages/migrate/tests/changeset/test_changeset.py
 
lib/python${MODPY_VERSION}/site-packages/migrate/tests/changeset/test_changeset.pyc
 
lib/python${MODPY_VERSION}/site-packages/migrate/tests/changeset/test_constraint.py
@@ -174,5 +183,7 @@
 
lib/python${MODPY_VERSION}/site-packages/sqlalchemy_migrate-${MODPY_EGG_VERSION}-py${MODPY_VERSION}.egg-info/SOURCES.txt

Re: UPDATE: databases/py-sqlalchemy

2016-08-31 Thread frantisek holop 
sqlalchemy-migrate is dead-ish,
IIRC alembic is the "official" sqlalchemy migration
tool (by the author of sqlalchemy)

thanks for the port update, it was really old

-f
-- 
the 4th world war will be fought with sticks and rocks.

Re: UPDATE: databases/py-sqlalchemy

2016-08-31 Thread Landry Breuil 
On Wed, Aug 31, 2016 at 04:54:00PM +0100, Edd Barrett wrote:
> This brings our old py-sqlalchemy up to the latest release.
> 
> It depends (directly or indirectly) on the following (all posted to
> ports@):
> 
>  * py-sqlite2 (update)
>  * py-execnet (new)
>  * py-apipkg (new)
>  * py-test-xdist (new)
> 
> All tests passing.
> 
> In terms of dependent ports, we have:
> 
> audio/fookebox
> databases/py-flask-sqlalchemy
> databases/py-sqlalchemy-migrate
> devel/py-buildbot
> devel/py-texscythe
> games/childsplay
> 
> I have only tested py-texscythe, which -- whilst it does lots and lots
> of SQL queries -- does not cover much of the sqlalchemy functionality.
> 
> What do people reckon -- get it in (after the above deps are in) and see
> what breaks?

Get it in, we'll handle the (eventual) breakage afterwards -
py-sqlalchemy-migrate is only used by py-buildbot, and an upcoming
py-twisted update by eric will probably disturb buildbot too, so i'll
have to spend some time on this anyway.

Landry

UPDATE: databases/py-sqlalchemy

2016-08-31 Thread Edd Barrett 
This brings our old py-sqlalchemy up to the latest release.

It depends (directly or indirectly) on the following (all posted to
ports@):

 * py-sqlite2 (update)
 * py-execnet (new)
 * py-apipkg (new)
 * py-test-xdist (new)

All tests passing.

In terms of dependent ports, we have:

audio/fookebox
databases/py-flask-sqlalchemy
databases/py-sqlalchemy-migrate
devel/py-buildbot
devel/py-texscythe
games/childsplay

I have only tested py-texscythe, which -- whilst it does lots and lots
of SQL queries -- does not cover much of the sqlalchemy functionality.

What do people reckon -- get it in (after the above deps are in) and see
what breaks?

OK?


Index: Makefile
===
RCS file: /home/edd/cvsync/ports/databases/py-sqlalchemy/Makefile,v
retrieving revision 1.30
diff -u -p -r1.30 Makefile
--- Makefile5 Mar 2016 22:46:59 -   1.30
+++ Makefile31 Aug 2016 15:36:04 -
@@ -1,11 +1,10 @@
-# $OpenBSD: Makefile,v 1.30 2016/03/05 22:46:59 kirby Exp $
+# $OpenBSD: Makefile,v 1.26 2013/03/11 02:52:07 espie Exp $
 
 COMMENT =  database toolkit for Python
 
-MODPY_EGG_VERSION =0.7.1
+MODPY_EGG_VERSION =1.0.14
 DISTNAME = SQLAlchemy-${MODPY_EGG_VERSION}
 PKGNAME =  py-sqlalchemy-${MODPY_EGG_VERSION:S/p/./}
-REVISION = 5
 
 CATEGORIES =   databases
 
@@ -23,9 +22,13 @@ MODPY_PI =   Yes
 
 MAKE_ENV +=PYTHONPATH=.
 
+RUN_DEPENDS += devel/py-apipkg
+
 # Other DB connectors would work, too.
-TEST_DEPENDS = databases/py-sqlite2 \
-   devel/py-nose
+TEST_DEPENDS = ${RUN_DEPENDS} \
+   databases/py-sqlite2>=2.8.3 \
+   devel/py-test-xdist \
+   devel/py-mock
 
 post-install:
${INSTALL_DATA_DIR} ${PREFIX}/share/doc/py-sqlalchemy
Index: distinfo
===
RCS file: /home/edd/cvsync/ports/databases/py-sqlalchemy/distinfo,v
retrieving revision 1.18
diff -u -p -r1.18 distinfo
--- distinfo5 Mar 2016 22:46:59 -   1.18
+++ distinfo31 Aug 2016 12:46:58 -
@@ -1,2 +1,2 @@
-SHA256 (SQLAlchemy-0.7.1.tar.gz) = XvldGcMajNOQXGl74KfpTnCrGSbs1BWcPmwc8B/DxJI=
-SIZE (SQLAlchemy-0.7.1.tar.gz) = 2341426
+SHA256 (SQLAlchemy-1.0.14.tar.gz) = 
2k0aOcHpnH/swqqjoFAJS2qnE03n2J935iFuer0XBbM=
+SIZE (SQLAlchemy-1.0.14.tar.gz) = 4765726
Index: patches/patch-setup_cfg
===
RCS file: 
/home/edd/cvsync/ports/databases/py-sqlalchemy/patches/patch-setup_cfg,v
retrieving revision 1.2
diff -u -p -r1.2 patch-setup_cfg
--- patches/patch-setup_cfg 5 Mar 2016 22:46:59 -   1.2
+++ patches/patch-setup_cfg 18 Mar 2016 22:37:04 -
@@ -1,7 +1,6 @@
-$OpenBSD: patch-setup_cfg,v 1.2 2016/03/05 22:46:59 kirby Exp $
-
 Disable configuration option not supported by nose.
 
+$OpenBSD: patch-setup_cfg,v 1.1 2010/05/24 16:42:44 wcmaier Exp $
 --- setup.cfg.orig Tue May  4 07:50:47 2010
 +++ setup.cfg  Tue May  4 07:50:49 2010
 @@ -5,6 +5,6 @@ tag_svn_revision = 0
Index: pkg/PLIST
===
RCS file: /home/edd/cvsync/ports/databases/py-sqlalchemy/pkg/PLIST,v
retrieving revision 1.11
diff -u -p -r1.11 PLIST
--- pkg/PLIST   27 May 2011 10:39:37 -  1.11
+++ pkg/PLIST   31 Aug 2016 12:46:58 -
@@ -12,53 +12,28 @@ lib/python${MODPY_VERSION}/site-packages
 lib/python${MODPY_VERSION}/site-packages/sqlalchemy/connectors/__init__.pyc
 lib/python${MODPY_VERSION}/site-packages/sqlalchemy/connectors/mxodbc.py
 lib/python${MODPY_VERSION}/site-packages/sqlalchemy/connectors/mxodbc.pyc
-lib/python${MODPY_VERSION}/site-packages/sqlalchemy/connectors/mysqldb.py
-lib/python${MODPY_VERSION}/site-packages/sqlalchemy/connectors/mysqldb.pyc
 lib/python${MODPY_VERSION}/site-packages/sqlalchemy/connectors/pyodbc.py
 lib/python${MODPY_VERSION}/site-packages/sqlalchemy/connectors/pyodbc.pyc
 lib/python${MODPY_VERSION}/site-packages/sqlalchemy/connectors/zxJDBC.py
 lib/python${MODPY_VERSION}/site-packages/sqlalchemy/connectors/zxJDBC.pyc
 lib/python${MODPY_VERSION}/site-packages/sqlalchemy/cprocessors.so
 lib/python${MODPY_VERSION}/site-packages/sqlalchemy/cresultproxy.so
+lib/python${MODPY_VERSION}/site-packages/sqlalchemy/cutils.so
 lib/python${MODPY_VERSION}/site-packages/sqlalchemy/databases/
 lib/python${MODPY_VERSION}/site-packages/sqlalchemy/databases/__init__.py
 lib/python${MODPY_VERSION}/site-packages/sqlalchemy/databases/__init__.pyc
 lib/python${MODPY_VERSION}/site-packages/sqlalchemy/dialects/
 lib/python${MODPY_VERSION}/site-packages/sqlalchemy/dialects/__init__.py
 lib/python${MODPY_VERSION}/site-packages/sqlalchemy/dialects/__init__.pyc
-lib/python${MODPY_VERSION}/site-packages/sqlalchemy/dialects/access/
-lib/python${MODPY_VERSION}/site-packages/sqlalchemy/dialects/access/__init__.py

[Update]databases/py-sqlalchemy

2011-08-01 Thread wen heping 
Hi,

   Here is an update of databases/py-sqlalchemy to 0.7.2.

   Tested OK and regress OK on Loongson.

   Comments? OK?

wen




cvs server: Diffing py-sqlalchemy
Index: py-sqlalchemy/Makefile
===
RCS file: /cvs/ports/databases/py-sqlalchemy/Makefile,v
retrieving revision 1.23
diff -u -p -r1.23 Makefile
--- py-sqlalchemy/Makefile  14 Jul 2011 14:36:34 -  1.23
+++ py-sqlalchemy/Makefile  1 Aug 2011 12:31:09 -
@@ -2,7 +2,7 @@

 COMMENT =  database toolkit for Python

-MODPY_EGG_VERSION =0.7.1
+MODPY_EGG_VERSION =0.7.2
 DISTNAME = SQLAlchemy-${MODPY_EGG_VERSION}
 PKGNAME =  py-sqlalchemy-${MODPY_EGG_VERSION:S/p/./}

Index: py-sqlalchemy/distinfo
===
RCS file: /cvs/ports/databases/py-sqlalchemy/distinfo,v
retrieving revision 1.16
diff -u -p -r1.16 distinfo
--- py-sqlalchemy/distinfo  14 Jul 2011 14:36:34 -  1.16
+++ py-sqlalchemy/distinfo  1 Aug 2011 12:31:09 -
@@ -1,5 +1,5 @@
-MD5 (SQLAlchemy-0.7.1.tar.gz) = duLh5IuAR/HKcCPxQzdK7w==
-RMD160 (SQLAlchemy-0.7.1.tar.gz) = /91dE3uOp6a2B4hnjWKgz9sRza4=
-SHA1 (SQLAlchemy-0.7.1.tar.gz) = WL3uLbsznnfPXvcW/DtSqC7Bz04=
-SHA256 (SQLAlchemy-0.7.1.tar.gz) = 7t0tY9ZATZu+PExqY6VELSwmULhi+cEPchz65Kc10Fo=
-SIZE (SQLAlchemy-0.7.1.tar.gz) = 2341398
+MD5 (SQLAlchemy-0.7.2.tar.gz) = I0SUgA8qCsOtfAbg/6RkHg==
+RMD160 (SQLAlchemy-0.7.2.tar.gz) = XScmm0kFmxbRfTdcI0v4juUz/bM=
+SHA1 (SQLAlchemy-0.7.2.tar.gz) = 5B6CK6S3KK4TlTLYS7uLUEP7kRY=
+SHA256 (SQLAlchemy-0.7.2.tar.gz) = ntCRl85kZXOLe7n5FT2KHjkiVrm28UT5vu2UszE83do=
+SIZE (SQLAlchemy-0.7.2.tar.gz) = 2380948
cvs server: Diffing py-sqlalchemy/patches
cvs server: Diffing py-sqlalchemy/pkg
Index: py-sqlalchemy/pkg/PLIST
===
RCS file: /cvs/ports/databases/py-sqlalchemy/pkg/PLIST,v
retrieving revision 1.11
diff -u -p -r1.11 PLIST
--- py-sqlalchemy/pkg/PLIST 27 May 2011 10:39:37 -  1.11
+++ py-sqlalchemy/pkg/PLIST 1 Aug 2011 12:31:09 -
@@ -427,6 +427,7 @@ share/doc/py-sqlalchemy/build/templates/
 share/doc/py-sqlalchemy/build/templates/static_base.mako
 share/doc/py-sqlalchemy/build/testdocs.py
 share/doc/py-sqlalchemy/build/texinputs/
+share/doc/py-sqlalchemy/build/texinputs/Makefile
 share/doc/py-sqlalchemy/build/texinputs/sphinx.sty
 share/doc/py-sqlalchemy/contents.html
 share/doc/py-sqlalchemy/copyright.html
@@ -551,6 +552,7 @@ share/examples/py-sqlalchemy/sharding/__
 share/examples/py-sqlalchemy/sharding/attribute_shard.py
 share/examples/py-sqlalchemy/versioning/
 share/examples/py-sqlalchemy/versioning/__init__.py
+share/examples/py-sqlalchemy/versioning/_lib.py
 share/examples/py-sqlalchemy/versioning/history_meta.py
 share/examples/py-sqlalchemy/versioning/test_versioning.py
 share/examples/py-sqlalchemy/vertical/

UPDATE: databases/py-sqlalchemy

2011-07-14 Thread Benoit Lecocq 

Hi,

This diff updates py-sqlalchemy to the latest release 0.7.1.
Tested on amd64, regression OK.

Maintainer timeout.

Comments ? OK ?

Cheers,
benoit
Index: Makefile
===
RCS file: /cvs/ports/databases/py-sqlalchemy/Makefile,v
retrieving revision 1.22
diff -u -r1.22 Makefile
--- Makefile8 Jun 2011 17:33:59 -   1.22
+++ Makefile14 Jul 2011 13:38:55 -
@@ -2,10 +2,9 @@
 
 COMMENT =  database toolkit for Python
 
-MODPY_EGG_VERSION =0.7.0
+MODPY_EGG_VERSION =0.7.1
 DISTNAME = SQLAlchemy-${MODPY_EGG_VERSION}
 PKGNAME =  py-sqlalchemy-${MODPY_EGG_VERSION:S/p/./}
-REVISION = 0
 
 CATEGORIES =   databases
 
Index: distinfo
===
RCS file: /cvs/ports/databases/py-sqlalchemy/distinfo,v
retrieving revision 1.15
diff -u -r1.15 distinfo
--- distinfo27 May 2011 10:39:37 -  1.15
+++ distinfo14 Jul 2011 13:38:55 -
@@ -1,5 +1,5 @@
-MD5 (SQLAlchemy-0.7.0.tar.gz) = 7r5hxAEenWcYbtXlXTfFcA==
-RMD160 (SQLAlchemy-0.7.0.tar.gz) = zPkQDGB+SI6+MwR4NmxpoONd20k=
-SHA1 (SQLAlchemy-0.7.0.tar.gz) = zoCKuKo3OPyudY2+cIfsQYVPnZI=
-SHA256 (SQLAlchemy-0.7.0.tar.gz) = E3U3cy0Iw1O9y+4wrs9hbdzhgV8yVgqOGIdLB3WOb8M=
-SIZE (SQLAlchemy-0.7.0.tar.gz) = 2318728
+MD5 (SQLAlchemy-0.7.1.tar.gz) = duLh5IuAR/HKcCPxQzdK7w==
+RMD160 (SQLAlchemy-0.7.1.tar.gz) = /91dE3uOp6a2B4hnjWKgz9sRza4=
+SHA1 (SQLAlchemy-0.7.1.tar.gz) = WL3uLbsznnfPXvcW/DtSqC7Bz04=
+SHA256 (SQLAlchemy-0.7.1.tar.gz) = 7t0tY9ZATZu+PExqY6VELSwmULhi+cEPchz65Kc10Fo=
+SIZE (SQLAlchemy-0.7.1.tar.gz) = 2341398

Re: [Update] databases/py-sqlalchemy

2011-05-26 Thread wen heping 
2011/5/26 Jasper Lievisse Adriaanse jas...@openbsd.org:
 On Sat, May 21, 2011 at 09:34:17PM +0800, wen heping wrote:
 Hi,

     Here I resubmitt the update of databases/py-sqlalchemy to 0.7.0.

     Tested OK on Loongson and regress test OK too.

      patches/patch-setup_py is no more needed.

      Comments? OK ?

 wen


 2011/4/7 Will Maier willma...@ml1.net:
  Hi Wen-
 
  On Wed, Apr 06, 2011 at 09:50:56PM +0800, wen heping wrote:
  ??Here's an update of databases/py-sqlalchemy to 0.6.6
 
  ??Tested on loongson OK. .
  ?? ?? ?? ?? ?? ?? 
  Awesome. ;)
 
  The diff looks good to me; I'll test it a bit and then commit.
 
  Thanks!
 
  --
 
  Will Maier
  http://will.m.aier.us/
 
 Could you please have a look at the failing regress tests for py-exlier?


Hi,

   You can use this patch to fix the regress fail of databases/py-elixir:

--- test_options.py.origThu May 26 22:36:39 2011
+++ test_options.py Thu May 26 22:37:17 2011
@@ -4,7 +4,7 @@

 from sqlalchemy import UniqueConstraint, create_engine, Column
 from sqlalchemy.orm import scoped_session, sessionmaker
-from sqlalchemy.exceptions import SQLError, ConcurrentModificationError
+from sqlalchemy.exceptions import DBAPIError, ConcurrentModificationError
 from elixir import *

 class TestOptions(object):
@@ -225,7 +225,7 @@
 raised = False
 try:
 session.commit()
-except SQLError:
+except DBAPIError:
 raised = True

 assert raised
@@ -258,7 +258,7 @@
 raised = False
 try:
 session.commit()
-except SQLError:
+except DBAPIError:
 raised = True

 assert raised


But I shall point:
1) py-elixir fail regress was not caused by the update of py-sqlalchemy,
from sqlalchemy-0.6.0, py-elixir regress fail.
 2) now there is py-elixir-0.7.1(0.7.0 in OpenBSD portstree),
which removed these regress test file
 3) py-elixir had been inactive for about 2 years.

  BTW, Jasper@, would you commit p5-POE related ports which you
did not finished from last commit? Some of them had newer version.


Regards,
wen

Re: [Update] databases/py-sqlalchemy

2011-05-25 Thread Jasper Lievisse Adriaanse 
On Sat, May 21, 2011 at 09:34:17PM +0800, wen heping wrote:
 Hi,
 
 Here I resubmitt the update of databases/py-sqlalchemy to 0.7.0.
 
 Tested OK on Loongson and regress test OK too.
 
  patches/patch-setup_py is no more needed.
 
  Comments? OK ?
 
 wen
 
 
 2011/4/7 Will Maier willma...@ml1.net:
  Hi Wen-
 
  On Wed, Apr 06, 2011 at 09:50:56PM +0800, wen heping wrote:
  ??Here's an update of databases/py-sqlalchemy to 0.6.6
 
  ??Tested on loongson OK. .
  ?? ?? ?? ?? ?? ?? 
  Awesome. ;)
 
  The diff looks good to me; I'll test it a bit and then commit.
 
  Thanks!
 
  --
 
  Will Maier
  http://will.m.aier.us/
 
Could you please have a look at the failing regress tests for py-exlier? 

 Index: py-sqlalchemy/Makefile
 ===
 RCS file: /cvs/ports/databases/py-sqlalchemy/Makefile,v
 retrieving revision 1.20
 diff -u -r1.20 Makefile
 --- py-sqlalchemy/Makefile15 Nov 2010 00:22:53 -  1.20
 +++ py-sqlalchemy/Makefile21 May 2011 13:19:02 -
 @@ -2,7 +2,7 @@
  
  COMMENT =database toolkit for Python
  
 -MODPY_EGG_VERSION =  0.6.3
 +MODPY_EGG_VERSION =  0.7.0
  DISTNAME =   SQLAlchemy-${MODPY_EGG_VERSION}
  PKGNAME =py-sqlalchemy-${MODPY_EGG_VERSION:S/p/./}
  
 @@ -38,7 +38,6 @@
   pax -rw * ${PREFIX}/share/examples/py-sqlalchemy
  
  do-regress:
 - ${_MODPY_CMD} develop -d.
 - @cd ${WRKSRC}  ${MAKE_ENV} nosetests
 + @cd ${WRKSRC}  ${MODPY_BIN} setup.py test
  
  .include bsd.port.mk
 Index: py-sqlalchemy/distinfo
 ===
 RCS file: /cvs/ports/databases/py-sqlalchemy/distinfo,v
 retrieving revision 1.14
 diff -u -r1.14 distinfo
 --- py-sqlalchemy/distinfo6 Sep 2010 21:55:57 -   1.14
 +++ py-sqlalchemy/distinfo21 May 2011 13:19:02 -
 @@ -1,5 +1,5 @@
 -MD5 (SQLAlchemy-0.6.3.tar.gz) = EDvcFWqVKRowKsxCwTa/fQ==
 -RMD160 (SQLAlchemy-0.6.3.tar.gz) = RP7pH91TxcA4nO5dM1NYzqawOcc=
 -SHA1 (SQLAlchemy-0.6.3.tar.gz) = eQ23wzZ10zYzeRdzpXRq3eBY6m4=
 -SHA256 (SQLAlchemy-0.6.3.tar.gz) = 
 M+W3xpHzsHuGB5kWYZCUTqmQjNCceqe2bA6HG2NAfJs=
 -SIZE (SQLAlchemy-0.6.3.tar.gz) = 1891372
 +MD5 (SQLAlchemy-0.7.0.tar.gz) = 7r5hxAEenWcYbtXlXTfFcA==
 +RMD160 (SQLAlchemy-0.7.0.tar.gz) = zPkQDGB+SI6+MwR4NmxpoONd20k=
 +SHA1 (SQLAlchemy-0.7.0.tar.gz) = zoCKuKo3OPyudY2+cIfsQYVPnZI=
 +SHA256 (SQLAlchemy-0.7.0.tar.gz) = 
 E3U3cy0Iw1O9y+4wrs9hbdzhgV8yVgqOGIdLB3WOb8M=
 +SIZE (SQLAlchemy-0.7.0.tar.gz) = 2318728
 Index: py-sqlalchemy/pkg/PLIST
 ===
 RCS file: /cvs/ports/databases/py-sqlalchemy/pkg/PLIST,v
 retrieving revision 1.10
 diff -u -r1.10 PLIST
 --- py-sqlalchemy/pkg/PLIST   6 Sep 2010 21:55:57 -   1.10
 +++ py-sqlalchemy/pkg/PLIST   21 May 2011 13:19:05 -
 @@ -1,9 +1,8 @@
 -@comment $OpenBSD: PLIST,v 1.10 2010/09/06 21:55:57 fgsch Exp $
 +@comment $OpenBSD$
  
 lib/python${MODPY_VERSION}/site-packages/SQLAlchemy-${MODPY_EGG_VERSION}-py${MODPY_VERSION}.egg-info/
  
 lib/python${MODPY_VERSION}/site-packages/SQLAlchemy-${MODPY_EGG_VERSION}-py${MODPY_VERSION}.egg-info/PKG-INFO
  
 lib/python${MODPY_VERSION}/site-packages/SQLAlchemy-${MODPY_EGG_VERSION}-py${MODPY_VERSION}.egg-info/SOURCES.txt
  
 lib/python${MODPY_VERSION}/site-packages/SQLAlchemy-${MODPY_EGG_VERSION}-py${MODPY_VERSION}.egg-info/dependency_links.txt
 -lib/python${MODPY_VERSION}/site-packages/SQLAlchemy-${MODPY_EGG_VERSION}-py${MODPY_VERSION}.egg-info/entry_points.txt
  
 lib/python${MODPY_VERSION}/site-packages/SQLAlchemy-${MODPY_EGG_VERSION}-py${MODPY_VERSION}.egg-info/top_level.txt
  lib/python${MODPY_VERSION}/site-packages/sqlalchemy/
  lib/python${MODPY_VERSION}/site-packages/sqlalchemy/__init__.py
 @@ -13,6 +12,8 @@
  lib/python${MODPY_VERSION}/site-packages/sqlalchemy/connectors/__init__.pyc
  lib/python${MODPY_VERSION}/site-packages/sqlalchemy/connectors/mxodbc.py
  lib/python${MODPY_VERSION}/site-packages/sqlalchemy/connectors/mxodbc.pyc
 +lib/python${MODPY_VERSION}/site-packages/sqlalchemy/connectors/mysqldb.py
 +lib/python${MODPY_VERSION}/site-packages/sqlalchemy/connectors/mysqldb.pyc
  lib/python${MODPY_VERSION}/site-packages/sqlalchemy/connectors/pyodbc.py
  lib/python${MODPY_VERSION}/site-packages/sqlalchemy/connectors/pyodbc.pyc
  lib/python${MODPY_VERSION}/site-packages/sqlalchemy/connectors/zxJDBC.py
 @@ -30,6 +31,13 @@
  
 lib/python${MODPY_VERSION}/site-packages/sqlalchemy/dialects/access/__init__.pyc
  lib/python${MODPY_VERSION}/site-packages/sqlalchemy/dialects/access/base.py
  lib/python${MODPY_VERSION}/site-packages/sqlalchemy/dialects/access/base.pyc
 +lib/python${MODPY_VERSION}/site-packages/sqlalchemy/dialects/drizzle/
 +lib/python${MODPY_VERSION}/site-packages/sqlalchemy/dialects/drizzle/__init__.py
 +lib/python${MODPY_VERSION}/site-packages/sqlalchemy/dialects/drizzle/__init__.pyc

[Update] databases/py-sqlalchemy

2011-04-06 Thread wen heping 
Hi,

 Here's an update of databases/py-sqlalchemy to 0.6.6

 Tested on loongson OK. .

  Comments? Ok?

wen
diff -urN py-sqlalchemy/Makefile py-sqlalchemy.new/Makefile
--- py-sqlalchemy/Makefile  Mon Nov 15 08:22:53 2010
+++ py-sqlalchemy.new/Makefile  Wed Apr  6 21:22:26 2011
@@ -2,7 +2,7 @@
 
 COMMENT =  database toolkit for Python
 
-MODPY_EGG_VERSION =0.6.3
+MODPY_EGG_VERSION =0.6.6
 DISTNAME = SQLAlchemy-${MODPY_EGG_VERSION}
 PKGNAME =  py-sqlalchemy-${MODPY_EGG_VERSION:S/p/./}
 
diff -urN py-sqlalchemy/distinfo py-sqlalchemy.new/distinfo
--- py-sqlalchemy/distinfo  Tue Sep  7 05:55:57 2010
+++ py-sqlalchemy.new/distinfo  Wed Apr  6 21:23:06 2011
@@ -1,5 +1,5 @@
-MD5 (SQLAlchemy-0.6.3.tar.gz) = EDvcFWqVKRowKsxCwTa/fQ==
-RMD160 (SQLAlchemy-0.6.3.tar.gz) = RP7pH91TxcA4nO5dM1NYzqawOcc=
-SHA1 (SQLAlchemy-0.6.3.tar.gz) = eQ23wzZ10zYzeRdzpXRq3eBY6m4=
-SHA256 (SQLAlchemy-0.6.3.tar.gz) = M+W3xpHzsHuGB5kWYZCUTqmQjNCceqe2bA6HG2NAfJs=
-SIZE (SQLAlchemy-0.6.3.tar.gz) = 1891372
+MD5 (SQLAlchemy-0.6.6.tar.gz) = NZ8CJCxS6SqogcNsjjcg2A==
+RMD160 (SQLAlchemy-0.6.6.tar.gz) = 0NIV7ttF0V9/f+BFnq6TrXITIlw=
+SHA1 (SQLAlchemy-0.6.6.tar.gz) = btmQFBcQuVpYOz4iy9XA7v9QdsU=
+SHA256 (SQLAlchemy-0.6.6.tar.gz) = FKiBqKDtZiOht6vMwSIQMrYE2rG4AlA4O4TEa8xK0kY=
+SIZE (SQLAlchemy-0.6.6.tar.gz) = 2084833
diff -urN py-sqlalchemy/patches/patch-setup_cfg 
py-sqlalchemy.new/patches/patch-setup_cfg
--- py-sqlalchemy/patches/patch-setup_cfg   Tue May 25 00:42:44 2010
+++ py-sqlalchemy.new/patches/patch-setup_cfg   Wed Apr  6 21:27:23 2011
@@ -1,13 +1,9 @@
-Disable configuration option not supported by nose.
-
-$OpenBSD: patch-setup_cfg,v 1.1 2010/05/24 16:42:44 wcmaier Exp $
 setup.cfg.orig Tue May  4 07:50:47 2010
-+++ setup.cfg  Tue May  4 07:50:49 2010
-@@ -5,6 +5,6 @@ tag_svn_revision = 0
- 
+--- setup.cfg.orig Sun Jan  9 06:38:21 2011
 setup.cfg  Wed Apr  6 21:26:27 2011
+@@ -6,5 +6,5 @@
  [nosetests]
+ with-sqlalchemy = true
  exclude = ^examples
 -first-package-wins = true
 +#first-package-wins = true
- with-sqlalchemy = true
  
diff -urN py-sqlalchemy/pkg/PLIST py-sqlalchemy.new/pkg/PLIST
--- py-sqlalchemy/pkg/PLIST Tue Sep  7 05:55:57 2010
+++ py-sqlalchemy.new/pkg/PLIST Wed Apr  6 21:29:23 2011
@@ -1,4 +1,4 @@
-@comment $OpenBSD: PLIST,v 1.10 2010/09/06 21:55:57 fgsch Exp $
+@comment $OpenBSD$
 
lib/python${MODPY_VERSION}/site-packages/SQLAlchemy-${MODPY_EGG_VERSION}-py${MODPY_VERSION}.egg-info/
 
lib/python${MODPY_VERSION}/site-packages/SQLAlchemy-${MODPY_EGG_VERSION}-py${MODPY_VERSION}.egg-info/PKG-INFO
 
lib/python${MODPY_VERSION}/site-packages/SQLAlchemy-${MODPY_EGG_VERSION}-py${MODPY_VERSION}.egg-info/SOURCES.txt
@@ -234,14 +234,10 @@
 lib/python${MODPY_VERSION}/site-packages/sqlalchemy/test/__init__.pyc
 lib/python${MODPY_VERSION}/site-packages/sqlalchemy/test/assertsql.py
 lib/python${MODPY_VERSION}/site-packages/sqlalchemy/test/assertsql.pyc
-lib/python${MODPY_VERSION}/site-packages/sqlalchemy/test/config.py
-lib/python${MODPY_VERSION}/site-packages/sqlalchemy/test/config.pyc
 lib/python${MODPY_VERSION}/site-packages/sqlalchemy/test/engines.py
 lib/python${MODPY_VERSION}/site-packages/sqlalchemy/test/engines.pyc
 lib/python${MODPY_VERSION}/site-packages/sqlalchemy/test/entities.py
 lib/python${MODPY_VERSION}/site-packages/sqlalchemy/test/entities.pyc
-lib/python${MODPY_VERSION}/site-packages/sqlalchemy/test/noseplugin.py
-lib/python${MODPY_VERSION}/site-packages/sqlalchemy/test/noseplugin.pyc
 lib/python${MODPY_VERSION}/site-packages/sqlalchemy/test/orm.py
 lib/python${MODPY_VERSION}/site-packages/sqlalchemy/test/orm.pyc
 lib/python${MODPY_VERSION}/site-packages/sqlalchemy/test/pickleable.py
@@ -262,60 +258,67 @@
 lib/python${MODPY_VERSION}/site-packages/sqlalchemy/types.pyc
 lib/python${MODPY_VERSION}/site-packages/sqlalchemy/util.py
 lib/python${MODPY_VERSION}/site-packages/sqlalchemy/util.pyc
+lib/python${MODPY_VERSION}/site-packages/sqlalchemy_nose/
+lib/python${MODPY_VERSION}/site-packages/sqlalchemy_nose/__init__.py
+lib/python${MODPY_VERSION}/site-packages/sqlalchemy_nose/__init__.pyc
+lib/python${MODPY_VERSION}/site-packages/sqlalchemy_nose/config.py
+lib/python${MODPY_VERSION}/site-packages/sqlalchemy_nose/config.pyc
+lib/python${MODPY_VERSION}/site-packages/sqlalchemy_nose/noseplugin.py
+lib/python${MODPY_VERSION}/site-packages/sqlalchemy_nose/noseplugin.pyc
 share/doc/py-sqlalchemy/
 share/doc/py-sqlalchemy/_images/
-share/doc/py-sqlalchemy/_images/sqla_arch_small.jpg
+share/doc/py-sqlalchemy/_images/sqla_arch_small.png
+share/doc/py-sqlalchemy/_images/sqla_engine_arch.png
 share/doc/py-sqlalchemy/_sources/
-share/doc/py-sqlalchemy/_sources/dbengine.txt
-share/doc/py-sqlalchemy/_sources/examples.txt
+share/doc/py-sqlalchemy/_sources/copyright.txt
+share/doc/py-sqlalchemy/_sources/core/
+share/doc/py-sqlalchemy/_sources/core/compiler.txt
+share/doc/py-sqlalchemy/_sources/core/connections.txt

UPDATE: databases/py-sqlalchemy

2010-05-04 Thread Will Maier 
Hi all-

The diff below updates SQLAlchemy to 0.6.0. The few failures in regress don't
seem to impact real-world use, but please let me know if you think they'll pose
a problem. Also, I don't use SQLALchemy any more -- would anyone out there like
to take it on as MAINTAINER?

Thanks!

-- 

o--{ Will Maier }--o
| web:...http://www.lfod.us/ | email.willma...@ml1.net |
*-[ BSD: Live Free or Die ]*

Index: Makefile
===
RCS file: /cvs/ports/databases/py-sqlalchemy/Makefile,v
retrieving revision 1.16
diff -N -u -p Makefile
--- Makefile4 Jun 2009 19:49:17 -   1.16
+++ Makefile4 May 2010 12:54:29 -
@@ -2,7 +2,7 @@
 
 COMMENT =  database toolkit for Python
 
-MODPY_EGG_VERSION =0.5.4p2
+MODPY_EGG_VERSION =0.6.0
 DISTNAME = SQLAlchemy-${MODPY_EGG_VERSION}
 PKGNAME =  py-sqlalchemy-${MODPY_EGG_VERSION:S/p/./}
 
@@ -24,8 +24,11 @@ MODULES =lang/python
 MODPY_SETUPTOOLS = Yes
 PKG_ARCH = *
 
+MAKE_ENV +=PYTHONPATH=.
+
 # Other DB connectors would work, too.
-REGRESS_DEPENDS =  ::databases/py-sqlite2
+REGRESS_DEPENDS =  ::databases/py-sqlite2 \
+   ::devel/py-nose
 
 post-install:
${INSTALL_DATA_DIR} ${PREFIX}/share/doc/py-sqlalchemy
@@ -35,7 +38,7 @@ post-install:
pax -rw * ${PREFIX}/share/examples/py-sqlalchemy
 
 do-regress:
-   @cd ${WRKSRC}  ${MAKE_ENV} \
-   PYTHONPATH=test ${MODPY_BIN} test/alltests.py --db sqlite
+   ${_MODPY_CMD} develop -d.
+   @cd ${WRKSRC}  ${MAKE_ENV} nosetests
 
 .include bsd.port.mk
Index: distinfo
===
RCS file: /cvs/ports/databases/py-sqlalchemy/distinfo,v
retrieving revision 1.12
diff -N -u -p distinfo
--- distinfo4 Jun 2009 19:49:17 -   1.12
+++ distinfo4 May 2010 12:54:29 -
@@ -1,5 +1,5 @@
-MD5 (SQLAlchemy-0.5.4p2.tar.gz) = QI37CGgBirwWVLF6L6+vcA==
-RMD160 (SQLAlchemy-0.5.4p2.tar.gz) = aHnRTLNonlX4mSMcV8m7ZndqgyQ=
-SHA1 (SQLAlchemy-0.5.4p2.tar.gz) = oszKW82eRKFL8YDDmPmPjSwAP8Y=
-SHA256 (SQLAlchemy-0.5.4p2.tar.gz) = 
jRmJ4nAE5OB7PxdJhYfGl93Ke3bhc/Vk8uQl+xwU08g=
-SIZE (SQLAlchemy-0.5.4p2.tar.gz) = 1471063
+MD5 (SQLAlchemy-0.6.0.tar.gz) = V1wsp0LpqzwIw4TbxIYfhg==
+RMD160 (SQLAlchemy-0.6.0.tar.gz) = v+CwFgU2mJ5cCI7cdQdRp0NdxbI=
+SHA1 (SQLAlchemy-0.6.0.tar.gz) = A8aGyJIXjUc46c4pqQCRa5KV+Q0=
+SHA256 (SQLAlchemy-0.6.0.tar.gz) = 7VVSsGhfRgTy6dDPHblwEPKt9vE4if2ngP8wY5rO4bk=
+SIZE (SQLAlchemy-0.6.0.tar.gz) = 1830678
Index: patches/patch-setup_cfg
===
RCS file: patches/patch-setup_cfg
diff -N -u -p patches/patch-setup_cfg
--- /dev/null   4 May 2010 12:54:29 -
+++ patches/patch-setup_cfg 4 May 2010 12:54:29 -
@@ -0,0 +1,13 @@
+Disable configuration option not supported by nose.
+
+$OpenBSD$
+--- setup.cfg.orig Tue May  4 07:50:47 2010
 setup.cfg  Tue May  4 07:50:49 2010
+@@ -5,6 +5,6 @@ tag_svn_revision = 0
+ 
+ [nosetests]
+ exclude = ^examples
+-first-package-wins = true
++#first-package-wins = true
+ with-sqlalchemy = true
+ 
Index: patches/patch-setup_py
===
RCS file: /cvs/ports/databases/py-sqlalchemy/patches/Attic/patch-setup_py,v
diff -N -u -p patches/patch-setup_py
--- /dev/null   4 May 2010 12:54:29 -
+++ patches/patch-setup_py  4 May 2010 12:54:29 -
@@ -0,0 +1,49 @@
+Build cextensions.
+
+$OpenBSD$
+--- setup.py.orig  Sun Apr 18 18:10:46 2010
 setup.py   Tue May  4 07:38:32 2010
+@@ -7,7 +7,7 @@ Please see README for basic installation instructions.
+ # If using distutils (not distribute/setuptools),
+ # set this flag to True to compile C extensions.
+ # Otherwise use --with-cextensions
+-BUILD_CEXTENSIONS = False
++BUILD_CEXTENSIONS = True
+ 
+ import os
+ import sys
+@@ -31,8 +31,17 @@ except ImportError:
+ from distutils.core import setup, Extension
+ Feature = None
+ 
+-if Feature:
++if BUILD_CEXTENSIONS:
+ extra.update(
++ext_modules = [
++Extension('sqlalchemy.cprocessors',
++  sources=['lib/sqlalchemy/cextension/processors.c']),
++Extension('sqlalchemy.cresultproxy',
++  sources=['lib/sqlalchemy/cextension/resultproxy.c'])
++]
++)
++elif Feature:
++extra.update(
+ features = {'cextensions' : Feature(
+ optional C speed-enhancements,
+ standard = False,
+@@ -43,15 +52,6 @@ if Feature:
+sources=['lib/sqlalchemy/cextension/resultproxy.c'])
+ ],
+ )}
+-)
+-elif BUILD_CEXTENSIONS:
+-extra.update(
+-ext_modules = [
+-Extension('sqlalchemy.cprocessors',
+-

UPDATE: databases/py-sqlalchemy

2010-01-11 Thread Will Maier 
Hi all-

I'd like to commit this[0] (and below) py-sqlalchemy update soonish.
Substantially similar to one by Robert 
(thanks!). Note that regress requires nose as well as an invocation
of setup.py develop now.

Works fine on i386 for me -- anyone else want to test?

Thanks!

-- 

o--{ Will Maier }--o
| web:...http://www.lfod.us/ | email.willma...@ml1.net |
*-[ BSD: Live Free or Die ]*

Index: Makefile
===
RCS file: /cvs/ports/databases/py-sqlalchemy/Makefile,v
retrieving revision 1.16
diff -u Makefile
--- Makefile4 Jun 2009 19:49:17 -   1.16
+++ Makefile11 Jan 2010 22:13:44 -
@@ -2,7 +2,7 @@
 
 COMMENT =  database toolkit for Python
 
-MODPY_EGG_VERSION =0.5.4p2
+MODPY_EGG_VERSION =0.5.7
 DISTNAME = SQLAlchemy-${MODPY_EGG_VERSION}
 PKGNAME =  py-sqlalchemy-${MODPY_EGG_VERSION:S/p/./}
 
@@ -24,8 +24,11 @@
 MODPY_SETUPTOOLS = Yes
 PKG_ARCH = *
 
+MAKE_ENV +=PYTHONPATH=.
+
 # Other DB connectors would work, too.
-REGRESS_DEPENDS =  ::databases/py-sqlite2
+REGRESS_DEPENDS =  ::databases/py-sqlite2 \
+   ::devel/py-nose
 
 post-install:
${INSTALL_DATA_DIR} ${PREFIX}/share/doc/py-sqlalchemy
@@ -35,7 +38,7 @@
pax -rw * ${PREFIX}/share/examples/py-sqlalchemy
 
 do-regress:
-   @cd ${WRKSRC}  ${MAKE_ENV} \
-   PYTHONPATH=test ${MODPY_BIN} test/alltests.py --db sqlite
+   ${_MODPY_CMD} develop -d.
+   @cd ${WRKSRC}  ${MAKE_ENV} nosetests
 
 .include bsd.port.mk
Index: distinfo
===
RCS file: /cvs/ports/databases/py-sqlalchemy/distinfo,v
retrieving revision 1.12
diff -u distinfo
--- distinfo4 Jun 2009 19:49:17 -   1.12
+++ distinfo11 Jan 2010 22:13:44 -
@@ -1,5 +1,5 @@
-MD5 (SQLAlchemy-0.5.4p2.tar.gz) = QI37CGgBirwWVLF6L6+vcA==
-RMD160 (SQLAlchemy-0.5.4p2.tar.gz) = aHnRTLNonlX4mSMcV8m7ZndqgyQ=
-SHA1 (SQLAlchemy-0.5.4p2.tar.gz) = oszKW82eRKFL8YDDmPmPjSwAP8Y=
-SHA256 (SQLAlchemy-0.5.4p2.tar.gz) = 
jRmJ4nAE5OB7PxdJhYfGl93Ke3bhc/Vk8uQl+xwU08g=
-SIZE (SQLAlchemy-0.5.4p2.tar.gz) = 1471063
+MD5 (SQLAlchemy-0.5.7.tar.gz) = tqdhXsZ2H2YLIzWfOp2QKw==
+RMD160 (SQLAlchemy-0.5.7.tar.gz) = aJB/Gt6E9+BZ+5GmW37Qmq1c4xo=
+SHA1 (SQLAlchemy-0.5.7.tar.gz) = difN5Va9eVfU5p00LPsQFgOICCE=
+SHA256 (SQLAlchemy-0.5.7.tar.gz) = l+/zsAaM0PdqAppk3vqQjKaG3i15BPph8JmSfl9Djas=
+SIZE (SQLAlchemy-0.5.7.tar.gz) = 1542756
Index: pkg/PLIST
===
RCS file: /cvs/ports/databases/py-sqlalchemy/pkg/PLIST,v
retrieving revision 1.8
diff -u pkg/PLIST
--- pkg/PLIST   4 Jun 2009 19:49:17 -   1.8
+++ pkg/PLIST   11 Jan 2010 22:13:44 -
@@ -3,11 +3,13 @@
 
lib/python${MODPY_VERSION}/site-packages/SQLAlchemy-${MODPY_EGG_VERSION}-py${MODPY_VERSION}.egg-info/PKG-INFO
 
lib/python${MODPY_VERSION}/site-packages/SQLAlchemy-${MODPY_EGG_VERSION}-py${MODPY_VERSION}.egg-info/SOURCES.txt
 
lib/python${MODPY_VERSION}/site-packages/SQLAlchemy-${MODPY_EGG_VERSION}-py${MODPY_VERSION}.egg-info/dependency_links.txt
+lib/python${MODPY_VERSION}/site-packages/SQLAlchemy-${MODPY_EGG_VERSION}-py${MODPY_VERSION}.egg-info/entry_points.txt
 
lib/python${MODPY_VERSION}/site-packages/SQLAlchemy-${MODPY_EGG_VERSION}-py${MODPY_VERSION}.egg-info/top_level.txt
 lib/python${MODPY_VERSION}/site-packages/SQLAlchemy.egg-info/
 lib/python${MODPY_VERSION}/site-packages/SQLAlchemy.egg-info/PKG-INFO
 lib/python${MODPY_VERSION}/site-packages/SQLAlchemy.egg-info/SOURCES.txt
 
lib/python${MODPY_VERSION}/site-packages/SQLAlchemy.egg-info/dependency_links.txt
+lib/python${MODPY_VERSION}/site-packages/SQLAlchemy.egg-info/entry_points.txt
 lib/python${MODPY_VERSION}/site-packages/SQLAlchemy.egg-info/top_level.txt
 lib/python${MODPY_VERSION}/site-packages/sqlalchemy/
 lib/python${MODPY_VERSION}/site-packages/sqlalchemy/__init__.py
@@ -35,6 +37,8 @@
 lib/python${MODPY_VERSION}/site-packages/sqlalchemy/databases/oracle.pyc
 lib/python${MODPY_VERSION}/site-packages/sqlalchemy/databases/postgres.py
 lib/python${MODPY_VERSION}/site-packages/sqlalchemy/databases/postgres.pyc
+lib/python${MODPY_VERSION}/site-packages/sqlalchemy/databases/postgresql.py
+lib/python${MODPY_VERSION}/site-packages/sqlalchemy/databases/postgresql.pyc
 lib/python${MODPY_VERSION}/site-packages/sqlalchemy/databases/sqlite.py
 lib/python${MODPY_VERSION}/site-packages/sqlalchemy/databases/sqlite.pyc
 lib/python${MODPY_VERSION}/site-packages/sqlalchemy/databases/sybase.py
@@ -137,6 +141,29 @@
 lib/python${MODPY_VERSION}/site-packages/sqlalchemy/sql/util.pyc
 lib/python${MODPY_VERSION}/site-packages/sqlalchemy/sql/visitors.py
 lib/python${MODPY_VERSION}/site-packages/sqlalchemy/sql/visitors.pyc
+lib/python${MODPY_VERSION}/site-packages/sqlalchemy/test/

Re: UPDATE: databases/py-sqlalchemy

2010-01-11 Thread Federico G. Schwindt 
On Mon, Jan 11, 2010 at 04:19:18PM -0600, Will Maier wrote:
 Hi all-
 
 I'd like to commit this[0] (and below) py-sqlalchemy update soonish.
 Substantially similar to one by Robert 
 (thanks!). Note that regress requires nose as well as an invocation
 of setup.py develop now.
 
 Works fine on i386 for me -- anyone else want to test?

  i will test and come back to you asap.

  f.-

Re: UPDATE: databases/py-sqlalchemy

2010-01-11 Thread Robert 
On Mon, 11 Jan 2010 16:19:18 -0600
Will Maier willma...@ml1.net wrote:

Still works for me on amd64.
(Only tested amd64 and a local test set of about a years worth of
transaction fuzzing for my main app, as the port is basicly the same.)

  do-regress:
 - @cd ${WRKSRC}  ${MAKE_ENV} \
 - PYTHONPATH=test ${MODPY_BIN} test/alltests.py --db sqlite
 + ${_MODPY_CMD} develop -d.
 + @cd ${WRKSRC}  ${MAKE_ENV} nosetests

Those substitutions are much cuter, than what i did there.


- Robert

UPDATE: databases/py-sqlalchemy

2009-06-02 Thread Will Maier 
Hi all-

Please see below. I've tested it with py-elixir and py-turbogears, but
would be interested in other test reports. Changelog here:


http://www.sqlalchemy.org/trac/browser/sqlalchemy/tags/rel_0_5_4p2/CHANGES?format=raw

Thanks!

-- 

o--{ Will Maier }--o
| web:...http://www.lfod.us/ | email.willma...@ml1.net |
*-[ BSD: Live Free or Die ]*

Index: Makefile
===
RCS file: /cvs/ports/databases/py-sqlalchemy/Makefile,v
retrieving revision 1.15
diff -u -p -r1.15 Makefile
--- Makefile11 Apr 2009 13:50:57 -  1.15
+++ Makefile3 Jun 2009 02:42:40 -
@@ -2,7 +2,7 @@
 
 COMMENT =  database toolkit for Python
 
-MODPY_EGG_VERSION =0.5.3
+MODPY_EGG_VERSION =0.5.4p2
 DISTNAME = SQLAlchemy-${MODPY_EGG_VERSION}
 PKGNAME =  py-sqlalchemy-${MODPY_EGG_VERSION}
 
Index: distinfo
===
RCS file: /cvs/ports/databases/py-sqlalchemy/distinfo,v
retrieving revision 1.11
diff -u -p -r1.11 distinfo
--- distinfo11 Apr 2009 13:50:57 -  1.11
+++ distinfo3 Jun 2009 02:42:40 -
@@ -1,5 +1,5 @@
-MD5 (SQLAlchemy-0.5.3.tar.gz) = igOsk6ooqfTqXswFV+kJVA==
-RMD160 (SQLAlchemy-0.5.3.tar.gz) = bCQN88X0XqMbG6GoW96dqYv/uOM=
-SHA1 (SQLAlchemy-0.5.3.tar.gz) = Ck9QtpCulGwxiGFO7qbx5fAmgdk=
-SHA256 (SQLAlchemy-0.5.3.tar.gz) = rk+clVhqZLvab1l5NZ2i9OYh0HT53V4RajbDwUSURFA=
-SIZE (SQLAlchemy-0.5.3.tar.gz) = 1455432
+MD5 (SQLAlchemy-0.5.4p2.tar.gz) = QI37CGgBirwWVLF6L6+vcA==
+RMD160 (SQLAlchemy-0.5.4p2.tar.gz) = aHnRTLNonlX4mSMcV8m7ZndqgyQ=
+SHA1 (SQLAlchemy-0.5.4p2.tar.gz) = oszKW82eRKFL8YDDmPmPjSwAP8Y=
+SHA256 (SQLAlchemy-0.5.4p2.tar.gz) = 
jRmJ4nAE5OB7PxdJhYfGl93Ke3bhc/Vk8uQl+xwU08g=
+SIZE (SQLAlchemy-0.5.4p2.tar.gz) = 1471063
Index: pkg/PLIST
===
RCS file: /cvs/ports/databases/py-sqlalchemy/pkg/PLIST,v
retrieving revision 1.7
diff -u -p -r1.7 PLIST
--- pkg/PLIST   11 Apr 2009 13:50:57 -  1.7
+++ pkg/PLIST   3 Jun 2009 02:42:40 -
@@ -59,6 +59,8 @@ lib/python${MODPY_VERSION}/site-packages
 lib/python${MODPY_VERSION}/site-packages/sqlalchemy/ext/__init__.pyc
 lib/python${MODPY_VERSION}/site-packages/sqlalchemy/ext/associationproxy.py
 lib/python${MODPY_VERSION}/site-packages/sqlalchemy/ext/associationproxy.pyc
+lib/python${MODPY_VERSION}/site-packages/sqlalchemy/ext/compiler.py
+lib/python${MODPY_VERSION}/site-packages/sqlalchemy/ext/compiler.pyc
 lib/python${MODPY_VERSION}/site-packages/sqlalchemy/ext/declarative.py
 lib/python${MODPY_VERSION}/site-packages/sqlalchemy/ext/declarative.pyc
 lib/python${MODPY_VERSION}/site-packages/sqlalchemy/ext/orderinglist.py
@@ -102,6 +104,8 @@ lib/python${MODPY_VERSION}/site-packages
 lib/python${MODPY_VERSION}/site-packages/sqlalchemy/orm/session.pyc
 lib/python${MODPY_VERSION}/site-packages/sqlalchemy/orm/shard.py
 lib/python${MODPY_VERSION}/site-packages/sqlalchemy/orm/shard.pyc
+lib/python${MODPY_VERSION}/site-packages/sqlalchemy/orm/state.py
+lib/python${MODPY_VERSION}/site-packages/sqlalchemy/orm/state.pyc
 lib/python${MODPY_VERSION}/site-packages/sqlalchemy/orm/strategies.py
 lib/python${MODPY_VERSION}/site-packages/sqlalchemy/orm/strategies.pyc
 lib/python${MODPY_VERSION}/site-packages/sqlalchemy/orm/sync.py
@@ -163,6 +167,7 @@ share/doc/py-sqlalchemy/_sources/referen
 share/doc/py-sqlalchemy/_sources/reference/dialects/sybase.txt
 share/doc/py-sqlalchemy/_sources/reference/ext/
 share/doc/py-sqlalchemy/_sources/reference/ext/associationproxy.txt
+share/doc/py-sqlalchemy/_sources/reference/ext/compiler.txt
 share/doc/py-sqlalchemy/_sources/reference/ext/declarative.txt
 share/doc/py-sqlalchemy/_sources/reference/ext/index.txt
 share/doc/py-sqlalchemy/_sources/reference/ext/orderinglist.txt
@@ -225,6 +230,7 @@ share/doc/py-sqlalchemy/build/reference/
 share/doc/py-sqlalchemy/build/reference/dialects/sybase.rst
 share/doc/py-sqlalchemy/build/reference/ext/
 share/doc/py-sqlalchemy/build/reference/ext/associationproxy.rst
+share/doc/py-sqlalchemy/build/reference/ext/compiler.rst
 share/doc/py-sqlalchemy/build/reference/ext/declarative.rst
 share/doc/py-sqlalchemy/build/reference/ext/index.rst
 share/doc/py-sqlalchemy/build/reference/ext/orderinglist.rst
@@ -285,6 +291,7 @@ share/doc/py-sqlalchemy/reference/dialec
 share/doc/py-sqlalchemy/reference/dialects/sybase.html
 share/doc/py-sqlalchemy/reference/ext/
 share/doc/py-sqlalchemy/reference/ext/associationproxy.html
+share/doc/py-sqlalchemy/reference/ext/compiler.html
 share/doc/py-sqlalchemy/reference/ext/declarative.html
 share/doc/py-sqlalchemy/reference/ext/index.html
 share/doc/py-sqlalchemy/reference/ext/orderinglist.html

UPDATE: databases/py-sqlalchemy

2007-11-21 Thread Will Maier 
The attached patch updates databases/py-sqlalchemy from 0.3.7 to
0.4.1 (changes[0]). Due to upstream changes in the setuptools
configuration, patch-setup_py seems to be necessary to make the
build target work.

The port passes its regress tests and a small site using
py-turbogears (the only port which depends on py-sqlalchemy) worked
find with the 0.4.1 update.

Tested on -current/i386. Patch also available via HTTP:

http://www.lfod.us/files/ports/py-sqlalchemy-0_4_1.diff

Thanks!

diffstat:
4 files changed, 93 insertions(+), 38 deletions(-)
Makefile   |4 -
distinfo   |   10 ++--
patches/patch-setup_py |   13 ++
pkg/PLIST  |  104 
+---

[0] http://www.sqlalchemy.org/CHANGES

-- 

o--{ Will Maier }--o
| web:...http://www.lfod.us/ | [EMAIL PROTECTED] |
*--[ BSD Unix: Live Free or Die ]--*
diff --git a/Makefile b/Makefile
--- a/Makefile
+++ b/Makefile
@@ -2,9 +2,9 @@
 
 COMMENT=   database toolkit for Python
 
-V= 0.3.7
+V= 0.4.1
 DISTNAME=  SQLAlchemy-${V}
-PKGNAME=   py-sqlalchemy-${V}p0
+PKGNAME=   py-sqlalchemy-${V}
 
 CATEGORIES=databases lang/python
 
diff --git a/distinfo b/distinfo
--- a/distinfo
+++ b/distinfo
@@ -1,5 +1,5 @@ MD5 (SQLAlchemy-0.3.7.tar.gz) = 8zFGmKJw
-MD5 (SQLAlchemy-0.3.7.tar.gz) = 8zFGmKJw6Pxqaf6V6YzzTg==
-RMD160 (SQLAlchemy-0.3.7.tar.gz) = rrJKFCZsZ+9cn0znlbpODEhH6dQ=
-SHA1 (SQLAlchemy-0.3.7.tar.gz) = 9aB9vkxr+/9u9o6vmpNBnS/Q91U=
-SHA256 (SQLAlchemy-0.3.7.tar.gz) = PbK0UJVBzFaLvMERDwE8Yiy2SGcNBMxoYIX+n20cHBI=
-SIZE (SQLAlchemy-0.3.7.tar.gz) = 879706
+MD5 (SQLAlchemy-0.4.1.tar.gz) = vm/jGYBhQdV3+KsC+Qhwog==
+RMD160 (SQLAlchemy-0.4.1.tar.gz) = oLnkuQ18u8j2ZSJncyN6/IGZzWo=
+SHA1 (SQLAlchemy-0.4.1.tar.gz) = ytUYXooxARcMwW9cE+7R4PPUtHA=
+SHA256 (SQLAlchemy-0.4.1.tar.gz) = 7flCWdqu3mGCRlRCxNl1coObjMNPJZOzKklQ2Wwlfs0=
+SIZE (SQLAlchemy-0.4.1.tar.gz) = 1143337
diff --git a/patches/patch-setup_py b/patches/patch-setup_py
new file mode 100644
--- /dev/null
+++ b/patches/patch-setup_py
@@ -0,0 +1,13 @@
+$OpenBSD$
+--- setup.py.orig  Sun Nov 18 16:49:52 2007
 setup.py   Tue Nov 20 12:32:10 2007
+@@ -14,7 +14,8 @@ class build_py(_build_py):
+ def run(self):
+ init = path.join(self.build_lib, 'sqlalchemy', '__init__.py')
+ if path.exists(init):
+-os.unlink(init)
++#os.unlink(init)
++pass
+ _build_py.run(self)
+ _stamp_version(init)
+ self.byte_compile([init])
diff --git a/pkg/PLIST b/pkg/PLIST
--- a/pkg/PLIST
+++ b/pkg/PLIST
@@ -14,19 +14,23 @@ lib/python${MODPY_VERSION}/site-packages
 lib/python${MODPY_VERSION}/site-packages/sqlalchemy/
 lib/python${MODPY_VERSION}/site-packages/sqlalchemy/__init__.py
 lib/python${MODPY_VERSION}/site-packages/sqlalchemy/__init__.pyc
-lib/python${MODPY_VERSION}/site-packages/sqlalchemy/ansisql.py
-lib/python${MODPY_VERSION}/site-packages/sqlalchemy/ansisql.pyc
 lib/python${MODPY_VERSION}/site-packages/sqlalchemy/databases/
 lib/python${MODPY_VERSION}/site-packages/sqlalchemy/databases/__init__.py
 lib/python${MODPY_VERSION}/site-packages/sqlalchemy/databases/__init__.pyc
+lib/python${MODPY_VERSION}/site-packages/sqlalchemy/databases/access.py
+lib/python${MODPY_VERSION}/site-packages/sqlalchemy/databases/access.pyc
 lib/python${MODPY_VERSION}/site-packages/sqlalchemy/databases/firebird.py
 lib/python${MODPY_VERSION}/site-packages/sqlalchemy/databases/firebird.pyc
 
lib/python${MODPY_VERSION}/site-packages/sqlalchemy/databases/information_schema.py
 
lib/python${MODPY_VERSION}/site-packages/sqlalchemy/databases/information_schema.pyc
 lib/python${MODPY_VERSION}/site-packages/sqlalchemy/databases/informix.py
 lib/python${MODPY_VERSION}/site-packages/sqlalchemy/databases/informix.pyc
+lib/python${MODPY_VERSION}/site-packages/sqlalchemy/databases/maxdb.py
+lib/python${MODPY_VERSION}/site-packages/sqlalchemy/databases/maxdb.pyc
 lib/python${MODPY_VERSION}/site-packages/sqlalchemy/databases/mssql.py
 lib/python${MODPY_VERSION}/site-packages/sqlalchemy/databases/mssql.pyc
+lib/python${MODPY_VERSION}/site-packages/sqlalchemy/databases/mxODBC.py
+lib/python${MODPY_VERSION}/site-packages/sqlalchemy/databases/mxODBC.pyc
 lib/python${MODPY_VERSION}/site-packages/sqlalchemy/databases/mysql.py
 lib/python${MODPY_VERSION}/site-packages/sqlalchemy/databases/mysql.pyc
 lib/python${MODPY_VERSION}/site-packages/sqlalchemy/databases/oracle.py
@@ -35,6 +39,8 @@ lib/python${MODPY_VERSION}/site-packages
 lib/python${MODPY_VERSION}/site-packages/sqlalchemy/databases/postgres.pyc
 lib/python${MODPY_VERSION}/site-packages/sqlalchemy/databases/sqlite.py
 lib/python${MODPY_VERSION}/site-packages/sqlalchemy/databases/sqlite.pyc
+lib/python${MODPY_VERSION}/site-packages/sqlalchemy/databases/sybase.py

UPDATE: databases/py-sqlalchemy

2007-03-31 Thread Will Maier 
This is a trivial update for databases/py-sqlalchemy from version
0.3.4 to 0.3.6. Nearly all regress tests pass; the three that fail
depend on a more recent version of sqlite3 which fixes an ordering
bug.

Tested on -current/i386.

The diff is attached and available via HTTP:

http://www.lfod.us/files/ports/py-sqlalchemy.diff

Thanks!

-- 

o--{ Will Maier }--o
| web:...http://www.lfod.us/ | [EMAIL PROTECTED] |
*--[ BSD Unix: Live Free or Die ]--*
Index: Makefile
===
RCS file: /cvs/ports/databases/py-sqlalchemy/Makefile,v
retrieving revision 1.1.1.1
diff -u -u -r1.1.1.1 Makefile
--- Makefile2007/02/04 23:00:06 1.1.1.1
+++ Makefile2007/03/31 20:44:20
@@ -2,7 +2,7 @@
 
 COMMENT=   database toolkit for Python
 
-V= 0.3.4
+V= 0.3.6
 DISTNAME=  SQLAlchemy-${V}
 PKGNAME=   py-sqlalchemy-${V}
 
Index: distinfo
===
RCS file: /cvs/ports/databases/py-sqlalchemy/distinfo,v
retrieving revision 1.1.1.1
diff -u -u -r1.1.1.1 distinfo
--- distinfo2007/02/04 23:00:06 1.1.1.1
+++ distinfo2007/03/31 20:44:20
@@ -1,4 +1,5 @@
-MD5 (SQLAlchemy-0.3.4.tar.gz) = 38b258725d3c76c9d5aa36f471789064
-RMD160 (SQLAlchemy-0.3.4.tar.gz) = af1f1f2eaaffc61beb64d620995454b6dc26dfef
-SHA1 (SQLAlchemy-0.3.4.tar.gz) = 7b5a3e6b7dfad7b940c31ca32803ef5ecd7e21c8
-SIZE (SQLAlchemy-0.3.4.tar.gz) = 769753
+MD5 (SQLAlchemy-0.3.6.tar.gz) = 06cd60950d8f97f9466a323d3fae5cb5
+RMD160 (SQLAlchemy-0.3.6.tar.gz) = 507eacb1c2f86c0d8e718423f56abb16a17d97c5
+SHA1 (SQLAlchemy-0.3.6.tar.gz) = fc9f73663e27dd932bc7e1b41bde28a54a5e7bf4
+SHA256 (SQLAlchemy-0.3.6.tar.gz) = 
32099b7d3190fe2c4dba14890eae829d403e4780f68d270dfe410c484d521c05
+SIZE (SQLAlchemy-0.3.6.tar.gz) = 824550