Skip to content

HTTPS clone URL

Subversion checkout URL

You can clone with HTTPS or Subversion.

Download ZIP
SQL Code Assistant Plugin for Intellij IDEA
Java

Build the plugin

latest commit 6bbbb94e69
Serhiy Kulyk authored

README

INTRODUCTION

SQL Code Assistant plugin for IntelliJ IDEA provides extended editing capability
for SQL and PL/SQL code of the Oracle database.

The database objects are always at your fingertips no matter where they came from - the database
or sql scripts on the local File System. With the SQL Code Assistant you are able to browse
the objects, edit and execute SQL statements, navigate over the code, search for usages in
the database schema or scripts on the File System.

The plugin uses lexer and parser generated by ANTLR tool, thanks to Terence Parr (parrt@cs.usfca.edu, parrt@antlr.org).

Feature list:
- Syntax and error highlighting
- Highlighting of keywords, types, system functions, table names, pl/sql varaible, etc
- Static code analysis (arithmetic expression evaluation, resolving references)
- Context aware code completion
- Viewing the Structure of SQL and PL/SQL code
- Code Navigation
- Code Formatting
- Quick object lookup (Ctrl-Shift-O)
- Find Usages tables, views, columns, function, procedures, etc over a database schema
  or objects in the sql scripts on the local File System
- SQL and PL/SQL code execution with sortable query result (Ctrl-Shift-M)
- Code Folding and bracket matching support
- Code commenting
- Database Schema Browsing
- Connection management

Supported version IntelliJ IDEA 12  (ver. 13 is coming soon)


HOW TO BUILD

1. Make sure you have set up maven locally

2. Compile project from command line
mvn -Ddebug1=true clean install

At the end it should display success:
...

[INFO] ------------------------------------------------------------------------
[INFO] Reactor Summary:
[INFO] ------------------------------------------------------------------------
[INFO] Unnamed - sql-assistant:sql-assistant:pom:1.12.1-SNAPSHOT  SUCCESS [3.277s]
[INFO] Unnamed - sql-assistant:antl_patch:jar:1.12.1-SNAPSHOT  SUCCESS [4.983s]
[INFO] Unnamed - sql-assistant:commons:jar:1.12.1-SNAPSHOT ... SUCCESS [3.962s]
[INFO] Unnamed - sql-assistant:tools:jar:1.12.1-SNAPSHOT ..... SUCCESS [5.403s]
[INFO] Unnamed - sql-assistant:parser:jar:1.12.1-SNAPSHOT .... SUCCESS [2.512s]
[INFO] Unnamed - sql-assistant:resolver:jar:1.12.1-SNAPSHOT .. SUCCESS [0.351s]
[INFO] Unnamed - sql-assistant:database:jar:1.12.1-SNAPSHOT .. SUCCESS [1.247s]
[INFO] Unnamed - sql-assistant:result_panel:jar:1.12.1-SNAPSHOT  SUCCESS [2.601s]
[INFO] Unnamed - sql-assistant:main:jar:1.12.1-SNAPSHOT ...... SUCCESS [40.677s]
[INFO] Unnamed - sql-assistant:db_browser:jar:1.12.1-SNAPSHOT  SUCCESS [4.604s]
[INFO] ------------------------------------------------------------------------
[INFO] ------------------------------------------------------------------------
[INFO] BUILD SUCCESSFUL
[INFO] ------------------------------------------------------------------------
[INFO] Total time: 1 minute 10 seconds
[INFO] Finished at: Mon Dec 23 22:00:49 EET 2013
[INFO] Final Memory: 60M/377M
[INFO] ------------------------------------------------------------------------


3. Open project in IntelliJ IDEA, in the ANT Build Tool window call "build_plugin" then "bundle_plugin".
Resulting sql_assisnant.zip file ready for installation can be found under "out" directory


AUTHOR

Serhiy Kulyk (plsql.assistant@gmail.com)
Something went wrong with that request. Please try again.