/// <summary>
/// 分割SQL
/// </summary>
public static PartedSql SplitSql(string sql)
{
var parts = new PartedSql {
Raw = sql
};
// Extract the sql from "SELECT <whatever> FROM"
var s = _rexSelect1.Match(sql);
if (s.Success)
{
parts.Select = s.Groups[1].Value;
sql = sql.Substring(s.Length);
s = _rexOrderBy.Match(sql);
if (s.Success)
{
sql = sql.Substring(0, s.Index);
parts.OrderBy = s.Groups[1].Value;
}
parts.Body = "(" + sql;
return(parts);
}
var m = _rexSelect.Match(sql);
if (!m.Success)
{
throw new ArgumentException("Unable to parse SQL statement for select");
}
parts.Select = m.Groups[1].Value;
sql = sql.Substring(m.Length);
m = _rexOrderBy.Match(sql);
if (m.Success)
{
sql = sql.Substring(0, m.Index);
parts.OrderBy = m.Groups[1].Value;
}
parts.Body = sql;
return(parts);
}
public static string GetCountSql(PartedSql sql)
{
return($"SELECT COUNT(*) FROM {sql.Body}");
}