/// <summary> /// +/- blocking /// </summary> /// <param name="nextAction"></param> public void Prepare(Action nextAction = null) { _execState = QueryExecState.Prepare; _queryUsedMode = QueryUseMode.Prepare; if (_cmdParams == null) { throw new Exception("Sql cmdParams can not null."); } //------------------- //blocking method*** //wait until execute finish //------------------- //prepare sql query _sqlParserMx.UsePrepareResponseParser(); _prepareContext = null; //------------------------------------------------------------- _writer.Reset(); ComPrepareStatementPacket.Write( _writer, _sqlStrTemplate.BindValues(_cmdParams, true)); //------------------------------------------------------------- if (nextAction != null) { //not block here SendAndRecv_A(_writer.ToArray(), nextAction); } else { //blocking _conn.InitWait(); SendAndRecv_A(_writer.ToArray(), _conn.UnWait); _conn.Wait(); } }
/// <summary> /// open connection, +/- blocking /// </summary> /// <param name="nextAction"></param> public void Connect(Action nextAction = null) { if (State == ConnectionState.Connected) { throw new NotSupportedException("already connected"); } _mysqlParserMx.UseConnectionParser(); this._workingState = WorkingState.Rest; //-------------- var endpoint = new IPEndPoint(IPAddress.Parse(config.host), config.port); socket.Connect(endpoint); this._workingState = WorkingState.Rest; //-------------- //**start listen after connect InitWait(); StartReceive(mysql_result => { //when complete1 //create handshake packet and send back var handshakeResult = mysql_result as MySqlHandshakeResult; if (handshakeResult == null) { //error throw new Exception("err1"); } HandshakePacket handshake_packet = handshakeResult.packet; this.threadId = handshake_packet.threadId; // https://dev.mysql.com/doc/internals/en/sha256.html byte[] token = string.IsNullOrEmpty(config.password) ? /*1*/ new byte[0] : //Empty passwords are not hashed, but sent as empty string. /* or 2*/ MakeToken(config.password, GetScrollbleBuffer( handshake_packet.scrambleBuff1, handshake_packet.scrambleBuff2)); _writer.IncrementPacketNumber(); //---------------------------- //send authen packet to the server var authPacket = new ClientAuthenticationPacket(new PacketHeader()); authPacket.SetValues(config.user, token, config.database, isProtocol41 = handshake_packet.protocol41); authPacket.WritePacket(_writer); byte[] sendBuff = _writer.ToArray(); _writer.Reset(); //------------------------------------ //switch to result packet parser _mysqlParserMx.SetProtocol41(isProtocol41); _mysqlParserMx.UseResultParser(); //------------------------------------ StartSend(sendBuff, 0, sendBuff.Length, () => { StartReceive(mysql_result2 => { var ok = mysql_result2 as MySqlOkResult; if (ok != null) { this._workingState = WorkingState.Rest; } else { //TODO: review here //error _workingState = WorkingState.Error; } //set max allow of the server *** //todo set max allow packet*** UnWait(); if (nextAction != null) { nextAction(); } }); }); }); if (nextAction == null) { //block .... Wait(); } else { UnWait(); } }