OrderIt | order foods and beverages more quickly and in a managed way | State Container library

you could try to use f strings.

are the "path" and "Path" suppose to be the same?

Path(f"c:\df{x}.txt").touch() logger.warning("New files named {path} created".format(a="c:\df{x}.txt"))

if so try this

Path(f"c:\df{x}.txt").touch() logger.warning(f"New files named {Path} created")

not so sure if this will solve anything but i just wondered

The problem is that in the 2nd argument of delete() you use the full sql statement, which is not nedeed and you concatenate the variable file to the sql statement's string without surrounding it with single quotes.
But even if you did, it is not the safe and recommended way.
Pass the parameter file in the 3d argument of the method delete() and use a ? placeholder inside the sql statement which will be replaced by the value of file, properly quoted, when the statement will be parsed: