How to enabe CLS?

[SMAH1]

In this link show how to enable cls for sequelize.

What are we can do it in sequelize-typescript?

[RobinBuschmann]

Since Sequelize of sequelize-typescript extends Sequelize of sequelize libraray, useCLS is available. But this method is not part of the typescript type definitions, so if you want to make the compiler happy, you need to access useCLS like this:

import {Sequelize} from 'sequelize-typescript';

Sequelize['useCLS'](namespace);

[thormengkheang]

@RobinBuschmann I can't use the way you mention. the compiler throw an error

[RobinBuschmann]

This is caused by the noImplicitAny: true tsc compiler option. You can avoid this via Sequelize['useCLS' as any](namespace).

But we should add useCLS to the typings.

[thormengkheang]

@RobinBuschmann yeah adding it to the typing would be nice.

[thormengkheang]

@RobinBuschmann still the same error by using Sequelize['useCLS' as any](namespace). I tried (Sequelize as any)['useCLS'](namespace); still didn't work

select statement didn't execute the transaction it's executing the default.

[RobinBuschmann]

@mengkheang your screens looking good to me. According to the sequelize docs it seems to be working like it should: http://docs.sequelizejs.com/manual/tutorial/transactions.html

[thormengkheang]

@RobinBuschmann as you can see in the sql log the select statement doesn't execute with the transaction id

[RobinBuschmann]

@mengkheang Sry, I didn't notice. Did you tried it with pure sequelize?

[thormengkheang]

@RobinBuschmann haven't tried it yet let me try it and see what happen.

[thormengkheang]

@RobinBuschmann it's working with pure sequelize

const cls = require('continuation-local-storage'),
	namespace = cls.createNamespace('sequelize-transaction');

const Sequelize = require('sequelize');
Sequelize.useCLS(namespace);

const sequelize = new Sequelize('test', 'root', 'password', {
	host: 'localhost',
	dialect: 'mysql'
});

const Project = sequelize.define('project', {
	title: Sequelize.STRING,
	description: Sequelize.TEXT
});

sequelize
	.authenticate()
	.then(() => {
		console.log('Connection has been established successfully.');
		sequelize.transaction(async function(t1) {
			console.log('check cls:', namespace.get('transaction') === t1); // true
			await Project.find();
		});
	})
	.catch((err) => {
		console.error('Unable to connect to the database:', err);
	});

SQL log

Executing (deafc788-28ea-4fb8-80b2-63603c818a8c): START TRANSACTION;
check cls: true
Executing (deafc788-28ea-4fb8-80b2-63603c818a8c): SELECT `id`, `title`, `description`, `createdAt`, `updatedAt` FROM `projects` AS `project` LIMIT 1;
Executing (deafc788-28ea-4fb8-80b2-63603c818a8c): COMMIT;

[thormengkheang]

@RobinBuschmann finally got it's working using it origin class

import * as cls from 'continuation-local-storage';
import * as SequelizeOrigin from 'sequelize';
import { Sequelize } from 'sequelize-typescript';

import { mysql as mysqlConfig } from '../config';

const namespace = cls.createNamespace('sequelize-transaction');

(SequelizeOrigin as any).useCLS(namespace);

[RobinBuschmann]

@mengkheang so you set useCLS on the origin sequelize class, continued using a sequelize-typescript sequelize instance and it is working now? Strange, but good to here that you got it to work. However this need to be investigated. Thanks for posting this!