TinyBase logoTinyBase β

getMsSql

The getMsSql method returns a reference to the database connection the Store is being persisted to.

getMsSql(): ConnectionPool
returnsConnectionPool

A reference to the mssql ConnectionPool.

Example

This example creates a Persister object against a newly-created Store and then gets the database connection back out again.

import {connect} from 'mssql';
import {createStore} from 'tinybase';
import {createMsSqlPersister} from 'tinybase/persisters/persister-mssql';

const pool = await connect('Server=localhost,1433;Database=tinybase');
const store = createStore().setTables({pets: {fido: {species: 'dog'}}});
const persister = await createMsSqlPersister(store, pool, 'my_tinybase');

console.log(persister.getMsSql() == pool);
// -> true

await persister.destroy();
await pool.close();

Since

10.0.0