[Alon2k2]

Hi,

I wanted to ask if there are transactions in sqlx?

And where are there examples because I couldn't find it on Google.

[Bugsy]

Not sure what you mean by “transactions in sqlx ”

If you’re asking if you can execute SQL statements in sqlx , yes.

[Alon2k2]

Originally Posted by Bugsy Not sure what you mean by “transactions in sqlx ” If you’re asking if you can execute SQL statements in sqlx , yes.

In SourceMod there is SQL_CreateTransaction and SQL_ExecuteTransaction functions
Is there something similar in amxmodx?

[Bugsy]

If you want to execute something immediately, use SQL_Execute().
Example use-case would be a player connected and you need his data immediately.

To avoid interrupting gameplay due to poor/slow connection with the DB and you do not care if the transaction is not executed immediately, use SQL_ThreadQuery().
Example use-case is a player is disconnecting and you want to save his data - timing does not matter for this.

[Alon2k2]

Originally Posted by Bugsy If you want to execute something immediately, use SQL_Execute(). Example use-case would be a player connected and you need his data immediately. To avoid interrupting gameplay due to poor/slow connection with the DB and you do not care if the transaction is not executed immediately, use SQL_ThreadQuery(). Example use-case is a player is disconnecting and you want to save his data - timing does not matter for this.

What happens for example if I want to make 2 updates in the database, for example points taken from player A to player B this means I have to take points from one record and add it to another record,
This means I have to make sure both updates are happened.

Did you figure out the problem?

[Bugsy]

Originally Posted by Alon2k2 What happens for example if I want to make 2 updates in the database, for example points taken from player A to player B this means I have to take points from one record and add it to another record, This means I have to make sure both updates are happened. Did you figure out the problem?

2 transactions

UPDATE tblPoints SET Points=(current points - 1) WHERE ID=PlayerA
UPDATE tblPoints SET Points=(current points + 1) WHERE ID=PlayerB

[Alon2k2]

Originally Posted by Bugsy 2 transactions UPDATE tblPoints SET Points=(current points - 1) WHERE ID=PlayerA UPDATE tblPoints SET Points=(current points + 1) WHERE ID=PlayerB

Exactly what you wrote, there is a mechanism that makes sure that both happen?

If the first succeeds and the second fails it is not good

[Bugsy]

I wouldn’t worry about a transaction failing, assuming you write your sql statements correctly.

[damage220]

Bugsy,
There are situations where you need, for example, to get primary key of the newly created row and if something goes wrong you can rollback any changes made to the database. These are called transactions and it has nothing to do with errors in SQL syntax but rather the logic of the program.

Alon2k2,
There are no such functions in the API. I was too disappointed when discovered this.

[Alon2k2]

Originally Posted by damage220 Bugsy, There are situations where you need, for example, to get primary key of the newly created row and if something goes wrong you can rollback any changes made to the database. These are called transactions and it has nothing to do with errors in SQL syntax but rather the logic of the program. Alon2k2, There are no such functions in the API. I was too disappointed when discovered this.

Thank you, Too bad there isn't, is something very important when working with database