public static OracleSingleScript Create(string script)
{
script = (script ?? string.Empty).Trim().Trim(';').Trim();
if (string.IsNullOrWhiteSpace(script))
{
return(null);
}
OracleSingleScript item = new OracleSingleScript();
item.SqlScript = script;
item.IsSelect = script.StartsWith("SELECT", StringComparison.CurrentCultureIgnoreCase);
if (!item.IsSelect)
{
item.IsInsert = script.StartsWith("INSERT", StringComparison.CurrentCultureIgnoreCase);
if (!item.IsInsert)
{
item.IsUpdate = script.StartsWith("UPDATE", StringComparison.CurrentCultureIgnoreCase);
if (!item.IsUpdate)
{
item.IsDelete = script.StartsWith("DELETE", StringComparison.CurrentCultureIgnoreCase);
}
}
}
return(item);
}
/// <summary>
/// Oracle 不支持 多条脚本 同时执行, 这里按照 ; 拆分脚本, 分次执行
/// </summary>
private static List <OracleSingleScript> SplitOracleScript(string cmdText)
{
List <OracleSingleScript> listScript = new List <OracleSingleScript>();
if (string.IsNullOrWhiteSpace(cmdText))
{
return(listScript);
}
if (!cmdText.Contains(";"))
{
OracleSingleScript singleScript = OracleSingleScript.Create(cmdText);
if (singleScript != null)
{
listScript.Add(singleScript);
}
return(listScript);
}
string cmdTextTrim = cmdText.Trim().Trim(';').Trim();
if (cmdTextTrim.StartsWith("BEGIN", StringComparison.CurrentCultureIgnoreCase))
{
cmdTextTrim = cmdTextTrim.Substring("BEGIN".Length);
}
if (cmdTextTrim.EndsWith("END", StringComparison.CurrentCultureIgnoreCase))
{
cmdTextTrim = cmdTextTrim.Substring(0, cmdTextTrim.Length - "END".Length);
}
string[] splitTemp = cmdTextTrim.Split(new[] { ';' }, StringSplitOptions.None);
List <string> listGroup = new List <string>();
foreach (string temp in splitTemp)
{
string tempTrim = temp.Trim();
//可以作为开头的 脚本
if (tempTrim.StartsWith("SELECT", StringComparison.CurrentCultureIgnoreCase) ||
tempTrim.StartsWith("INSERT", StringComparison.CurrentCultureIgnoreCase) ||
tempTrim.StartsWith("UPDATE", StringComparison.CurrentCultureIgnoreCase) ||
tempTrim.StartsWith("DELETE", StringComparison.CurrentCultureIgnoreCase)
)
{
if (listGroup.Count > 0)
{
string script = string.Join(";", listGroup).Trim().Trim(';').Trim();
OracleSingleScript singleScript = OracleSingleScript.Create(script);
if (singleScript != null)
{
listScript.Add(singleScript);
}
listGroup.Clear();
}
}
listGroup.Add(temp);
}
if (listGroup.Count > 0)
{
string lastScript = string.Join(";", listGroup).Trim().Trim(';').Trim();
OracleSingleScript singleScript = OracleSingleScript.Create(lastScript);
if (singleScript != null)
{
listScript.Add(singleScript);
}
listGroup.Clear();
}
return(listScript);
}