add completed insert and update implementations