public IntoDestinationTable(string name)
{
var f = IntoDestinationTable.Parse(name);
_table = f._table;
_column = f._column;
_alias = f._alias;
}
public static IntoDestinationTable Parse(string sqlStatement)
{
var field = new IntoDestinationTable();
if (sqlStatement == null)
{
throw new ArgumentNullException(nameof(sqlStatement));
}
sqlStatement = sqlStatement.ClearString();
if (sqlStatement.EndsWith(" AS", StringComparison.OrdinalIgnoreCase))
{
sqlStatement = sqlStatement.Substring(0, sqlStatement.Length - 3);
}
var indexOfAs = sqlStatement.ToUpper().IndexOf(" AS ", StringComparison.OrdinalIgnoreCase);
if (indexOfAs > 0)
{
field._alias = sqlStatement.Substring(indexOfAs + 4).ClearString();
sqlStatement = sqlStatement.Substring(0, indexOfAs).ClearString();
}
if (sqlStatement.Contains("."))
{
var arr = sqlStatement.Split('.');
field._table = arr[0].ClearString();
sqlStatement = arr[1].ClearString();
}
if (sqlStatement == "*")
{
field._alias = null;
}
field._column = sqlStatement;
return(field);
}
