[Bug 203949] [new port] databases/pguri: uri datatype extension for PostgreSQL

[bugzilla-noreply at freebsd.org]

https://bugs.freebsd.org/bugzilla/show_bug.cgi?id=203949

Chris Hutchinson <portmaster at bsdforge.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |portmaster at bsdforge.com

--- Comment #1 from Chris Hutchinson <portmaster at bsdforge.com> ---
(In reply to Torsten Zühlsdorff from comment #0)
> Created attachment 162343 [details]
> shar with new port pguri
> 
> Hello,
> 
> i've created a port for this fine extension:
> https://github.com/petere/pguri
> 
> It adds a datatype "uri" to PostgreSQL and allows storage of URIs. It also
> provides some handy functions for uri-handling.
> 
> Some QA for the new port:
> 
> /usr/ports/databases/pguri # portlint -AC
> WARN: Makefile: Consider defining LICENSE.
> 0 fatal errors and 1 warning found.
> 
> /usr/ports/databases/pguri #  make && make stage-qa && make check-plist &&
> make install && make deinstall
> ===>   pguri-1.20150415 depends on file: /usr/local/sbin/pkg - found
> ===> Fetching all distfiles required by pguri-1.20150415 for building
> ===>  Extracting for pguri-1.20150415
> => SHA256 Checksum OK for petere-pguri-1.20150415_GH0.tar.gz.
> ===>  Patching for pguri-1.20150415
> ===>   pguri-1.20150415 depends on package: uriparser>=0.7.9 - found
> ===>   pguri-1.20150415 depends on executable: gmake - found
> ===>   pguri-1.20150415 depends on executable: pkgconf - found
> ===>   pguri-1.20150415 depends on shared library: libpq.so.5 - found
> (/usr/local/lib/libpq.so.5)
> ===>  Configuring for pguri-1.20150415
> ===>  Building for pguri-1.20150415
> [gmake output]
> ===>  Staging for pguri-1.20150415
> ===>   Generating temporary packing list
> gmake[1]: Verzeichnis „/usr/ports/databases/pguri/work/pguri-1.20150415“
> wird betreten
> /bin/mkdir -p
> '/usr/ports/databases/pguri/work/stage/usr/local/lib/postgresql'
> /bin/mkdir -p
> '/usr/ports/databases/pguri/work/stage/usr/local/share/postgresql/extension'
> /bin/mkdir -p
> '/usr/ports/databases/pguri/work/stage/usr/local/share/postgresql/extension'
> /usr/bin/install -c -m 755  uri.so
> '/usr/ports/databases/pguri/work/stage/usr/local/lib/postgresql/uri.so'
> /usr/bin/install -c -m 644 uri.control
> '/usr/ports/databases/pguri/work/stage/usr/local/share/postgresql/extension/'
> /usr/bin/install -c -m 644 uri--0.sql
> '/usr/ports/databases/pguri/work/stage/usr/local/share/postgresql/extension/'
> gmake[1]: Verzeichnis „/usr/ports/databases/pguri/work/pguri-1.20150415“
> wird verlassen
> /usr/bin/strip
> /usr/ports/databases/pguri/work/stage/usr/local/lib/postgresql/uri.so
> ====> Compressing man pages (compress-man)
> ====> Running Q/A tests (stage-qa)
> ====> Running Q/A tests (stage-qa)
> ====> Checking for pkg-plist issues (check-plist)
> ===> Parsing plist
> ===> Checking for items in STAGEDIR missing from pkg-plist
> ===> Checking for items in pkg-plist which are not in STAGEDIR
> ===> No pkg-plist issues found (check-plist)
> ===>  Installing for pguri-1.20150415
> ===>   pguri-1.20150415 depends on shared library: libpq.so.5 - found
> (/usr/local/lib/libpq.so.5)
> ===>  Checking if pguri already installed
> ===>   Registering installation for pguri-1.20150415
> Installing pguri-1.20150415...
> In order to use the extension within database execute the following command:
> 
> CREATE EXTENSION uri;
> 
> ===>  Deinstalling for pguri
> ===>   Deinstalling pguri-1.20150415
> Updating database digests format: 100%
> Checking integrity... done (0 conflicting)
> Deinstallation has been requested for the following 1 packages (of 0
> packages in the universe):
> 
> Installed packages to be REMOVED:
>         pguri-1.20150415
> 
> The operation will free 17 KiB.
> [1/1] Deinstalling pguri-1.20150415...
> [1/1] Deleting files for pguri-1.20150415: 100%

This looks great. But the copy of uriparser currently in the ports
tree is too old (0.79). pguri recommends at least version 0.8.0,
and for good reason - 0.80 Changelog:

2013-12-20 -- 0.8.0

  * Fixed: Resolution of relative URI "/" broken
      Thanks to Mo McRoberts for the patch!
  * Fixed: uriAddBaseUri produced uriUri objects with both host
      and the absolutePath flag set (while the absolutePath flag
      should only be true for URI objects without a host) when
      resolving absolute URIs like "/" or "/foo/bar".
      Now the absolutePath flag is set to URI_FALSE and an empty
      segment is added as necessary
  * Fixed: .errorCode could end up unset, previously
      Thanks to Radu Hociung for the patch!  (bug #16)
  * Fixed: Resolve use of non-POSIX "sed -r" used when building
     documentation  (bug #18)
     Thanks to Ryan Schmidt for reporting!
  * Fixed: Build DLL with -no-undefined on Windows
      Thanks to Michel Zou for the patch!  (bug #19)
  * Added: Command line tool "uriparse"
      Thanks to Radu Hociung for coding!  (feature request #3)
  * Soname: 1:15:0

Perhaps you should poke the uriparser maintainer. You might even
craft an svn diff to upgrade it. ;)

--Chris

-- 
You are receiving this mail because:
You are the assignee for the bug.