- BaseX-Talk - mailman.uni-konstanz.de

help required for xquery
by Ganesh K 18 Mar '10

18 Mar '10

Hello, Attached is xquery which i used. I tried using the xquery it halts with error Stopped at line 1, column 8191: [XPST0003] Expecting ">". i did try adding one more } as escaping. Need some help. I am using PHP to do so. Will try this in java later. Awaiting your quick reply. Thanks Ganesh K

2 1

Building BaseX
by Adrien Guillon 17 Mar '10

17 Mar '10

I want to build my own version of BaseX... I'm on Kubuntu 9.10 and do all my work through the command line (no eclipse for me). I ran make clean && make at the root of the project and I get a bunch of errors. This is a fresh build. What I want is to build a version of the source code with debugging enabled (-g). If there is already a way to do this please let me know. It looks like I need a stub function or something for XQJ ? Here are the errors: aj@laptopzilla:~/basex_src/clean/basex$ make test -r sourcelist || find src -regex '.*/[^./]*\.java' > sourcelist test -e bin || mkdir bin javac -sourcepath src -d bin @sourcelist src/org/basex/api/xqj/BXQDataSource.java:7: package javax.xml.xquery does not exist import javax.xml.xquery.XQConnection; ^ src/org/basex/api/xqj/BXQDataSource.java:8: package javax.xml.xquery does not exist import javax.xml.xquery.XQDataSource; ^ src/org/basex/api/xqj/BXQDataSource.java:9: package javax.xml.xquery does not exist import javax.xml.xquery.XQException; ^ src/org/basex/api/xqj/BXQDataSource.java:17: cannot find symbol symbol: class XQDataSource public final class BXQDataSource implements XQDataSource { ^ src/org/basex/api/xqj/BXQConnection.java:5: package javax.xml.xquery does not exist import javax.xml.xquery.XQConnection; ^ src/org/basex/api/xqj/BXQConnection.java:6: package javax.xml.xquery does not exist import javax.xml.xquery.XQException; ^ src/org/basex/api/xqj/BXQConnection.java:7: package javax.xml.xquery does not exist import javax.xml.xquery.XQExpression; ^ src/org/basex/api/xqj/BXQConnection.java:8: package javax.xml.xquery does not exist import javax.xml.xquery.XQMetaData; ^ src/org/basex/api/xqj/BXQConnection.java:9: package javax.xml.xquery does not exist import javax.xml.xquery.XQPreparedExpression; ^ src/org/basex/api/xqj/BXQConnection.java:10: package javax.xml.xquery does not exist import javax.xml.xquery.XQStaticContext; ^ src/org/basex/api/xqj/BXQDataFactory.java:12: package javax.xml.xquery does not exist import javax.xml.xquery.XQDataFactory; ^ src/org/basex/api/xqj/BXQDataFactory.java:13: package javax.xml.xquery does not exist import javax.xml.xquery.XQException; ^ src/org/basex/api/xqj/BXQDataFactory.java:14: package javax.xml.xquery does not exist import javax.xml.xquery.XQItem; ^ src/org/basex/api/xqj/BXQDataFactory.java:15: package javax.xml.xquery does not exist import javax.xml.xquery.XQItemType; ^ src/org/basex/api/xqj/BXQDataFactory.java:16: package javax.xml.xquery does not exist import javax.xml.xquery.XQSequence; ^ src/org/basex/api/xqj/BXQDataFactory.java:17: package javax.xml.xquery does not exist import javax.xml.xquery.XQSequenceType; ^ src/org/basex/api/xqj/BXQAbstract.java:14: package javax.xml.xquery does not exist import javax.xml.xquery.XQException; ^ src/org/basex/api/xqj/BXQAbstract.java:15: package javax.xml.xquery does not exist import javax.xml.xquery.XQItemType; ^ src/org/basex/api/xqj/BXQDataFactory.java:39: cannot find symbol symbol: class XQDataFactory class BXQDataFactory extends BXQAbstract implements XQDataFactory { ^ src/org/basex/api/xqj/BXQConnection.java:19: cannot find symbol symbol: class XQConnection final class BXQConnection extends BXQDataFactory implements XQConnection { ^ src/org/basex/api/xqj/BXQDataSource.java:27: cannot find symbol symbol : class XQConnection location: class org.basex.api.xqj.BXQDataSource public XQConnection getConnection(final Connection c) throws XQException { ^ src/org/basex/api/xqj/BXQDataSource.java:27: cannot find symbol symbol : class XQException location: class org.basex.api.xqj.BXQDataSource public XQConnection getConnection(final Connection c) throws XQException { ^ src/org/basex/api/xqj/BXQDataSource.java:31: cannot find symbol symbol : class XQConnection location: class org.basex.api.xqj.BXQDataSource public XQConnection getConnection(final String name, final String pw) { ^ src/org/basex/api/xqj/BXQDataSource.java:43: cannot find symbol symbol : class XQException location: class org.basex.api.xqj.BXQDataSource public String getProperty(final String key) throws XQException { ^ src/org/basex/api/xqj/BXQDataSource.java:59: cannot find symbol symbol : class XQException location: class org.basex.api.xqj.BXQDataSource public void setProperties(final Properties prop) throws XQException { ^ src/org/basex/api/xqj/BXQDataSource.java:64: cannot find symbol symbol : class XQException location: class org.basex.api.xqj.BXQDataSource throws XQException { ^ src/org/basex/api/xqj/BXQMetaData.java:6: package javax.xml.xquery does not exist import javax.xml.xquery.XQException; ^ src/org/basex/api/xqj/BXQMetaData.java:7: package javax.xml.xquery does not exist import javax.xml.xquery.XQMetaData; ^ src/org/basex/api/xqj/BXQMetaData.java:16: cannot find symbol symbol: class XQMetaData final class BXQMetaData extends BXQAbstract implements XQMetaData { ^ src/org/basex/api/xqj/BXQConnection.java:25: cannot find symbol symbol : class XQException location: class org.basex.api.xqj.BXQConnection public void commit() throws XQException { ^ src/org/basex/api/xqj/BXQConnection.java:29: cannot find symbol symbol : class XQExpression location: class org.basex.api.xqj.BXQConnection public XQExpression createExpression() throws XQException { ^ src/org/basex/api/xqj/BXQConnection.java:29: cannot find symbol symbol : class XQException location: class org.basex.api.xqj.BXQConnection public XQExpression createExpression() throws XQException { ^ src/org/basex/api/xqj/BXQConnection.java:33: cannot find symbol symbol : class XQStaticContext location: class org.basex.api.xqj.BXQConnection public XQExpression createExpression(final XQStaticContext sc) ^ src/org/basex/api/xqj/BXQConnection.java:33: cannot find symbol symbol : class XQExpression location: class org.basex.api.xqj.BXQConnection public XQExpression createExpression(final XQStaticContext sc) ^ src/org/basex/api/xqj/BXQConnection.java:34: cannot find symbol symbol : class XQException location: class org.basex.api.xqj.BXQConnection throws XQException { ^ src/org/basex/api/xqj/BXQConnection.java:44: cannot find symbol symbol : class XQMetaData location: class org.basex.api.xqj.BXQConnection public XQMetaData getMetaData() throws XQException { ^ src/org/basex/api/xqj/BXQConnection.java:44: cannot find symbol symbol : class XQException location: class org.basex.api.xqj.BXQConnection public XQMetaData getMetaData() throws XQException { ^ src/org/basex/api/xqj/BXQConnection.java:49: cannot find symbol symbol : class XQStaticContext location: class org.basex.api.xqj.BXQConnection public XQStaticContext getStaticContext() throws XQException { ^ src/org/basex/api/xqj/BXQConnection.java:49: cannot find symbol symbol : class XQException location: class org.basex.api.xqj.BXQConnection public XQStaticContext getStaticContext() throws XQException { ^ src/org/basex/api/xqj/BXQConnection.java:55: cannot find symbol symbol : class XQStaticContext location: class org.basex.api.xqj.BXQConnection final XQStaticContext sc) throws XQException { ^ src/org/basex/api/xqj/BXQConnection.java:54: cannot find symbol symbol : class XQPreparedExpression location: class org.basex.api.xqj.BXQConnection public XQPreparedExpression prepareExpression(final InputStream is, ^ src/org/basex/api/xqj/BXQConnection.java:55: cannot find symbol symbol : class XQException location: class org.basex.api.xqj.BXQConnection final XQStaticContext sc) throws XQException { ^ src/org/basex/api/xqj/BXQConnection.java:59: cannot find symbol symbol : class XQPreparedExpression location: class org.basex.api.xqj.BXQConnection public XQPreparedExpression prepareExpression(final InputStream is) ^ src/org/basex/api/xqj/BXQConnection.java:60: cannot find symbol symbol : class XQException location: class org.basex.api.xqj.BXQConnection throws XQException { ^ src/org/basex/api/xqj/BXQConnection.java:65: cannot find symbol symbol : class XQStaticContext location: class org.basex.api.xqj.BXQConnection final XQStaticContext sc) throws XQException { ^ src/org/basex/api/xqj/BXQConnection.java:64: cannot find symbol symbol : class XQPreparedExpression location: class org.basex.api.xqj.BXQConnection public XQPreparedExpression prepareExpression(final Reader r, ^ src/org/basex/api/xqj/BXQConnection.java:65: cannot find symbol symbol : class XQException location: class org.basex.api.xqj.BXQConnection final XQStaticContext sc) throws XQException { ^ src/org/basex/api/xqj/BXQConnection.java:69: cannot find symbol symbol : class XQPreparedExpression location: class org.basex.api.xqj.BXQConnection public XQPreparedExpression prepareExpression(final Reader r) ^ src/org/basex/api/xqj/BXQConnection.java:70: cannot find symbol symbol : class XQException location: class org.basex.api.xqj.BXQConnection throws XQException { ^ src/org/basex/api/xqj/BXQConnection.java:75: cannot find symbol symbol : class XQStaticContext location: class org.basex.api.xqj.BXQConnection final XQStaticContext sc) throws XQException { ^ src/org/basex/api/xqj/BXQConnection.java:74: cannot find symbol symbol : class XQPreparedExpression location: class org.basex.api.xqj.BXQConnection public XQPreparedExpression prepareExpression(final String query, ^ src/org/basex/api/xqj/BXQConnection.java:75: cannot find symbol symbol : class XQException location: class org.basex.api.xqj.BXQConnection final XQStaticContext sc) throws XQException { ^ src/org/basex/api/xqj/BXQConnection.java:83: cannot find symbol symbol : class XQPreparedExpression location: class org.basex.api.xqj.BXQConnection public XQPreparedExpression prepareExpression(final String query) ^ src/org/basex/api/xqj/BXQConnection.java:84: cannot find symbol symbol : class XQException location: class org.basex.api.xqj.BXQConnection throws XQException { ^ src/org/basex/api/xqj/BXQConnection.java:88: cannot find symbol symbol : class XQException location: class org.basex.api.xqj.BXQConnection public void rollback() throws XQException { ^ src/org/basex/api/xqj/BXQConnection.java:92: cannot find symbol symbol : class XQException location: class org.basex.api.xqj.BXQConnection public void setAutoCommit(final boolean ac) throws XQException { ^ src/org/basex/api/xqj/BXQConnection.java:97: cannot find symbol symbol : class XQStaticContext location: class org.basex.api.xqj.BXQConnection public void setStaticContext(final XQStaticContext sc) throws XQException { ^ src/org/basex/api/xqj/BXQConnection.java:97: cannot find symbol symbol : class XQException location: class org.basex.api.xqj.BXQConnection public void setStaticContext(final XQStaticContext sc) throws XQException { ^ src/org/basex/api/xqj/BXQItemType.java:6: package javax.xml.xquery does not exist import javax.xml.xquery.XQItemType; ^ src/org/basex/api/xqj/BXQItemType.java:7: package javax.xml.xquery does not exist import javax.xml.xquery.XQSequenceType; ^ src/org/basex/api/xqj/BXQItemType.java:18: cannot find symbol symbol: class XQItemType final class BXQItemType implements XQItemType { ^ src/org/basex/api/xqj/BXQDataFactory.java:49: cannot find symbol symbol : class XQException location: class org.basex.api.xqj.BXQDataFactory final URI uri) throws XQException { ^ src/org/basex/api/xqj/BXQDataFactory.java:53: cannot find symbol symbol : class XQException location: class org.basex.api.xqj.BXQDataFactory public BXQItemType createAtomicType(final int b) throws XQException { ^ src/org/basex/api/xqj/BXQDataFactory.java:59: cannot find symbol symbol : class XQException location: class org.basex.api.xqj.BXQDataFactory final QName qn2, final URI uri) throws XQException { ^ src/org/basex/api/xqj/BXQDataFactory.java:64: cannot find symbol symbol : class XQException location: class org.basex.api.xqj.BXQDataFactory throws XQException { ^ src/org/basex/api/xqj/BXQDataFactory.java:70: cannot find symbol symbol : class XQException location: class org.basex.api.xqj.BXQDataFactory public BXQItemType createCommentType() throws XQException { ^ src/org/basex/api/xqj/BXQDataFactory.java:75: cannot find symbol symbol : class XQItemType location: class org.basex.api.xqj.BXQDataFactory public BXQItemType createDocumentElementType(final XQItemType it) ^ src/org/basex/api/xqj/BXQDataFactory.java:76: cannot find symbol symbol : class XQException location: class org.basex.api.xqj.BXQDataFactory throws XQException { ^ src/org/basex/api/xqj/BXQDataFactory.java:85: cannot find symbol symbol : class XQItemType location: class org.basex.api.xqj.BXQDataFactory public BXQItemType createDocumentSchemaElementType(final XQItemType it) ^ src/org/basex/api/xqj/BXQDataFactory.java:86: cannot find symbol symbol : class XQException location: class org.basex.api.xqj.BXQDataFactory throws XQException { ^ src/org/basex/api/xqj/BXQDataFactory.java:95: cannot find symbol symbol : class XQException location: class org.basex.api.xqj.BXQDataFactory public BXQItemType createDocumentType() throws XQException { ^ src/org/basex/api/xqj/BXQDataFactory.java:101: cannot find symbol symbol : class XQException location: class org.basex.api.xqj.BXQDataFactory final QName qn2, final URI uri, final boolean n) throws XQException { ^ src/org/basex/api/xqj/BXQDataFactory.java:107: cannot find symbol symbol : class XQException location: class org.basex.api.xqj.BXQDataFactory throws XQException { ^ src/org/basex/api/xqj/BXQDataFactory.java:111: cannot find symbol symbol : class XQItem location: class org.basex.api.xqj.BXQDataFactory public BXQItem createItem(final XQItem v) throws XQException { ^ src/org/basex/api/xqj/BXQItem.java:14: package javax.xml.xquery does not exist import javax.xml.xquery.XQConnection; ^ src/org/basex/api/xqj/BXQItem.java:15: package javax.xml.xquery does not exist import javax.xml.xquery.XQException; ^ src/org/basex/api/xqj/BXQItem.java:16: package javax.xml.xquery does not exist import javax.xml.xquery.XQItemType; ^ src/org/basex/api/xqj/BXQItem.java:17: package javax.xml.xquery does not exist import javax.xml.xquery.XQResultItem; ^ src/org/basex/api/xqj/BXQItem.java:41: cannot find symbol symbol: class XQResultItem final class BXQItem extends BXQAbstract implements XQResultItem { ^ src/org/basex/api/xqj/BXQDataFactory.java:111: cannot find symbol symbol : class XQException location: class org.basex.api.xqj.BXQDataFactory public BXQItem createItem(final XQItem v) throws XQException { ^ src/org/basex/api/xqj/BXQDataFactory.java:122: cannot find symbol symbol : class XQItemType location: class org.basex.api.xqj.BXQDataFactory public BXQItem createItemFromAtomicValue(final String v, final XQItemType it) ^ src/org/basex/api/xqj/BXQDataFactory.java:123: cannot find symbol symbol : class XQException location: class org.basex.api.xqj.BXQDataFactory throws XQException { ^ src/org/basex/api/xqj/BXQDataFactory.java:133: cannot find symbol symbol : class XQItemType location: class org.basex.api.xqj.BXQDataFactory public BXQItem createItemFromBoolean(final boolean v, final XQItemType it) ^ src/org/basex/api/xqj/BXQDataFactory.java:134: cannot find symbol symbol : class XQException location: class org.basex.api.xqj.BXQDataFactory throws XQException { ^ src/org/basex/api/xqj/BXQDataFactory.java:139: cannot find symbol symbol : class XQItemType location: class org.basex.api.xqj.BXQDataFactory public BXQItem createItemFromByte(final byte v, final XQItemType it) ^ src/org/basex/api/xqj/BXQDataFactory.java:140: cannot find symbol symbol : class XQException location: class org.basex.api.xqj.BXQDataFactory throws XQException { ^ src/org/basex/api/xqj/BXQDataFactory.java:145: cannot find symbol symbol : class XQItemType location: class org.basex.api.xqj.BXQDataFactory final String base, final XQItemType it) throws XQException { ^ src/org/basex/api/xqj/BXQDataFactory.java:145: cannot find symbol symbol : class XQException location: class org.basex.api.xqj.BXQDataFactory final String base, final XQItemType it) throws XQException { ^ src/org/basex/api/xqj/BXQDataFactory.java:151: cannot find symbol symbol : class XQItemType location: class org.basex.api.xqj.BXQDataFactory final XQItemType it) throws XQException { ^ src/org/basex/api/xqj/BXQDataFactory.java:151: cannot find symbol symbol : class XQException location: class org.basex.api.xqj.BXQDataFactory final XQItemType it) throws XQException { ^ src/org/basex/api/xqj/BXQDataFactory.java:156: cannot find symbol symbol : class XQItemType location: class org.basex.api.xqj.BXQDataFactory public BXQItem createItemFromDocument(final Source s, final XQItemType it) ^ src/org/basex/api/xqj/BXQDataFactory.java:157: cannot find symbol symbol : class XQException location: class org.basex.api.xqj.BXQDataFactory throws XQException { ^ src/org/basex/api/xqj/BXQDataFactory.java:162: cannot find symbol symbol : class XQItemType location: class org.basex.api.xqj.BXQDataFactory final XQItemType it) throws XQException { ^ src/org/basex/api/xqj/BXQDataFactory.java:162: cannot find symbol symbol : class XQException location: class org.basex.api.xqj.BXQDataFactory final XQItemType it) throws XQException { ^ src/org/basex/api/xqj/BXQDataFactory.java:169: cannot find symbol symbol : class XQItemType location: class org.basex.api.xqj.BXQDataFactory final XQItemType it) throws XQException { ^ src/org/basex/api/xqj/BXQDataFactory.java:169: cannot find symbol symbol : class XQException location: class org.basex.api.xqj.BXQDataFactory final XQItemType it) throws XQException { ^ src/org/basex/api/xqj/BXQDataFactory.java:174: cannot find symbol symbol : class XQItemType location: class org.basex.api.xqj.BXQDataFactory public BXQItem createItemFromDouble(final double v, final XQItemType it) ^ src/org/basex/api/xqj/BXQDataFactory.java:175: cannot find symbol symbol : class XQException location: class org.basex.api.xqj.BXQDataFactory throws XQException { ^ src/org/basex/api/xqj/BXQDataFactory.java:180: cannot find symbol symbol : class XQItemType location: class org.basex.api.xqj.BXQDataFactory public BXQItem createItemFromFloat(final float v, final XQItemType it) ^ src/org/basex/api/xqj/BXQDataFactory.java:181: cannot find symbol symbol : class XQException location: class org.basex.api.xqj.BXQDataFactory throws XQException { ^ 100 errors make: *** [bin] Error 1 rm sourcelist

