bool synaxErrorJudger::isAlldataTypeValid(QStringList &data, vector<pair<int, size_t>> &dataTypeInfo)
{
QStringList::iterator it;
for (it = data.begin(); it != data.end(); ++it) {
*it = it->trimmed();
if (*it == "") {
return false;
}
bool ok;
if (it->indexOf('\'') != -1) { //引号'应该是字符或字符串
it->remove(0, 1).remove(QRegExp("'$"));
size_t len = it->size();
if (len < 1 || len > 255) {
return false;
}
else if (len == 1) {
dataTypeInfo.push_back(pair<int, size_t>(_CHAR, sizeof(char)));
}
else {
dataTypeInfo.push_back(pair<int, size_t>(_STRING, len * sizeof(char)));
}
}
else if (it->indexOf('.') != -1) { //有小数点且不是字符串，应该是float
it->toFloat(&ok);
if (!ok) {
return false;
}
else {
dataTypeInfo.push_back(pair<int, size_t>(_FLOAT, sizeof(float)));
}
}
else { //剩下的应该是int类型
it->toInt(&ok);
if (!ok) {
return false;
}
else {
dataTypeInfo.push_back(pair<int, size_t>(_INT, sizeof(int)));
}
}
}
return true;
}
void synaxErrorJudger::generateCondition()
{
int begin = sqlExp.indexOf("where") + 5;
int end = sqlExp.indexOf(QRegExp(";$")) - 1;
QStringList conditions = sqlExp.mid(begin, end - begin + 1).split("and");
QStringList::iterator it;
pair<int, size_t> dataType;
int logicType;
string rightSide, leftSide;
for (it = conditions.begin(); it != conditions.end(); ++it) {
*it = it->trimmed();
if (*it == "") {
throw QString("Synax Error: Conditions' format is incorrect.");
}
int begin = 0;
int end = it->indexOf(QRegExp("[=><]"))-1;
rightSide = it->mid(begin, end - begin + 1).trimmed().toStdString();
begin = end + 1;
end = it->indexOf(QRegExp("[=><]"), begin + 1);
if (end - begin > 1 || end == -1) { //如果下一个"=",">","<"号出现在较远处
end = begin; //说明这个逻辑关系是"=",">","<"而非">=", "<=", "<>"
}
logicType = condition::getLogicTypeFromStr(it->mid(begin, end - begin + 1).toStdString());
if (logicType == _ERROR) {
throw QString("Synax Error: The logic arithemtic is invalid.");
}
bool ok;
*it = it->mid(end + 1).trimmed();
if (it->indexOf(QRegExp("^'")) != -1) { //引号'应该是字符或字符串
it->remove(0, 1).remove(QRegExp("'$"));
size_t len = it->size();
pair<int, size_t> dType;
Api::cManager.getAttributeDataType(*tblName, rightSide, dType);
if (len < 1 || len > 255 || len > dType.second) {
throw QString("Synax Error: The length of string is overflow.");
}
else if (len == 1) {
dataType = pair<int, size_t>(_CHAR, sizeof(char));
}
else {
dataType = pair<int, size_t>(_STRING, dType.second * sizeof(char));
}
}
else if (it->indexOf('.') != -1) { //有小数点且不是字符串，应该是float
it->toFloat(&ok);
if (!ok) {
;
}
else {
dataType = pair<int, size_t>(_FLOAT, sizeof(float));
}
}
else { //剩下的应该是int类型
it->toInt(&ok);
if (!ok) {
;
}
else {
dataType = pair<int, size_t>(_INT, sizeof(int));
}
}
leftSide = it->toStdString();
if (cond == 0) {
cond = new vector<condition>;
}
cond->push_back(condition(rightSide, logicType, dataType, leftSide));
}
}