On Tue, Jun 5, 2012 at 6:13 PM, Mark Ehle <[email protected]> wrote: > capable with mysql. Can someone tell me what the query would be to extract > from dspace all the item names, their handles. and the bitstream associated > with each one?
Hi Mark, here's the DSpace database schema: https://wiki.duraspace.org/display/DSPACE/DSpace+2.0+Requirements+and+Issues#DSpace2.0RequirementsandIssues-DatabaseOverviewGraphic item name is stored in the "metadatavalue" table (by default " WHERE metadata_field_id=64", you can look up the value in "metadatafieldregistry"), handle in "handle" (resource_id is item ID) and bistream in "bitstream" connected to items via bundle2bitstream and item2bundle. The queries can get a bit hairy, since metadatavalue is an EAV table, but it is doable. Let me know if you have any problems. Regards, ~~helix84 ------------------------------------------------------------------------------ Live Security Virtual Conference Exclusive live event will cover all the ways today's security and threat landscape has changed and how IT managers can respond. Discussions will include endpoint security, mobile security and the latest in malware threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/ _______________________________________________ DSpace-tech mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/dspace-tech
