headers
eGenix Team: M.-A. Lemburg | 5 Aug 14:43

ANN: eGenix mx Base Distribution 3.1.1

________________________________________________________________________

ANNOUNCING

                     eGenix.com mx Base Distribution

                             Version 3.1.1

       Open Source Python extensions providing important and useful
                   services for Python programmers.

This announcement is also available on our web-site for online reading:
http://www.egenix.com/company/news/eGenix-mx-Base-Distribution-3.1.1-GA.html

________________________________________________________________________

ABOUT

The eGenix.com mx Base Distribution for Python is a collection of
professional quality software tools which enhance Python's usability
in many important areas such as fast text searching, date/time
processing and high speed data types.

The tools have a proven record of being portable across many Unix and
Windows platforms. You can write applications which use the tools on
Windows and then run them on Unix platforms without change due to the
consistent platform independent interfaces.

Contents of the distribution:
(Continue reading)

Permalink | Reply | 0 comments |
headers
M.-A. Lemburg | 22 Jul 19:45

Re: Problems deploying mx.DateTime

[Please keep egenix-users on CC]

On 2008-07-22 19:40, Weverton Gomes wrote:
> I'm deploing a zip file and not a exe because I have another app in Delphi
> who integrates with this app in Python through Python4Delphi.

That's fine, but py2exe does in fact build a program.zip file
with the Python code that it places into a directory with the needed
DLLs.

What it does nicely is to find all your module dependencies ...

> When I put the mxDateTime pyd file inside my Delphi app dir, the error
> change. Now it is:
> 
> Traceback (most recent call last):
>   File "<string>", line 1, in <module>
>   File "C:\Program Files\Tron\Folha\Folha.pyz\engine\__init__.py", line 3,
> in <module>
>   File "C:\Program Files\Tron\Folha\Folha.pyz\engine\general\__init__.py",
> line 3, in <module>
>   File "C:\Program Files\Tron\Folha\Folha.pyz\engine\general\date_utils.py",
> line 8, in <module>
>   File "C:\Program Files\Tron\Folha\Folha.pyz\mx\DateTime\__init__.py", line
> 8, in <module>
>   File "C:\Program Files\Tron\Folha\Folha.pyz\mx\DateTime\DateTime.py", line
> 28, in <module>
>   File "C:\Program Files\Tron\Folha\Folha.pyz\mx\DateTime\DateTime.py", line
> 31, in modinit
> ImportError: No module named string
(Continue reading)

Permalink | Reply | 2 comments |
headers
M.-A. Lemburg | 22 Jul 19:23

Re: Problems deploying mx.DateTime

On 2008-07-22 19:14, Weverton Gomes wrote:
> I'm just making a zip file. Inside it there are the following folders:
> 
> elementtree
> engine => (my app)
> kinterbasdb
> mx
> 
> About mxDateTime.pyd, I already tried erase all other files (.py, .h, .c)
> inside mx.DateTime.mxDateTime and leaving only mxDateTime.pyd.

Why would you do that ?

> When I did
> this, I got the following error:
> 
> Traceback (most recent call last):
> File "<string>", line 1, in <module>
> File "C:\Program Files\Tron\Folha\Folha.pyz\engine\__init__.py", line 3, in
> <module>
> File "C:\Program Files\Tron\Folha\Folha.pyz\engine\general\__init__.py",
> line 3, in <module>
> File "C:\Program Files\Tron\Folha\Folha.pyz\engine\general\date_utils.py",
> line 8, in <module>
> File "C:\Program Files\Tron\Folha\Folha.pyz\mx\DateTime\__init__.py", line
> 8, in <module>
> File "C:\Program Files\Tron\Folha\Folha.pyz\mx\DateTime\DateTime.py", line
> 9, in <module>
> ImportError: No module named mxDateTime
>
(Continue reading)

Permalink | Reply | 0 comments |
headers
Weverton Gomes | 22 Jul 17:51

Problems deploying mx.DateTime

Hi,

I'm trying to deploy an application I've made, in a zip file. So, I added the folder mx (who is inside Python25\Lib\site-packages) but, when I try to run my app, I get the following error:

