Re: [PATCH v1 2/2] daemon: telegram: Handle MySQL error

[Muhammad Rizki <kiizuha@gnuweeb.org>]

On 29/10/22 01.15, Muhammad Rizki wrote:
> 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. 🤔

Anyway, I've ever wanted to refactor the DB using the SQLAlchemy and 
want to implement the clean-arch method too, but, IDK when to do that, 
maybe I could just re-create the daemon in my local and make the version 
2 of it.