2 3

Re: [basex-talk] Information
by Christian Grün 17 Mar '10

17 Mar '10

> i have executed the below query in php > $session->execute("insert {" . $row['UDFInformation'] . "} into > basex:db(""nhlive"")/NewDataSet"); Note that the PHP API is just a simple wrapper for BaseX commands. If you define valid XQuery expressions, they should work fine within PHP, so it's advisable to first run them in the BaseX GUI or on command-line. The following tutorials might give you a clue how to perform updates via XQuery Update: – http://xqilla.sourceforge.net/XQueryUpdate – http://www.xmlmind.com/_tutorials/XQueryUpdate/index.html Best, Christian > but no result > as per my understanding Insert is the command udinformation is the xml data > and which is being added to nhlive database after /NewDataSet. For your > reference i have attached one xml file. There will be more xml files like > this to be added in the XMLServer. > so it would be like this > 1st file content > <NewDataSet> > </NewDataSet> > 2nd file content > <NewDataSet> > </NewDataSet> > hope you getting what i am attempting to do. > > i dont have much idea of XQuery i am just learning them. If you point me > link of PHP with Xquery would be great. > > Thanks > Ganesh K > > On Wed, Mar 17, 2010 at 12:36 PM, Ganesh K <ganeshk(a)21chms.com> wrote: >> >> Hi Christian, >> Thanks for your reply, i will find some way. Mean while as you >> mentioned with regards to api. I tried converting the jar file to .Net >> using ikvm the compilation was successful without any error and got the dll, >> but when i tried to use it in .Net below two namespace were not available >> dont know is it problem of the IKVM or something else. >> 'Imports org.basex.core.proc.XQuery >> 'Imports org.basex.data.Result >> >> I also tried using the api using php now what happens i am not able to get >> the result i.e the xml structure which it contains. i shall mail u with >> attachment in short while. >> >> >> Thanks >> >> On Tue, Mar 16, 2010 at 7:05 PM, Christian Grün >> <christian.gruen(a)gmail.com> wrote: >>> >>> Dear Ganesh K, >>> >>> thanks for your update. I am sorry I can't give you more information >>> on MS SQL and PHP; it might help to look up the correspondent mailing >>> lists and forums. If you need some particular help on BaseX and its >>> APIs, we'll be glad to help out (note that we might extend our APIs if >>> more people need specific features). >>> >>> Christian >>> >>> >>> On Tue, Mar 16, 2010 at 5:29 AM, Ganesh K <ganeshk(a)21chms.com> wrote: >>> > Christian, >>> > I have tried thats how i check the php is working. >>> > Ok let me give my scenario. >>> > I got SQL Server (it might be Oracle also) since these both sucks when >>> > given xml search, thats the reason for switching for BaseX. >>> > Now i will coding in PHP which will connect to the DB >>> > (SQLServer/Oracle) and >>> > take the data and add some more xml information and pump in BaseX. Then >>> > have >>> > another PHP interface to search the nodes text or only text. >>> > I know this will not be your task but any help will help i am having >>> > trouble >>> > connecting to MSSSQLServer from Apache/PHP. >>> > Hope i was clear, if need any more information then let me know. >>> > Thanks >>> > Ganesh K >>> > >>> > On Tue, Mar 16, 2010 at 3:04 AM, Christian Grün >>> > <christian.gruen(a)gmail.com> >>> > wrote: >>> >> >>> >> Ganesh K, >>> >> >>> >> nice to hear that you successfully manage to use the PHP API. The >>> >> following example should tell you how to receive results: >>> >> >>> >> https://svn.uni-konstanz.de/dbis/basex/trunk/api/etc/php/Example.php >>> >> >>> >> If you need more help, please give us more details on your scenario. >>> >> Christian >>> >> >>> >> >>> >> On Mon, Mar 15, 2010 at 8:01 AM, Ganesh K <ganeshk(a)21chms.com> wrote: >>> >> > Dear Christian, >>> >> > Thanks for your reply, i could take some steps and proceed >>> >> > so >>> >> > finally i configured Apache and PHP and i am using that, i executed >>> >> > the >>> >> > php >>> >> > code also so the code is quite successful. But i need some help or >>> >> > guide >>> >> > on >>> >> > how to use the commands on PHP like how to get the results of the >>> >> > executed >>> >> > queries. if you could link to forum also will do .. >>> >> > >>> >> > Thanks >>> >> > Ganesh K >>> >>> ___________________________ >>> >>> Christian Gruen >>> Universitaet Konstanz >>> Department of Computer & Information Science >>> D-78457 Konstanz, Germany >>> Tel: +49 (0)7531/88-4449, Fax: +49 (0)7531/88-3577 >>> http://www.inf.uni-konstanz.de/~gruen >> > >

