void Interpret::InsertParse(Command & cmd)
{
Attribute tempAttr;
Condition tempCon;
string tempRow;
int indexStr = 2;
m_nOperation = INSERT_ERR;
if (cmd.n == indexStr)
return;
m_tablename = cmd.str[indexStr];
if (!catalog.ExistTable(m_tablename))
{
m_nOperation = TABLE_ERR;
return;
}
table_info = catalog.gettableinformation(m_tablename);
indexStr++;
if (cmd.n == indexStr)
return;
if (cmd.str[indexStr] != "values")
return;
indexStr++;
if (cmd.n == indexStr)
return;
if (cmd.str[indexStr] != "(")
return;
indexStr++;
int i = 0;
while (cmd.n > indexStr)
{
int datatype = JudgeDataType(indexStr);
if (table_info.attr[i].type == FLOAT && datatype == INT)
datatype = FLOAT;
if (datatype != table_info.attr[i].type)
return;
if (datatype == CHARN)
{
tempRow = cmd.str[indexStr - 1];
if (tempRow.length() > table_info.attr[i].length - 1)
return;
}
else
tempRow = cmd.str[indexStr];
data.columns.push_back(tempRow);
indexStr++;
if (cmd.n == indexStr)
return;
if (cmd.str[indexStr] == ")")
break;
if (cmd.str[indexStr] != ",")
return;
indexStr++;
i++;
}
if (data.columns.size() != table_info.attriNum)
{
m_nOperation = INSERT_NUM_ERR;
return;
}
for (int i = 0; i<table_info.attriNum; i++)
{
if (table_info.attr[i].isUnique)
{
if (table_info.attr[i].isPrimaryKey)
{
if (PrimaryKeyValue[0] != table_info.name)
{
Data tableValue = record.select(table_info);
PrimaryKeyValue[0] = table_info.name;
for (int j = 0; j < tableValue.rows.size(); j++)
PrimaryKeyValue[j + 1] = tableValue.rows[j].columns[i];
}
for (int j = 0; j < table_info.recordNum;j++)
if (PrimaryKeyValue[j + 1] == data.columns[i])
{
m_nOperation = PRIMARY_RAID;
return;
}
PrimaryKeyValue[table_info.recordNum+1] = data.columns[i];
}
if (table_info.attr[i].isPrimaryKey != 1 && table_info.attr[i].isUnique)
{
if (UniqueKeyValue[0] != table_info.name)
{
Data tableValue = record.select(table_info);
table_info.recordNum = tableValue.rows.size();
UniqueKeyValue[0] = table_info.name;
for (int j = 0; j < tableValue.rows.size(); j++)
UniqueKeyValue[j + 1] = tableValue.rows[j].columns[i];
}
for (int j = 0; j < table_info.recordNum;j++)
if (UniqueKeyValue[j + 1] == data.columns[i])
{
m_nOperation = UNIQUE_RAID;
return;
}
UniqueKeyValue[table_info.recordNum+1] = data.columns[i];
}
}
}
indexStr++;
if (cmd.n == indexStr)
m_nOperation = INSERT;
return;
}
void Execute()
{
int i;
int j;
int k;
Table tableinfor;
Index indexinfor;
string tempKeyValue;
int tempPrimaryPosition=-1;
int rowCount=0;
Data data;
switch(parsetree.m_operation)
{
case CRETAB:
parsetree.getTableInfo.attriNum=parsetree.getTableInfo.attributes.size();
catalog.createTable(parsetree.getTableInfo);
record.createTable(parsetree.getTableInfo);
cout<<"Table "<<parsetree.getTableInfo.name<<" is created successfully"<<endl;
break;
case TABLEEXISTED:
cout<<"CREATE ERROR: Table existed"<<endl;
break;
case DRPTAB:
record.dropTable(parsetree.getTableInfo);
for(int i = 0; i < parsetree.getTableInfo.attriNum; i++){//���������е�index��ɾ��
indexinfor = catalog.getIndexInformation(parsetree.getTableInfo.name, i);
if(indexinfor.index_name != "")
indexm.dropIndex(indexinfor);
}
catalog.dropTable(parsetree.getTableInfo);
cout<<"Table "<<parsetree.getTableInfo.name<<" is dropped successfully"<<endl;
break;
case INSERT:
tableinfor = parsetree.getTableInfo;
if(parsetree.PrimaryKeyPosition==-1&&parsetree.UniquePostion==-1){
record.insertValue(tableinfor, parsetree.row);
catalog.update(tableinfor);
cout<<"Insert successfully"<<endl;
break;
}
if(parsetree.PrimaryKeyPosition!=-1)
{
data=record.select(tableinfor, parsetree.condition);
if(data.rows.size()>0){
cout<<"INSERT ERROR: Primary key redundancy"<<endl;
break;
}
}
if(parsetree.UniquePostion!=-1){
data=record.select(tableinfor, parsetree.UniqueCondition);
if(data.rows.size()>0){
cout<<"INSERT ERROR: Unique value redundancy"<<endl;
break;
}
}
record.insertValue(tableinfor,parsetree.row);
catalog.update(tableinfor);
cout<<"Insert successfully"<<endl;
break;
case INSERTERR:
cout << "Syntax ERROR: Incorrect usage of \"insert\"." << endl;
break;
case SELECT_NOWHERE_CAULSE:
tableinfor = parsetree.getTableInfo;
data=record.select(tableinfor);
if(data.rows.size()!=0)
ShowResult( data, tableinfor, parsetree.column);
else{
cout << "No data is found." << endl;
}
break;
case SELECT_WHERE_CAULSE:
tableinfor=parsetree.getTableInfo;
if(parsetree.condition.size()==1){
for(int i=0;i<parsetree.getTableInfo.attributes.size();i++){
/*��*/if((parsetree.getTableInfo.attributes[i].isPrimeryKey==true||parsetree.getTableInfo.attributes[i].isUnique==true)&&parsetree.m_colname==parsetree.getTableInfo.attributes[i].name){
tempPrimaryPosition=i;
indexinfor=catalog.getIndexInformation(tableinfor.name,i);
break;
}
}
if(tempPrimaryPosition==parsetree.condition[0].columnNum&&parsetree.condition[0].op==Eq&&indexinfor.table_name!=""){
tempKeyValue=parsetree.condition[0].value;
data= indexm.selectEqual(tableinfor,indexinfor,tempKeyValue);
}
else{
data=record.select(tableinfor,parsetree.condition);
}
}
else{
data=record.select(tableinfor,parsetree.condition);
}
if(data.rows.size()!=0)
ShowResult( data, tableinfor, parsetree.column);
else{
cout << "No data is found." << endl;
}
break;
case DELETE:
rowCount = record.deleteValue(parsetree.getTableInfo,parsetree.condition);
cout<< rowCount <<" tuples are deleted."<<endl;
break;
case CREIND:
indexinfor = parsetree.getIndexInfo;
tableinfor = parsetree.getTableInfo;
if(!tableinfor.attributes[indexinfor.column].isPrimeryKey && !tableinfor.attributes[indexinfor.column].isUnique){//����primary key�������Խ�index
cout << "Column " << tableinfor.attributes[indexinfor.column].name <<" is not unique."<< endl;
break;
}
catalog.createIndex(indexinfor);
indexm.createIndex(tableinfor, indexinfor);
catalog.update(indexinfor);
cout<<"Index "<< indexinfor.index_name << "is created successfully."<<endl;
break;
case INDEXERROR:
cout<<"ERROR: Index existed."<<endl;
break;
case DRPIND:
indexinfor = catalog.getIndexInformation(parsetree.m_indname);
if(indexinfor.index_name == ""){
cout << "ERROR: Index" << parsetree.m_indname << "does not exist!" << endl;
}
indexm.dropIndex(indexinfor);
catalog.dropIndex(parsetree.m_indname);
cout<<"The index is dropped successfully"<<endl;
break;
case CREINDERR:
cout << "Syntax ERROR: Incorrect usage of \"create index\" query." << endl;
break;
case QUIT:
cout << "Bye Bye~" << endl;
system("pause");
exit(0);
break;
case EMPTY:
cout << "Query Empty." << endl;
break;
case UNKNOW:
cout << "Syntax ERROR: Please check your query." << endl;
break;
case SELERR:
cout << "Syntax ERROR: Incorrect usage of \"select\" query." << endl;
break;
case CRETABERR:
cout << "Syntax ERROR: Incorrect usage of \"create table\" query." << endl;
break;
case DELETEERR:
cout << "Syntax ERROR: Incorrect usage of \"delete from\" query." << endl;
break;
case DRPTABERR:
cout << "Syntax ERROR: Incorrect usage of \"drop table\" query." << endl;
break;
case DRPINDERR:
cout << "Syntax ERROR: Incorrect usage of \"drop index\" query." << endl;
break;
case VOIDPRI:
cout << "ERROR: Invalid primary key." << endl;
break;
case VOIDUNI:
cout << "ERROR: Invalid unique key." << endl;
break;
case CHARBOUD:
cout << "ERROR: Too long query. Only 1~255 charactors is allowed." << endl;
break;
case NOPRIKEY:
cout << "ERROR: Please define a primary key." << endl;
break;
case TABLEERROR:
cout << "ERROR: Table is not existed."<<endl;
break;
case INDEXEROR:
cout << "ERROR: Index is not existed."<<endl;
break;
case COLUMNERROR:
cout << "ERROR: Column is not existed"<<endl;
break;
case INSERTNUMBERERROR:
cout << "ERROR: The amount of the columns is not matched."<<endl;
break;
}
}
