Create Snippets

[FelixVicis]

Prerequisites

• [x] Put an X between the brackets on this line if you have done all of the following:
  • Reproduced the problem in Safe Mode: http://flight-manual.atom.io/hacking-atom/sections/debugging/#using-safe-mode
  • Followed all applicable steps in the debugging guide: http://flight-manual.atom.io/hacking-atom/sections/debugging/
  • Checked the FAQs on the message board for common solutions: https://discuss.atom.io/c/faq
  • Checked that your issue isn't already filed: https://github.com/issues?utf8=✓&q=is%3Aissue+user%3Aatom
  • Checked that there is not already an Atom package that provides the described functionality: https://atom.io/packages

Description

It would be awesome if this package added snippets in the same way that language-javascript did.

[FelixVicis]

Just a few that I've added to my own file are:

'.source.sql':
    'select all':
        'prefix': 'SELECTALL'
        'body': """
            SELECT ${1:*}
            FROM ${2:"tableName"}
            $3
        """
    'select one':
        'prefix': 'SELECT'
        'body':"""
            SELECT "${2:${1:table}_id}"
            FROM "${3:${1:table}s}"
            $4
        """
    'where':
        'prefix':'WHERE'
        'body':"""
            WHERE $1
        """
    'join':
        'prefix':'JOIN'
        'body':"""
            JOIN $1
        """
    'join as':
        'prefix':'JOINAS'
        'body':"""
            JOIN $1 as $2
        """
    'time now':
        'prefix':'NOW'
        'body':"""
            now()
        """