Skip to content

CauaCriz/easySQL

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

165 Commits
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

easySQL

Um jeito mais facil de usar SQL no Pawn

native db_create_table(DB:handle, table[]);
native db_drop_table(DB:handle, table[]);
native db_table_exists(DB:handle, table[]);
native db_add_column(DB:handle, table[], name[], type[], length = 11, bool:notnull = false, default[] = "");
native db_column_exists(DB:handle, table[], column[]);
native DBResult:db_pragma_table_info(DB:handle, table[]);
native DBResult:db_select_all(DB:handle, table[], more[] = "");
native db_delete(DB:handle, table[], more[] = "");

 // insert table values
native db_insert_field(DB:handle, table[], column[], value[], id = -1);
native db_insert_field_int(DB:handle, table[], column[], value, id = -1);
native db_insert_field_float(DB:handle, table[], column[], Float:value, id = -1);
 
 // update table values
native db_update_field(DB:handle, table[], column[], value[], more[] = "");
native db_update_field_int(DB:handle, table[], column[], value, more[] = "");
native db_update_field_float(DB:handle, table[], column[], Float:value, more[] = "");
 
 // formatting for 'more' options
native StringColumn(string[], column[], sinal[] = "=");
native DecimalColumn(decimal, column[], sinal[] = "=");
native RealColumn(Float:real, column[], sinal[] = "=");

Nova versao! nao testado.
Nessa versao o objetivo era deixar o mais semelhante possivel com o a_sampdb dessa forma seria mais convidativo a entender essa biblioteca que poucos usam

About

Um jeito mais facil de usar SQL no Pawn

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

 
 
 

Contributors