I am working on a meeting room reservation module on Odoo I am trying to compare the date that I am about the insert with the dates that I have in the database. i tried the search(), the browse() functions i also tried to iterate on the recordset but it always points on the record that i am about to insert. i was thinking about doint it through an SQL query but i can't find the table's name where the data is stored.

Here is the class definition:

class Reservation(models.Model):
    _name = 'module001.reservation'

    name = fields.Char(String="Reservation Number", required=True)
    start_date = fields.Datetime(default=fields.Date.today)
    room_number = fields.Many2one('module001.room', ondelete='cascade', string="Room", required=True)
    reserved_for = fields.Many2one('res.partner', string="Reserved for ")
    end_date = fields.Datetime(string="End Date", store=True)

Thank you in advance