[Checkins] SVN: Products.SQLAlchemyDA/trunk/ moved
Andreas Jung
andreas at andreas-jung.com
Wed Mar 12 07:00:13 EDT 2008
Log message for revision 84603:
moved
Changed:
A Products.SQLAlchemyDA/trunk/Products/SQLAlchemyDA/README.txt
A Products.SQLAlchemyDA/trunk/Products/SQLAlchemyDA/config.py
A Products.SQLAlchemyDA/trunk/Products/SQLAlchemyDA/header.txt
D Products.SQLAlchemyDA/trunk/README.txt
D Products.SQLAlchemyDA/trunk/config.py
D Products.SQLAlchemyDA/trunk/header.txt
-=-
Copied: Products.SQLAlchemyDA/trunk/Products/SQLAlchemyDA/README.txt (from rev 84599, Products.SQLAlchemyDA/trunk/README.txt)
===================================================================
--- Products.SQLAlchemyDA/trunk/Products/SQLAlchemyDA/README.txt (rev 0)
+++ Products.SQLAlchemyDA/trunk/Products/SQLAlchemyDA/README.txt 2008-03-12 11:00:13 UTC (rev 84603)
@@ -0,0 +1,143 @@
+##########################################################################
+# A DA-like integration of SQLAlchemy based on z3c.sqlalchemy
+#
+# (C) Zope Corporation and Contributors
+# Written by Andreas Jung for Haufe Mediengruppe, Freiburg, Germany
+# and ZOPYX Ltd. & Co. KG, Tuebingen, Germany
+##########################################################################
+
+
+What is SQLAlchemyDA?
+---------------------
+
+SQLAlchemyDA is a generic database adapter for ZSQL methods. Since it is based
+on SQLAlchemy, SQLAlchemyDA supports all databases out-of-the box that are
+supported by SQLAlchemy (Postgres, MySQL, Oracle, SQLite, MS-SQL, Firebird,
+Informix).
+
+
+Requirements:
+-------------
+
+ - Zope 2.8 +
+
+ - SQLAlchemy 0.3.8 (+ database specific low-level Python drivers)
+
+ - z3c.sqlalchemy 1.0.4 +
+
+
+Installation:
+-------------
+
+ - download and install SQLAlchemy as egg or from the sources
+ from Cheeseshop (easy_install sqlalchemy). See
+
+ http://www.sqlalchemy.org
+
+ for details
+
+ - download and install z3c.sqlalchemy as egg or from the sources
+ from Cheeseshop (easy_install z3c.sqlalchemy). See
+
+ http://cheeseshop.python.org/pypi/z3c.sqlalchemy/
+
+ for details.
+
+ - unpack the archive containing SQLAlchemyDA inside the "Products"
+ directory of your Zope instance home.
+
+ - after restarting Zope you go to the ZMI and create an instance of
+ "SQLAlchemyDA" (as you would create some DA instance)
+
+ - click on the new created SQLAlchemyDA instance within the ZMI
+ and configure your database connection through the "Properties" tab.
+ The connection parameter 'dsn' must be specified as a valid SQLAlchemy DSN
+ like
+
+ <dbschema>://<username>:<password>@<hostname>/<databasename>
+
+ Example:
+
+ postgres://admin:123@localhost:5432/TestDB
+
+ - ZSQL methods should see the new DA through the selection widget of available
+ database adapters
+
+ - NOTE: you must have the low-level Python DB drivers installed in order to
+ access a particular database. See
+
+ http://www.sqlalchemy.org/docs/dbengine.html#dbengine_supported
+
+ for details.
+
+
+Configuration of SQLAlchemyDA:
+------------------------------
+
+ - 'dsn' - SQLAlchemy compliant Database Set Name (see www.sqlalchemy.org/docs)
+
+ - 'transactional' - uncheck this property if you are working with a non-transactional
+ database like older versions of MySQL. Uncheck this property *only* if you see any
+ commit() related error. Otherwise leave this property checked. Changing this
+ property *requires* a Zope restart.
+
+ - 'quoting_style' - affects how strings are quoted in SQL. By default 'standard'
+ quotes strings correctly. Setting the value to 'no-quote' might solve quoting issues
+ with some databases.
+
+
+Using SQLAlchemyDA:
+-------------------
+
+ SQLAlchemyDA works as a database adapter as documented within "The Zope Book"
+
+ http://www.plope.com/Books/2_7Edition/RelationalDatabases.stx
+
+ and can be used like any other DA together with ZSQL methods.
+
+
+Tested with databases:
+----------------------
+
+ - Postgres 7.4, 8.0-8.2
+
+ - SQLite 3.3.X
+
+ - MySQL is *only* supported for MySQL databases with transaction support.
+ (see also z3c/sqlalchemy/README.txt)
+
+
+Known issues:
+-------------
+
+""" Database connection could not be opened ((ProgrammingError) (1064, You
+have an error in your SQL syntax near 'COMMIT .
+"""
+ This bug might appear with older MySQL versions when opening/closing
+ the connections manually through the ZMI. It should not affect the
+ functionality of SQLAlchemyDA.
+
+
+Author
+======
+SQLAlchemyDA was written by Andreas Jung for Haufe Mediengruppe, Freiburg,
+Germany and ZOPYX Ltd. & Co. KG, Tuebingen, Germany.
+
+
+License
+=======
+SQLAlchemyDA is licensed under the Zope Public License 2.1.
+See LICENSE.txt.
+
+
+Contact
+=======
+Andreas Jung
+E-mail: info at zopyx dot com
+Web: http://www.zopyx.com
+
+
+Credits
+=======
+Parts of the SQLAlchemyDA V 0.3.X development has been sponsored by Wayne
+Volkmuth (renovis.com)
Copied: Products.SQLAlchemyDA/trunk/Products/SQLAlchemyDA/config.py (from rev 84599, Products.SQLAlchemyDA/trunk/config.py)
===================================================================
--- Products.SQLAlchemyDA/trunk/Products/SQLAlchemyDA/config.py (rev 0)
+++ Products.SQLAlchemyDA/trunk/Products/SQLAlchemyDA/config.py 2008-03-12 11:00:13 UTC (rev 84603)
@@ -0,0 +1,10 @@
+##########################################################################
+# A DA-like integration of SQLAlchemy based on z3c.sqlalchemy
+#
+# (C) Zope Corporation and Contributors
+# Written by Andreas Jung for Haufe Mediengruppe, Freiburg, Germany
+# and ZOPYX Ltd. & Co. KG, Tuebingen, Germany
+##########################################################################
+
+
+ADD_SA_WRAPPER_PERMISSION = 'Add SQLAlchemy DA'
Copied: Products.SQLAlchemyDA/trunk/Products/SQLAlchemyDA/header.txt (from rev 84599, Products.SQLAlchemyDA/trunk/header.txt)
===================================================================
--- Products.SQLAlchemyDA/trunk/Products/SQLAlchemyDA/header.txt (rev 0)
+++ Products.SQLAlchemyDA/trunk/Products/SQLAlchemyDA/header.txt 2008-03-12 11:00:13 UTC (rev 84603)
@@ -0,0 +1,8 @@
+##########################################################################
+# A DA-like integration of SQLAlchemy based on z3c.sqlalchemy
+#
+# (C) Zope Corporation and Contributors
+# Written by Andreas Jung for Haufe Mediengruppe, Freiburg, Germany
+# and ZOPYX Ltd. & Co. KG, Tuebingen, Germany
+##########################################################################
+
Deleted: Products.SQLAlchemyDA/trunk/README.txt
===================================================================
--- Products.SQLAlchemyDA/trunk/README.txt 2008-03-12 10:59:49 UTC (rev 84602)
+++ Products.SQLAlchemyDA/trunk/README.txt 2008-03-12 11:00:13 UTC (rev 84603)
@@ -1,143 +0,0 @@
-##########################################################################
-# A DA-like integration of SQLAlchemy based on z3c.sqlalchemy
-#
-# (C) Zope Corporation and Contributors
-# Written by Andreas Jung for Haufe Mediengruppe, Freiburg, Germany
-# and ZOPYX Ltd. & Co. KG, Tuebingen, Germany
-##########################################################################
-
-
-What is SQLAlchemyDA?
----------------------
-
-SQLAlchemyDA is a generic database adapter for ZSQL methods. Since it is based
-on SQLAlchemy, SQLAlchemyDA supports all databases out-of-the box that are
-supported by SQLAlchemy (Postgres, MySQL, Oracle, SQLite, MS-SQL, Firebird,
-Informix).
-
-
-Requirements:
--------------
-
- - Zope 2.8 +
-
- - SQLAlchemy 0.3.8 (+ database specific low-level Python drivers)
-
- - z3c.sqlalchemy 1.0.4 +
-
-
-Installation:
--------------
-
- - download and install SQLAlchemy as egg or from the sources
- from Cheeseshop (easy_install sqlalchemy). See
-
- http://www.sqlalchemy.org
-
- for details
-
- - download and install z3c.sqlalchemy as egg or from the sources
- from Cheeseshop (easy_install z3c.sqlalchemy). See
-
- http://cheeseshop.python.org/pypi/z3c.sqlalchemy/
-
- for details.
-
- - unpack the archive containing SQLAlchemyDA inside the "Products"
- directory of your Zope instance home.
-
- - after restarting Zope you go to the ZMI and create an instance of
- "SQLAlchemyDA" (as you would create some DA instance)
-
- - click on the new created SQLAlchemyDA instance within the ZMI
- and configure your database connection through the "Properties" tab.
- The connection parameter 'dsn' must be specified as a valid SQLAlchemy DSN
- like
-
- <dbschema>://<username>:<password>@<hostname>/<databasename>
-
- Example:
-
- postgres://admin:123@localhost:5432/TestDB
-
- - ZSQL methods should see the new DA through the selection widget of available
- database adapters
-
- - NOTE: you must have the low-level Python DB drivers installed in order to
- access a particular database. See
-
- http://www.sqlalchemy.org/docs/dbengine.html#dbengine_supported
-
- for details.
-
-
-Configuration of SQLAlchemyDA:
-------------------------------
-
- - 'dsn' - SQLAlchemy compliant Database Set Name (see www.sqlalchemy.org/docs)
-
- - 'transactional' - uncheck this property if you are working with a non-transactional
- database like older versions of MySQL. Uncheck this property *only* if you see any
- commit() related error. Otherwise leave this property checked. Changing this
- property *requires* a Zope restart.
-
- - 'quoting_style' - affects how strings are quoted in SQL. By default 'standard'
- quotes strings correctly. Setting the value to 'no-quote' might solve quoting issues
- with some databases.
-
-
-Using SQLAlchemyDA:
--------------------
-
- SQLAlchemyDA works as a database adapter as documented within "The Zope Book"
-
- http://www.plope.com/Books/2_7Edition/RelationalDatabases.stx
-
- and can be used like any other DA together with ZSQL methods.
-
-
-Tested with databases:
-----------------------
-
- - Postgres 7.4, 8.0-8.2
-
- - SQLite 3.3.X
-
- - MySQL is *only* supported for MySQL databases with transaction support.
- (see also z3c/sqlalchemy/README.txt)
-
-
-Known issues:
--------------
-
-""" Database connection could not be opened ((ProgrammingError) (1064, You
-have an error in your SQL syntax near 'COMMIT .
-"""
- This bug might appear with older MySQL versions when opening/closing
- the connections manually through the ZMI. It should not affect the
- functionality of SQLAlchemyDA.
-
-
-Author
-======
-SQLAlchemyDA was written by Andreas Jung for Haufe Mediengruppe, Freiburg,
-Germany and ZOPYX Ltd. & Co. KG, Tuebingen, Germany.
-
-
-License
-=======
-SQLAlchemyDA is licensed under the Zope Public License 2.1.
-See LICENSE.txt.
-
-
-Contact
-=======
-Andreas Jung
-E-mail: info at zopyx dot com
-Web: http://www.zopyx.com
-
-
-Credits
-=======
-Parts of the SQLAlchemyDA V 0.3.X development has been sponsored by Wayne
-Volkmuth (renovis.com)
Deleted: Products.SQLAlchemyDA/trunk/config.py
===================================================================
--- Products.SQLAlchemyDA/trunk/config.py 2008-03-12 10:59:49 UTC (rev 84602)
+++ Products.SQLAlchemyDA/trunk/config.py 2008-03-12 11:00:13 UTC (rev 84603)
@@ -1,10 +0,0 @@
-##########################################################################
-# A DA-like integration of SQLAlchemy based on z3c.sqlalchemy
-#
-# (C) Zope Corporation and Contributors
-# Written by Andreas Jung for Haufe Mediengruppe, Freiburg, Germany
-# and ZOPYX Ltd. & Co. KG, Tuebingen, Germany
-##########################################################################
-
-
-ADD_SA_WRAPPER_PERMISSION = 'Add SQLAlchemy DA'
Deleted: Products.SQLAlchemyDA/trunk/header.txt
===================================================================
--- Products.SQLAlchemyDA/trunk/header.txt 2008-03-12 10:59:49 UTC (rev 84602)
+++ Products.SQLAlchemyDA/trunk/header.txt 2008-03-12 11:00:13 UTC (rev 84603)
@@ -1,8 +0,0 @@
-##########################################################################
-# A DA-like integration of SQLAlchemy based on z3c.sqlalchemy
-#
-# (C) Zope Corporation and Contributors
-# Written by Andreas Jung for Haufe Mediengruppe, Freiburg, Germany
-# and ZOPYX Ltd. & Co. KG, Tuebingen, Germany
-##########################################################################
-
More information about the Checkins
mailing list