public void _runDelete(ISqlHeadstream nSqlHeadstream)
{
mValue += @"DELETE FROM ";
mValue += mFieldCharacter;
mValue += nSqlHeadstream._tableName();
mValue += mFieldCharacter;
mValue += @" ";
mSqlDeal = SqlDeal_.mWhere_;
nSqlHeadstream._runWhere(this);
mSqlDeal = SqlDeal_.mNone_;
}
public void _runSelect(ISqlHeadstream nSqlHeadstream)
{
mValue += @"SELECT ";
mBeg = true;
mSqlDeal = SqlDeal_.mSelect_;
nSqlHeadstream._runSelect(this);
mValue += @" FROM ";
mValue += mFieldCharacter;
mValue += nSqlHeadstream._tableName();
mValue += mFieldCharacter;
mValue += @" ";
mSqlDeal = SqlDeal_.mWhere_;
nSqlHeadstream._runWhere(this);
mSqlDeal = SqlDeal_.mNone_;
}
public void _runUpdate(ISqlHeadstream nSqlHeadstream)
{
mValue += @"UPDATE ";
mValue += mFieldCharacter;
mValue += nSqlHeadstream._tableName();
mValue += mFieldCharacter;
mValue += @" SET ";
mBeg = true;
mSqlDeal = SqlDeal_.mUpdate_;
nSqlHeadstream._runSelect(this);
mSqlDeal = SqlDeal_.mWhere_;
mValue += @" ";
nSqlHeadstream._runWhere(this);
mSqlDeal = SqlDeal_.mNone_;
}
public void _runInsertUpdateEx(ISqlHeadstream nSqlHeadstream)
{
mValue += @"INSERT INTO ";
mValue += mFieldCharacter;
mValue += nSqlHeadstream._tableName();
mValue += mFieldCharacter;
mValue += @" VALUES (";
mBeg = true;
mSqlDeal = SqlDeal_.mInsertUpdateE_;
nSqlHeadstream._runSelect(this);
mValue += @") ON DUPLICATE KEY UPDATE ";
mBeg = true;
mSqlDeal = SqlDeal_.mInsertUpdateEx_;
nSqlHeadstream._runSelect(this);
mSqlDeal = SqlDeal_.mWhere_;
nSqlHeadstream._runWhere(this);
mSqlDeal = SqlDeal_.mNone_;
}
public void _runInsert(ISqlHeadstream nSqlHeadstream)
{
mValue += @"INSERT INTO ";
mValue += mFieldCharacter;
mValue += nSqlHeadstream._tableName();
mValue += mFieldCharacter;
mValue += @" (";
mBeg = true;
mSqlDeal = SqlDeal_.mSelect_;
nSqlHeadstream._runSelect(this);
mValue += @") VALUES (";
mBeg = true;
mSqlDeal = SqlDeal_.mInsert_;
nSqlHeadstream._runSelect(this);
mValue += @") ";
mSqlDeal = SqlDeal_.mWhere_;
nSqlHeadstream._runWhere(this);
mSqlDeal = SqlDeal_.mNone_;
}
public void _runCreate(ISqlHeadstream nSqlHeadstream)
{
mValue += @"CREATE TABLE ";
mValue += mFieldCharacter;
mValue += nSqlHeadstream._tableName();
mValue += mFieldCharacter;
mValue += @"(";
mBeg = true;
mSqlDeal = SqlDeal_.mCreate_;
nSqlHeadstream._runSelect(this);
mBeg = true;
mEnd = false;
mSqlDeal = SqlDeal_.mPrimary_;
nSqlHeadstream._runSelect(this);
if (mEnd)
{
mValue += @")";
}
mValue += @")ENGINE=MYISAM DEFAULT CHARSET=utf8;";
mSqlDeal = SqlDeal_.mNone_;
}