[Library] pawn-plus-mysql: PawnPlus extensions and helpers for the MySQL plugin

[Graber]

pawn-plus-mysql







PawnPlus extensions and helpers for the MySQL plugin



Installation



Simply install to your project:

Code:

sampctl package install AGraber/pawn-plus-mysql

Include in your code and begin using the library:

Code:

#include <pp-mysql>

It is recommended that you set a PawnPlus version explicitely on your pawn.json (preferibly the latest) to avoid always downloading the latest one.



If you don?t use sampctl, just download the pp-mysql.inc include and drop it to your includes/ folder, and then download the PawnPlus plugin and include from here.



While you?re on it and if you don?t use PawnPlus yet, you should check it out!



Usage



All existing mysql_[t/p]query now have a variant that accepts PawnPlus strings, ending with _s (for example, mysql_tquery_s).



In addition, a new member arrives into the family of these natives: mysql_aquery[_s], which returns a task that will be set as completed when the query completes successfully, or fault when there?s an error during its execution.



Note that mysql_aquery[_s] will piggyback on mysql_tquery by default. You can override this and use mysql_tquery by setting the parallel parameter at the end to true, or explicitly change this default value by defining MYSQL_ASYNC_DEFAULT_PARALLEL to you desired value.



Examples



Using PawnPlus strings on natives

PHP Code:

public OnPlayerTookAllCandies(playerid)

{

? ?mysql_tquery_s(DatabaseHandle, @("UPDATE player SET took_candies = UNIX_TIMESTAMP() WHERE id = ") % GetPlayerDBID(playerid));

} 


Task-based asynchronous queries:

PHP Code:

LoadPlayerData(playerid)

{

? ?await mysql_aquery_s(DatabaseHandle, @("SELECT * FROM player WHERE id = ") % GetPlayerDBID(playerid), .parallel = false);

? ?// Cache functions will be available after this

? ?cache_get_value_name_float(0, "health", PlayerHealth[playerid]);

? ?// ...

} 


[#Fede]

Very useful!

[TommyB]

another incredible revolution in the pawner world

[Toretto]

I was waiting for this, thought it was just a joke or an idea when it was being discussed on discord. I will be using pawn plus from now on, see if I can get used to it. Thanks for the release Graber.

[Y_Less]

I know pawn-plus uses this naming scheme, but please don't copy it. One thing we want to do with open.mp is promote consistency in naming schemes and styles. The argument used with pawn-plus was that the core library is inconsistent, so why can't that also be inconsistent (in a different way)? We intend to fix the core library.

[kristo]

I know pawn-plus uses this naming scheme, but please don't copy it. One thing we want to do with open.mp is promote consistency in naming schemes and styles. The argument used with pawn-plus was that the core library is inconsistent, so why can't that also be inconsistent (in a different way)? We intend to fix the core library.

Actually I think it follows the naming scheme of the MySQL plugin.

[JustMichael]

It's about time, I've been nagging you forever uwu



Best include, very much love ;)

[Graber]

I know pawn-plus uses this naming scheme, but please don't copy it. One thing we want to do with open.mp is promote consistency in naming schemes and styles. The argument used with pawn-plus was that the core library is inconsistent, so why can't that also be inconsistent (in a different way)? We intend to fix the core library.

Actually I think it follows the naming scheme of the MySQL plugin.

It comes from both mysql (the function base name) and also PawnPlus (the _s part). I was trying to make it consistent with those, although they are not consistent. What do you recommend instead?

[DonutXD]

not work with pawnplus 1.2