public MyStructData[] PrepareBoundData(CommandParams cmdParams)
{
//1. check proper type and
//2. check all values are in its range
//extract and arrange
int j = _keys.Count;
for (int i = 0; i < j; ++i)
{
SqlBoundSection key = _keys[i];
if (!cmdParams.TryGetData(key.Text, out _preparedValues[i]))
{
//not found key
throw new Exception("not found " + _keys[i].Text);
}
else
{
//-------------------------------
//TODO: check here
//all field type is 253 ?
//error
//-------------------------------
//check
//FieldPacket fieldInfo = key.fieldInfo;
//switch ((MySqlDataType)fieldInfo.columnType)
//{
// case MySqlDataType.VARCHAR:
// case MySqlDataType.VAR_STRING:
// {
// //check length
// if (_preparedValues[i].myString.Length > fieldInfo.maxLengthOfField)
// {
// //TODO: notify user how to handle this data
// //before error
// }
// }
// break;
// case MySqlDataType.BLOB:
// case MySqlDataType.LONG_BLOB:
// case MySqlDataType.MEDIUM_BLOB:
// {
// if (_preparedValues[i].myString.Length > fieldInfo.maxLengthOfField)
// {
// //TODO: notify user how to handle this data
// //before error
// }
// }
// break;
//}
}
}
return(_preparedValues);
}
string _userRawSql; //raw sql from user code
public SqlStringTemplate(string rawSql)
{
_userRawSql = rawSql;
//------------------------------
//parse
int length = rawSql.Length;
ParseState state = ParseState.FIND_MARKER;
StringBuilder stBuilder = new StringBuilder();
//TODO: review parser state, escape ' or " or `
char binderEscapeChar = '\0';
char escapeChar = '\0';
for (int i = 0; i < length; i++)
{
char ch = rawSql[i];
switch (state)
{
default:
//unknown state must throw exception, so we can see if something changed
throw new NotSupportedException();
case ParseState.FIND_MARKER:
if (ch == '?' || ch == '@')
{
binderEscapeChar = ch;
//found begining point of new marker
if (stBuilder.Length > 0)
{
_sqlSections.Add(new SqlSection(stBuilder.ToString(), SqlSectionKind.SqlText));
stBuilder.Length = 0;
}
state = ParseState.COLLECT_MARKER_KEY;
}
else if (ch == '\'' || ch == '"' || ch == '`')
{
escapeChar = ch;
state = ParseState.STRING_ESCAPE;
}
stBuilder.Append(ch);
break;
case ParseState.COLLECT_MARKER_KEY:
if ((ch >= 'a' && ch <= 'z') || (ch >= 'A' && ch <= 'Z') || (ch >= '0' && ch <= '9') || ch == '_')
{
stBuilder.Append(ch);
}
else if (ch == '?')
{
//this is special marker key
stBuilder.Append(ch);
if (binderEscapeChar == '?')
{
state = ParseState.COLLECT_SP_MARKER_KEY;
}
else
{
//eg ?@
//error
throw new NotSupportedException("syntax err!");
}
}
else if (ch == '@')
{
stBuilder.Append(ch);
if (binderEscapeChar == '@')
{
//@@
state = ParseState.FIND_MARKER; //goto normal text state
}
else
{
//eg @?
//eg ?@
//error
throw new NotSupportedException("syntax err!");
}
}
else
{
//value binding marking end here
if (stBuilder.Length > 0)
{
var valueSection = new SqlBoundSection(stBuilder.ToString());
_sqlSections.Add(valueSection);
_valuesKeys.Add(valueSection);
stBuilder.Length = 0;
}
state = ParseState.FIND_MARKER;
stBuilder.Append(ch);
}
break;
case ParseState.COLLECT_SP_MARKER_KEY:
if ((ch >= 'a' && ch <= 'z') || (ch >= 'A' && ch <= 'Z') || (ch >= '0' && ch <= '9') || ch == '_')
{
stBuilder.Append(ch);
}
else
{
//special marker end here
if (stBuilder.Length > 0)
{
var specialSection = new SqlSection(stBuilder.ToString(), SqlSectionKind.SpecialKey);
_sqlSections.Add(specialSection);
_specialKeys.Add(specialSection);
stBuilder.Length = 0;
}
state = ParseState.FIND_MARKER;
stBuilder.Append(ch);
}
break;
case ParseState.STRING_ESCAPE:
{
if (ch == '\'' || ch == '"' || ch == '`')
{
if (escapeChar == ch)
{
escapeChar = '\0';
//go back to find marker state
state = ParseState.FIND_MARKER;
}
}
stBuilder.Append(ch);
}
break;
}//end swicth
}//end for
if (stBuilder.Length > 0)
{
switch (state)
{
default:
throw new NotSupportedException();
case ParseState.FIND_MARKER:
_sqlSections.Add(new SqlSection(stBuilder.ToString(), SqlSectionKind.SqlText));
break;
case ParseState.COLLECT_MARKER_KEY:
var valueSection = new SqlBoundSection(stBuilder.ToString());
_sqlSections.Add(valueSection);
_valuesKeys.Add(valueSection);
break;
case ParseState.COLLECT_SP_MARKER_KEY:
var specialSection = new SqlSection(stBuilder.ToString(), SqlSectionKind.SpecialKey);
_sqlSections.Add(specialSection);
_specialKeys.Add(specialSection);
break;
}
}
}
string _userRawSql; //raw sql from user code
public SqlStringTemplate(string rawSql)
{
_userRawSql = rawSql;
//------------------------------
//parse
int length = rawSql.Length;
ParseState state = ParseState.FIND_MARKER;
StringBuilder stBuilder = new StringBuilder();
//TODO: review parser state, escape ' or " or `
char binderEscapeChar = '\0';
char escapeChar = '\0';
for (int i = 0; i < length; i++)
{
char ch = rawSql[i];
switch (state)
{
default:
//unknown state must throw exception, so we can see if something changed
throw new NotSupportedException();
case ParseState.FIND_MARKER:
if (ch == '?' || ch == '@')
{
binderEscapeChar = ch;
//found begining point of new marker
if (stBuilder.Length > 0)
{
_sqlSections.Add(new SqlSection(stBuilder.ToString(), SqlSectionKind.SqlText));
stBuilder.Length = 0;
}
state = ParseState.COLLECT_MARKER_KEY;
}
else if (ch == '\'' || ch == '"' || ch == '`')
{
escapeChar = ch;
state = ParseState.STRING_ESCAPE;
}
stBuilder.Append(ch);
break;
case ParseState.COLLECT_MARKER_KEY:
if ((ch >= 'a' && ch <= 'z') || (ch >= 'A' && ch <= 'Z') || (ch >= '0' && ch <= '9') || ch == '_')
{
stBuilder.Append(ch);
}
else if (ch == '?')
{
//this is special marker key
stBuilder.Append(ch);
if (binderEscapeChar == '?')
{
state = ParseState.COLLECT_SP_MARKER_KEY;
}
else
{
//eg ?@
//error
throw new NotSupportedException("syntax err!");
}
}
else if (ch == '@')
{
stBuilder.Append(ch);
if (binderEscapeChar == '@')
{
//@@
state = ParseState.FIND_MARKER; //goto normal text state
}
else
{
//eg @?
//eg ?@
//error
throw new NotSupportedException("syntax err!");
}
}
else
{
//value binding marking end here
if (stBuilder.Length > 0)
{
var valueSection = new SqlBoundSection(stBuilder.ToString());
_sqlSections.Add(valueSection);
_valuesKeys.Add(valueSection);
stBuilder.Length = 0;
}
state = ParseState.FIND_MARKER;
stBuilder.Append(ch);
}
break;
case ParseState.COLLECT_SP_MARKER_KEY:
if ((ch >= 'a' && ch <= 'z') || (ch >= 'A' && ch <= 'Z') || (ch >= '0' && ch <= '9') || ch == '_')
{
stBuilder.Append(ch);
}
else
{
//special marker end here
if (stBuilder.Length > 0)
{
var specialSection = new SqlSection(stBuilder.ToString(), SqlSectionKind.SpecialKey);
_sqlSections.Add(specialSection);
_specialKeys.Add(specialSection);
stBuilder.Length = 0;
}
state = ParseState.FIND_MARKER;
stBuilder.Append(ch);
}
break;
case ParseState.STRING_ESCAPE:
{
if (ch == '\'' || ch == '"' || ch == '`')
{
if (escapeChar == ch)
{
escapeChar = '\0';
//go back to find marker state
state = ParseState.FIND_MARKER;
}
}
stBuilder.Append(ch);
}
break;
} //end swicth
} //end for
if (stBuilder.Length > 0)
{
switch (state)
{
default:
throw new NotSupportedException();
case ParseState.FIND_MARKER:
_sqlSections.Add(new SqlSection(stBuilder.ToString(), SqlSectionKind.SqlText));
break;
case ParseState.COLLECT_MARKER_KEY:
var valueSection = new SqlBoundSection(stBuilder.ToString());
_sqlSections.Add(valueSection);
_valuesKeys.Add(valueSection);
break;
case ParseState.COLLECT_SP_MARKER_KEY:
var specialSection = new SqlSection(stBuilder.ToString(), SqlSectionKind.SpecialKey);
_sqlSections.Add(specialSection);
_specialKeys.Add(specialSection);
break;
}
}
}