reorg tests
db adapter index and create actions for api server