On Mon, Nov 12, 2012 at 10:14 PM, Calloni, Rodrigo <[email protected]>
wrote:
> I would prefer option 2. I just need a hard-copy of the thumbnail files
and if I can do that via SQL even better.
Warning, untested code ahead:
SELECT 'cp /dspace/assetstore/' || substr(bitstream.internal_id, 1, 2)
|| '/' || substr(bitstream.internal_id, 3, 2) || '/' ||
substr(bitstream.internal_id, 5, 2) || '/' || bitstream.internal_id ||
' ' || bitstream.nameFROM bitstream,bundle2bitstream,bundleWHERE
bitstream.bitstream_id = bundle2bitstream.bitstream_idAND
bundle2bitstream.bundle_id = bundle.bundle_idAND bundle.name =
'THUMBNAIL';
but it should give you the idea.
Regards,
~~helix84
Compulsory reading: DSpace Mailing List Etiquette
https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette
------------------------------------------------------------------------------
Monitor your physical, virtual and cloud infrastructure from a single
web console. Get in-depth insight into apps, servers, databases, vmware,
SAP, cloud infrastructure, etc. Download 30-day Free Trial.
Pricing starts from $795 for 25 servers or applications!
http://p.sf.net/sfu/zoho_dev2dev_nov
_______________________________________________
DSpace-tech mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/dspace-tech
