10000 sample sql and pic · sqlparser/python_data_lineage@a85383c · GitHub
[go: up one dir, main page]
Skip to content

Commit a85383c

Browse files
sqlparsersqlparser
committed
sample sql and pic
1 parent 0a2b34c commit a85383c

File tree

4 files changed

+28
-1
lines changed

4 files changed

+28
-1
lines changed

‎README_cn.md

Lines changed: 17 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -67,6 +67,23 @@ python dlineage.py /t oracle /f samlples/oracle_plsql.sql /graph
6767

6868
The [source code of this sample Oracle PL/SQL](samlples/oracle_plsql.sql).
6969

70+
### Able to analyze dynamic SQL to get data lineage (Postgres stored procedure)
71+
```sql
72+
CREATE OR REPLACE FUNCTION t.mergemodel(_modelid integer)
73+
RETURNS void
74+
LANGUAGE plpgsql
75+
AS $function$
76+
BEGIN
77+
EXECUTE format ('INSERT INTO InSelections
78+
SELECT * FROM AddInSelections_%s', modelid);
79+
80+
END;
81+
$function$
82+
```
83+
84+
![Postgres stored procedure data lineage sample](samples/images/postgresql_plsql_data_lineage.png)
85+
86+
7087
### 分析 DDL, 自动画出 ER Diagram
7188

7289
通过执行这条命令，

‎samples/images/postgresql_plsql_data_lineage.png

5 KB
Loading

‎samples/postgresql_plsql.sql

Lines changed: 10 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,10 @@
1+
CREATE OR REPLACE FUNCTION t.mergemodel(_modelid integer)
2+
RETURNS void
3+
LANGUAGE plpgsql
4+
AS $function$
5+
BEGIN
6+
EXECUTE format ('INSERT INTO InSelections
7+
SELECT * FROM AddInSelections_%s', modelid);
8+
9+
END;
10+
$function$

0 commit comments

Comments
 (0)
0