[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