Skip to content

Latest commit

 

History

History
32 lines (29 loc) · 1.42 KB

README.md

File metadata and controls

32 lines (29 loc) · 1.42 KB

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