[Zope] Cataloging a ZSQL database

[J. Cameron Cooper]

Clara Baiget wrote:

> Hi JCC,
> Thank you very much for your help - the problem was actually the 
> location of one of the scripts - I looked for some documentation on 
> the concat SQL command - you were right, it seems it's not cut out for 
> gadfly. Unfortunately the option of using My SQL with zope seems too 
> buggy, as I keep getting errors with the MySQL DA....(it seems like a 
> common problem). The reason I wanted to use MySQL was to be able to 
> reuse the data, but I'm not sure this is possible with Postgres or 
> gadfly. Can data be transferred into a MySQL database?
> Thanks again for your help!
> Clara

I'm also including the list: we might as well have the info out there 
for posterity, no?

I know Postgres to work very well with Zope. The only problem I've ever 
seen is that frequent use of the "refresh" function will sometimes cause 
connection leakages, and I'm not even sure this isn't just a general 
behaviour.

Gadfly also interacts well, but frankly I wouldn't use it for anything 
other than demonstration or the most trivial of applications. (Which is 
its job description, after all.)

If you must have information available in some external relational 
database, Postgres will usually work every bit as well as MySQL. I'm 
sure there are ways to transfer data between the two (if you already 
have data in one) if that's in question. (And since you appear to have 
good reasons, I'll withhold the usual tract about where I think data 
should usually be stored (hint: ZODB). If you care, you can look it up 
in the list archives.)

I don't know about the errors you get with the MySQL DA: perhaps the 
list or the author can help clear those up and solve the whole problem.

             --jcc

>> I am a fairly new user to zope, and although I know the basics, I am
>>
>>> having problems trying to catalog a zsql database. Fortunately I 
>>> found this Ho-to on the Zope site, which explains how to do this:
>>> http://www.my-zope.org/HowtosRating/20020109160026
>>> But following their example, when I create the getBooksToCatalog
>>> method, Test then hit the "Submit Query" button, I get the following
>>> error:
>>>
>>> Error, exceptions.SyntaxError: unexpected token sequence.near :: ',
>>> Title,\nconcat'*'(Description, T' *******************************
>>> current state = 45 expects: '.', ('nomatch1',) current token = ((-
>>> 6, '('), '(')
>>
>>
>> Seems like your database has problems with the concat operator. 
>> You'll need to find out how you can do a similar operation in your 
>> database's dialect of SQL. (Of course, you could not have a 
>> concatenated field for your PrincipiaSearchSource.)
>


-- 
"My point and period will be throughly wrought,
Or well or ill, as this day's battle's fought."