use is_deleted column in codeSnippets table