🔗Data Source Engine

Mainly provides data sources, similar in nature to the interface engine, and additionally supports SQL data sources and common data sources.

---

📌Preface

• The data source engine mainly provides data sources, which are similar in nature to the interface engine, with the addition of SQL data sources and common data sources.
• When the [Type] of the data source engine is [V8 Data Source], there is no difference from [Interface Engine]

SQL data source

• directly enter SQL statements in the code editor. $CurrentUser.* $variables are supported
• The advantage is that you don't need to use V8.Db.FromSql() to execute SQL statements like the interface engine, but write SQL statements directly. Some implementation engineers prefer this mode.

• Sample code:

SELECT * FROM tableName WHERE UserId = '$CurrentUser.Id$'

Common data source

• Enter json data directly in the code editor
• The advantage is the extreme performance. There is no need to call the bottom layer of the V8 engine and directly return data, such as the storage of some basic data: data such as the addresses of provinces and cities across the country.
• Example code:

[{ Id : 1, Name : '张三' }, { Id : 2, Name : '李四' }]

{ Id : 1, Name : '张三' }

V8 Data Source

• There is no difference from the interface engine at this time