Source code for sqllineage.cli

import argparse
import logging
import logging.config
import warnings

from sqllineage import (
    DEFAULT_DIALECT,
    DEFAULT_HOST,
    DEFAULT_LOGGING,
    DEFAULT_PORT,
    NAME as MAIN_NAME,
    VERSION as MAIN_VERSION,
)
from sqllineage.core.metadata.dummy import DummyMetaDataProvider
from sqllineage.core.metadata.sqlalchemy import SQLAlchemyMetaDataProvider
from sqllineage.drawing import draw_lineage_graph
from sqllineage.runner import LineageRunner
from sqllineage.utils.constant import LineageLevel
from sqllineage.utils.helpers import extract_sql_from_args

logger = logging.getLogger(__name__)


[docs] def main(args=None) -> None: """ The command line interface entry point. :param args: the command line arguments for sqllineage command """ logging.config.dictConfig(DEFAULT_LOGGING) parser = argparse.ArgumentParser( prog="sqllineage", description="SQL Lineage Parser." ) parser.add_argument( "--version", action="version", version="%s %s" % (MAIN_NAME, MAIN_VERSION) ) parser.add_argument( "-e", metavar="<quoted-query-string>", help="SQL from command line" ) parser.add_argument("-f", metavar="<filename>", help="SQL from files") parser.add_argument( "-v", "--verbose", help="increase output verbosity, show statement level lineage result", action="store_true", ) parser.add_argument( "-l", "--level", help="lineage level, column or table, default at table level", choices=[LineageLevel.TABLE, LineageLevel.COLUMN], default=LineageLevel.TABLE, ) parser.add_argument( "-g", "--graph-visualization", help="show graph visualization of the lineage in a webserver", action="store_true", ) parser.add_argument( "-H", "--host", help="the host visualization webserver will be bind to", type=str, default=DEFAULT_HOST, metavar="<hostname>", ) parser.add_argument( "-p", "--port", help="the port visualization webserver will be listening on", type=int, default=DEFAULT_PORT, metavar="<port_number>{0..65536}", ) parser.add_argument( "-d", "--dialect", help="the dialect used to analyze the lineage, use --dialects to show all available dialects", type=str, default=DEFAULT_DIALECT, metavar="<dialect>", ) parser.add_argument( "-ds", "--dialects", help="list all the available dialects", action="store_true", ) parser.add_argument( "--silent_mode", help="skip unsupported statements", action="store_true", ) parser.add_argument( "--sqlalchemy_url", help="sqlalchemy url to provide metadata for lineage analysis", type=str, ) args = parser.parse_args(args) if args.e and args.f: warnings.warn("Both -e and -f options are specified. -e option will be ignored") if args.f or args.e: sql = extract_sql_from_args(args) runner = LineageRunner( sql, dialect=args.dialect, metadata_provider=( SQLAlchemyMetaDataProvider(args.sqlalchemy_url) if args.sqlalchemy_url else DummyMetaDataProvider() ), verbose=args.verbose, draw_options={ "host": args.host, "port": args.port, "f": args.f if args.f else None, }, silent_mode=args.silent_mode, ) if args.graph_visualization: runner.draw() elif args.level == LineageLevel.COLUMN: runner.print_column_lineage() else: runner.print_table_lineage() elif args.graph_visualization: return draw_lineage_graph(**{"host": args.host, "port": args.port}) elif args.dialects: dialects = [] for _, supported_dialects in LineageRunner.supported_dialects().items(): dialects += supported_dialects print("\n".join(dialects)) else: parser.print_help()
if __name__ == "__main__": main()