create unittest
add transaction support
add test for create_table