v0.5.0: refactor: convert tests to use external test package

- Changed all test files from `package database` to `package database_test`
- Added explicit imports for the database package being tested
- Updated all function and constant references to use the `database.` prefix