Commit4590e57

Artur Zakirov

committed

Added pgv_exists(package) function

1 parent95c2c2b commit4590e57Copy full SHA for 4590e57

File tree

+64

-0

lines changed

+64

-0

lines changed

Lines changed: 1 addition & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -145,6 +145,7 @@ Function \| Returns \| Description`
`145`	`145`	`Function \| Returns \| Description`
`146`	`146`	`-------- \| ------- \| -----------`
`147`	`147`	`pgv_exists(package text, name text)` \|`bool` \| Returnstrue if package and variable exists.
	`148`	+`pgv_exists(package text)` \|`bool` \| Returnstrue if package exists.
`148`	`149`	`pgv_remove(package text, name text)` \|`void` \| Removes the variable with the corresponding name. Required package and variable must exists, otherwise the error will be raised.
`149`	`150`	`pgv_remove(package text)` \|`void` \| Removes the package and all package variables with the corresponding name. Required package must exists, otherwise the error will be raised.
`150`	`151`	`pgv_free()` \|`void` \| Removes all packages and variables.

Lines changed: 30 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -64,6 +64,18 @@ SELECT pgv_exists('vars', 'int1');`
`64`	`64`	`t`
`65`	`65`	`(1 row)`
`66`	`66`
	`67`	`+SELECT pgv_exists('vars2');`
	`68`	`+ pgv_exists`
	`69`	`+------------`
	`70`	`+ f`
	`71`	`+(1 row)`
	`72`	`+`
	`73`	`+SELECT pgv_exists('vars');`
	`74`	`+ pgv_exists`
	`75`	`+------------`
	`76`	`+ t`
	`77`	`+(1 row)`
	`78`	`+`
`67`	`79`	`SELECT pgv_set_int('vars', 'intNULL', NULL);`
`68`	`80`	`pgv_set_int`
`69`	`81`	`-------------`
`@@ -669,6 +681,12 @@ SELECT pgv_remove('vars', 'int1');`
`669`	`681`
`670`	`682`	`SELECT pgv_get_int('vars', 'int1');`
`671`	`683`	`ERROR: unrecognized variable "int1"`
	`684`	`+SELECT pgv_exists('vars');`
	`685`	`+ pgv_exists`
	`686`	`+------------`
	`687`	`+ t`
	`688`	`+(1 row)`
	`689`	`+`
`672`	`690`	`SELECT pgv_remove('vars2');`
`673`	`691`	`pgv_remove`
`674`	`692`	`------------`
`@@ -677,6 +695,12 @@ SELECT pgv_remove('vars2');`
`677`	`695`
`678`	`696`	`SELECT pgv_get_jsonb('vars2', 'j1');`
`679`	`697`	`ERROR: unrecognized package "vars2"`
	`698`	`+SELECT pgv_exists('vars2');`
	`699`	`+ pgv_exists`
	`700`	`+------------`
	`701`	`+ f`
	`702`	`+(1 row)`
	`703`	`+`
`680`	`704`	`SELECT * FROM pgv_list() order by package, name;`
`681`	`705`	`package \| name`
`682`	`706`	`---------+----------`
`@@ -707,6 +731,12 @@ SELECT pgv_free();`
`707`	`731`
`708`	`732`	`(1 row)`
`709`	`733`
	`734`	`+SELECT pgv_exists('vars');`
	`735`	`+ pgv_exists`
	`736`	`+------------`
	`737`	`+ f`
	`738`	`+(1 row)`
	`739`	`+`
`710`	`740`	`SELECT * FROM pgv_list() order by package, name;`
`711`	`741`	`package \| name`
`712`	`742`	`---------+------`