**** You don't have the (right) mxDateTime binaries installed
Traceback (most recent call last):
File "<string>", line 1, in <module>
File "C:\Program Files\Tron\Folha\Folha.pyz\engine\__init__.py", line 3, in <module>
File "C:\Program Files\Tron\Folha\Folha.pyz\engine\general\__init__.py", line 3, in <module>
File "C:\Program Files\Tron\Folha\Folha.pyz\engine\general\date_utils.py", line 8, in <module>
File "C:\Program Files\Tron\Folha\Folha.pyz\mx\DateTime\__init__.py", line 8, in <module>
File "C:\Program Files\Tron\Folha\Folha.pyz\mx\DateTime\DateTime.py", line 9, in <module>
File "C:\Program Files\Tron\Folha\Folha.pyz\mx\DateTime\mxDateTime\__init__.py", line 13, in <module>

What can I do to solve this problem??

Thanks,

--
Weverton Gomes de Morais
Tecnólogo em Redes de Comunicação
Desenvolvedor Delphi
Entusiasta Ruby/Rails
"Todos juntos somos fortes" 

_______________________________________________________________________
eGenix.com User Mailing List                     http://www.egenix.com/
https://www.egenix.com/mailman/listinfo/egenix-users
Permalink | Reply | 1 comment |
headers
eGenix Team: M.-A. Lemburg | 21 Jul 23:26

ANN: eGenix EuroPython 2008 Presentations & Videos

________________________________________________________________________

           eGenix EuroPython 2008 Presentations & Videos

________________________________________________________________________

We have uploaded our EuroPython 2008 presentations to our website.

Learn the concepts behind the Python DB-API and how to design
large-scale applications.

This announcement is also available on our web-site for online reading:
http://www.egenix.com/company/news/EuroPython-2008-Presentations.html
________________________________________________________________________

INTRODUCTION

The EuroPython Conference is the one of the premier conferences for
Python & Zope users and developers. This year it was being held from
the 7th to 9th July in Vilnius, Lithuania.

eGenix was one of the founding members of the EuroPython conference
team and played a major role in organizing the first EuroPython
conference in the year 2002.

Since then we have attended every EuroPython conference to meet up
face-to-face with the people from the Python & Zope communities and
have given regular talks at these conferences.

________________________________________________________________________

TALKS AT EUROPYTHON 2008

We gave the following two talks at the conference. The presentations
are available for viewing and download from our Presentations and
Talks section:

         http://www.egenix.com/library/presentations/

As special feature, we have added talk videos in addition to providing
the slide PDFs. You can view the talks online if you have the Adobe
Flash Player 8 or later installed.

* Using the Python Database API

The Python Database API (DB-API) is a specification of a module
interface that allows interfacing from Python to a relational database.

The talk gives a high-level introduction to the concepts used in the
Python DB-API and relational databases in general. Connection, cursors
and transactions are discussed, and their use in Python database
applications is explained.

* Designing Large-Scale Applications in Python

Python is widely and somewhat inaccurately referred to as a scripting
language. While Python is an ideal platform for small scripting tasks,
it does in fact cover all the concepts needed for large scale object
oriented application development. However, complex applications bring
different challenges.

This talk draws on eGenix' many years experience with large scale
application development using Python as central implementation language
and provides a cookbook approach to many of the the problems you face
when designing and organizing complex application frameworks.

Enjoy,
-- 
Marc-Andre Lemburg
eGenix.com

