Re: [PyWrapper-devel] Query Result
Status: Alpha
Brought to you by:
jatorre
Menu
▾
▴
Re: [PyWrapper-devel] Query Result
|
From: <m.d...@BG...> - 2007-05-14 10:59:50
|
I was thinking about that too. We already have that in the BioCASE = software. But the problem with TAPIR is that the concepts you map to are = themselves *not* mandatory. Only the output model which is used in a = request states that a certain concept is required. So basically any ABCD = or Darwin Core concept could be mandatory. The only way around I see is = to use a "canonical" model in the back to do the mapping, i.e. the model = which looks exactly like the schema that is used to define concepts. = This is an item on pywrappers requested feature list, but I dont have = time to do anything about it soon I am afraid. http://trac.pywrapper.org/pywrapper/ticket/97 thanks, markus -----Original Message----- From: pyw...@li... on behalf of Shunde = Zhang Sent: Mon 5/14/2007 8:22 AM To: PyWrapper Developers mailing list Cc:=09 Subject: Re: [PyWrapper-devel] Query Result Hi Markus, Thanks for your reply. I finally got it working. Since I don't know = which concept is compulsory, I just missed some concepts. It would be good if = I add a schema to the mapping, those must-have concepts will be added by default = so that I don't need to look for them from the long long list. Sorry the system is in our intranet, so you cannot access it. Thanks = anyway. Cheers, Shunde. Quoting Markus D=F6ring <m.d...@bg...>: > Dear Shunde, > the problem is found in the diagnostics here: > > "The element /DataSets/DataSet..Sequence:-1360356980 was dropped 1 > times because of missing required subelements or attributes: > [u'TechnicalContacts']" > > This means that ABCD defines a mandatory element TechnicalContacts > that cannot be created. This usually results of missing mappings or > NULL in the data of that specific record. Is the configuration tool > externally visible? Then we (su...@bi...) could check your > mappings directly online. > > best wishes > -- > Markus > > > > On 10.05.2007, at 04:55, Shunde Zhang wrote: > > > Hi all, > > > > I just installed pywrapper 3.1.0a, and set up a simple mapping to > > ABCD 2.06. > > > > I now have mapped 8 concepts. and when I did a simple query, I got > > the correct > > number of records but not the content as below. I used Query Forms > > to do this. > > Could you please tell me if anything wrong with my config? Thanks a > > lot. > > > > Cheers, > > Shunde. > > > > > > <response xsi:schemaLocation=3D"http://rs.tdwg.org/tapir/1.0 > > http://rs.tdwg.org/tapir/1.0/schema/tapir.xsd"> > > - > > <header> > > - > > <source sendtime=3D"2007-05-10T12:14:09.34" > > = accesspoint=3D"http://ristretto.sapac.edu.au:8088/pywrapper/pywrapper? > > dsa=3Davh"> > > <software version=3D"3.1.0alpha" name=3D"PyWrapper"/> > > </source> > > - > > <custom> > > <pyw:webapps pyw:location=3D"http://ristretto.sapac.edu.au:8088/ > > pywrapper"/> > > </custom> > > </header> > > <!-- CONTENT START --> > > - > > <search> > > <summary start=3D"0" totalMatched=3D"1"/> > > </search> > > <!-- CONTENT END --> > > - > > <diagnostics> > > <diagnostic time=3D"2007-05-10T12:18:21.15" level=3D"INFO">Reading > > request</diagnostic> > > - > > <diagnostic time=3D"2007-05-10T12:18:21.21" level=3D"INFO"> > > Read model http://rs.tdwg.org/tapir/cs/abcd/2.06/model/abcd206.xml > > </diagnostic> > > - > > <diagnostic time=3D"2007-05-10T12:18:22.22" level=3D"INFO"> > > Parsed response structure contains 991 leaf concepts with type out > > of 1663 nodes > > in total > > </diagnostic> > > <diagnostic time=3D"2007-05-10T12:18:22.91" level=3D"INFO">Request = fully > > parsed</diagnostic> > > <diagnostic time=3D"2007-05-10T12:18:22.91" level=3D"INFO">Init = model > > ACBD 2.06 with > > datasource preferences</diagnostic> > > - > > <diagnostic time=3D"2007-05-10T12:18:23.26" level=3D"INFO"> > > Model init finished. The model contains 1324 mapped concepts for > > datasource > > 'avh' out of 1324 model nodes mapped. > > </diagnostic> > > <diagnostic time=3D"2007-05-10T12:18:23.26" level=3D"INFO">Update = model > > structure > > with datasource preferences</diagnostic> > > - > > <diagnostic time=3D"2007-05-10T12:18:26.11" level=3D"INFO"> > > Executing SQL: "SELECT COUNT(DISTINCT SpecimenRecord.Id) FROM > > SpecimenRecord AS > > SpecimenRecord JOIN TaxonName AS TaxonName ON > > SpecimenRecord.TaxonNameId =3D > > TaxonName.Id WHERE TaxonName.FullScientificName LIKE 'Baccharis > > pingraea' " > > </diagnostic> > > <diagnostic time=3D"2007-05-10T12:18:41.22" level=3D"INFO">DB query > > finished</diagnostic> > > - > > <diagnostic time=3D"2007-05-10T12:18:41.22" level=3D"INFO"> > > Ordering view by [TaxonName.FullScientificName(text)] > > </diagnostic> > > - > > <diagnostic time=3D"2007-05-10T12:18:41.23" level=3D"INFO"> > > Executing SQL: "SELECT DISTINCT SpecimenRecord.Id FROM > > SpecimenRecord AS > > SpecimenRecord JOIN TaxonName AS TaxonName ON > > SpecimenRecord.TaxonNameId =3D > > TaxonName.Id WHERE TaxonName.FullScientificName LIKE 'Baccharis > > pingraea' ORDER > > BY TaxonName.FullScientificName, SpecimenRecord.Id LIMIT 51 OFFSET = 0" > > </diagnostic> > > <diagnostic time=3D"2007-05-10T12:18:54.29" level=3D"INFO">DB query > > finished</diagnostic> > > - > > <diagnostic time=3D"2007-05-10T12:18:54.29" level=3D"INFO"> > > Executing SQL: "SELECT TaxonName.FullScientificName, > > SpecimenRecord.Id, > > SpecimenRecord.SourceInstitutionID, SpecimenRecord.UnitId, > > SpecimenRecord.DateLastEdited, TaxonName.Id, TaxonName.Genus, > > TaxonName.Species, > > CollectSite.Id, CollectSite.LongitudeDecimal, > > CollectSite.LatitudeDecimal FROM > > SpecimenRecord AS SpecimenRecord LEFT JOIN TaxonName AS TaxonName ON > > SpecimenRecord.TaxonNameId =3D TaxonName.Id LEFT JOIN CollectSite AS > > CollectSite > > ON SpecimenRecord.CollectSiteId =3D CollectSite.Id WHERE > > SpecimenRecord.Id IN > > ('459464') ORDER BY TaxonName.FullScientificName " > > </diagnostic> > > <diagnostic time=3D"2007-05-10T12:18:54.32" level=3D"INFO">DB query > > finished</diagnostic> > > <diagnostic time=3D"2007-05-10T12:18:54.32" level=3D"INFO">Create = XML > > content from > > recordset</diagnostic> > > <diagnostic time=3D"2007-05-10T12:18:54.32" level=3D"INFO">Use > > intelligent model > > interpreter</diagnostic> > > - > > <diagnostic time=3D"2007-05-10T12:18:54.32" level=3D"WARNING"> > > No content produced. Probably there were no matches for your query. > > </diagnostic> > > <diagnostic time=3D"2007-05-10T12:18:54.32" level=3D"INFO">Finished > > creating XML > > content</diagnostic> > > - > > <diagnostic time=3D"2007-05-10T12:18:54.32" level=3D"INFO"> > > Total number of elements created=3D0. Elements dropped=3D0 > > </diagnostic> > > - > > <diagnostic time=3D"2007-05-10T12:18:54.33" level=3D"WARNING"> > > The element /DataSets..Sequence:-1360356532 was dropped 1 times > > because of > > missing required subelements or attributes: [u'DataSet'] > > </diagnostic> > > - > > <diagnostic time=3D"2007-05-10T12:18:54.33" level=3D"WARNING"> > > The element /DataSets/DataSet..Sequence:-1360356980 was dropped 1 > > times because > > of missing required subelements or attributes: = [u'TechnicalContacts'] > > </diagnostic> > > </diagnostics> > > </response> > > > > = ---------------------------------------------------------------------- > > --- > > This SF.net email is sponsored by DB2 Express > > Download DB2 Express C - the FREE version of DB2 express and take > > control of your XML. No limits. Just data. Click to get it now. > > http://sourceforge.net/powerbar/db2/ > > _______________________________________________ > > PyWrapper-devel mailing list > > PyW...@li... > > https://lists.sourceforge.net/lists/listinfo/pywrapper-devel > > > = -------------------------------------------------------------------------= > This SF.net email is sponsored by DB2 Express > Download DB2 Express C - the FREE version of DB2 express and take > control of your XML. No limits. Just data. Click to get it now. > http://sourceforge.net/powerbar/db2/ > _______________________________________________ > PyWrapper-devel mailing list > PyW...@li... > https://lists.sourceforge.net/lists/listinfo/pywrapper-devel > -------------------------------------------------------------------------= This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ _______________________________________________ PyWrapper-devel mailing list PyW...@li... https://lists.sourceforge.net/lists/listinfo/pywrapper-devel |
