fix dependencies and test spacing
specify primary key when inserting data