Professional Python Services directly from the Source  (#1, Jul 21 2008)
>>> Python/Zope Consulting and Support ...        http://www.egenix.com/
>>> mxODBC.Zope.Database.Adapter ...             http://zope.egenix.com/
>>> mxODBC, mxDateTime, mxTextTools ...        http://python.egenix.com/
________________________________________________________________________

:::: Try mxODBC.Zope.DA for Windows,Linux,Solaris,MacOSX for free ! ::::

    eGenix.com Software, Skills and Services GmbH  Pastor-Loeh-Str.48
     D-40764 Langenfeld, Germany. CEO Dipl.-Math. Marc-Andre Lemburg
            Registered at Amtsgericht Duesseldorf: HRB 46611

_______________________________________________________________________
eGenix.com User Mailing List                     http://www.egenix.com/
https://www.egenix.com/mailman/listinfo/egenix-users
Permalink | Reply | 0 comments |
headers
Joel Bard | 17 Jul 21:48

insert fails with no error

Hi-

I'm connecting from linux x86_64 to a sqlserver2005 instance using mxODBC 3.0.1 with unixODBC.  I'm able to
retrieve data with no problem.  When I try a simple insert:

        c=db.cursor()
        p1="test"
        p2="mxodbc test"
        c.execute("insert into bug" + \
                  " (UIElement,Description)" + \
                  "values (?,?)" \
                  ,(p1,p2) \
                  )

c.rowcount is 1 but the row is not present in the table.  If I execute the same sql command using isql it works. 
The table uses an autoincrement key column and values for the key are consumed even though the record is not
being created.  c.messages is empty.  The same behavior is seen regardless of whether parameters are used
and regardless of wether I use execute or executedirect.  Any help would be appreciated.

Thanks,

Joel

_______________________________________________________________________
eGenix.com User Mailing List                     http://www.egenix.com/
https://www.egenix.com/mailman/listinfo/egenix-users
Permalink | Reply | 3 comments |
headers
Greg Corradini | 23 Jun 18:19

Simple mx.ODBC Update question

Hello all,
Can I use mx.ODBC to write an UPDATE SQL statement using a list of tuples and a parameterized statement format?

For example, I can batch INSERT with the following parameterized statement using "?":
cursor.executemany("Insert into MYTABLE(ID,VALUE) values(?,?)", dataAsListofTuples)

Using mxODBC  is there a parameterized Update statement like above?


_______________________________________________________________________
eGenix.com User Mailing List                     http://www.egenix.com/
https://www.egenix.com/mailman/listinfo/egenix-users
Permalink | Reply | 1 comment |
headers
eGenix Team: M.-A. Lemburg | 18 Jun 18:25

ANN: eGenix mx Base Distribution 3.1.0

________________________________________________________________________

ANNOUNCING

                     eGenix.com mx Base Distribution

                             Version 3.1.0

       Open Source Python extensions providing important and useful
                   services for Python programmers.

This announcement is also available on our web-site for online reading:
http://www.egenix.com/company/news/eGenix-mx-Base-Distribution-3.1.0-GA.html

________________________________________________________________________

ABOUT

The eGenix.com mx Base Distribution for Python is a collection of
professional quality software tools which enhance Python's usability
in many important areas such as fast text searching, date/time
processing and high speed data types.

The tools have a proven record of being portable across many Unix and
Windows platforms. You can write applications which use the tools on
Windows and then run them on Unix platforms without change due to the
consistent platform independent interfaces.

Contents of the distribution:

  * mxDateTime - Date/Time Library for Python
  * mxTextTools - Fast Text Parsing and Processing Tools for Python
  * mxProxy - Object Access Control for Python
  * mxBeeBase - On-disk B+Tree Based Database Kit for Python
  * mxURL - Flexible URL Data-Type for Python
  * mxUID - Fast Universal Identifiers for Python
  * mxStack - Fast and Memory-Efficient Stack Type for Python
  * mxQueue - Fast and Memory-Efficient Queue Type for Python
  * mxTools - Fast Everyday Helpers for Python

All available packages have proven their stability and usefulness in
many mission critical applications and various commercial settings all
around the world.

* About Python:
Python is an object-oriented Open Source programming language which
runs on all modern platforms (http://www.python.org/). By integrating
ease-of-use, clarity in coding, enterprise application connectivity
and rapid application design, Python establishes an ideal programming
platform for todays IT challenges.

* About eGenix:
eGenix is a consulting and software product company focused on
providing professional quality services and products to Python
users and developers (http://www.egenix.com/).

________________________________________________________________________

NEWS

The 3.1.0 release of the eGenix mx Base Distribution has a number
of enhancements over the previous version 3.0.0. Apart from a few
minor bug fixes, it provides a few new features:

Some highlights:

     * mxTools now has a new mx.Tools.dlopen() function which allow
       loading shared libraries explicitly and from a specific
       path. This allows working around problems with not being able to
       dynamically set LD_LIBRARY_PATH on Unix platforms.

     * mxTools can be configured to expose a new API called
       mx.Tools.setproctitle() which allows setting the process title
       on Unix platforms.

     * mxBeeBase comes with a new on-disk dictionary version called
       BeeFixedLengthStringDict, which allows using keys with embedded
       \0 characters.

     * mxSetup, our Python distutils extension, can now build prebuilt
       archives that no longer require the "... build --skip ..."
       command to skip the build process.  The uninstall command now
       also works for prebuilt archives and the bdist_prebuilt command
       has been enhanced to be able to build pure Python distributions
       as well.

     * mxSetup now also works together with setuptools to e.g. build
       and install the packages as eggs. Run setup.py with
       --use-setuptools to enable this support.

For a more detailed description of changes, please see the respective
package documentation on our web-site.

As always, we are providing pre-compiled versions of the package for
the most popular Python platforms. For all others, you can compile the
package from source using "python setup.py install".

________________________________________________________________________

DOWNLOADS

The download archives and instructions for installing the packages can
be found on the eGenix mx Base Distribution page:

     http://www.egenix.com/products/python/mxBase/

________________________________________________________________________

LICENSE

The eGenix mx Base package is distributed under the eGenix.com Public
License 1.1.0 which is a CNRI Python License style Open Source
license.  You can use the package in both commercial and
non-commercial settings without fee or charge.

The package comes with full source code

________________________________________________________________________

SUPPORT

Commercial support for these packages is available from eGenix.com.
Please see

     http://www.egenix.com/services/support/

for details about our support offerings.

Enjoy,
-- 
Marc-Andre Lemburg
eGenix.com

Professional Python Services directly from the Source  (#1, Jun 18 2008)
>>> Python/Zope Consulting and Support ...        http://www.egenix.com/
>>> mxODBC.Zope.Database.Adapter ...             http://zope.egenix.com/
>>> mxODBC, mxDateTime, mxTextTools ...        http://python.egenix.com/
________________________________________________________________________
2008-07-07: EuroPython 2008, Vilnius, Lithuania            18 days to go

:::: Try mxODBC.Zope.DA for Windows,Linux,Solaris,MacOSX for free ! ::::

    eGenix.com Software, Skills and Services GmbH  Pastor-Loeh-Str.48
     D-40764 Langenfeld, Germany. CEO Dipl.-Math. Marc-Andre Lemburg
            Registered at Amtsgericht Duesseldorf: HRB 46611

_______________________________________________________________________
eGenix.com User Mailing List                     http://www.egenix.com/
https://www.egenix.com/mailman/listinfo/egenix-users
Permalink | Reply | 0 comments |
headers
eGenix Team: M.-A. Lemburg | 16 Jun 12:10

ANN: eGenix mxODBC Connect Database Interface for Python 0.9.1 (beta)

________________________________________________________________________

ANNOUNCING
                     eGenix.com mxODBC Connect

                   Database Interface for Python

                        Version 0.9.1 (beta)

   Our new client-server product for connecting Python applications
          to relational databases - on all major platforms

This announcement is also available on our web-site for online reading:
http://www.egenix.com/company/news/eGenix-mxODBC-Connect-0.9.1-beta.html

________________________________________________________________________

INTRODUCTION

The mxODBC Connect Database Interface for Python allows users to
easily connect Python applications to all major databases on the
market today in a highly portable and convenient way.  This makes
mxODBC Connect the ideal basis for writing cross-platform database
programs and utilities in Python.

mxODBC Connect extends our eGenix mx Python Extension series with a
new client-server based product, that removes the need to install and
configure ODBC drivers on the client side. This greatly simplifies
setup and configuration of database driven client applications, while
at the same time making the network communication between client and
database server more efficient and more secure.

* About Python:
Python is an object-oriented Open Source programming language which
runs on all modern platforms (http://www.python.org/). By integrating
ease-of-use, clarity in coding, enterprise application connectivity
and rapid application design, Python establishes an ideal programming
platform for todays IT challenges.

* About eGenix:
eGenix is a consulting and software product company focused on
providing professional quality services and products to Python
users and developers (http://www.egenix.com/).

________________________________________________________________________

HOW IT WORKS

mxODBC Connect consists of two parts: a server installation which
typically runs directly on the database server and a client Python
package which is installed on the client machine that runs the Python
application.

The server part uses our high-performance database adapter mxODBC to
connect to the database server.

The client package communicates with the server part over a TCP/IP
network, optionally using SSL encryption, advanced authentication and
access controls - a feature that many database drivers fail to
deliver.

By separating the client application database interface from the
server and using mxODBC Connect, you gain several benefits:

  * high portability and flexibility
  * centralized configuration and administration
  * added security
  * automatic fail-over
  * scalability
  * lower costs

For more information, please have a look at the product page:

     http://www.egenix.com/products/python/mxODBCConnect/

________________________________________________________________________

NEWS

mxODBC Connect 0.9 is a public beta release of our new mxODBC Connect
product.

If you would like to participate in the beta, please see our beta
program page:

     http://www.egenix.com/products/python/mxODBCConnect/beta.html

*SPECIAL OFFER*

In order to make participation in the beta program more interesting
for our users, we will be giving out *free discount coupons* to all
participants who report back bugs in the product.

________________________________________________________________________

DOWNLOADS

The download archives as well as instructions for installation and
configuration of the product can be found on the product page:

     http://www.egenix.com/products/python/mxODBCConnect/

_______________________________________________________________________

SUPPORT

Commercial support for this product is available from eGenix.com.

Please see

     http://www.egenix.com/services/support/

for details about our support offerings.

-- 
Marc-Andre Lemburg
eGenix.com

Professional Python Services directly from the Source  (#1, Jun 16 2008)
>>> Python/Zope Consulting and Support ...        http://www.egenix.com/
>>> mxODBC.Zope.Database.Adapter ...             http://zope.egenix.com/
>>> mxODBC, mxDateTime, mxTextTools ...        http://python.egenix.com/
________________________________________________________________________
2008-07-07: EuroPython 2008, Vilnius, Lithuania            20 days to go

:::: Try mxODBC.Zope.DA for Windows,Linux,Solaris,MacOSX for free ! ::::

    eGenix.com Software, Skills and Services GmbH  Pastor-Loeh-Str.48
     D-40764 Langenfeld, Germany. CEO Dipl.-Math. Marc-Andre Lemburg
            Registered at Amtsgericht Duesseldorf: HRB 46611

_______________________________________________________________________
eGenix.com User Mailing List                     http://www.egenix.com/
https://www.egenix.com/mailman/listinfo/egenix-users
Permalink | Reply | 0 comments |
headers
eGenix Team: M.-A. Lemburg | 12 Jun 22:03

ANN: eGenix pyOpenSSL Distribution 0.7.0-0.9.8h-1

________________________________________________________________________

ANNOUNCING

                    eGenix.com pyOpenSSL Distribution

                         Version 0.7.0-0.9.8h-1

              An easy to install and use repackaged distribution
                of the pyOpenSSL Python interface for OpenSSL -
                   available on Windows and Unix platforms

This announcement is also available on our web-site for online reading:
http://www.egenix.com/company/news/eGenix-pyOpenSSL-Distribution-0.7.0-0.9.8h-1-GA.html

________________________________________________________________________

INTRODUCTION

The eGenix.com pyOpenSSL Distribution includes everything you need to
get started with SSL in Python. It comes with an easy to use installer
that includes the most recent OpenSSL library versions in pre-compiled
form.

pyOpenSSL is an open-source Python add-on (http://pyopenssl.sf.net/).
OpenSSL is an open-source implementation of the SSL protocol
(http://www.openssl.org/).

* About Python:
Python is an object-oriented Open Source programming language which
runs on all modern platforms (http://www.python.org/). By integrating
ease-of-use, clarity in coding, enterprise application connectivity
and rapid application design, Python establishes an ideal programming
platform for todays IT challenges.

* About eGenix:
eGenix is a consulting and software product company focused on
providing professional quality services and products to Python
users and developers (http://www.egenix.com/).

________________________________________________________________________

NEWS

This is the first release of the eGenix.com pyOpenSSL Distribution.
It includes pyOpenSSL 0.7.0 and the OpenSSL 0.9.8h libraries on all
supported platforms.

________________________________________________________________________

DOWNLOADS

The download archives and instructions for installing the package can
be found at:

     http://www.egenix.com/products/python/pyOpenSSL/

________________________________________________________________________

UPGRADING

Before installing this version of pyOpenSSL, please make sure that
you uninstall any previously installed pyOpenSSL version. Otherwise,
you could end up not using the included OpenSSL libs.

_______________________________________________________________________

SUPPORT

Commercial support for these packages is available from eGenix.com.
Please see

     http://www.egenix.com/services/support/

for details about our support offerings.

Enjoy,
-- 
Marc-Andre Lemburg
eGenix.com

Professional Python Services directly from the Source  (#1, Jun 12 2008)
>>> Python/Zope Consulting and Support ...        http://www.egenix.com/
>>> mxODBC.Zope.Database.Adapter ...             http://zope.egenix.com/
>>> mxODBC, mxDateTime, mxTextTools ...        http://python.egenix.com/
________________________________________________________________________
2008-07-07: EuroPython 2008, Vilnius, Lithuania            24 days to go

:::: Try mxODBC.Zope.DA for Windows,Linux,Solaris,MacOSX for free ! ::::

    eGenix.com Software, Skills and Services GmbH  Pastor-Loeh-Str.48
     D-40764 Langenfeld, Germany. CEO Dipl.-Math. Marc-Andre Lemburg
            Registered at Amtsgericht Duesseldorf: HRB 46611

_______________________________________________________________________
eGenix.com User Mailing List                     http://www.egenix.com/
https://www.egenix.com/mailman/listinfo/egenix-users
Permalink | Reply | 0 comments |
headers
M.-A. Lemburg | 6 Jun 22:11

Installing mxODBC Zope DA for use in Plone 3.x

The Plone universal installer ships with its own Python and Zope
installation. As a result the installation procedure for our
Zope DA has to be adapted to the Plone setup.

The following assumes that you are using the unified Plone 3.1
installer and its default standalone configuration.

For a Plone 3.1 standalone installation:
----------------------------------------

cd /opt/Plone-3.1/

# Unzip the mxODBC Zope DA ZIP file in the instance directory
unzip -d zinstance/parts/instance \
     egenix-mxodbc-zopeda-1.0.10.*-py2.4_ucs2.zip

# Move the product package into place
mv zinstance/parts/instance/lib/python/Products/mxODBCZopeDA \
     zinstance/products/

# Remove the no longer needed Products/ directory to avoid
# confusion
rmdir zinstance/parts/instance/lib/python/Products

then install the license files into

/opt/Plone-3.1/zinstance/parts/instance/lib/python/mx/ODBC

and restart Plone.

Regards,
-- 
Marc-Andre Lemburg
eGenix.com

Professional Python Services directly from the Source  (#1, Jun 06 2008)
 >>> Python/Zope Consulting and Support ...        http://www.egenix.com/
 >>> mxODBC.Zope.Database.Adapter ...             http://zope.egenix.com/
 >>> mxODBC, mxDateTime, mxTextTools ...        http://python.egenix.com/
________________________________________________________________________
2008-07-07: EuroPython 2008, Vilnius, Lithuania            30 days to go

:::: Try mxODBC.Zope.DA for Windows,Linux,Solaris,MacOSX for free ! ::::

    eGenix.com Software, Skills and Services GmbH  Pastor-Loeh-Str.48
     D-40764 Langenfeld, Germany. CEO Dipl.-Math. Marc-Andre Lemburg
            Registered at Amtsgericht Duesseldorf: HRB 46611

_______________________________________________________________________
eGenix.com User Mailing List                     http://www.egenix.com/
https://www.egenix.com/mailman/listinfo/egenix-users
Permalink | Reply | 3 comments |

Gmane