add createdbsql for unit testing

Signed-off-by:benjamincharlton <benjicharlton@gmail.com>