Не удаётся переписать данные из csv файла в бд с использованием PostreSQL

from flask import Flask
from flask_sqlalchemy import SQLAlchemy
from config import config
import csv
import psycopg2
 
app = Flask(__name__)
app.config['SQLALCHEMY_DATABASE_URI'] = config['DATABASE']['URI']
app.config['SQLALCHEMY_TRACK_MODIFICATIONS'] = True
db = SQLAlchemy(app)
 
conn = psycopg2.connect(database="weather",
                        user='postgres', password='1234567',
                        host='127.0.0.1', port='5432'
)
 
 
# from userApp.database import *
db.create_all()
 
cur = conn.cursor()
cur.execute("""CREATE TABLE IF NOT EXISTS public.weather
(
    id integer NOT NULL,
    year integer,
    month character varying(10) COLLATE pg_catalog."default",
    day character varying(10) COLLATE pg_catalog."default",
    day_half character varying(5) COLLATE pg_catalog."default",
    temperature character varying(10) COLLATE pg_catalog."default",
    bar character varying(10) COLLATE pg_catalog."default",
    cloudy character varying(20) COLLATE pg_catalog."default",
    phenomena character varying(20) COLLATE pg_catalog."default",
    wind_direction character varying(2) COLLATE pg_catalog."default",
    wind_speed character varying(10) COLLATE pg_catalog."default",
    CONSTRAINT tabel_pkey PRIMARY KEY (id)
)
 
TABLESPACE pg_default;
 
ALTER TABLE IF EXISTS public.tabel
    OWNER to postgres;""")
 
 
class weather(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    year = db.Column(db.Integer)
    month = db.Column(db.String(10))
    day = db.Column(db.String(10))
    day_half = db.Column(db.String(5))
    temperature = db.Column(db.String(10))
    bar = db.Column(db.String(10))
    cloudy = db.Column(db.String(20))
    phenomena = db.Column(db.String(20))
    wind_direction = db.Column(db.String(2))
    wind_speed = db.Column(db.String(10))
 
    # def __repr__(self):
    #     return '<weather %r>' % self.id
    @property
    def serialize(self):
        return {
            'id': self.id,
            'year': self.year,
            'month': self.month,
            'day': self.day,
            'day_half': self.day_half,
            'temperature': self.temperature,
            'bar': self.bar,
            'cloudy': self.cloudy,
            'phenomena': self.phenomena,
            'wind_direction': self.wind_direction,
            'wind_speed': self.wind_speed
        }
 
 
# Читаем CSV
with open('weather.csv', 'r', newline='', encoding='UTF-8') as csvfile:
    reader = csv.reader(csvfile, delimiter=',')
    # Пропуск заголовка
    next(reader)
    id_num=0
    for row in reader:
        # Создаем объект класса БД
        flight = weather(id=id_num,year=row[0], month=row[1],
                         day=row[2], day_half=row[3],
                         temperature=row[4], bar=row[5],
                         cloudy=row[6], phenomena=row[7],
                         wind_direction=row[8], wind_speed=row[9])
        # Добавляем объект к сессии
        db.session.add(flight)
        # Записываем изменения в БД
        db.session.commit()
        id_num += 1

cur.execute("""CREATE TABLE public.weather
(
    year integer,
    month character varying(10),
    day integer,
    day_half character varying(5),
    temperature character varying(10),
    bar character varying(10),
    cloudy character varying(20),
    phenomena character varying(20),
    wind_direction character varying(10),
    wind_speed character varying(10),
    id integer NOT NULL,
    PRIMARY KEY (id)
);
 
ALTER TABLE IF EXISTS public.weather
    OWNER to postgres;""")