From mboxrd@z Thu Jan  1 00:00:00 1970
Return-Path: <kiizuha@gnuweeb.org>
X-Spam-Checker-Version: SpamAssassin 3.4.6 (2021-04-09) on gnuweeb.org
X-Spam-Level: 
X-Spam-Status: No, score=-1.8 required=5.0 tests=ALL_TRUSTED,DKIM_SIGNED,
	DKIM_VALID,DKIM_VALID_AU,DKIM_VALID_EF,NICE_REPLY_A,NO_DNS_FOR_FROM,
	URIBL_BLOCKED autolearn=ham autolearn_force=no version=3.4.6
Received: from [192.168.1.2] (unknown [101.128.126.183])
	by gnuweeb.org (Postfix) with ESMTPSA id 8E00A804FD;
	Fri, 28 Oct 2022 18:15:18 +0000 (UTC)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=gnuweeb.org;
	s=default; t=1666980919;
	bh=lCDASi9oSyBQRUbyHuFDA8ftp3W2rwc5O3H7sa6Grp8=;
	h=Date:Subject:To:Cc:References:From:In-Reply-To:From;
	b=Kqlz+P3SuKTLmidqWpKkIMk3Kce2hyL8hJmmbBEAGHMuiDVjBb3NQUg2Qlu4vxJDu
	 avtLUbVLBUyVLbxgnfrU7ruMSpuwwAmq6DhIzdXqEd2ZRF54dJzp5NbPbus4uMN81h
	 pEHbf97lAv7j9X85MsQzV4lHVTgQwzVAwYuty0y8ilfvOJcPIMEeo0KtFhR5QKVyqW
	 GcBdyC1l7riGI/zVDUYyDya+WXxolJGhYO9BvbI07P5coOuSIb6WRqqEUrDPQ67pAU
	 ivue4xSZhAhAarXGmPaXP4FxLtYPzN80xq7ohg7xH9oWXh65hwWm/7PSFBl8qXSetf
	 wJEiBmMpf4nYw==
Message-ID: <67f786d9-f5b8-5e4a-3944-260483db1c6b@gnuweeb.org>
Date: Sat, 29 Oct 2022 01:15:15 +0700
MIME-Version: 1.0
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:102.0) Gecko/20100101
 Thunderbird/102.2.2
Subject: Re: [PATCH v1 2/2] daemon: telegram: Handle MySQL error
Content-Language: en-US
To: Ammar Faizi <ammarfaizi2@gnuweeb.org>
Cc: Alviro Iskandar Setiawan <alviro.iskandar@gnuweeb.org>,
 GNU/Weeb Mailing List <gwml@vger.gnuweeb.org>
References: <20221027150823.601914-1-ammarfaizi2@gnuweeb.org>
 <20221027150823.601914-3-ammarfaizi2@gnuweeb.org>
 <CAOG64qN9BZcnz1px8tAj9_Y96FhU1nVMOA58rfs-4nRY6GhWAg@mail.gmail.com>
 <1d500d37-b11b-75fd-38e5-d7f8e0a9b1d4@gnuweeb.org>
 <CAOG64qO8c4gE=HmL-1QQkqenD+T4ezsU=+FCGsth59=CFjyKpw@mail.gmail.com>
 <3a79a587-ddee-9e25-2ac5-b573938b44a9@gnuweeb.org>
 <043f55c3-67d8-9130-aca4-73c59926d2af@gnuweeb.org>
 <6aed0245-5156-7983-f4be-faf4d6cd7a13@gnuweeb.org>
 <CAFBCWQLcnqhJMJ7jr88dB01mm7a_1Kv98Lni=m9KnuHTSkJm7A@mail.gmail.com>
From: Muhammad Rizki <kiizuha@gnuweeb.org>
In-Reply-To: <CAFBCWQLcnqhJMJ7jr88dB01mm7a_1Kv98Lni=m9KnuHTSkJm7A@mail.gmail.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit
List-Id: <gwml.vger.gnuweeb.org>

On 29/10/22 00.19, Ammar Faizi wrote:
>
> For example:
>    begin_transaction()
>    insert_a  -> this is a success
>    insert_b  -> this is a success
>    insert_c  -> this is a fail, goto rollback
>    commit() -> this doesn't happen
> 
> rollback:
>    rollback() // insert_a and insert_b are undone.

This pseudo-code seems like C style. Anyway, the rollback() is from the 
MySQL function?

> 
> Those 3 inserts are atomic and consistent. If one fails, all
> operations must also fail. No half-insert, no unisolated select, no
> missing cleanup, no temp file not deleted due to error in the middle
> operation, etc.
> 

This is a little bit confused me to implement it. 🤔