pg-dev

Package in order to help developing on PostgreSQL (functions)
arianbessonart
1,125
Flag as spam or malicious

pg-dev package

Join the chat at https://gitter.im/arianbessonart/pg-dev Build Status

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.

    Main Workspace

  • 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).

    Function Workspace

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

Function Definition

Linter

Linter

Suggest Function Definition

Suggest Function Definition

Suggest Properties on record data type

Suggest Properties Record

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