Entity operation
2017-03-16 10:10:53 0 举报实体操作（Entity Operation）是数据库中的一种基本操作，用于对数据库中的实体（如表、行等）进行读取、插入、更新或删除。这些操作通常通过SQL（结构化查询语言）或其他数据库查询语言执行。实体操作可以应用于单个实体，也可以应用于多个实体。例如，您可以使用实体操作来查询特定用户的信息，或者在用户表中插入新记录。实体操作对于管理和维护数据库至关重要，因为它们使您能够访问和修改存储在数据库中的数据。
作者其他创作
大纲/内容
Column belong to one group setting?
Start delete entity
Time Series is null?
N
Column is Time series?
Delete all entries belong to this entity
Start TS + SHOW THREAD IN SAME ROW
Update entity's type
Y
Find out all column group settings
Add cross DB column to every Time series
Start NTS + NTS
Loop all tile configs
Set time zone and limit user's permission
Add column field to non-time series select state model
Find next tile
Add column to Cross DB list
Left join it to entity table
Loop all columns
Generate every single SQL model for every NON-Time series
Union Time series as virtual table and join with ts_entry using ID
Left join this SQL model to entry table
Loop all time series settings
End
Loop done?
Get one column
Generate every single SQL model for every Time series
Delete db and cache
Generate all Thread ID collection according to all time series setting
Use all entity to limit the final entity
Update db and cache
Add column field to cross DB select state model
Every time and NON-Time series SQL model left join to entity
Every NON-Time series SQL model left join to entity
Union all Time series SQL model
Generate the whole SQL model
Analyze every Time and NON-Time series setting
Find temp table of this tile config
Find this entity from temp table
Start TS + TS
Generate all thread and entity ID collection according to time and non-time series settings
Union all non-time series to get all entity
Union all time and non-time series to get all entity
Entity cache listener to monitor
Left join this SQL model to thread_entity ID table
Combine global filter and Time series filter
Non-time series is null?
Analyze every Time series setting
Pass all cross DataBase columns
Generate every single time series SQL model
Start update entity
Check the option of show thread in same row
Analyze every NON-Time series setting
Add column field to time series select state model
Start TS + NTS
Delete entity
Combine global filter and every NON-Time series filter
If new entity type meet current tile config?
Generate every non-time series
Combine global filter and every Time and NON-Time series filter
0 条评论
下一页
