sqlLinter 0.0.23

Linter tool for SQL packages written in Python

sqlLinter

A Linter tool for SQL

Getting Started

These instructions will get you a copy of the project up and running on your local machine for development and testing purposes.

Prerequisites

Requires Python 3.6 or higher

Installing

pip install sqlLinter

Usage

walk_pkg_gen

The function walk_pkg_gen is a generator that yields pathobject of any file that has the extensions pkb(package body) or pks(package specification). The following example is how to use walk_pkg_gen

from sqlLinter.plsql_util import walk_pkg_gen
import pathlib

directory = pathlib.Path.cwd()
for pathObject in walk_pkg_gen(directory)
    # use pathObject

missing_slash_in_pkg

The function missing_slash_in_pkg is a generator that yields a pathobject of package files that are missing the slash ‘/’ as last character in either package spec or package body.

from sqlLinter.plsql_util import missing_slash_in_pkg
import pathlib

directory = pathlib.Path.cwd()
for pathObject in missing_slash_in_pkg(directory)
    # use pathObject

commits_in_package

The function commits_in_package is a generator that yields a path object of package body files that contain a commit in their code.

from sqlLinter.plsql_util import commits_in_package
import pathlib

directory = pathlib.Path.cwd()
for pathObject in commits_in_package(directory)
    # use pathObject

License

This project is licensed under the MIT License