int N_insert_db(T_Connect *conn,char *tabname,void *data,T_PkgType *tp) { char stmt[32768]; char *p; T_CLI_Var *clip; clip=(T_CLI_Var *)conn->Var; p=stmt; p+=sprintf(p,"INSERT INTO "); if(*clip->DBOWN) p+=sprintf(p,"%s.",clip->DBOWN); p+=sprintf(p,"%s (",tabname); p=mkset(p,tp); p+=sprintf(p,") VALUES("); p=mk_values(p,data,tp); p+=sprintf(p,")"); return N_SQL_Exec(conn,stmt); }
/* * interp: interprets parse trees * */ RC interp(NODE *n) { RC errval = 0; /* returned error value */ /* if input not coming from a terminal, then echo the query */ if(!isatty(0)) echo_query(n); switch(n -> kind){ case N_CREATETABLE: /* for CreateTable() */ { int nattrs; AttrInfo attrInfos[MAXATTRS]; /* Make sure relation name isn't too long */ if(strlen(n -> u.CREATETABLE.relname) > MAXNAME){ print_error((char*)"create", E_TOOLONG); break; } /* Make a list of AttrInfos suitable for sending to Create */ nattrs = mk_attr_infos(n -> u.CREATETABLE.attrlist, MAXATTRS, attrInfos); if(nattrs < 0){ print_error((char*)"create", nattrs); break; } /* Make the call to create */ errval = pSmm->CreateTable(n->u.CREATETABLE.relname, nattrs, attrInfos); break; } case N_CREATEINDEX: /* for CreateIndex() */ errval = pSmm->CreateIndex(n->u.CREATEINDEX.relname, n->u.CREATEINDEX.attrname); break; case N_DROPINDEX: /* for DropIndex() */ errval = pSmm->DropIndex(n->u.DROPINDEX.relname, n->u.DROPINDEX.attrname); break; case N_DROPTABLE: /* for DropTable() */ errval = pSmm->DropTable(n->u.DROPTABLE.relname); break; case N_LOAD: /* for Load() */ errval = pSmm->Load(n->u.LOAD.relname, n->u.LOAD.filename); break; case N_SET: /* for Set() */ errval = pSmm->Set(n->u.SET.paramName, n->u.SET.string); break; case N_HELP: /* for Help() */ if (n->u.HELP.relname) errval = pSmm->Help(n->u.HELP.relname); else errval = pSmm->Help(); break; case N_PRINT: /* for Print() */ errval = pSmm->Print(n->u.PRINT.relname); break; case N_QUERY: /* for Query() */ { int nSelAttrs = 0; RelAttr relAttrs[MAXATTRS]; int nRelations = 0; char *relations[MAXATTRS]; int nConditions = 0; Condition conditions[MAXATTRS]; /* Make a list of RelAttrs suitable for sending to Query */ nSelAttrs = mk_rel_attrs(n->u.QUERY.relattrlist, MAXATTRS, relAttrs); if(nSelAttrs < 0){ print_error((char*)"select", nSelAttrs); break; } /* Make a list of relation names suitable for sending to Query */ nRelations = mk_relations(n->u.QUERY.rellist, MAXATTRS, relations); if(nRelations < 0){ print_error((char*)"select", nRelations); break; } /* Make a list of Conditions suitable for sending to Query */ nConditions = mk_conditions(n->u.QUERY.conditionlist, MAXATTRS, conditions); if(nConditions < 0){ print_error((char*)"select", nConditions); break; } /* Make the call to Select */ errval = pQlm->Select(nSelAttrs, relAttrs, nRelations, relations, nConditions, conditions); break; } case N_INSERT: /* for Insert() */ { int nValues = 0; Value values[MAXATTRS]; /* Make a list of Values suitable for sending to Insert */ nValues = mk_values(n->u.INSERT.valuelist, MAXATTRS, values); if(nValues < 0){ print_error((char*)"insert", nValues); break; } /* Make the call to insert */ errval = pQlm->Insert(n->u.INSERT.relname, nValues, values); break; } case N_DELETE: /* for Delete() */ { int nConditions = 0; Condition conditions[MAXATTRS]; /* Make a list of Conditions suitable for sending to delete */ nConditions = mk_conditions(n->u.DELETE.conditionlist, MAXATTRS, conditions); if(nConditions < 0){ print_error((char*)"delete", nConditions); break; } /* Make the call to delete */ errval = pQlm->Delete(n->u.DELETE.relname, nConditions, conditions); break; } case N_UPDATE: /* for Update() */ { RelAttr relAttr; // The RHS can be either a value or an attribute Value rhsValue; RelAttr rhsRelAttr; int bIsValue; int nConditions = 0; Condition conditions[MAXATTRS]; /* Make a RelAttr suitable for sending to Update */ mk_rel_attr(n->u.UPDATE.relattr, relAttr); struct node *rhs = n->u.UPDATE.relorvalue; if (rhs->u.RELATTR_OR_VALUE.relattr) { mk_rel_attr(rhs->u.RELATTR_OR_VALUE.relattr, rhsRelAttr); bIsValue = 0; } else { /* Make a value suitable for sending to update */ mk_value(rhs->u.RELATTR_OR_VALUE.value, rhsValue); bIsValue = 1; } /* Make a list of Conditions suitable for sending to Update */ nConditions = mk_conditions(n->u.UPDATE.conditionlist, MAXATTRS, conditions); if(nConditions < 0){ print_error((char*)"update", nConditions); break; } /* Make the call to update */ errval = pQlm->Update(n->u.UPDATE.relname, relAttr, bIsValue, rhsRelAttr, rhsValue, nConditions, conditions); break; } default: // should never get here break; } return (errval); }