to delete .svn files and folders using Windows Batch Script you can use the following snippet.
FOR /R "C:\Users\CodeSnippets.Fesslersoft.de\Documents\Visual Studio 2013\Projects\ConsoleApplication" %%X IN (.svn) DO (RD /S /Q "%%X" 2>nul)
Replace C:\Users\CodeSnippets.Fesslersoft.de\Documents\Visual Studio 2013\Projects\ConsoleApplication with your Solution’s Path.
To delete all unapproved comments in WordPress you can use the following snippet.
DELETE FROM wp_comments WHERE comment_approved = 0
To remove any post that is older than X days in WordPress you can use the query below.
DELETE FROM wp_posts WHERE post_type = 'post' AND DATEDIFF(NOW(), post_date) > X
To use select statement in a delete statement using MSSQL you can use the snippet below.
DELETE TableOne
FROM TableOne
INNER JOIN TableTwo
ON TableTwo.Id= TableOne.Id
AND ...
WHERE ...
To delete duplicate records using MSSQL you can use the following snippet.
The table must have identity column, which will be used to identify the duplicate records.
DELETE FROM TableName WHERE ID NOT IN ( SELECT MAX(ID) FROM TableName GROUP BY ColumnWithDuplicatesName)
To remove an element using javascript, you can use one of the following snippets.
//usage document.getElementById("ElementId").remove();
Element.prototype.remove = function() {
this.parentElement.removeChild(this);
}
//usage document.getElementsByClassName("Elements").remove();
NodeList.prototype.remove = HTMLCollection.prototype.remove = function() {
for(var index = 0, length = this.length; index < length; index++) {
if(this[index] && this[index].parentElement) {
this[index].parentElement.removeChild(this[index]);
}
}
}
removeChild() is the only method supported by the DOM to remove a element in Javascript (see -> Mozilla MDN Node.removeChild()).
To delete all pingbacks in WordPress you can use the mysql query below.
DELETE FROM wp_comments WHERE comment_type = 'pingback';
To delete a folder in Ruby you can use the following snippet.
import os os.rmdir(ourdir) #use with an empty dir import shutil shutil.rmtree(ourdir) #use with a non empty dir
To delete a file in Ruby you can use the following snippet.
File.delete('filePath')
To delete a file using python you can use the following snippet.
import os
try: os.unlink('filpath')
except OSError: pass # failed...