def test_column_not_searchable(self):
        self.populate(5)

        user6, addr6 = self.create_user('Run To', 'The Hills')
        user7, addr7 = self.create_user('Fear Of', 'The Dark')

        self.session.add(user6)
        self.session.add(user7)
        self.session.commit()

        columns = []
        columns.append(ColumnDT('id', mData='ID'))
        columns.append(ColumnDT('name', mData='Username', searchable=False))
        columns.append(ColumnDT('address.description', mData='Address'))
        columns.append(ColumnDT('created_at', mData='Created at'))

        req = self.create_dt_params(search='Fear')

        rowTable = DataTables(
            req, User, self.session.query(User).join(Address), columns)

        res = rowTable.output_result()

        assert len(res['aaData']) == 0
        assert res['iTotalRecords'] == '7'
        assert res['iTotalDisplayRecords'] == '0'
Test if a column is not searchable.
dataset/ETHPy150Open Pegase745/sqlalchemy-datatables/tests/test_datatables_legacy.py/DataTablesLegacyTest.test_column_not_searchable