TASK_ID=1
SRC_DIR=/home/lipan/massive-cloud/data/pointcloud

# 在容器内创建目录
docker exec massive-point-cloud-app-dev mkdir -p /data/tasks/${TASK_ID}/pointcloud

# 循环复制并写库
for f in ${SRC_DIR}/points*.txt; do
	  name=$(basename "$f")
	    size=$(stat -c%s "$f")

	      echo "复制 $name ($((size/1024/1024)) MB)..."
	        docker cp "$f" massive-point-cloud-app-dev:/data/tasks/${TASK_ID}/pointcloud/${name}

		  docker exec massive-point-cloud-mysql \
			      mysql -u pointcloud -ppointcloud_password pointcloud_db -e \
			          "INSERT IGNORE INTO task_pointcloud_files (taskId, name, fileSize, filePath, createdAt)
		       VALUES (${TASK_ID}, '${name}', ${size}, '/data/tasks/${TASK_ID}/pointcloud/${name}', NOW());"

		         echo "  ✓ 完成"
		 done

		 echo ""
		 echo "=== 验证 ==="
	 docker exec massive-point-cloud-mysql \
		   mysql -u pointcloud -ppointcloud_password pointcloud_db -e \
		     "SELECT id, name, ROUND(fileSize/1024/1024,1) AS size_MB FROM task_pointcloud_files WHERE taskId=${TASK_ID};"