Lines changed: 5 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -113,6 +113,11 @@ RETURNS bool`
`113`	`113`	`AS'MODULE_PATHNAME','variable_exists'`
`114`	`114`	`LANGUAGE C VOLATILE;`
`115`	`115`
	`116`	`+CREATEFUNCTIONpgv_exists(packagetext)`
	`117`	`+RETURNS bool`
	`118`	`+AS'MODULE_PATHNAME','package_exists'`
	`119`	`+LANGUAGE C VOLATILE;`
	`120`	`+`
`116`	`121`	`CREATEFUNCTIONpgv_remove(packagetext, nametext)`
`117`	`122`	`RETURNS void`
`118`	`123`	`AS'MODULE_PATHNAME','remove_variable'`

Lines changed: 23 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -52,6 +52,7 @@ PG_FUNCTION_INFO_V1(variable_select_by_values);`
`52`	`52`
`53`	`53`	`/* Functions to work with packages */`
`54`	`54`	`PG_FUNCTION_INFO_V1(variable_exists);`
	`55`	`+PG_FUNCTION_INFO_V1(package_exists);`
`55`	`56`	`PG_FUNCTION_INFO_V1(remove_variable);`
`56`	`57`	`PG_FUNCTION_INFO_V1(remove_package);`
`57`	`58`	`PG_FUNCTION_INFO_V1(remove_packages);`
`@@ -956,6 +957,28 @@ variable_exists(PG_FUNCTION_ARGS)`
`956`	`957`	`PG_RETURN_BOOL(found);`
`957`	`958`	`}`
`958`	`959`
	`960`	`+/*`
	`961`	`+ * Check if package exists.`
	`962`	`+ */`
	`963`	`+Datum`
	`964`	`+package_exists(PG_FUNCTION_ARGS)`
	`965`	`+{`
	`966`	`+text*package_name;`
	`967`	`+boolres;`
	`968`	`+`
	`969`	`+if (PG_ARGISNULL(0))`
	`970`	`+ereport(ERROR,`
	`971`	`+(errcode(ERRCODE_INVALID_PARAMETER_VALUE),`
	`972`	`+errmsg("package name can not be NULL")));`
	`973`	`+`
	`974`	`+package_name=PG_GETARG_TEXT_PP(0);`
	`975`	`+`
	`976`	`+res=getPackageByName(package_name, false, false)!=NULL;`
	`977`	`+`
	`978`	`+PG_FREE_IF_COPY(package_name,0);`
	`979`	`+PG_RETURN_BOOL(res);`
	`980`	`+}`
	`981`	`+`
`959`	`982`	`/*`
`960`	`983`	`* Remove variable from package by name.`
`961`	`984`	`*/`

Lines changed: 5 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -16,6 +16,8 @@ SELECT pgv_get_int('vars', 'int3');`
`16`	`16`	`SELECT pgv_get_int('vars','int3', false);`
`17`	`17`	`SELECT pgv_exists('vars','int3');`
`18`	`18`	`SELECT pgv_exists('vars','int1');`
	`19`	`+SELECT pgv_exists('vars2');`
	`20`	`+SELECT pgv_exists('vars');`
`19`	`21`
`20`	`22`	`SELECT pgv_set_int('vars','intNULL',NULL);`
`21`	`23`	`SELECT pgv_get_int('vars','intNULL');`
`@@ -176,12 +178,15 @@ SELECT * FROM pgv_list() order by package, name;`
`176`	`178`	`SELECT pgv_remove('vars','int3');`
`177`	`179`	`SELECT pgv_remove('vars','int1');`
`178`	`180`	`SELECT pgv_get_int('vars','int1');`
	`181`	`+SELECT pgv_exists('vars');`
`179`	`182`
`180`	`183`	`SELECT pgv_remove('vars2');`
`181`	`184`	`SELECT pgv_get_jsonb('vars2','j1');`
	`185`	`+SELECT pgv_exists('vars2');`
`182`	`186`
`183`	`187`	`SELECT*FROM pgv_list()order by package, name;`
`184`	`188`
`185`	`189`	`SELECT pgv_free();`
	`190`	`+SELECT pgv_exists('vars');`
`186`	`191`
`187`	`192`	`SELECT*FROM pgv_list()order by package, name;`

Comments

(0)