I set the DELETED field to 1 in the bitstream table and deleted the
matching lines from bundle2bitstream.
Ats,
Alcides Carlos de Moraes Neto
"Sometimes I think we're alone. Sometimes I think we're not. In either
case, the thought is staggering."
- R. Buckminster Fuller
2013/9/16 Alcides Carlos de Moraes Neto <[email protected]>
> How should I delete these bitstreams? Set the DELETED field to 1?
>
> Ats,
>
> Alcides Carlos de Moraes Neto
> "Sometimes I think we're alone. Sometimes I think we're not. In either
> case, the thought is staggering."
> - R. Buckminster Fuller
>
>
> 2013/9/16 Alcides Carlos de Moraes Neto <[email protected]>
>
>> Thank you helix that gave me a head start.
>> My query got more complex because I needed to filter only thumbnails as I
>> have some items that have .jpg files.
>> And some of them have very generic file names, so I had to match the
>> thumbnail to the file wihtin a specific ITEM_ID.
>>
>> This query will detect thumbnails that don't have a respective item
>> anymore:
>>
>> select i2b.item_id, b.* from bitstream b
>> inner join bundle2bitstream b2b on b2b.bitstream_id = b.bitstream_id
>> inner join item2bundle i2b on i2b.bundle_id = b2b.bundle_id
>> where (b.name like '%.___.jpg')
>> and rpad(b.name, length(b.name)-4) not in (
>> select b1.name from bitstream b1
>> inner join bundle2bitstream b2b1 on b2b1.bitstream_id = b1.bitstream_id
>> inner join item2bundle i2b1 on i2b1.bundle_id = b2b1.bundle_id
>> where i2b1.item_id = i2b.item_id
>> );
>>
>>
>> Ats,
>>
>> Alcides Carlos de Moraes Neto
>> "Sometimes I think we're alone. Sometimes I think we're not. In either
>> case, the thought is staggering."
>> - R. Buckminster Fuller
>>
>>
>> 2013/9/15 helix84 <[email protected]>
>>
>>> Hi Alcides,
>>>
>>> you could do something like the following SQL query. Please note that I
>>> didn't actually test it, it's just to give you the idea.
>>>
>>>
>>> SELECT bistream_id, nameFROM bitstreamWHERE name LIKE '%.jpg'AND
>>> rtrim(name, '.jpg') NOT IN (SELECT name FROM bitstream);
>>>
>>>
>>> Regards,
>>> ~~helix84
>>>
>>> Compulsory reading: DSpace Mailing List Etiquette
>>> https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette
>>>
>>>
>>>
>>
>
------------------------------------------------------------------------------
LIMITED TIME SALE - Full Year of Microsoft Training For Just $49.99!
1,500+ hours of tutorials including VisualStudio 2012, Windows 8, SharePoint
2013, SQL 2012, MVC 4, more. BEST VALUE: New Multi-Library Power Pack includes
Mobile, Cloud, Java, and UX Design. Lowest price ever! Ends 9/20/13.
http://pubads.g.doubleclick.net/gampad/clk?id=58041151&iu=/4140/ostg.clktrk
_______________________________________________
DSpace-tech mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/dspace-tech
List Etiquette: https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette
