95043049b4
Multi-cloud VM instance database with Cloudflare Workers - Linode, Vultr, AWS connector integration - D1 database with regions, instances, pricing - Query API with filtering, caching, pagination - Cron-based auto-sync (daily + 6-hourly) - Health monitoring endpoint Co-Authored-By: Claude Opus 4.5 <noreply@anthropic.com>
20 lines
610 B
SQL
20 lines
610 B
SQL
-- seed.sql - Initial provider data for cloud-instances-db
|
|
-- Purpose: Insert default provider records for Linode, Vultr, and AWS
|
|
|
|
-- Insert initial provider data
|
|
-- Using INSERT OR IGNORE to prevent duplicates on repeated seeding
|
|
INSERT OR IGNORE INTO providers (name, display_name, api_base_url, sync_status)
|
|
VALUES
|
|
('linode', 'Linode', 'https://api.linode.com/v4', 'pending'),
|
|
('vultr', 'Vultr', 'https://api.vultr.com/v2', 'pending'),
|
|
('aws', 'Amazon Web Services', 'https://ec2.shop', 'pending');
|
|
|
|
-- Verify insertion
|
|
SELECT
|
|
id,
|
|
name,
|
|
display_name,
|
|
sync_status,
|
|
created_at
|
|
FROM providers;
|