Why does the bible say that David kept all the commands of the Lord when he so clearly didn't?

Why does the bible say that David kept all the commands of the Lord when he so clearly didn't? > **1 Kings 15:5 NIV** - For David had done what was right in the eyes of the Lord and had not failed to keep any of the Lord’s commands all the days of his life—except in the case of Uriah the Hittite. Yes, there was the episode with Uriah the Hittite. But there was also the matter of David taking a census of the fighting men of Israel: > **2 Samuel 24:10 NIV** - David was conscience-stricken after he had counted the fighting men, and he said to the Lord, “I have sinned greatly in what I have done. Now, Lord, I beg you, take away the guilt of your servant. I have done a very foolish thing.” And that's just what's written down. Other biblical figures like Isaiah, Jesus, Paul, and even David himself says there is no one who is good, so certainly David would have been guilty of other sins.