[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