gretard / Sonar Tsql Plugin
Licence: gpl-3.0
T-SQL language plugin for SonarQube
Stars: ✭ 49
Programming Languages
java
68154 projects - #9 most used programming language
Labels
Projects that are alternatives of or similar to Sonar Tsql Plugin
Dagbot
The official Repository for dagbot, the self proclaimmed n1 meme bot.
Stars: ✭ 40 (-18.37%)
Mutual labels: sql
Examples
Demo applications and code examples for Confluent Platform and Apache Kafka
Stars: ✭ 571 (+1065.31%)
Mutual labels: sql
Rhodddoobie
My little sandbox for playing around with the FP + OOP + DDD combination, in particular using Rho, doobie, Docker, testing, etc in a project.
Stars: ✭ 38 (-22.45%)
Mutual labels: sql
Be Course 17 18
🎓 Backend · 2017-2018 · Curriculum and Syllabus 💾
Stars: ✭ 44 (-10.2%)
Mutual labels: sql
Cosyan
Transactional SQL based RDBMS with sophisticated multi table constraint logic.
Stars: ✭ 45 (-8.16%)
Mutual labels: sql
Ether sql
A python library to push ethereum blockchain data into an sql database.
Stars: ✭ 41 (-16.33%)
Mutual labels: sql
Rdbms To Graphql
A Java CLI program that generates a GraphQL schema from a JDBC data source.
Stars: ✭ 44 (-10.2%)
Mutual labels: sql
Go Starter
An opinionated production-ready SQL-/Swagger-first RESTful JSON API written in Go, highly integrated with VSCode DevContainers by allaboutapps.
Stars: ✭ 37 (-24.49%)
Mutual labels: sql
Dito
Dito.js is a declarative and modern web framework with a focus on API driven development, based on Objection.js, Koa.js and Vue.js – Released in 2018 under the MIT license, with support by Lineto.com
Stars: ✭ 44 (-10.2%)
Mutual labels: sql
Scala Db Codegen
Scala code/boilerplate generator from a db schema
Stars: ✭ 49 (+0%)
Mutual labels: sql
Joiner
A simple utility for SQL-like joins with Json, GeoJson or dbf data in Node, the browser and on the command line. Also creates join reports so you can know how successful a given join was. Try it in the browser -->
Stars: ✭ 47 (-4.08%)
Mutual labels: sql
sonar-tsql-plugin
This repository contains T-SQL language plug-in for Sonar.
!!! IMPORTANT!!! This plugin will no longer be updated. Please use sonar-sql-plugin instead as it supports multiple dialects and contains various code fixes.
Description
Currently plug-in supports:
- 14 code analysis rules by Microsoft. More details can be found at https://msdn.microsoft.com/en-us/library/dd172133(v=vs.100).aspx.
- Code analysis rules by SQL Code Guard tool. Supported rules details can be found at https://documentation.red-gate.com/scg/sql-code-guard-3-documentation/sql-static-code-analysis-rules
- Keyword highlighting and copy/paste detectiong using T-SQL grammar from (https://github.com/antlr/grammars-v4/tree/master/tsql)
- Custom plug-in rules to detect various issues. You can find more details at Plugin rules
- Support for adding your custom rules defined in xml format. See Custom rules section for more details.
- Complexity metrics: cyclomatic and cognitive.
- SQLCover reports (since version 0.8.0). SQLCover reporting details can be found at https://github.com/GoEddie/SQLCover. You can take a look at examples folder at /examples/example2-coverage.
- Adhoc rules (since version 0.9.0), please check example at example4-adhoc
Donating
You can support this project and others via Paypal
Usage
- Download and install SonarQube
- Download plug-in from the releases and copy it to sonarqube's extensions\downloads directory
- Start SonarQube and enable rules
- If you want plug-in to automatically run SQL Code guard analysis part, please install SQL Code Guard onto your build machines and make sure that property sonar.tsql.cg.path is set to an existing installation (default is C:\Program Files (x86)\SqlCodeGuard\SqlCodeGuard.Cmd.exe)
- If you want plug-in to import issues found by Microsoft, please before running a sonar analysis build solution with setting /p:RunSqlCodeAnalysis=true.
- If you want coverage to be reported - please run SQLCover before running sonar analysis
You can find more information on configuration at wiki at Getting started on how to configure external tools.
Configuration
Options which are available for overriding can be found at Configuration.
CI integration
TFS integration
For T-SQL code to be scanned from TFS Build, the easiest way to start is to install:
- SonarQube extension from marketplace https://marketplace.visualstudio.com/items?itemName=SonarSource.sonarqube into your TFS server
- SQL Code Guard into your build agents if you want to use SQL Code Guard tool
After having done this, please use and configure SonarQube Scanner CLI step in your build definition.
Note that the project description data, including the texts, logos, images, and/or trademarks,
for each open source project belongs to its rightful owner.
If you wish to add or remove any projects, please contact us at [email protected].