For me I find that there is no way that I can do what David did here successfully. I need Christ to transform me. As I said when I “purpose” I fail. It is only as I trust Him, ask Him to transform me, admit my total dependence on Him that real change begins in my behavior.
I have tried all manner of schemes and gimmicks to purposefully manage my sin. They do not work. What works is admitting to Christ that I am a mess and asking Him, trusting Him to fix the mess. Problem is I forget that from time to time and “purpose” like David did. It never works for me.