Hi,

Gabriela Radu wrote:

hi.
i don;t want to export my projects, i just want to see the tables that xwiki creates when i make a new space(project). how can i see that? like in using mysql you can see the db from the ".sql" . do i have something similar here? pls say yes :)
Thank you!

Hi Gabriela,

I am not sure what are you looking for, but I think that you must we aware about the fact that no new table is created when you create a new space. In fact a new space exists when a page is created on it. And it will be removed when all the pages belonging to it are deleted. So, new pages/spaces are stored in the predefined database structure.

XWiki has its own methods that will probably allow you to get what you want. For instance, look at the My Recent Modifications panel code:

#set($recentDocs = $xwiki.searchDocuments("where 1=1 and doc.author='$context.user' order by doc.date desc", 5, 0))
#if($recentDocs.size() > 0 || $showEmptyPanels)
#panelheader($msg.get("My Recent Modifications"))
#set($first = true)
#foreach($docname in $recentDocs)
#set($rdoc = $xwiki.getDocument($docname).getTranslatedDocument())
#if($first == true)
#set($first = false)
#else
<span class="pitemseparator"> | </span>
#end
<span class="panelitem"><a href="$rdoc.getURL("view")">$rdoc.displayTitle</a></span>
#end
#panelfooter()
#end

The first Velocity directive, #set, uses a method searchDocuments() of the $xwiki class to pass a given set of documents to $recentDocs. Its argument contents "pure" SQL: "where 1=1 and doc.author='$context.user' order by doc.date desc" :-)

On the other hand, it is possible to use SQL within XWiki. See this Groovy snippet...

<%
import groovy.sql.Sql
db = Sql.newInstance("jdbc:mysql://YourHots/YourDatabase", "username", "password", "com.mysql.jdbc.Driver")
List YourResults = db.rows('SELECT * FROM tablename s where field1 like "I" and field2 like "A" and field>=1')
%>

It allows you to use SQL statements and get the results on your XWiki page. It, of course, can ask XWiki schema as well.

Hope this helps,

Ricardo

-- 
Ricardo Rodríguez
Your EPEC Network ICT Team