search

earthchem / EarthChemAdmin2

Admin tools for Earthchem database person, organization, affiliation, citation
Apache License 2.0
0 stars 0 forks source link

Add function 'delete orphan sampling feature' on check view #5

Closed sparkji closed 5 years ago

sparkji commented 5 years ago

'Check view' just show orphan sampling feature, like station without child, specimen without child, etc. Please add delete function, allow curator delete orphan sampling features. And, please change 'No Child Station' to 'Station without child', 'No Parent Analyzed' to 'Analyzed sample without parent', 'No Child Specimen' to 'Specimen without child', 'No Parent Specimen' to 'Specimen without parent.

bhchen8 commented 5 years ago

In which table, view or original table, data should be deleted?

sparkji commented 5 years ago

Original table

bhchen8 commented 5 years ago

updated, please test it.

sparkji commented 5 years ago

we don't have table sampling_feature_extension_property any more, please remove it from queries.

bhchen8 commented 5 years ago

updated code and drop this table from jdbc:postgresql://dev-ecdb-vm.earthchem.org:5432/ecdb_v1

sparkji commented 5 years ago

@bhchen8 Great! Thanks.