Using mysql types in typescript

Question

I have a nodejs typescript project that requires the use of mysqljs (https://www.npmjs.com/package/mysql), I've imported the DefinitelyTyped package (https://www.npmjs.com/package/@types/mysql) and included them in my tsconfig file

tsconfig.json

{ "compilerOptions": { "noImplicitAny": false, "module": "commonjs", "noEmitOnError": true, "removeComments": false, "sourceMap": true, "target": "es6" }, "exclude": [ "node_modules" ], "typeRoots": [ "node_modules/@types", "Scripts/typings/node" ], "types": [ "mysql", "node" ] }

I can correctly use the mysql module functions but I cannot access the types (IConnection, IQuery, etc). I can also see the parameter and return types from intellisense.

Example

import * as mysql from 'mysql'
...
getUser(username: string): User {
        mysql.createConnection({ host: "...", user: "...", password: "..." });
    }

But I'd like to make a method that returns a type defined in the mysql typings (IQuery for example)

Something like

getUser(username:string): IQuery{
}

Being a beginner in typescript coming from a c# background, I don't see what's going on here.

Thanks for the help.

EDIT: I have tried prefixing he type without any success as well as importing through this format import {IConnection} from 'mysql' Thanks again.

uint32 · Accepted Answer · 2017-08-24 01:57:34Z

1

It seems as though ReSharper was my issue, I still haven't found how to omit the errors or fix them though. I reinstalled Visual Studio 2017 and it worked without Resharper, but when I did install it, I started having problems again. Thanks for the help! I'll edit this if I can find a solution.

answered Aug 24, 2017 at 1:57

uint32

211 gold badge1 silver badge5 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Saravana · Accepted Answer · 2017-08-23 03:56:48Z

0

You can access it by prefixing the interface with mysql:

getUser(username:string): mysql.IQuery {

}

answered Aug 23, 2017 at 3:56

Saravana

41k20 gold badges110 silver badges112 bronze badges

5 Comments

uint32 Over a year ago

I tried that but it still doesn't show up or compile, maybe it's my IDE?

Saravana Over a year ago

Have you actually installed the types? npm install @types/mysql --save-dev

uint32 Over a year ago

Yes, I can see the types in my IDE, I just can't seem to be able to access them from outside the module. I also tried your command with no success.

Saravana Over a year ago

I am able to use the interface with your exact same tsconfig. Can you post something reproducible?

uint32 Over a year ago

It seems as though ReSharper was my issue, still haven't found how to fix it but it's out of subject.

Collectives™ on Stack Overflow

Using mysql types in typescript

2 Answers 2

Comments

5 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

5 Comments

Your Answer

Sign up or log in

Post as a guest

Related