如何使用query在MVC中移植PostgreSQL？

import psycopg2

class PostgreModel:
    def __init__(self, host, port, database, user, password):
        self.connection = psycopg2.connect(
            host=host,
            port=port,
            database=database,
            user=user,
            password=password
        )
    
    def query(self, sql, params=None):
        cursor = self.connection.cursor()
        cursor.execute(sql, params)
        result = cursor.fetchall()
        cursor.close()
        return result

# 在Controller中调用Model层的query方法进行查询
class UserController:
    def __init__(self):
        self.model = PostgreModel(
            host='localhost',
            port=5432,
            database='mydb',
            user='myuser',
            password='mypassword'
        )
    
    def get_user(self, user_id):
        sql = 'SELECT * FROM users WHERE id = %s'
        params = (user_id,)
        result = self.model.query(sql, params)
        # 处理查询结果
        return result

# 在View中获取Controller返回的查询结果，并进行展示
class UserView:
    def __init__(self, controller):
        self.controller = controller
    
    def show_user(self, user_id):
        user_data = self.controller.get_user(user_id)
        # 展示用户数据
        print(user_data)

# 在应用的入口处初始化Controller和View，并执行查询操作
if __name__ == '__main__':
    controller = UserController()
    view = UserView(controller)
    view.show_user(1)