On Mittwoch, 9. September 2009, Karen L Schuchardt wrote:
> Thanks for the pointer.  We have tried this but the data in the semantic
> media wiki extension table is is not deleted.  Thus when we perform ask
> queries, we continue to get results for pages that have been deleted.  

Interesting. SMW usually cleans its records when pages are deleted *in the 
wiki*. Maybe more is needed to make sure that this also happens when using the 
DeleteBatch extension to delete pages (or did you use the MW script?). In any 
case, the deleted pages will continue to have IDs in SMW (and hence "exists" 
in a sense), but they should not have any other properties.

> I will look at the extension you mention.  Presumably it is true that I
> could delete all records in the SMW tables with matching subject-id
> fields to pages that are being deleted and that would constitute
> complete and proper cleanup?

That would not be the preferred method, since you need to know the internal 
storage logic to do such clean-up properly (e.g. for n-ary datatypes, you need 
to clean further tables and ids).

In general, you can always perform the steps for SMW data repair [1] to fix 
SMW records. It is also possible now to call the script SMW_refreshData.php 
with a specific page name to refresh, so this would be another option for 
cleaning a deleted page's data.

Markus

[1] http://semantic-mediawiki.org/wiki/Help:Repairing_SMW's_data

>
> Karen
>
> Yaron Koren wrote:
> > This list is intended only for SMW-related discussions, but the
> > easiest solution for you is probably this extension:
> >
> > http://www.mediawiki.org/wiki/Extension:DeleteBatch
> >
> >
> > On Wed, Sep 2, 2009 at 8:10 PM, Schuchardt, Karen L
> > <karen.schucha...@pnl.gov <mailto:karen.schucha...@pnl.gov>> wrote:
> >
> >     Hi all,
> >
> >     We have a need to programmatically delete wiki pages in order to
> >     clean up after ourselves as a result of both system and user
> >     testing.  The number of pages involved can easily run into the
> >     hundreds or thousands so deleting interactively is not an option.
> >      We can generate a list of page names targeted for deletion.  Is
> >     there an admin script that would do this for us.  We have not been
> >     able to find anything.  If not, could somebody please provide
> >     advise on all the steps that need to be taken.
> >
> >     Thanks in advance,
> >     Karen
> >
> >    
> > -------------------------------------------------------------------------
> >----- Let Crystal Reports handle the reporting - Free Crystal Reports 2008
> > 30-Day
> >     trial. Simplify your report design, integration and deployment -
> >     and focus on
> >     what you do best, core application coding. Discover what's new with
> >     Crystal Reports now.  http://p.sf.net/sfu/bobj-july
> >     _______________________________________________
> >     Semediawiki-devel mailing list
> >     Semediawiki-devel@lists.sourceforge.net
> >     <mailto:Semediawiki-devel@lists.sourceforge.net>
> >     https://lists.sourceforge.net/lists/listinfo/semediawiki-devel


-- 
Markus Krötzsch  <mar...@semantic-mediawiki.org>
* Personal page: http://korrekt.org
* Semantic MediaWiki: http://semantic-mediawiki.org
* Semantic Web textbook: http://semantic-web-book.org
--

Attachment: signature.asc
Description: This is a digitally signed message part.

------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day 
trial. Simplify your report design, integration and deployment - and focus on 
what you do best, core application coding. Discover what's new with 
Crystal Reports now.  http://p.sf.net/sfu/bobj-july
_______________________________________________
Semediawiki-devel mailing list
Semediawiki-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/semediawiki-devel

Reply via email to