Beginners Question: Where to find DB-query methods

[Deleted user]

Hi there.

I'm totally new to confluence but have to work on a project in my company that uses a wiki based on confluence. This is part of my bachelor-thesis and I'm completly stuck as the technical owner of the project left and I am here to beg for any help :-(

As far as I know, we are using confluence version 2.2.6a.

My task is, to build a third-party application in the same project enviroment as our wiki, thus accessing the same database and the same data. Therefore I would like to reuse the data-query methods of confluence (to avoid manual database connection etc.).

But I can't find ANYTHING like a function to query the database. My idea was, to open our wiki, locate the search-button in the browser, then locate the website in the project, identify the function and trace it.

Yet again, I wasn't even able to locate the main-page in the project as the overall top-view structure of this wiki is a big black screen to me.

My question twoards you guys is: do you maybe know, how the website access the dataquery-methods (or where)? And could you point me to any good page, that explains the structure of confluence? Please don't say href="http://confluence.atlassian.com,%20">http://confluence.atlassian.com, thats what support told me as well - I have limited time and can't try to understand the whole big load of the project :-(

Thank you guys in advance, I really appreciate any answers!

With kind regards,

Jonathan

[Alain Moran · Accepted solution]

You should not need to directly access the database ... ever!

I suspect what you are looking for is Lucene, your best way of interacting with the indexes is likely to be one of the SearchQuery related classes, if you have access to the source (buy a $10 license if you don't yet have one) I'd suggest grepping through looking for that class & you should be able to find your way from there.

[Deleted user]

Hey guys.

Thanks for your answers! Of course I will not try to be dirty and operate on the database itself :-P

Let me give you an example. On our wiki-main page, there is a box showing the "Recent articles". These are 10 articles. My thought now is, there must be a function, that returns a list of 10 items for the website to display.

Where might I find this function?

@Alain: We might have the source in our company. At least I have a collection of around 100 packages (com.atlassian.confluence.*)

[Nic Brough -Adaptavist-]

As Alain says, you shouldn't interact with the database directly, even reading it is questionable (writing to it is an absolute no-no). You should code your stuff into a plugin, which will have all the methods you need to get at the data without having to worry about the database. That insulates you from upgrades and updates too.