| 1 | #ifndef __OG_DBI |
|---|
| 2 | #define __OG_DBI |
|---|
| 3 | |
|---|
| 4 | #include <dbi/dbi.h> |
|---|
| 5 | #include <stdbool.h> |
|---|
| 6 | #include <sys/stat.h> |
|---|
| 7 | |
|---|
| 8 | struct og_dbi_config { |
|---|
| 9 | const char *user; |
|---|
| 10 | const char *pass; |
|---|
| 11 | const char *ip; |
|---|
| 12 | const char *port; |
|---|
| 13 | const char *name; |
|---|
| 14 | }; |
|---|
| 15 | |
|---|
| 16 | struct og_dbi { |
|---|
| 17 | dbi_conn conn; |
|---|
| 18 | dbi_inst inst; |
|---|
| 19 | }; |
|---|
| 20 | |
|---|
| 21 | struct og_dbi *og_dbi_open(struct og_dbi_config *config); |
|---|
| 22 | void og_dbi_close(struct og_dbi *db); |
|---|
| 23 | |
|---|
| 24 | #define OG_DB_COMPUTER_NAME_MAXLEN 100 |
|---|
| 25 | #define OG_DB_CENTER_NAME_MAXLEN 100 |
|---|
| 26 | #define OG_DB_ROOM_NAME_MAXLEN 100 |
|---|
| 27 | #define OG_DB_ROOM_LOC_MAXLEN 255 |
|---|
| 28 | #define OG_DB_SERIAL_NUMBER_MAXLEN 25 |
|---|
| 29 | #define OG_DB_IMAGE_DESCRIPTION_MAXLEN 250 |
|---|
| 30 | #define OG_DB_IMAGE_NAME_MAXLEN 50 |
|---|
| 31 | #define OG_DB_FILESYSTEM_MAXLEN 16 |
|---|
| 32 | #define OG_DB_NETDRIVER_MAXLEN 30 |
|---|
| 33 | #define OG_DB_NETIFACE_MAXLEN 4 |
|---|
| 34 | #define OG_DB_LIVEDIR_MAXLEN 50 |
|---|
| 35 | #define OG_DB_INT8_MAXLEN 8 |
|---|
| 36 | #define OG_DB_BOOT_MAXLEN 30 |
|---|
| 37 | #define OG_DB_INT_MAXLEN 11 |
|---|
| 38 | #define OG_DB_MAC_MAXLEN 15 |
|---|
| 39 | #define OG_DB_IP_MAXLEN 15 |
|---|
| 40 | #define OG_DB_SMALLINT_MAXLEN 6 |
|---|
| 41 | |
|---|
| 42 | struct og_image_legacy { |
|---|
| 43 | char software_id[OG_DB_INT_MAXLEN + 1]; |
|---|
| 44 | char image_id[OG_DB_INT_MAXLEN + 1]; |
|---|
| 45 | char name[OG_DB_IMAGE_NAME_MAXLEN + 1]; |
|---|
| 46 | char repo[OG_DB_IP_MAXLEN + 1]; |
|---|
| 47 | char part[OG_DB_SMALLINT_MAXLEN + 1]; |
|---|
| 48 | char disk[OG_DB_SMALLINT_MAXLEN + 1]; |
|---|
| 49 | char code[OG_DB_INT8_MAXLEN + 1]; |
|---|
| 50 | }; |
|---|
| 51 | |
|---|
| 52 | struct og_image { |
|---|
| 53 | char name[OG_DB_IMAGE_NAME_MAXLEN + 1]; |
|---|
| 54 | char description[OG_DB_IMAGE_DESCRIPTION_MAXLEN + 1]; |
|---|
| 55 | uint64_t software_id; |
|---|
| 56 | uint64_t center_id; |
|---|
| 57 | uint64_t datasize; |
|---|
| 58 | uint64_t group_id; |
|---|
| 59 | uint64_t type; |
|---|
| 60 | uint64_t id; |
|---|
| 61 | struct stat image_stats; |
|---|
| 62 | }; |
|---|
| 63 | |
|---|
| 64 | struct og_legacy_partition { |
|---|
| 65 | char partition[OG_DB_SMALLINT_MAXLEN + 1]; |
|---|
| 66 | char code[OG_DB_INT8_MAXLEN + 1]; |
|---|
| 67 | char size[OG_DB_INT_MAXLEN + 1]; |
|---|
| 68 | char filesystem[OG_DB_FILESYSTEM_MAXLEN + 1]; |
|---|
| 69 | char format[2]; /* Format is a boolean 0 or 1 => length is 2 */ |
|---|
| 70 | }; |
|---|
| 71 | |
|---|
| 72 | struct og_computer { |
|---|
| 73 | unsigned int procedure_id; |
|---|
| 74 | unsigned int hardware_id; |
|---|
| 75 | unsigned int repo_id; |
|---|
| 76 | unsigned int center; |
|---|
| 77 | unsigned int room; |
|---|
| 78 | unsigned int id; |
|---|
| 79 | bool maintenance; |
|---|
| 80 | bool remote; |
|---|
| 81 | char serial_number[OG_DB_SERIAL_NUMBER_MAXLEN + 1]; |
|---|
| 82 | char netdriver[OG_DB_NETDRIVER_MAXLEN + 1]; |
|---|
| 83 | char name[OG_DB_COMPUTER_NAME_MAXLEN + 1]; |
|---|
| 84 | char netiface[OG_DB_NETIFACE_MAXLEN + 1]; |
|---|
| 85 | char livedir[OG_DB_LIVEDIR_MAXLEN + 1]; |
|---|
| 86 | char netmask[OG_DB_IP_MAXLEN + 1]; |
|---|
| 87 | char boot[OG_DB_BOOT_MAXLEN + 1]; |
|---|
| 88 | char mac[OG_DB_MAC_MAXLEN + 1]; |
|---|
| 89 | char ip[OG_DB_IP_MAXLEN + 1]; |
|---|
| 90 | }; |
|---|
| 91 | |
|---|
| 92 | struct og_room { |
|---|
| 93 | uint32_t center; |
|---|
| 94 | uint32_t group; |
|---|
| 95 | char location[OG_DB_ROOM_LOC_MAXLEN + 1]; |
|---|
| 96 | char name[OG_DB_ROOM_NAME_MAXLEN + 1]; |
|---|
| 97 | char gateway[OG_DB_IP_MAXLEN + 1]; |
|---|
| 98 | char netmask[OG_DB_IP_MAXLEN + 1]; |
|---|
| 99 | char ntp[OG_DB_IP_MAXLEN + 1]; |
|---|
| 100 | char dns[OG_DB_IP_MAXLEN + 1]; |
|---|
| 101 | bool remote; |
|---|
| 102 | }; |
|---|
| 103 | |
|---|
| 104 | struct in_addr; |
|---|
| 105 | int og_dbi_get_computer_info(struct og_dbi *dbi, struct og_computer *computer, |
|---|
| 106 | struct in_addr addr); |
|---|
| 107 | int og_dbi_add_image(struct og_dbi *dbi, const struct og_image *image); |
|---|
| 108 | |
|---|
| 109 | int og_dbi_schema_update(void); |
|---|
| 110 | |
|---|
| 111 | #endif |
|---|
