{"id":544,"date":"2003-12-06T22:10:26","date_gmt":"2003-12-07T02:10:26","guid":{"rendered":"http:\/\/wordpress.cephas.net\/?p=544"},"modified":"2003-12-06T22:10:26","modified_gmt":"2003-12-07T02:10:26","slug":"indexing-database-content-with-lucene-coldfusion","status":"publish","type":"post","link":"https:\/\/cephas.net\/blog\/2003\/12\/06\/indexing-database-content-with-lucene-coldfusion\/","title":{"rendered":"Indexing Database Content with Lucene & ColdFusion"},"content":{"rendered":"

Terry emailed me a couple days ago wondering how he could use ColdFusion<\/a> and Lucene<\/a> to index and then search a database table. Since we’re completely socked in here in Boston, I had nothing better to do today that hack together a quick snippet that does just that:
\n
\n<cfset an = CreateObject(\"java\", \"org.apache.lucene.analysis.StopAnalyzer\")>
\n<cfset an.init()>
\n<cfset writer = CreateObject(\"java\", \"org.apache.lucene.index.IndexWriter\")>
\n<cfset writer.init(\"C:\\mysite\\index\\\", an, \"true\")>
\n<cfquery name=\"contentIndex\" datasource=\"sample\">
\nselect label, description, id
\nFROM product
\n<\/cfquery>
\n<cfloop query=\"contentIndex\">
\n  <cfset d = CreateObject(\"java\", \"org.apache.lucene.document.Document\")>
\n  <cfset fld = CreateObject(\"java\", \"org.apache.lucene.document.Field\")>
\n  <cfset content = contentIndex.description>
\n  <cfset title = contentIndex.label>
\n  <cfset urlpath = \"\/products\/detail.cfm?id=\" & contentIndex.id>
\n  <cfset d.add(fld.Keyword(\"url\", urlpath))>
\n  <cfset d.add(fld.Text(\"title\", title))>
\n  <cfset d.add(fld.UnIndexed(\"summary\", content))>
\n  <cfset d.add(fld.UnStored(\"body\", content))>
\n  <cfset writer.addDocument(doc)>
\n<\/cfloop>  
\n<cfset writer.close()>
\n<\/code>
\nThe only real change from the code that I wrote previously to index a document was that instead of looping over the file system looking for documents, I loop over a query and then indexed the text of a column from the database rather than the text of a document. (I would have written in in CFScript<\/a>, but you can’t do queries from CFScript yet, unless you use a UDF to do the query)<\/p>\n

You can download the source here<\/a>, if you’re so inclined.<\/p>\n","protected":false},"excerpt":{"rendered":"

Terry emailed me a couple days ago wondering how he could use ColdFusion and Lucene to index and then search a database table. Since we’re completely socked in here in Boston, I had nothing better to do today that hack together a quick snippet that does just that: <cfset an = CreateObject(“java”, “org.apache.lucene.analysis.StopAnalyzer”)> <cfset an.init()> … Continue reading Indexing Database Content with Lucene & ColdFusion<\/span> →<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[7,19],"tags":[],"_links":{"self":[{"href":"https:\/\/cephas.net\/blog\/wp-json\/wp\/v2\/posts\/544"}],"collection":[{"href":"https:\/\/cephas.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/cephas.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/cephas.net\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/cephas.net\/blog\/wp-json\/wp\/v2\/comments?post=544"}],"version-history":[{"count":0,"href":"https:\/\/cephas.net\/blog\/wp-json\/wp\/v2\/posts\/544\/revisions"}],"wp:attachment":[{"href":"https:\/\/cephas.net\/blog\/wp-json\/wp\/v2\/media?parent=544"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/cephas.net\/blog\/wp-json\/wp\/v2\/categories?post=544"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/cephas.net\/blog\/wp-json\/wp\/v2\/tags?post=544"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}