Hi there, I've been developing an application on Win32 using Zope 2.2.4 and a Gadfly database. Now that I've got a working prototype I will me rebuilding my app on Zope 2.3 in Unix using a MySQL database... tomorrow. I expect the process won't be a simple job i.e. copying & pasting *won't* do the trick ;-) I just have a few questions about the problems I expect to run into: 1- Python methods/scripts. In changing my python methods to python scripts will I need to make any drastic changes or will they perform just the same if I have the *exact* same content in them? 2- MySQL DBA. I'm not responsible for installing Zope or the MySQL DBA on the Unix machine but from what I understand, people have had a few problems working with MySQL DBA. What problems can I expect? 3- I would like to backup what I have done on my home machine and copy it to another windows machine at uni (that I can reference when I'm building on the Unix version). I don't have access to the Unix machine from outside uni so, apart from copying the source into text files, is there a way I can *copy* Zope's files and place them on another machine? Hmm... I expect I'll be bombarding the list with questions these coming weeks. Thanks in advance for any information/advice you can offer. - Best regards, Lee
From: "Lee" <lee.reilly@ntlworld.com>
1- Python methods/scripts. In changing my python methods to python scripts will I need to make any drastic changes or will they perform just the same if I have the *exact* same content in them?
If you want to minimize your transition effort, go ahead and install PythonMethods. They will live happily side-by-side with Python Scripts, and you can replace them whenever you feel like it.
3- I would like to backup what I have done on my home machine and copy it to another windows machine at uni (that I can reference when I'm building on the Unix version). I don't have access to the Unix machine from outside uni so, apart from copying the source into text files, is there a way I can *copy* Zope's files and place them on another machine?
I don't follow. You can copy your Data.fs, which contains your entire Zope database. You can copy any Products that you have installed. You can export parts of your Zope database as *.zexp files and import them elsewhere. Cheers, Evan @ digicool & 4-am
On Sun, 28 Jan 2001, Lee wrote:
2- MySQL DBA. I'm not responsible for installing Zope or the MySQL DBA on the Unix machine but from what I understand, people have had a few problems working with MySQL DBA. What problems can I expect?
The main problem seems to be that there are three distinct versions of ZMySQLDA available: 1.1.3 - very old version which uses MySQLmodule-1.4, which is also very old. There may be a 1.1.4 which has been adapted to use MySQLdb. 1.2.x - a somewhat newer version designed to use MySQLdb (not sure what the status is of this) 2.0.4 - my version, derived from the ZOracleDA, adapted to use MySQLdb-0.3.x. Issues: Returns INTEGER columns as Python longs (by design, to avoid overflows on INTEGER UNSIGNED columns), and Python 1.5.2 appends an L when converting to a string with str(). Can't put in your own LIMIT clause unless you set max_rows on the Z SQL Method to zero; max_rows=0 with no LIMIT clauses returns zero rows instead of all of them (fixed in upcoming MySQLdb-0.3.2, will not require a ZMySQLDA update). -- Andy Dustman PGP: 0xC72F3F1D @ .net http://dustman.net/andy "Normally with carbonara you use eggs, but I used lobster brains instead." -- Masahiko Kobe (Iron Chef Italian): 30-year-old Giant Lobster Battle
participants (3)
-
Andy Dustman -
Evan Simpson -
Lee