sql-analytic | sql-analytic | SQL Database library

by jbaliuka Java Version: Current License: LGPL-3.0

X-Ray Key Features Code Snippets Community Discussions(1)Vulnerabilities Install Support

kandi X-RAY | sql-analytic Summary

sql-analytic is a Java library typically used in Database, SQL Database applications. sql-analytic has no bugs, it has no vulnerabilities, it has build file available, it has a Weak Copyleft License and it has low support. You can download it from GitHub.

New library supports basic AST transformations to copy tree. Row level security is also implemented as a AST transformation to add security policy, filters. Security rules use extended [PostgreSQL Policy] (declaration syntax and also supports optional column list to restrict column level access. See [unit test] (./sql-parser/src/test/java/com/github/sql/analytic/transform/policy/PolicySelectTransformTest.java) and [h2 test] (./sql-dialect/sql-dialect-h2/src/test/java/com/github/sql/analytic/dialect/h2/H2SessionTest.java) for sample code. CREATE POLICY name ON table_name [( column_name [,…] )] [ FOR { ALL | SELECT | INSERT | UPDATE | DELETE } ] [ TO role_name [, …] ] [ USING ( using_expression ) ] [ WITH CHECK ( check_expression ) ] .

Support

Quality

Security

License

Reuse

Support

sql-analytic has a low active ecosystem.

It has 6 star(s) with 10 fork(s). There are 4 watchers for this library.

It had no major release in the last 6 months.

There are 0 open issues and 1 have been closed. On average issues are closed in 6 days. There are no pull requests.

It has a neutral sentiment in the developer community.

The latest version of sql-analytic is current.

Quality

sql-analytic has 0 bugs and 0 code smells.

Security

sql-analytic has no vulnerabilities reported, and its dependent libraries have no vulnerabilities reported.

sql-analytic code analysis shows 0 unresolved vulnerabilities.

There are 0 security hotspots that need review.

License

sql-analytic is licensed under the LGPL-3.0 License. This license is Weak Copyleft.

Weak Copyleft licenses have some restrictions, but you can use them in commercial projects.

Reuse

sql-analytic releases are not available. You will need to build from source code and install.

Build file is available. You can build the component from source.

sql-analytic saves you 6654 person hours of effort in developing the same functionality from scratch.

It has 13815 lines of code, 2097 functions and 214 files.

It has medium code complexity. Code complexity directly impacts maintainability of the code.

Top functions reviewed by kandi - BETA

kandi has reviewed sql-analytic and discovered the below as its top functions. This is intended to give you an instant insight into sql-analytic implemented functionality, and help decide if they suit your requirements.

Visits an in expression
Visit a cast expression
Visit an IsNullExpression
Visit a ExistsExpression
Visit a WHEN clause
Visit a grouping expression
Visits a Parenthesis
Visit a OrderBy element
Visit a table column
Visit Between
Transforms an analytic clause into a new analytic clause
Visits a CaseExpression
Visits a Function
Generate an Insert
Visit an update
Visit a replace
Generate a Delete
Visit a CreatePolicy
Visits the given Select
Updates the subselect
Visit a SubSelect
Returns a string representation of this query
Process a batch request
Returns a string representation of this Selector
Reads service document
Creates a SQL statement to replace this table
Sets the metadata
Delete entity
Returns SQL statement to update rows
Update entity
Visit a method call

Get all kandi verified functions for this library.

sql-analytic Key Features

No Key Features are available at this moment for sql-analytic.

sql-analytic Examples and Code Snippets

No Code Snippets are available at this moment for sql-analytic.

Community Discussions

Trending Discussions on sql-analytic

Azure Data Factory copy activity with stored procedure

QUESTION

Azure Data Factory copy activity with stored procedure

Asked 2018-Jul-04 at 14:18

Is there a workaround for the fact that you need to name the first parameter of the stored procedure (the one containing the table type) exactly as the property "tableName" in the input dataaset?

Im using Azure Data Factory V1.

Input dataset (On-premise Oracle source)

...

ANSWER

Answered 2018-Jan-04 at 15:05

I cannot test this right now, but as it is said here https://docs.microsoft.com/en-us/azure/data-factory/v1/data-factory-invoke-stored-procedure-from-copy-activity#stored-procedure-definition "The name of the first parameter of stored procedure must match the tableName defined in the dataset JSON".

In the example it declares two parameters in the sp:

@Marketing [dbo].[MarketingType] READONLY
@stringData varchar(256)

At the dataset it doesnt use the schema prefix, it just says: "tableName": "Marketing", without the schema (try this, as you have the schema in your output dataset definition).

Then at the pipeline, it just gives value for stringData. Also this: "SqlWriterTableType": "MarketingType", see that it doesnt have the schema prefix, and your pipeline definition does have it.

So to sum it up: MarketingType is the actual name of the table and is at the SqlWriterTableType property of the copy activity, while Marketing is the name of the parameter in the stored procedure, and the name of the tablename in the output dataset.

Hope this helps!

Source https://stackoverflow.com/questions/48092088

Community Discussions, Code Snippets contain sources that include Stack Exchange Network

Vulnerabilities

No vulnerabilities reported

Install sql-analytic

You can download it from GitHub.
You can use sql-analytic like any standard Java library. Please include the the jar files in your classpath. You can also use any IDE and you can run and debug the sql-analytic component as you would do with any other Java program. Best practice is to use a build tool that supports dependency management such as Maven or Gradle. For Maven installation, please refer maven.apache.org. For Gradle installation, please refer gradle.org .

Support

For any new features, suggestions and bugs create an issue on GitHub. If you have any questions check and ask questions on community page Stack Overflow .

Find more information at: