无法使用python scrapy框架在postgre中插入日期

import scrapy
from datetime import datetime

class MySpider(scrapy.Spider):
    name = 'my_spider'

    def start_requests(self):
        # 获取当前日期
        current_date = datetime.now().strftime('%Y-%m-%d')

        # 构造要插入的数据
        data = {
            'date': current_date,
            'other_field': 'value'
        }

        # 构造数据库插入语句
        query = "INSERT INTO my_table (date, other_field) VALUES ('%(date)s', '%(other_field)s')"

        # 执行数据库插入操作
        self.execute_query(query % data)

    def execute_query(self, query):
        # 执行数据库插入操作的代码
        pass

import scrapy
from datetime import datetime

class MySpider(scrapy.Spider):
    name = 'my_spider'

    def start_requests(self):
        # 获取当前日期
        current_date = datetime.now().strftime('%Y-%m-%d')

        # 构造要插入的数据
        data = {
            'date': current_date,
            'other_field': 'value'
        }

        # 构造数据库插入语句
        query = "INSERT INTO my_table (date, other_field) VALUES ('%(date)s', '%(other_field)s')"

        # 执行数据库插入操作
        self.execute_query(query % data)

    def execute_query(self, query):
        # 执行数据库插入操作的代码
        pass