[chef] only_if and not_if guard

[Ravindra < >]

Hello All,

I'm writing a recipe where I'm trying to create a database in MSSQL. I've
written and execute resource, which is working fine. Now I want it to be
executed conditionally, if database exist do not execute the resource.
Irrespective of the condition the resource is getting executed every time.

The resource I'm using is given below.

execute "Create_DB" do
   command "sqlcmd -S server -i C:\createDB.sql -o C"\Create_db.log"
   not_if { "sqlcmd -U user -P secret -S server -b -Q \"select Count (*) from
master.dbo.sysdatabases WHERE name = 'myDB'\""
end


Am I doing anything wrong here?

Thanks
Ravi