Mailing List Archive

ZOPE and "find in files feature"
Dear list members,

I am a Python programmer but not familiar with ZOPE.

I am building a website with a MYSQL database of text documents (several
thousand). I need to construct a feature similar to a "find in files" of a
text editor.

I.e. the user will enter a text string in a form on the client-side and be
passed back a results page from the server giving all the lines in the files
in the Mysql database that contain that string. When he clicks on a line in
the results page it will cause the file containing that line to be
downloaded.

Are there features in ZOPE that do any of this kind of functionality.

Many thanks,
Harry


Harry Spier
371 Brickman Rd.
Hurleyville, New York
USA 12747


_______________________________________________
Zope-DB mailing list
Zope-DB@zope.org
http://mail.zope.org/mailman/listinfo/zope-db
Re: ZOPE and "find in files feature" [ In reply to ]
--On 20. August 2006 05:51:18 -0400 Harry Spier <harryspier@hotmail.com>
wrote:

>
> Dear list members,
>
> I am a Python programmer but not familiar with ZOPE.
>
> I am building a website with a MYSQL database of text documents (several
> thousand). I need to construct a feature similar to a "find in files" of
> a text editor.
>
> I.e. the user will enter a text string in a form on the client-side and
> be passed back a results page from the server giving all the lines in the
> files in the Mysql database that contain that string. When he clicks on a
> line in the results page it will cause the file containing that line to
> be downloaded.
>
> Are there features in ZOPE that do any of this kind of functionality.

What is the problem? Zope supports most databases (The Zope Book -> RDBMS
chapter on plone.com is your primary sources). Using scripting with Python
you can implement anything you want. But you really want to read about the
basics first.

-aj
Re: ZOPE and "find in files feature" [ In reply to ]
Harry Spier wrote at 2006-8-20 05:51 -0400:
>I am building a website with a MYSQL database of text documents (several
>thousand). I need to construct a feature similar to a "find in files" of a
>text editor.

Looks as if you would need text indexing in MySQL.
Check whether MySQL does support this.

If not, you might be able to use Zope's search engine ("ZCatalog")
to index MySQL content. There is a (very old) HowTo, something
along the line "ZCatalog everything".



--
Dieter
_______________________________________________
Zope-DB mailing list
Zope-DB@zope.org
http://mail.zope.org/mailman/listinfo/zope-db
Re: ZOPE and "find in files feature" [ In reply to ]
Am 20.08.2006, 11:51 Uhr, schrieb Harry Spier <harryspier@hotmail.com>:

> Dear list members,
> I am a Python programmer but not familiar with ZOPE.
> I am building a website with a MYSQL database of text documents
> (several thousand). I need to construct a feature similar to a "find in
> files" of a text editor.
> I.e. the user will enter a text string in a form on the client-side and
> be passed back a results page from the server giving all the lines in
> the files in the Mysql database that contain that string. When he clicks
> on a line in the results page it will cause the file containing that
> line to be downloaded.
> Are there features in ZOPE that do any of this kind of functionality.

You can always use the ZODB to store the files and use the ZCatalog and to
be honest that might be your best option. Otherwise you will need to use
the MySQL full-text search system which is built-in. I don't think it is
as customisable as ZCatalog but may suffice.

Charlie

--
Charlie Clark
eGenix.com

* Professional Python Services directly from the Source *
_______________________________________________
Zope-DB mailing list
Zope-DB@zope.org
http://mail.zope.org/mailman/listinfo/zope-db