backend/com.tecknobit.brownie.services.hostservices.repositories/HostServicesRepository/storeService

store Service

@Modifying(clearAutomatically = true )

@Query(value = "INSERT INTO " + SERVICES_KEY + " (" + IDENTIFIER_KEY + "," + NAME_KEY + "," + STATUS_KEY + "," + INSERTION_DATE_KEY + "," + HOST_IDENTIFIER_KEY + "," + SERVICE_PATH_KEY + ") VALUES (" + ":" + IDENTIFIER_KEY + "," + ":" + NAME_KEY + "," + ":" + STATUS_KEY + "," + ":" + INSERTION_DATE_KEY + "," + ":" + HOST_IDENTIFIER_KEY + "," + ":" + SERVICE_PATH_KEY + ")", nativeQuery = true )

abstract fun storeService(@Param(value = "id") serviceId: String, @Param(value = "name") serviceName: String, @Param(value = "status") status: String, @Param(value = "insertion_date") insertionDate: Long, @Param(value = "host_id") hostId: String, @Param(value = "service_path") servicePath: String)

Query used to store a new service

Parameters

serviceId

The identifier of the service

serviceName

The name of the service

status

The status of the service

insertionDate

The date when the service has been stored

hostId

The identifier of the host owner of the service

servicePath

The path of the service inside the filesystem of the host