Import statement error

[Ivanf1]

Hello! I'm having a problem setting up ts-jest with knex. Here is a simplified copy of the codebase I am using with only the files directly correlated to this problem that can be used to reproduce the issue.

When i run npm test i get the error

project-root-dir\db\migrations\20210308215038_init.ts:1
import { Knex } from "knex";
^^^^^^

SyntaxError: Cannot use import statement outside a module

I don't get this error when I run npm run migrate to run the migration via Knex.
It seems like the files inside the db folder don't get transformed.

I tried adding

require("ts-node/register");

as the second line in the file knexfile.ts. With this I don't get the import error mentioned before, the tests run but when it gets to the function in teardownTests.ts I get this error

TSError: src/teardownTests.ts:2:5 - error TS7022: '__awaiter' implicitly has type 'any' because it does not have a type annotation and is referenced directly or indirectly in its own initializer.

How can I solve this problem? Thank you.

[ahnpnl]

The repo you linked doesn't exist

[Ivanf1]

Thank you for your answer.
Yes, I'm sorry, I took it down after I had resolved the issue but I forgot to post here.

I found out my problem was relate to this.
Unfortunately the answer mentioned did not work for me (jest 26.6.3, ts-jest 26.5.5).
I ended up running the database setup part from a different npm script before running jest. It works but it's definitely not an ideal solution.