1 0

Set External Variable in BaseX API
by Adrien Guillon 15 Mar '10

15 Mar '10

I switched from XQJ to the BaseX API...however I do not see how to set an external variable in a query. Could you point me to the documentation on how to do this? Thanks!

2 1

Help Making Query More Efficient
by Adrien Guillon 15 Mar '10

15 Mar '10

I have what I would think is a relatively small database (~1MB) and I have full indexing turned on. I am writing a query to rank instructors based on various properties, which are determined from the database. The query is much slower than I would expect, and I'd like to ask for assistance in optimizing it. The full query is below... if you would like me to send you the XML input file I am working on I will do so. The query takes 13166ms on a high-end system. declare namespace db="http://cdf.utoronto.ca/2010/CSC301H1S/TeamYankee/TeacherSubstitution/Databa…"; declare variable $database_name as xs:string := 'substituter_db'; declare variable $course_code as xs:string := 'MAT244'; declare variable $section as xs:string := 'L0101'; declare variable $session as xs:string := 'S'; declare variable $date as xs:date := xs:date('2010-02-11'); declare variable $start as xs:time := xs:time('10:00:00'); declare variable $end as xs:time := xs:time('11:00:00'); (: --------- Declare Functions ------------- :) (: --- Compute weight based on same department --- :) declare function local:same_department_weight($instructor as element(db:instructor), $lecture as element(db:lecture)) as xs:int { let $department_id := basex:db($database_name)/db:database/db:courses/db:course_details[db:course_code eq $lecture/db:course/db:course_code]/db:department_id/text() let $weight := basex:db($database_name)/db:database/db:ranking_criteria/db:same_department/text() return if ($instructor/db:department_id eq $department_id) then xs:int($weight) else xs:int(0) }; (: --- Compute weight based on the fact they teach the same course --- :) declare function local:teaches_same_course_weight($instructor as element(db:instructor), $lecture as element(db:lecture)) as xs:int { let $weight := basex:db($database_name)/db:database/db:ranking_criteria/db:teaches_same_course/text() let $same_course := basex:db($database_name)/db:database/db:lecture_schedule/db:lecture [ db:course/db:course_code eq $lecture/db:course/db:course_code and db:instructor_id eq $instructor/db:instructor_id ] return if ( exists($same_course) ) then xs:int($weight) else xs:int(0) }; (: --- Compute weight based on the fact they have covered the course before --- :) (: --- Compute weight based on the fact they teach at the same level --- :) declare function local:teaches_at_same_level_weight($instructor as element(db:instructor), $lecture as element(db:lecture)) as xs:int { (: Courses taught by this instructor :) let $courses_taught := distinct-values ( basex:db($database_name)/db:database/db:lecture_schedule/db:lecture [ db:instructor_id eq $instructor/db:instructor_id ]/db:course/db:course_code/text() ) let $levels_taught := distinct-values( for $course_taught in $courses_taught return basex:db($database_name)/db:database/db:courses/db:course_details[db:course_code/text() eq $course_taught]/db:course_level/text() ) (: The level of the lecture the sub is for :) let $level_of_lecture := basex:db($database_name)/db:database/db:courses/db:course_details[db:course_code eq $lecture/db:course/db:course_code]/db:course_level/text() let $weight := basex:db($database_name)/db:database/db:ranking_criteria/db:teaches_at_same_level/text() return if ( exists(index-of($levels_taught, $level_of_lecture)) ) then xs:int($weight) else xs:int(0) }; (: --- Compute weight based on the total number of hours spent covering before --- :) (: --- Compute weight based on the fact this course is one they prefer to teach --- :) (: --- Compute weight based on the fact they teach in the same department --- :) (: Compute the rank of the instructor for this course :) declare function local:compute_rank($instructor as element(db:instructor), $lecture as element(db:lecture)) as xs:int { xs:int(local:same_department_weight($instructor, $lecture) + local:teaches_same_course_weight($instructor, $lecture) + local:teaches_at_same_level_weight($instructor, $lecture)) }; (: ------- Do actual Work --------- :) (: Get the lecture :) let $lecture := basex:db($database_name)/db:database/db:lecture_schedule/db:lecture [ db:course/db:course_code eq $course_code and db:course/db:section eq $section and db:course/db:session eq $session and xs:date(db:event_time/db:date) eq $date and xs:time(db:event_time/db:time/db:start) eq $start and xs:time(db:event_time/db:time/db:end) eq $end ] (: Iterate over all instructors and rank them :) let $instructors := basex:db($database_name)/db:database/db:instructors/db:instructor let $ranked_instructors := for $instructor in $instructors return <db:ranked_instructor> {$instructor} <db:rank>{local:compute_rank($instructor, $lecture)}</db:rank> </db:ranked_instructor> for $ranked_instructor in $ranked_instructors order by xs:int($ranked_instructor/db:rank) descending return $ranked_instructor

