QSortFilterProxyModel not updating View

As the title says I have QTableViews with QFilteProxyModels.But when any change is made to the database,the view is not updated.
Here is my code

Code:

void Factory::setupDealersTabModel()
{
    QSqlQueryModel *model = new QSqlQueryModel(this);
    QSqlQuery q(*db);
    QString query = "select name,organization,debt from dealers";
 
    if(!q.exec(query)){
        QSqlError err = q.lastError();
        QMessageBox::critical(this,"Error",err.text());
    }
    model->setQuery(query);
 
    //test code
    dealer_proxy_model = new QSortFilterProxyModel(this);
    dealer_proxy_model->setDynamicSortFilter(true);
 
    //set model
    ui->dealers_tableview->setModel(dealer_proxy_model);
    dealer_proxy_model->setSourceModel(model);
}
 
void Factory::setupSuppliersTabModel()
{
    QSqlQueryModel *model = new QSqlQueryModel(this);
    QSqlQuery q(*db);
    QString query = "select name,organization,balance from supplier";
 
    if(!q.exec(query)){
        QSqlError err = q.lastError();
        QMessageBox::critical(this,"Error",err.text());
    }
    model->setQuery(query);
 
    //set proxy
    supplier_proxy_model = new QSortFilterProxyModel(this);
    supplier_proxy_model->setDynamicSortFilter(true);
 
    //set model
    supplier_proxy_model->setSourceModel(model);
    ui->suppliers_tableview->setModel(supplier_proxy_model);
}

---