NAME

SQL::Validator - Validate JSON-SQL

ABSTRACT

Validate JSON-SQL Schemas

SYNOPSIS

use SQL::Validator;

my $sql = SQL::Validator->new;

# my $valid = $sql->validate({
#   insert => {
#     into => {
#       table => 'users'
#     },
#     default => 1
#   }
# });

# i.e. represents (INSERT INTO "users" DEFAULT VALUES)

# die $sql->error if !$valid;

# $sql->error->report('insert');

DESCRIPTION

This package provides a json-sql data structure validation library based on the JSON-SQL json-schema standard.

ATTRIBUTES

This package has the following attributes:

schema

schema(Any)

This attribute is read-only, accepts (Any) values, and is optional.

validator

validator(InstanceOf["JSON::Validator"])

This attribute is read-only, accepts (InstanceOf["JSON::Validator"]) values, and is optional.

version

version(Str)

This attribute is read-only, accepts (Str) values, and is optional.

METHODS

This package implements the following methods:

error

error() : InstanceOf["SQL::Validator::Error"]

The error method validates the JSON-SQL schema provided.

error example #1

# given: synopsis

$sql->validate({select => {}});

my $error = $sql->error;

error example #2

# given: synopsis

$sql->validate({select => { from => { table => 'users' } } });

my $error = $sql->error;

validate

validate(HashRef $schema) : Bool

The validate method validates the JSON-SQL schema provided.

validate example #1

# given: synopsis

my $valid = $sql->validate({
  insert => {
    into => {
      table => 'users'
    },
    default => 1
  }
});

# VALID

validate example #2

# given: synopsis

my $valid = $sql->validate({
  insert => {
    into => {
      table => 'users'
    },
    default => 'true' # coerced booleans
  }
});

# VALID

validate example #3

# given: synopsis

my $valid = $sql->validate({
  insert => {
    into => 'users',
    values => [1, 2, 3]
  }
});

# INVALID

AUTHOR

Al Newkirk, awncorp@cpan.org

LICENSE

Copyright (C) 2011-2019, Al Newkirk, et al.

This is free software; you can redistribute it and/or modify it under the terms of the The Apache License, Version 2.0, as elucidated in the "license file".

PROJECT

Wiki

Project

Initiatives

Milestones

Contributing

Issues

cpanm SQL::Validator

perl -MCPAN -e shell
install SQL::Validator