public static bool ParseAlterCommnad(string sql, out List <ParseSqlData> parseSqlDatas)
{
parseSqlDatas = new List <ParseSqlData>();
BaseSqlReader reader = new MySqlReader(sql);
string table = "ALTER TABLE";
while (reader.NextLine(out string line))
{
if (line.ToUpper().StartsWith(table))
{
int findIndex = line.IndexOf(' ', table.Length + 1);
var tableName = line.Substring(table.Length + 1, findIndex - table.Length - 1).Replace("`", "");
findIndex++;
while (findIndex <= line.Length)
{
int beforeFindIndex = findIndex++;
findIndex = line.IndexOfAny(new char[] { ',', ';' }, findIndex);
if (findIndex == -1)
{
findIndex = line.Length;
}
var command = line.Substring(beforeFindIndex, findIndex - beforeFindIndex).Trim();
if (!ParseSubAlterTableCommand(command, out ParseSqlData parseSqlData))
{
throw new Exception($"sql : {sql}");
}
parseSqlData.TableName = tableName;
parseSqlDatas.Add(parseSqlData);
findIndex++;
}
}
}
return(true);
}
public static bool CheckConnectDatabase(string sql, out string database)
{
database = null;
BaseSqlReader reader = new MySqlReader(sql);
while (reader.NextLine(out string line))
{
if (line.ToUpper().StartsWith("USE"))
{
database = line.Split(' ').Skip(1).Aggregate((l, r) => $"{l} {r}").Replace("`", "");
return(true);
}
}
return(false);
}
public static bool ParseCreateTableCommnad(string sql, out TableInfoModel tableInfoData)
{
tableInfoData = new TableInfoModel()
{
Columns = new Dictionary <string, ParseSqlData>(),
};
BaseSqlReader reader = new MySqlReader(sql);
while (reader.NextLine(out string line))
{
if (line.ToUpper().StartsWith("CREATE TABLE"))
{
var openIndex = line.IndexOf("(", 0);
var closeIndex = line.LastIndexOf(')');
if (openIndex == -1)
{
throw new Exception($"CreateTable Parse Error: {sql}");
}
var tableNameIndex = line.ToUpper().IndexOf("CREATE TABLE") + "CREATE TABLE".Length;
var tableName = line.Substring(tableNameIndex, openIndex - tableNameIndex).Replace("`", "").Trim();
var body = line.Substring(openIndex + 1, closeIndex - openIndex - 1).Trim();
tableInfoData.TableName = tableName;
var findIndex = 0;
while (findIndex <= body.Length)
{
int beforeIndex = findIndex;
findIndex = body.IndexOf(",", findIndex);
if (findIndex == -1)
{
findIndex = body.Length;
}
line = body.Substring(beforeIndex, findIndex - beforeIndex).Trim();
bool isReservedKeyword = false;
var queue = new Queue <string>();
foreach (var key in Consts.MySqlReservedKeyword.Keys)
{
isReservedKeyword = line.ToUpper().StartsWith(key);
if (isReservedKeyword == false)
{
continue;
}
queue.Enqueue(key);
break;
}
if (isReservedKeyword == false)//기본 컬럼
{
var datas = line.Split(new char[] { ' ' }, StringSplitOptions.RemoveEmptyEntries).ToList();
var option = "";
for (int ii = 2; ii < datas.Count; ii++)
{
if (datas[ii].StartsWith("(") && datas[ii].EndsWith(")"))
{
datas[1] += datas[ii];
}
else
{
option += $"{datas[ii]} ";
}
}
if (Consts.BaseMySqlDataType.ContainsKey(datas[1]))
{
datas[1] = Consts.BaseMySqlDataType[datas[1]];
}
var column = new ParseSqlData()
{
ColumnName = datas[0].Replace("`", ""),
ColumnType = datas[1],
ColumnOptions = option,
TableName = tableName
};
tableInfoData.Columns.Add(column.ColumnName, column);
}
else
{
int maxIndex = 0;
int minIndex = beforeIndex;
while (queue.Count > 0)
{
var item = queue.Dequeue();
var index = body.IndexOf(item, minIndex);
if (index == -1)
{
maxIndex = body.Length;
}
if (maxIndex <= index)
{
maxIndex = index + item.Length;
}
findIndex = maxIndex;
//InputManager.Instance.Write(body.Substring(beforeIndex, findIndex - beforeIndex).Trim());
minIndex = findIndex;
if (!Consts.MySqlReservedKeyword.ContainsKey(item))
{
continue;
}
foreach (var key in Consts.MySqlReservedKeyword[item])
{
queue.Enqueue(key);
}
}
}
findIndex++;
}
}
}
return(true);
}