| 1 | import { relations } from "drizzle-orm"; |
| 2 | import { user } |
| 3 | import { locations } |
| 4 | import { nodes } |
| 5 | import { nodeAllocations } |
| 6 | import { nests } |
| 7 | import { eggs } |
| 8 | import { eggVariables } |
| 9 | import { databaseHosts } |
| 10 | import { servers } |
| 11 | import { serverVariables } |
| 12 | import { mounts } |
| 13 | import { serverMounts } |
| 14 | import { serverDatabases } |
| 15 | import { backups } |
| 16 | import { schedules, scheduleTasks |
| 17 | import { subusers } |
| 18 | import { activityLogs } |
| 19 | import { servers as |
| 20 | import { nodes as |
| 21 | import { billingSubscriptions } |
| 22 | export const locationsRelations = |
| 23 | nodes: many(nodes |
| 24 | })); |
| 25 | |
| 26 | export const nodesRelations = |
| 27 | location: one(locations |
| 28 | fields: [nodes.locationId |
| 29 | references: [locations.id |
| 30 | }), |
| 31 | allocations: many(nodeAllocations |
| 32 | servers: many(servers |
| 33 | })); |
| 34 | |
| 35 | export const nodeAllocationsRelations = |
| 36 | nodeAllocations, |
| 37 | ({ one }) |
| 38 | node: one(nodes |
| 39 | fields: [nodeAllocations.nodeId |
| 40 | references: [nodes.id |
| 41 | }), |
| 42 | }), |
| 43 | ); |
| 44 | |
| 45 | export const nestsRelations = |
| 46 | eggs: many(eggs |
| 47 | })); |
| 48 | |
| 49 | export const eggsRelations = |
| 50 | nest: one(nests |
| 51 | fields: [eggs.nestId |
| 52 | references: [nests.id |
| 53 | }), |
| 54 | variables: many(eggVariables |
| 55 | servers: many(servers |
| 56 | })); |
| 57 | |
| 58 | export const eggVariablesRelations = |
| 59 | egg: one(eggs |
| 60 | fields: [eggVariables.eggId |
| 61 | references: [eggs.id |
| 62 | }), |
| 63 | })); |
| 64 | |
| 65 | export const databaseHostsRelations = |
| 66 | serverDatabases: many(serverDatabases |
| 67 | })); |
| 68 | |
| 69 | export const serversRelations = |
| 70 | user: one(user |
| 71 | fields: [servers.userId |
| 72 | references: [user.id |
| 73 | }), |
| 74 | node: one(nodes |
| 75 | fields: [servers.nodeId |
| 76 | references: [nodes.id |
| 77 | }), |
| 78 | egg: one(eggs |
| 79 | fields: [servers.eggId |
| 80 | references: [eggs.id |
| 81 | }), |
| 82 | allocation: one(nodeAllocations |
| 83 | fields: [servers.allocationId |
| 84 | references: [nodeAllocations.id |
| 85 | }), |
| 86 | subscription: one(billingSubscriptions |
| 87 | fields: [servers.subscriptionId |
| 88 | references: [billingSubscriptions.id |
| 89 | }), |
| 90 | variables: many(serverVariables |
| 91 | databases: many(serverDatabases |
| 92 | backups: many(backups |
| 93 | schedules: many(schedules |
| 94 | subusers: many(subusers |
| 95 | mounts: many(serverMounts |
| 96 | })); |
| 97 | |
| 98 | export const serverVariablesRelations = |
| 99 | server: one(servers |
| 100 | fields: [serverVariables.serverId |
| 101 | references: [servers.id |
| 102 | }), |
| 103 | variable: one(eggVariables |
| 104 | fields: [serverVariables.variableId |
| 105 | references: [eggVariables.id |
| 106 | }), |
| 107 | })); |
| 108 | |
| 109 | export const mountsRelations = |
| 110 | servers: many(serverMounts |
| 111 | })); |
| 112 | |
| 113 | export const serverMountsRelations = |
| 114 | server: one(servers |
| 115 | fields: [serverMounts.serverId |
| 116 | references: [servers.id |
| 117 | }), |
| 118 | mount: one(mounts |
| 119 | fields: [serverMounts.mountId |
| 120 | references: [mounts.id |
| 121 | }), |
| 122 | })); |
| 123 | |
| 124 | export const serverDatabasesRelations = |
| 125 | server: one(servers |
| 126 | fields: [serverDatabases.serverId |
| 127 | references: [servers.id |
| 128 | }), |
| 129 | host: one(databaseHosts |
| 130 | fields: [serverDatabases.hostId |
| 131 | references: [databaseHosts.id |
| 132 | }), |
| 133 | })); |
| 134 | |
| 135 | export const backupsRelations = |
| 136 | server: one(servers |
| 137 | fields: [backups.serverId |
| 138 | references: [servers.id |
| 139 | }), |
| 140 | })); |
| 141 | |
| 142 | export const schedulesRelations = |
| 143 | server: one(servers |
| 144 | fields: [schedules.serverId |
| 145 | references: [servers.id |
| 146 | }), |
| 147 | tasks: many(scheduleTasks |
| 148 | })); |
| 149 | |
| 150 | export const scheduleTasksRelations = |
| 151 | schedule: one(schedules |
| 152 | fields: [scheduleTasks.scheduleId |
| 153 | references: [schedules.id |
| 154 | }), |
| 155 | })); |
| 156 | |
| 157 | export const subusersRelations = |
| 158 | user: one(user |
| 159 | fields: [subusers.userId |
| 160 | references: [user.id |
| 161 | }), |
| 162 | server: one(servers |
| 163 | fields: [subusers.serverId |
| 164 | references: [servers.id |
| 165 | }), |
| 166 | })); |
| 167 | |
| 168 | export const userExtendedRelations = |
| 169 | servers: many(servers |
| 170 | subusers: many(subusers |
| 171 | activityLogs: many(activityLogs |
| 172 | })); |
| 173 | |
| 174 | export const activityLogsRelations = |
| 175 | user: one(user |
| 176 | fields: [activityLogs.userId |
| 177 | references: [user.id |
| 178 | }), |
| 179 | server: one(serversTable |
| 180 | fields: [activityLogs.serverId |
| 181 | references: [serversTable.id |
| 182 | }), |
| 183 | node: one(nodesTable |
| 184 | fields: [activityLogs.nodeId |
| 185 | references: [nodesTable.id |
| 186 | }), |
| 187 | })); |
| 188 | |