refactor(connector): refactor connector code to the connector module

Description

Due to legacy, in the backend code base the connector-related logic is spread all over the place, especially in database/repository.js. In this issue we want to refactor to the connector module for easier maintenance.