活动专区

活动公告

上车！GBase 8a开发者联盟发车了 技术福利、人脉资源全都有！

认证培训专区

认证培训资料

GBase 8s GDCA 认证培训课前准备

GBase 8a

其他

物化视图报错：references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them

01-GBase 8s 事务型数据库 安装与卸载

GBase 8s

适配迁移

[GBase 8s 教程]GBase 8s 常用函数、表达式

### 代码如下：

``````
from GBaseConnector import connect, GBaseError
from datetime import datetime

db_config = {
    'host': '******',
    'user': 'admin',
    'passwd': '****',
    'port': 5258
}

try:
    # 连接数据库
    conn = connect(**db_config)
    cursor = conn.cursor()

    # 第一步：查询zyglpt schema下的所有表名
    cursor.execute("""
    SELECT table_schema, table_name
    FROM information_schema.tables
    WHERE table_schema = 'zyglpt' AND table_type = 'BASE TABLE';
    """)
    tables = cursor.fetchall()
    for table in tables:
        schema = table[0]
        table_name = table[1]

        cursor.execute(f"""
        SELECT *
        FROM information_schema.cluster_tables
        WHERE table_schema = '{schema}'
        AND table_name = '{table_name}'
        """)
        cluster_info = cursor.fetchall()
        current_time = datetime.now().strftime('%Y-%m-%d %H:%M:%S')
        for row in cluster_info:
            insert_sql = """
            INSERT INTO admindb.table_space_usage (
                TABLE_VC,
                TABLE_SCHEMA,
                TABLE_NAME,
                CREATE_TIME,
                UPDATE_TIME,
                TABLE_DATA_SIZE,
                TABLE_STORAGE_SIZE,
                TABLE_TYPE,
                TJSJ
            ) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s);
            """
            # 组装参数，最后一个参数为当前时间
            params = list(row) + [current_time]
            cursor.execute(insert_sql, params)

    # 提交事务
    conn.commit()
except GBaseError as e:
    print(f"Database error occurred: {e}")
except Exception as e:
    print(f"An error occurred: {e}")
finally:
    # 确保关闭连接
    if 'cursor' in locals():
        cursor.close()
    if 'conn' in locals():
        conn.close()
```
````
`````
``````

### 问题：

- 不报任何错误，但是最终table_space_usage表里没有数据。
- 已经添加过很多回显，每一步都有结果返回。
### 请大佬帮忙看看



关于GBase8a数据库通过python插入数据失败

评论

热门帖子