Packages

like_sanitizer

0.1.0

SQL-LIKE sanitization for strings.

HexDocs

Current section

Files

Jump to

Readme 1 Version 0 Dependencies Dependants Files Activity

like_sanitizer lib like_sanitizer.ex

Raw

lib/like_sanitizer.ex

defmodule LikeSanitizer do
    @metacharacters ~r/([\\_%])/

    @doc """
      Escape an SQL LIKE pattern.

      Example
      -------
        iex> LikeSanitizer.escape("\\\\a_b%c")
        "\\\\\\\\a\\\\_b\\\\%c"

        iex> LikeSanitizer.escape("\\\\a_b%c", ".")
        ".\\\\a._b.%c"

        iex> LikeSanitizer.escape("\\\\a_b%c", "")
        "abc"
    """
    def escape(string, escape \\ "\\\\")
    def escape(string, ""), do: String.replace(string, @metacharacters, "")
    def escape(string, escape), do: String.replace(string, @metacharacters, escape <> "\\1")
end

Search filters

Type any of these into the search box. They can be combined with free text which searches package names and descriptions.

Operator	Description	Example
name:	Match package name. Supports * wildcards and repo/package form	name:phx* or name:hexpm/phoenix
description:	Full-text search of package descriptions	description:auth
depends:	Packages depending on a given package. Supports repo:package form	depends:ecto or depends:hexpm:ecto
build_tool:	Filter by build tool	build_tool:mix
updated_after:	Packages updated after an ISO8601 datetime	updated_after:2025-01-01T00:00:00Z
extra:	Match custom metadata (key,value). Nested keys are separated by commas	extra:license,MIT

Wrap values in double quotes to include spaces, e.g. name:"my package".