Package com.simplicite.util.tools
Class SQLTool
- java.lang.Object
-
- com.simplicite.util.tools.SQLTool
-
public class SQLTool extends java.lang.Object
SQL Tools
This class only provides static variables and methods
-
-
Nested Class Summary
Nested Classes Modifier and Type Class Description class
SQLTool.Metrics
LogSQL metricsclass
SQLTool.TopSQL
-
Method Summary
All Methods Static Methods Concrete Methods Modifier and Type Method Description static void
clearStatistics()
static double
getAvgTime()
Average of SQL times in millisecondsstatic long
getCountTotal()
Requests counterstatic SQLTool.Metrics
getMetrics()
Get the SQL metrics for the periodstatic java.lang.String
getSequence(java.lang.String datasource, java.lang.String table, java.lang.String column, boolean create)
Get and check sequence existence (Oracle and PostgreSQL only)static java.lang.String
getSequenceName(int dbvendor, java.lang.String table, java.lang.String col)
static java.lang.String
getSequenceNextval(java.lang.String datasource, java.lang.String table, java.lang.String column, boolean create)
Next sequence value (Oracle and PostgreSQL only)static java.lang.String
getString(java.sql.ResultSet rs, int type, int index)
Get a String in a resultstatic int
getTopSize()
static java.util.List<SQLTool.TopSQL>
getTopSQL()
Get the top SQL long requestsstatic double
getTotalTime()
Total of SQL times in millisecondsstatic void
insertTopSQL(int index, java.lang.String date, java.lang.String sql, long ms, java.lang.String logId)
static boolean
rebuildSequence(java.lang.String datasource, java.lang.String table)
Rebuild sequence associated with an internal tablestatic void
setTopSize(int size)
static void
statistics(java.lang.String sql, long begin, java.lang.String login)
SQL statisticsstatic void
statistics(java.lang.String sql, java.util.List<ObjectField> host, long begin, java.lang.String login)
Manage SQL statistics (time average, long requests...)
-
-
-
Method Detail
-
getString
public static java.lang.String getString(java.sql.ResultSet rs, int type, int index)
Get a String in a result
-
setTopSize
public static void setTopSize(int size)
-
getTopSize
public static int getTopSize()
-
getTopSQL
public static java.util.List<SQLTool.TopSQL> getTopSQL()
Get the top SQL long requests
-
getCountTotal
public static long getCountTotal()
Requests counter
-
getAvgTime
public static double getAvgTime()
Average of SQL times in milliseconds
-
getTotalTime
public static double getTotalTime()
Total of SQL times in milliseconds
-
getMetrics
public static SQLTool.Metrics getMetrics()
Get the SQL metrics for the period
-
statistics
public static void statistics(java.lang.String sql, long begin, java.lang.String login)
SQL statistics- Parameters:
sql
- Querybegin
- Start time (ms)
-
statistics
public static void statistics(java.lang.String sql, java.util.List<ObjectField> host, long begin, java.lang.String login)
Manage SQL statistics (time average, long requests...)- Parameters:
sql
- Queryhost
- Host values to tracebegin
- Start time (ms)
-
insertTopSQL
public static void insertTopSQL(int index, java.lang.String date, java.lang.String sql, long ms, java.lang.String logId)
-
clearStatistics
public static void clearStatistics()
-
getSequenceName
public static java.lang.String getSequenceName(int dbvendor, java.lang.String table, java.lang.String col)
-
rebuildSequence
public static boolean rebuildSequence(java.lang.String datasource, java.lang.String table)
Rebuild sequence associated with an internal table- Parameters:
datasource
- Datasource nametable
- Table name (with a row_id primary key)
-
getSequence
public static java.lang.String getSequence(java.lang.String datasource, java.lang.String table, java.lang.String column, boolean create)
Get and check sequence existence (Oracle and PostgreSQL only)- Parameters:
datasource
- Datasource nametable
- Table namecolumn
- Column namecreate
- True to create if not exists- Returns:
- Sequence name if exists
-
getSequenceNextval
public static java.lang.String getSequenceNextval(java.lang.String datasource, java.lang.String table, java.lang.String column, boolean create)
Next sequence value (Oracle and PostgreSQL only)- Parameters:
datasource
- Datasource nametable
- Table namecolumn
- Column namecreate
- True to create if not exists- Returns:
- nextval or null if not exists
-
-