sql api test added
layer tests added