JtSQL | noear : :javascript sql
kandi X-RAY | JtSQL Summary
kandi X-RAY | JtSQL Summary
JtSQL is a Java library. JtSQL has no vulnerabilities, it has a Permissive License and it has low support. However JtSQL has 2 bugs and it build file is not available. You can download it from GitHub.
JtSQL = javascript + sql + 模板理念，组合而成的一种创意脚本 定位为数据库的批处理或计划任务（尤其在分布式数据库情境下...） 源码很简单，很有创意哦。哈哈... JtSQL 特点： *.结合了JS、SQL、模板理念； *.保持了JS和SQL的语法高亮（利于DBA审核）； *.方便统一管理、部署、运行 *.像存储过程一样，提供当前上下文及变量支持； *.像SQL客户端工具一样，即时编写即时运行； *.像定制统计程序一样，提供过程和逻辑控制能力； *.服务端运行（别误会成客户端运行啊...） JtSQL 编码说明： 使用$，在Js里嵌入SQL脚本 使用{{...}}，在SQL里嵌入Js脚本（注：若它处出现{{ 或 }} 当中加个空隔） 函数log(str)，用于记录日志 函数set(key,val)，用于设置配置信息 函数get(key)，用于获取配置信息 函数http({url,form,header})，用于请求http 函数require(url)，用于引入一个JS脚本 函数guid()，用于生成一个GUID 函数md5(str)，用于生成MD5加密值 函数sha1(str)，用于生成sha1加密值 JtSQL 运行说明： 1.终端运行模式（可用于调试代码或即时运行）： 1.1.运行：java -jar jtsql.jar 1.2.输入：脚本代码//可把写好的脚本粘贴进去... 1.3.输入：;;; 并回车. 2.批处理运行模式： 运行：java -jar jtsql.jar /data/a/a.jt.sql 3.引入自己的项目： 把源码：JtSqlEngine 放到自己的项目里，随便弄：）.
JtSQL = javascript + sql + 模板理念，组合而成的一种创意脚本 定位为数据库的批处理或计划任务（尤其在分布式数据库情境下...） 源码很简单，很有创意哦。哈哈... JtSQL 特点： *.结合了JS、SQL、模板理念； *.保持了JS和SQL的语法高亮（利于DBA审核）； *.方便统一管理、部署、运行 *.像存储过程一样，提供当前上下文及变量支持； *.像SQL客户端工具一样，即时编写即时运行； *.像定制统计程序一样，提供过程和逻辑控制能力； *.服务端运行（别误会成客户端运行啊...） JtSQL 编码说明： 使用$，在Js里嵌入SQL脚本 使用{{...}}，在SQL里嵌入Js脚本（注：若它处出现{{ 或 }} 当中加个空隔） 函数log(str)，用于记录日志 函数set(key,val)，用于设置配置信息 函数get(key)，用于获取配置信息 函数http({url,form,header})，用于请求http 函数require(url)，用于引入一个JS脚本 函数guid()，用于生成一个GUID 函数md5(str)，用于生成MD5加密值 函数sha1(str)，用于生成sha1加密值 JtSQL 运行说明： 1.终端运行模式（可用于调试代码或即时运行）： 1.1.运行：java -jar jtsql.jar 1.2.输入：脚本代码//可把写好的脚本粘贴进去... 1.3.输入：;;; 并回车. 2.批处理运行模式： 运行：java -jar jtsql.jar /data/a/a.jt.sql 3.引入自己的项目： 把源码：JtSqlEngine 放到自己的项目里，随便弄：）.
Support
Quality
Security
License
Reuse
Support
JtSQL has a low active ecosystem.
It has 33 star(s) with 5 fork(s). There are 3 watchers for this library.
It had no major release in the last 6 months.
JtSQL has no issues reported. There are 1 open pull requests and 0 closed requests.
It has a neutral sentiment in the developer community.
The latest version of JtSQL is current.
Quality
JtSQL has 2 bugs (1 blocker, 0 critical, 1 major, 0 minor) and 45 code smells.
Security
JtSQL has no vulnerabilities reported, and its dependent libraries have no vulnerabilities reported.
JtSQL code analysis shows 0 unresolved vulnerabilities.
There are 5 security hotspots that need review.
License
JtSQL is licensed under the Apache-2.0 License. This license is Permissive.
Permissive licenses have the least restrictions, and you can use them in most projects.
Reuse
JtSQL releases are not available. You will need to build from source code and install.
JtSQL has no build file. You will be need to create the build yourself to build the component from source.
Installation instructions are not available. Examples and code snippets are available.
JtSQL saves you 225 person hours of effort in developing the same functionality from scratch.
It has 551 lines of code, 65 functions and 13 files.
It has medium code complexity. Code complexity directly impacts maintainability of the code.
Top functions reviewed by kandi - BETA
kandi has reviewed JtSQL and discovered the below as its top functions. This is intended to give you an instant insight into JtSQL implemented functionality, and help decide if they suit your requirements.
- Main entry point
- Compile jts sql
- Reads all the contents of a file into a String
- Get input from System out
- Get all days
- Get all hours
- Get date
- Convert to string
- Get the number of milliseconds in milliseconds
- Gets the current time in milliseconds
- Add a month
- Add a year
- Get the hours
- Gets the milliseconds in milliseconds
- Get the minutes
- Sets the date
- Perform a HTTP POST request
- Perform an HTTP GET
- Gets month
- Hashes a string
- Creates a MD5 hash of a string
- Tries to parse the given string using the given format and format
- Parse a string into a Datetime object
- Gets the days
- Gets the year
- Gets seconds
Get all kandi verified functions for this library.
JtSQL Key Features
No Key Features are available at this moment for JtSQL.
JtSQL Examples and Code Snippets
No Code Snippets are available at this moment for JtSQL.
Community Discussions
No Community Discussions are available at this moment for JtSQL.Refer to stack overflow page for discussions.
Community Discussions, Code Snippets contain sources that include Stack Exchange Network
Vulnerabilities
No vulnerabilities reported
Install JtSQL
You can download it from GitHub.
You can use JtSQL 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 JtSQL 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 .
You can use JtSQL 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 JtSQL 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:
Reuse Trending Solutions
Find, review, and download reusable Libraries, Code Snippets, Cloud APIs from over 650 million Knowledge Items
Find more librariesStay Updated
Subscribe to our newsletter for trending solutions and developer bootcamps
Share this Page
