perl-JsonSQL-0.41-alt1.noarch.rpm


Advertisement

Description

perl-JsonSQL - Defines a JSON format to represent SQL queries which can be validated and then used to generate SQL

Property Value
Distribution ALT Linux Sisyphus
Repository Autoimports noarch
Package name perl-JsonSQL
Package version 0.41
Package release alt1
Package architecture noarch
Package type rpm
Installed size 150.93 KB
Download size 150.93 KB
Official Mirror ftp.altlinux.org
The purpose of this distribution is to provide a reasonably safe mechanism for SQL query generation using data from untrusted sources, namely
web browsers. JSON is a convenient format native to JavaScript (ECMAScript), which can be translated to and from Perl objects fairly easily.
JSON was selected to provide a structured format for representing SQL statements such that it can be validated, checked for appropriate
access restrictions, and used to generate a well-formed and parameterized SQL statement that can be passed off to the the DBI manpage module.
The format is somewhat verbose in a few places, with the idea that the user/developer needs to be very explicit when passing parameters
to the query. This makes it well-suited for handling untrusted data (for example, from HTML forms), but if you just need a basic SQL
generator, you would probably be better off looking at the SQL::Abstract manpage or the SQL::Maker manpage instead.
A simple SELECT statement,
{
"fields": [
{"column": "*"}
],
"from": [
{"table": "my_table"}
]
}
A more complicated SELECT statement,
{
"fields": [
{"column": "field1"},
{"column": "field2", "alias": "test"}
],
"from": [
{"table": "table1", "schema": "MySchema"}
],
"where": {
"and": [
{ "eq": {"field": {"column": "field2"}, "value": "Test.Field2"} },
{ "eq": {"field": {"column": "field1"}, "value": "453.6"} },
{ "or": [
{ "eq": {"field": {"column": "field2"}, "value": "field3"} },
{ "gt": {"field": {"column": "field3"}, "value": "45"} }
]}
]
}
}
A SELECT statement with JOINs,
{
"fields": [
{"column": "field1"},
{"column": "field2", "alias": "test"}
],
"joins": [
{"jointype": "inner", "from": {"table": "table1", "schema": "MySche...

Alternatives

Package Version Architecture Repository
perl-JsonSQL - - -

Requires

Name Value
/usr/share/perl5 -
perl(Class/Load.pm) -
perl(Data/Dumper.pm) -
perl(JSON/Parse.pm) -
perl(JSON/Validator.pm) -
perl(List/Util.pm) -
perl(SQL/Maker/Select.pm) -
perl(SQL/QueryMaker.pm) -
perl(base.pm) -
perl-base >= 1:5.14.0
rpmlib(PayloadIsLzma) -

Provides

Name Value
perl(JsonSQL.pm) = 0.410
perl(JsonSQL/Error.pm) = 0.410
perl(JsonSQL/Param/Condition.pm) = 0.410
perl(JsonSQL/Param/ConditionDispatcher.pm) = 0.410
perl(JsonSQL/Param/Conditions/EnumCondition.pm) = 0.410
perl(JsonSQL/Param/Conditions/LogicCondition.pm) = 0.410
perl(JsonSQL/Param/Conditions/NullCondition.pm) = 0.410
perl(JsonSQL/Param/Conditions/RangeCondition.pm) = 0.410
perl(JsonSQL/Param/Conditions/TestCondition.pm) = 0.410
perl(JsonSQL/Param/Field.pm) = 0.410
perl(JsonSQL/Param/Fields.pm) = 0.410
perl(JsonSQL/Param/Insert.pm) = 0.410
perl(JsonSQL/Param/InsertValues.pm) = 0.410
perl(JsonSQL/Param/Join.pm) = 0.410
perl(JsonSQL/Param/Joins.pm) = 0.410
perl(JsonSQL/Param/Order.pm) = 0.410
perl(JsonSQL/Param/OrderBy.pm) = 0.410
perl(JsonSQL/Param/Table.pm) = 0.410
perl(JsonSQL/Param/Tables.pm) = 0.410
perl(JsonSQL/Query/Insert.pm) = 0.410
perl(JsonSQL/Query/Query.pm) = 0.410
perl(JsonSQL/Query/Select.pm) = 0.410
perl(JsonSQL/Schemas/Schema.pm) = 0.410
perl(JsonSQL/Schemas/insert.pm) = 0.410
perl(JsonSQL/Schemas/select.pm) = 0.410
perl(JsonSQL/Validator.pm) = 0.410
perl-JsonSQL = 0.41-alt1

Download

Type URL
Binary Package perl-JsonSQL-0.41-alt1.noarch.rpm
Source Package perl-JsonSQL-0.41-alt1.src.rpm

Install Howto

  1. Add the following line to /etc/apt/sources.list:
    
    rpm [Sisyphus] http://ftp.altlinux.org/pub/distributions/ALTLinux/autoimports/Sisyphus noarch autoimports
    rpm [Sisyphus] http://ftp.altlinux.org/pub/distributions/ALTLinux/autoimports/Sisyphus noarch autoimports
    
  2. Update the package index:
    # sudo apt-get update
  3. Install perl-JsonSQL rpm package:
    # sudo apt-get install perl-JsonSQL

Files

Path
/usr/share/doc/perl-JsonSQL-0.41/Changes
/usr/share/doc/perl-JsonSQL-0.41/LICENSE
/usr/share/doc/perl-JsonSQL-0.41/README
/usr/share/perl5/JsonSQL.pm
/usr/share/perl5/JsonSQL/Error.pm
/usr/share/perl5/JsonSQL/Validator.pm
/usr/share/perl5/JsonSQL/Param/Condition.pm
/usr/share/perl5/JsonSQL/Param/ConditionDispatcher.pm
/usr/share/perl5/JsonSQL/Param/Field.pm
/usr/share/perl5/JsonSQL/Param/Fields.pm
/usr/share/perl5/JsonSQL/Param/Insert.pm
/usr/share/perl5/JsonSQL/Param/InsertValues.pm
/usr/share/perl5/JsonSQL/Param/Join.pm
/usr/share/perl5/JsonSQL/Param/Joins.pm
/usr/share/perl5/JsonSQL/Param/Order.pm
/usr/share/perl5/JsonSQL/Param/OrderBy.pm
/usr/share/perl5/JsonSQL/Param/Table.pm
/usr/share/perl5/JsonSQL/Param/Tables.pm
/usr/share/perl5/JsonSQL/Param/Conditions/EnumCondition.pm
/usr/share/perl5/JsonSQL/Param/Conditions/LogicCondition.pm
/usr/share/perl5/JsonSQL/Param/Conditions/NullCondition.pm
/usr/share/perl5/JsonSQL/Param/Conditions/RangeCondition.pm
/usr/share/perl5/JsonSQL/Param/Conditions/TestCondition.pm
/usr/share/perl5/JsonSQL/Query/Insert.pm
/usr/share/perl5/JsonSQL/Query/Query.pm
/usr/share/perl5/JsonSQL/Query/Select.pm
/usr/share/perl5/JsonSQL/Schemas/Schema.pm
/usr/share/perl5/JsonSQL/Schemas/insert.pm
/usr/share/perl5/JsonSQL/Schemas/select.pm

See Also

Package Description
perl-Juju-0.5-alt1.noarch.rpm Non-blocking Perl bindings for http://juju.ubuntu.com/
perl-Junction-Quotelike-0.01-alt1.noarch.rpm quotelike junction operators
perl-Just-Another-Perl-Hacker-0.01-alt1.noarch.rpm perl module Just-Another-Perl-Hacker
perl-KML-PolyMap-1.34-alt1.noarch.rpm perl module KML-PolyMap
perl-Kafka-0.12-alt1.noarch.rpm Apache Kafka low-level synchronous API, which does not use Zookeeper
perl-Kafka-Client-0.02-alt1.noarch.rpm Client for LinkedIn's Kafka
perl-Kaiten-Container-0.37-alt1.noarch.rpm Simples dependency-injection (DI) container, distant relation of IoC
perl-Kamaitachi-0.05-alt1.noarch.rpm perl flash media server
perl-Karas-0.07-alt1.noarch.rpm Yet another O/R Mapper
perl-Karel-0.04-alt1.noarch.rpm Learn programming with a robot that understands few simple commands
perl-Kasago-0.29-alt1.noarch.rpm A Perl source code indexer
perl-Katsubushi-Client-0.2-alt1.noarch.rpm A client library for katsubushi
perl-Katsubushi-Client-scripts-0.2-alt1.noarch.rpm Katsubushi-Client scripts
perl-Kayako-RestAPI-0.07-alt1.noarch.rpm Perl library for working with L<Kayako REST API|https://kayako.atlassian.net/wiki/display/DEV/Kayak
perl-Kayako-RestAPI-scripts-0.07-alt1.noarch.rpm Kayako-RestAPI scripts
Advertisement
Advertisement