gudusoft.gsqlparser.dlineage

Class SQLFileStatistics

Object

gudusoft.gsqlparser.dlineage.SQLFileStatistics

public class SQLFileStatistics
extends Object

SQL file statistics utility class for analyzing various statistical information in SQL files. Supports both multi-file statistics and single SQL statement statistics modes. Single SQL statistics functionality: 1. Create an instance using constructor SQLFileStatistics(String sqlContent, Option option) 2. Call generateSingleSQLStatistics() method to get statistics results 3. Or use the static convenience method analyzeSingleSQL(String sqlContent, Option option) Single SQL statistics features: - File size: counts the number of characters in SQL content - Line count: counts the number of lines in SQL content - Other statistics: same as file statistics, including statement types, JOINs, subqueries, etc. Usage example:

 String sql = "SELECT * FROM table WHERE id = 1";
 Option option = new Option();
 option.setVendor(EDbVendor.dbvmysql);
 
 // Method 1: Using static method
 String result = SQLFileStatistics.analyzeSingleSQL(sql, option);
 
 // Method 2: Using instance method
 SQLFileStatistics analyzer = new SQLFileStatistics(sql, option);
 String result = analyzer.generateSingleSQLStatistics();
 

Constructor Summary

Constructors

Constructor and Description
SQLFileStatistics(File[] sqlFiles, Option option)
SQLFileStatistics(SqlInfo[] sqlInfos, Option option)
SQLFileStatistics(String sqlContent, Option option)

Method Summary

Modifier and Type	Method and Description
static String	analyzeSingleSQL(String sqlContent, Option option) Static method: Conveniently analyze a single SQL statement
String	generateFileStatistics()
String	generateSQLQueryStatistics()
void	merge(SQLFileStatistics other) Merge analysis results from another SQLFileStatistics object into the current object

Methods inherited from class Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

SQLFileStatistics

public SQLFileStatistics(SqlInfo[] sqlInfos,
                         Option option)

SQLFileStatistics

public SQLFileStatistics(String sqlContent,
                         Option option)

SQLFileStatistics

public SQLFileStatistics(File[] sqlFiles,
                         Option option)

Method Detail

merge

public void merge(SQLFileStatistics other)

Merge analysis results from another SQLFileStatistics object into the current object

Parameters:

other - The SQLFileStatistics object to merge

generateSQLQueryStatistics

public String generateSQLQueryStatistics()

analyzeSingleSQL

public static String analyzeSingleSQL(String sqlContent,
                                      Option option)

Static method: Conveniently analyze a single SQL statement

Parameters:

sqlContent - SQL content to analyze

option - Analysis options

Returns:

Statistical results in JSON format

generateFileStatistics

public String generateFileStatistics()