[Dachs-support] custom grammar on obscore tables
Nathanaƫl Jourdane
njourdane at irap.omp.eu
Thu Nov 8 17:55:07 CET 2018
Le vendredi 26 octobre 2018, 15:45:14 CET Markus Demleitner a écrit :
> EPN-TAP and obscore work quite differently -- the main reason for
> this is that a data center can have many epn-tap tables, whereas it
> can only have one obscore table. Hence, at least in DaCHS,
> ivoa.obscore is always a view, whereas epn-tap tables are normally
> actual tables.
>
> Another reason obscore is different is that at least historically,
> you'd first build SIAP (images) or SSAP (spectra and time series)
> services, and then just map the underlying tables into the obscore
> view. Hence, the actual import was (well, is) done through mixins
> and procDefs from siap and ssap, and there are no import helpers
> outside of them.
>
> So -- if what you have is celestial images or spectra, build SIAP or
> SSAP services as by the tutorials, and then simply use the
> corresponding mixins on the tables.
>
> If it's something else, don't despair -- what the tuturial said about
> "pure" obscore tables was just a bit hidden until now. I've introduced
> a new section header, so there's now
> http://docs.g-vo.org/DaCHS/tutorial.html#pure-obscore-tables
>
> Does that help already? As always, questions on this stuff help me
> improve the documentation.
Thank you Markus.
So, I started to use SSAP successfully, and now I want to use obscore among with SSAP, using the //obscore#publishSSAPHCD mixin.
I got this error message:
2018-11-08 16:27:20.681 UTC [71] gavoadmin at gavo ERROR: relation "ivoa._obscoresources" does not exist at character 13
2018-11-08 16:27:20.681 UTC [71] gavoadmin at gavo STATEMENT: DELETE FROM ivoa._obscoresources WHERE tableName='cade.obs_core'
Apparently, it comes from line 420 on obscore mixin:
<script id="removeTableFromObscoreSources" lang="python" type="beforeDrop"
name="remove table from obscore sources">
from gavo import rsc
table.query(
* "DELETE FROM ivoa._obscoresources WHERE tableName='\qName'")*
# importing this table may take a long time, and we don't want
# to have obscore offline for so long; so, we immediately recreate
# it.
rsc.makeData(base.caches.getRD("//obscore").getById("create"),
connection=table.connection)
</script>
Any idea?
Thank you.
--
Nathanaël Jourdane
Développeur
IRAP - Institut de Recherche en Astrophysique et Planétologie
9 avenue du Colonel Roche - 31028 Toulouse cedex 4
+33(0)5.61.55.58.37
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.g-vo.org/pipermail/dachs-support/attachments/20181108/072dc148/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 488 bytes
Desc: This is a digitally signed message part.
URL: <http://lists.g-vo.org/pipermail/dachs-support/attachments/20181108/072dc148/attachment.sig>
More information about the Dachs-support
mailing list