284313f908
Some checks are pending
Bidi Control Character Guard / bidi-control-guard (push) Waiting to run
Circular Dependency Check / Check for new circular dependencies (push) Waiting to run
Citus Migration Smoke / Combined migrations on single-node Citus (push) Waiting to run
E2E Fresh Install Tests / fresh-install-e2e (push) Waiting to run
ext-v2 guardrails / Run ext-v2 guard and ESLint (push) Waiting to run
Integration Tests / Check for relevant changes (push) Waiting to run
Integration Tests / ${{ (github.event_name == 'schedule' || github.event.inputs.suite == 'full') && 'Full integration suite' || 'Tier-1 integration subset' }} (push) Blocked by required conditions
Mobile checks / Mobile lint + typecheck (push) Waiting to run
Mobile checks / Mobile unit tests (push) Waiting to run
Mobile checks / Mobile dependency audit (report) (push) Waiting to run
Mobile checks / Mobile reproducibility checks (push) Waiting to run
Secrets guard (env backups) / Ensure no tracked env backup files (push) Waiting to run
Temporal Readiness / fast-readiness (push) Waiting to run
Temporal Readiness / docker-parity (push) Waiting to run
TypeScript Type Check / Nx affected typecheck (push) Waiting to run
Unit Tests / Skipped-test budget (push) Waiting to run
Unit Tests / Nx affected unit tests (push) Waiting to run
Unit Tests / Server unit coverage (informational) (push) Waiting to run
Validate Tenant Management Schema / Check for relevant changes (push) Waiting to run
Validate Tenant Management Schema / Validate Tenant Management Schema (push) Blocked by required conditions
EE Workflows Build Guard / ee-workflows-build-guard (push) Waiting to run
Excluded: .git, node_modules, secrets/, compose.env, assemblyscript tgz Source: /opt/alga-psa on psa.joliet.tech
215 lines
8.1 KiB
JavaScript
215 lines
8.1 KiB
JavaScript
exports.seed = async function(knex) {
|
|
// First delete from extension tables
|
|
await knex('workstation_assets').del();
|
|
await knex('server_assets').del();
|
|
await knex('network_device_assets').del();
|
|
await knex('assets').del();
|
|
|
|
const [tenant, clients] = await Promise.all([
|
|
knex('tenants').select('tenant').first(),
|
|
knex('clients').select('client_id', 'client_name')
|
|
]);
|
|
|
|
if (tenant) {
|
|
const emeraldCity = clients.find(c => c.client_name === 'Emerald City');
|
|
const wonderland = clients.find(c => c.client_name === 'Wonderland');
|
|
const now = new Date().toISOString();
|
|
|
|
// Create purchase and warranty dates
|
|
const purchaseDate1 = new Date('2023-01-15').toISOString();
|
|
const warrantyDate1 = new Date('2026-01-15').toISOString();
|
|
const purchaseDate2 = new Date('2023-03-20').toISOString();
|
|
const warrantyDate2 = new Date('2026-03-20').toISOString();
|
|
const purchaseDate3 = new Date('2023-02-10').toISOString();
|
|
const warrantyDate3 = new Date('2026-02-10').toISOString();
|
|
const purchaseDate4 = new Date('2023-04-01').toISOString();
|
|
const warrantyDate4 = new Date('2026-04-01').toISOString();
|
|
const purchaseDate5 = new Date('2023-05-15').toISOString();
|
|
const warrantyDate5 = new Date('2026-05-15').toISOString();
|
|
|
|
// Insert base assets first
|
|
const assets = [
|
|
// Emerald City Assets
|
|
{
|
|
tenant: tenant.tenant,
|
|
asset_id: '11111111-1111-1111-1111-111111111111',
|
|
asset_type: 'server',
|
|
client_id: emeraldCity.client_id,
|
|
asset_tag: 'EC-SRV-001',
|
|
serial_number: 'RS789012',
|
|
name: 'Ruby Slippers Server',
|
|
status: 'active',
|
|
location: 'Main Data Center',
|
|
purchase_date: purchaseDate1,
|
|
warranty_end_date: warrantyDate1,
|
|
created_at: now,
|
|
updated_at: now
|
|
},
|
|
{
|
|
tenant: tenant.tenant,
|
|
asset_id: '22222222-2222-2222-2222-222222222222',
|
|
asset_type: 'workstation',
|
|
client_id: emeraldCity.client_id,
|
|
asset_tag: 'EC-WS-001',
|
|
serial_number: 'CB456789',
|
|
name: 'Crystal Ball Workstation',
|
|
status: 'active',
|
|
location: 'Wizard\'s Chamber',
|
|
purchase_date: purchaseDate2,
|
|
warranty_end_date: warrantyDate2,
|
|
created_at: now,
|
|
updated_at: now
|
|
},
|
|
{
|
|
tenant: tenant.tenant,
|
|
asset_id: '33333333-3333-3333-3333-333333333333',
|
|
asset_type: 'network_device',
|
|
client_id: emeraldCity.client_id,
|
|
asset_tag: 'EC-NSW-001',
|
|
serial_number: 'YB123456',
|
|
name: 'Yellow Brick Switch',
|
|
status: 'active',
|
|
location: 'Network Room',
|
|
purchase_date: purchaseDate3,
|
|
warranty_end_date: warrantyDate3,
|
|
created_at: now,
|
|
updated_at: now
|
|
},
|
|
// Wonderland Assets
|
|
{
|
|
tenant: tenant.tenant,
|
|
asset_id: '44444444-4444-4444-4444-444444444444',
|
|
asset_type: 'server',
|
|
client_id: wonderland.client_id,
|
|
asset_tag: 'WL-SRV-001',
|
|
serial_number: 'TT987654',
|
|
name: 'Mad Hatter Tea Time Server',
|
|
status: 'active',
|
|
location: 'Tea Party Data Center',
|
|
purchase_date: purchaseDate4,
|
|
warranty_end_date: warrantyDate4,
|
|
created_at: now,
|
|
updated_at: now
|
|
},
|
|
{
|
|
tenant: tenant.tenant,
|
|
asset_id: '55555555-5555-5555-5555-555555555555',
|
|
asset_type: 'workstation',
|
|
client_id: wonderland.client_id,
|
|
asset_tag: 'WL-WS-001',
|
|
serial_number: 'LG789123',
|
|
name: 'Looking Glass Workstation',
|
|
status: 'active',
|
|
location: 'Queen\'s Court',
|
|
purchase_date: purchaseDate5,
|
|
warranty_end_date: warrantyDate5,
|
|
created_at: now,
|
|
updated_at: now
|
|
}
|
|
];
|
|
|
|
await knex('assets').insert(assets);
|
|
|
|
// Insert server assets
|
|
const serverAssets = [
|
|
{
|
|
tenant: tenant.tenant,
|
|
asset_id: '11111111-1111-1111-1111-111111111111',
|
|
os_type: 'Linux',
|
|
os_version: 'Ubuntu 22.04 LTS',
|
|
cpu_model: 'Oz EPYC',
|
|
cpu_cores: 64,
|
|
ram_gb: 512,
|
|
storage_config: JSON.stringify([
|
|
{ type: 'SSD', capacity_gb: 48000 }
|
|
]),
|
|
raid_config: 'RAID 10',
|
|
is_virtual: false,
|
|
network_interfaces: JSON.stringify([
|
|
{ name: 'eth0', speed: '10Gbps' }
|
|
]),
|
|
primary_ip: '10.0.1.10',
|
|
installed_services: JSON.stringify(['nginx', 'postgresql'])
|
|
},
|
|
{
|
|
tenant: tenant.tenant,
|
|
asset_id: '44444444-4444-4444-4444-444444444444',
|
|
os_type: 'Linux',
|
|
os_version: 'Red Hat 8',
|
|
cpu_model: 'Wonderland EPYC',
|
|
cpu_cores: 32,
|
|
ram_gb: 256,
|
|
storage_config: JSON.stringify([
|
|
{ type: 'SSD', capacity_gb: 24000 }
|
|
]),
|
|
raid_config: 'RAID 5',
|
|
is_virtual: false,
|
|
network_interfaces: JSON.stringify([
|
|
{ name: 'eth0', speed: '10Gbps' }
|
|
]),
|
|
primary_ip: '10.0.2.10',
|
|
installed_services: JSON.stringify(['apache', 'mysql'])
|
|
}
|
|
];
|
|
|
|
// Insert workstation assets
|
|
const workstationAssets = [
|
|
{
|
|
tenant: tenant.tenant,
|
|
asset_id: '22222222-2222-2222-2222-222222222222',
|
|
os_type: 'Windows',
|
|
os_version: 'Windows 11 Pro',
|
|
cpu_model: 'Emerald i9',
|
|
cpu_cores: 16,
|
|
ram_gb: 64,
|
|
storage_type: 'NVMe SSD',
|
|
storage_capacity_gb: 2000,
|
|
gpu_model: 'Oz RTX 4090',
|
|
installed_software: JSON.stringify(['Adobe Creative Suite', 'AutoCAD'])
|
|
},
|
|
{
|
|
tenant: tenant.tenant,
|
|
asset_id: '55555555-5555-5555-5555-555555555555',
|
|
os_type: 'Windows',
|
|
os_version: 'Windows 11 Pro',
|
|
cpu_model: 'Cheshire i7',
|
|
cpu_cores: 8,
|
|
ram_gb: 32,
|
|
storage_type: 'NVMe SSD',
|
|
storage_capacity_gb: 1000,
|
|
gpu_model: 'Wonderland RTX 3080',
|
|
installed_software: JSON.stringify(['Office 365', 'Photoshop'])
|
|
}
|
|
];
|
|
|
|
// Insert network device assets
|
|
const networkDeviceAssets = [
|
|
{
|
|
tenant: tenant.tenant,
|
|
asset_id: '33333333-3333-3333-3333-333333333333',
|
|
device_type: 'switch',
|
|
management_ip: '10.0.1.100',
|
|
port_count: 48,
|
|
firmware_version: '2.3.4',
|
|
supports_poe: true,
|
|
power_draw_watts: 150,
|
|
vlan_config: JSON.stringify({
|
|
'1': 'Management',
|
|
'10': 'Users',
|
|
'20': 'Servers'
|
|
}),
|
|
port_config: JSON.stringify({
|
|
'speed': '100Gbps',
|
|
'duplex': 'full'
|
|
})
|
|
}
|
|
];
|
|
|
|
await Promise.all([
|
|
knex('server_assets').insert(serverAssets),
|
|
knex('workstation_assets').insert(workstationAssets),
|
|
knex('network_device_assets').insert(networkDeviceAssets)
|
|
]);
|
|
}
|
|
};
|