pg-dev package

pg-dev is a package for Atom editor, in order to help developing on PostgreSQL (functions).

How?

Load functions from file system, so you MUST have the functions mapped there.

Usage

• Set main directory path: must be an absolute path on package config.

  

• Set workspace directories (support multiples, splitted by comma) on package config. By default, the functions must go inside of "functions" directory (The package must read this files as functions).

  

Features

• Suggest Functions
• Suggest Variables
• Suggest Data Types
• Suggest Out parameters on function. (i.e: get_test('test')).id)
• Suggest parameters on 'record' variable type
• Go to function - open in a new tab (hyperclick) - ctrl+click
• Linter on:
  • Unused variable
  • Undeclared variable
  • Inexistent function
• Function definition (on click)
• Snippets: If, ElseIf, Else, For, Create Function, Raise Notice, Raise Exception, do (anonymous function)

Function Definition

Linter

Suggest Function Definition

Suggest Properties on record data type

Restrictions

• Every file MUST HAVE one and only one function
• The name of the function must be equal than fileName
• The name of the function can not be longer than 64 characters

TODO

• Connect to a database in order to synchronize functions with file system
• Improve file parser (need Regex expert)
• Add more features gifs
• Add spec/travis-ci