2 2

Fabio Camposgu
by fcamposgu＠bncr.fi.cr 14 Mar '10

14 Mar '10

Guys! Hi, good job with this aplication, I really enjoy use that but I have one question, where can I find the locations.xml file to use it like an example to my class?

2 1

Waiting For Commands to Complete
by Adrien Guillon 13 Mar '10

13 Mar '10

I didn't see it in the documentation, and I've been looking through example programs to find this out. How do I wait for a command to complete? For instance, I'm attempting to do an Export with the BaseX Java API. What I don't understand is how I can block execution until the command is finished... I looked quickly at Process and the Context class and did not find anything revealing.

2 2

Information
by ganeshk＠21chms.com 11 Mar '10

11 Mar '10

Hello, First of all your team has done a great job of creating BaseX, pretty impressed with it. Now to the point for writing this mail. We into Healthcare solutions for past 25 years, myself technical leader has got a task of finding tool for our xml data fetching. We have got xml data (in sqlserver and Oracle also), Which can contain plain text, Image, RTF also. in sql server or oracle we write queries it is fine but when it comes for analysis kind of thing it tumbles down. So we were planning to have an XML server which will contain the code and the xml data and that can be queried. Couple of questions. 1] Can i directly import data to BaseX from queries or does it require to be in xml file or can it be a string also. 2] Is relational query possible, in xml we got a sort of table structure (if required can send the dataxml file for reference) 3] How much load can BaseX take because the xml file content will be say 1 to 2 mb max, but there will be millions of records. 4] Is there any .Net api too (not a constraint but just curious). Hope i made sense. Awaiting your quick response. Thanks Ganesh K

