我有一个包含多个存储过程的文件,如下所示
--
-- Name: abc(character varying); Type: FUNCTION; Schema: schema_name; Owner: -
--
CREATE FUNCTION schema_name.abc(schema_name character varying) RETURNS opaque
LANGUAGE plpgsql
AS '54:-1', $$
DECLARE
a INT:= 0;
b INT:= 0;
BEGIN
END;
$$;
--
-- Name: bcd(); Type: FUNCTION; Schema: schema_name; Owner: -
--
CREATE FUNCTION schema_name.bcd() RETURNS opaque
LANGUAGE plpgsql
AS '-1', $$
DECLARE
a INT:= 0;
b INT:= 0;
BEGIN
END;
$$;
--
-- Name: cde(); Type: FUNCTION; Schema: schema_name; Owner: -
--
CREATE FUNCTION schema_name.cde() RETURNS opaque
LANGUAGE plpgsql
AS '-1', $$
DECLARE
a INT:= 0;
b INT:= 0;
BEGIN
END;
$$;
我需要将它分成以
--
-- Name:
此外,各个文件应以架构名称命名。在这种情况下,文件名应该是abc.sql、bcd.sql、cde.sql
到目前为止我试过这个
token = 'CREATE FUNCTION'
chunks = []
current_chunk = []
for line in open('procedures.txt'):
if line.startswith(token) and current_chunk:
chunks.append(current_chunk[:])
current_chunk = []
current_chunk.append(line)
print (current_chunk)
chunks.append(current_chunk)
试试这个:
相关问题 更多 >
编程相关推荐