

<?php if (!defined('BASEPATH')) {
    exit('No direct script access allowed');
}

class Bank_model extends CI_Model
{
    public function __construct()
    {
        parent::__construct();
    }

    public function insert($data) {
        $data_insert = array('bank_name' => $data['bank_name']);

        $sql = $this->db->insert_string('banks', $data_insert)
        . ' ON CONFLICT (bank_name) 
            DO UPDATE SET bank_name=EXCLUDED.bank_name
            RETURNING id';

        return $this->db->query($sql)->result_array()[0]['id'];
    }

    public function delete($data) {
        $this->db->where('id', $data['bank_id']);
        $this->db->delete('banks');
    }
}