2 1

RESTful BaseX
by Christian Grün 11 Mar '10

11 Mar '10

Dear all, in the "basex-api" package of our Subversion and Maven repository, you find a preliminary implementation of our soon-to-be-released REST API: http://www.inf.uni-konstanz.de/dbis/basex/maven/org/basex/basex-api/6.0.4/ http://svn.uni-konstanz.de/dbis/basex/trunk/api/src/main/java/org/basex/api… The runnable test class is: org.basex.api.jaxrx.StartJAXRX You can play around with the following URLs: – Root directory: http://localhost:8984/ – List of databases: http://localhost:8984/basex/jaxrx/db – Perform a factbook query: http://localhost:8984/basex/jaxrx/db/factbook?query=//name Beside the GET operation, PUT, POST, and DELETE are implemented as well. The API is built upon JAX-RX, a new REST interface layer for XML databases: https://sourceforge.net/projects/jax-rx Documentation and more examples will follow soon. As usual, testing and feedback is welcome! Christian ___________________________ Christian Gruen Universitaet Konstanz Department of Computer & Information Science D-78457 Konstanz, Germany Tel: +49 (0)7531/88-4449, Fax: +49 (0)7531/88-3577 http://www.inf.uni-konstanz.de/~gruen

1 0

Information
by ganeshk＠21chms.com 11 Mar '10

11 Mar '10

Hello, First of all your team has done a great job of creating BaseX, pretty impressed with it. Now to the point for writing this mail. We into Healthcare solutions for past 25 years, myself technical leader has got a task of finding tool for our xml data fetching. We have got xml data (in sqlserver and Oracle also), Which can contain plain text, Image, RTF also. in sql server or oracle we write queries it is fine but when it comes for analysis kind of thing it tumbles down. So we were planning to have an XML server which will contain the code and the xml data and that can be queried. Couple of questions. 1] Can i directly import data to BaseX from queries or does it require to be in xml file or can it be a string also. 2] Is relational query possible, in xml we got a sort of table structure (if required can send the dataxml file for reference) 3] How much load can BaseX take because the xml file content will be say 1 to 2 mb max, but there will be millions of records. 4] Is there any .Net api too (not a constraint but just curious). Hope i made sense. Awaiting your quick response. Thanks Ganesh K

2 1