import Database from 'sosise-core/build/Database/Database';
import %name%Interface from './%name%Interface';
import { Knex } from 'knex';

export default class %name% implements %name%Interface {

    private dbClient: Knex;

    /**
     * Constructor
     */
    constructor() {
        this.dbClient = Database.getConnection(process.env.DB_PROJECT_CONNECTION as string).client;
    }

    /**
     * Get all customers
     */
    public async getAllCustomers(): Promise<any> {
        // Get rows
        const customers = await this.dbClient
            .table('customers');

        return customers;
    }
}