exists – Tarik Billa

Delete files from directory if filename contains a certain word

April 8, 2024 by Tarik

To expand on Henk’s answer, you need: string rootFolderPath = @”C:\\SomeFolder\\AnotherFolder\\FolderCOntainingThingsToDelete”; string filesToDelete = @”*DeleteMe*.doc”; // Only delete DOC files containing “DeleteMe” in their filenames string[] fileList = System.IO.Directory.GetFiles(rootFolderPath, filesToDelete); foreach(string file in fileList) { System.Diagnostics.Debug.WriteLine(file + “will be deleted”); // System.IO.File.Delete(file); } BE VERY CAREFUL! Note that I’ve commented out the delete command. Run … Read more

What does “exists” mean in Haskell type system?

December 4, 2023 by Tarik

A use of existential types that I’ve run into is with my code for mediating a game of Clue. My mediation code sort of acts like a dealer. It doesn’t care what the types of the players are – all it cares about is that all the players implement the hooks given in the Player … Read more

Set Variable value in exists condition sql server

December 1, 2023 by Tarik

Declare @CategoryID as int SET @CategoryID = CASE WHEN EXISTS(SELECT 1 FROM Categories WHERE Categoryname = @CategoryName) THEN 1 ELSE 0 END Another way would be something like …. IF EXISTS (SELECT 1 FROM Categories WHERE Categoryname = @CategoryName) BEGIN SET @CategoryID = 1; END ELSE BEGIN SET @CategoryID = 0; END

Check if method exists in the same class

September 26, 2023 by Tarik

Checking whether an item does not exist in another table

September 16, 2023 by Tarik

In general if you want rows that don’t exist in another table, then LEFT JOIN the other table and WHERE … IS NULL to a column on the second table. Also you mentioned that you don’t want rows where process.id_string is NULL. SELECT p.name, p.id_string FROM process p LEFT JOIN value_search v ON v.id_string = … Read more

How to say create procedure if not exists in MySQL

September 9, 2023 by Tarik

Just drop the procedure if it does exist and then re-add it: DROP PROCEDURE IF EXISTS my_procedure; CREATE PROCEDURE my_procedure()

Check if extended property description already exists before adding

August 6, 2023 by Tarik

This first script checks if the extended property describing the table exists: IF NOT EXISTS (SELECT NULL FROM SYS.EXTENDED_PROPERTIES WHERE [major_id] = OBJECT_ID(‘Table_Name’) AND [name] = N’MS_Description’ AND [minor_id] = 0) EXECUTE sp_addextendedproperty @name = N’MS_Description’, @value = N’This table is responsible for holding information.’, @level0type = N’SCHEMA’, @level0name = N’dbo’, @level1type = N’TABLE’, @level1name … Read more

How to Check if value exists in a MySQL database

July 30, 2023 by Tarik

How to check if a file exists and is readable in C++?

July 10, 2023 by Tarik

I would probably go with: ifstream my_file(“test.txt”); if (my_file.good()) { // read away } The good method checks if the stream is ready to be read from.

How can you check to see if a file exists (on the remote server) in Capistrano?

June 10, 2023 by Tarik

In capistrano 3, you can do: on roles(:all) do if test(“[ -f /path/to/my/file ]”) # the file exists else # the file does not exist end end This is nice because it returns the result of the remote test back to your local ruby program and you can work in simpler shell commands.