update

vault update <key> <value>

Updating key: api_key with the value: sk-new-token-9876543210 in the vault

Key: missing_key does not exist in db

# Add a key
vault add version "1.0.0"

# Update it
vault update version "1.1.0"
# Output: Updating key: version with the value: 1.1.0 in the vault

# Verify the update
vault get version
# Output: 1.1.0

# Try to update non-existent key
vault update nonexistent "value"
# Output: Key: nonexistent does not exist in db

UPDATE store
SET value = $value
WHERE key = $key

public int Update(string key, string value)
{
    using var command = connection.CreateCommand();
    command.CommandText = """
        UPDATE store
        SET value = $value
        WHERE key = $key
        """;
    command.Parameters.AddWithValue("$key", key);
    command.Parameters.AddWithValue("$value", value);
    int rowsAffected = command.ExecuteNonQuery();
    if (rowsAffected == 0)
    {
        Console.WriteLine($"Key: {key} does not exist in db");
        return 0;
    }
    Console.WriteLine($"Updating key: {key} with the value: {value} in the vault");
    return 0;
}

case "update":
    if (args.Length == 2)
    {
        return Command.UPDATE;
    }