-
Notifications
You must be signed in to change notification settings - Fork 0
/
query_funcs.h
36 lines (24 loc) · 1.06 KB
/
query_funcs.h
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
#include <stdio.h>
#include <my_global.h> //includes some global function declarations
#include <mysql.h> //includes mysql function
#ifndef _QUERY_FUNCS_
#define _QUERY_FUNCS_
void exit_with_error(MYSQL *conn);
void add_player(MYSQL *conn, int team_id, int jersey_num, char *first_name, char *last_name,
int mpg, int ppg, int rpg, int apg, double spg, double bpg);
void add_team(MYSQL *conn, char *name, int state_id, int color_id, int wins, int losses);
void add_state(MYSQL *conn, char *name);
void add_color(MYSQL *conn, char *name);
void query1(MYSQL *conn,
int use_mpg, int min_mpg, int max_mpg,
int use_ppg, int min_ppg, int max_ppg,
int use_rpg, int min_rpg, int max_rpg,
int use_apg, int min_apg, int max_apg,
int use_spg, double min_spg, double max_spg,
int use_bpg, double min_bpg, double max_bpg
);
void query2(MYSQL *conn, char *team_color);
void query3(MYSQL *conn, char *team_name);
void query4(MYSQL *conn, char *team_state, char *team_color);
void query5(MYSQL *conn, int num_wins);
#endif //_QUERY_FUNCS_