package impl

const (
	InsertResourceSQL = `
	INSERT INTO resource (
		id,
		vendor,
		region,
		create_at,
		expire_at,
		type,
		name,
		description,
		status,
		update_at,
		sync_at,
		accout,
		public_ip,
		private_ip
	)
	VALUES
		(?,?,?,?,?,?,?,?,?,?,?,?,?,?);
	`

	// INSERT INTO `host` ( resource_id, cpu, memory, gpu_amount, gpu_spec, os_type, os_name, serial_number )
	// VALUES
	// ( "111", 1, 2048, 1, 'n', 'linux', 'centos8', '00000' );
	InsertDescribeSQL = `
	INSERT INTO host ( resource_id, cpu, memory, gpu_amount, gpu_spec, os_type, os_name, serial_number )
	VALUES
		( ?,?,?,?,?,?,?,? );
	`

	queryHostSQL = `SELECT r.id, r.name, r.description  FROM resource as r LEFT JOIN host h ON r.id=h.resource_id`

	queryHostAllSQL = `SELECT r.*, h.cpu, h.memory, h.gpu_amount, h.gpu_spec, h.os_type, h.os_name, h.serial_number  FROM resource as r LEFT JOIN host h ON r.id=h.resource_id`

	updateHostResourceSQL = `UPDATE resource SET vendor=?,region=?,expire_at=?,name=?,description=? WHERE id = ?`

	updateHostDescribeSQL = `UPDATE host SET cpu=?,memory=? WHERE resource_id = ?`
)