[Dovecot] Updating Database records from a Plugin

[Timo Sirainen]

On Tue, 2010-08-03 at 17:10 +1000, John O'Brien wrote:
> 
> What I want to do from the plugin is the following:
> 
> UPDATE embedded_device SET PIN=pin_value
>         WHERE username=user;
> 
> Questions:
> Is there a way to locate the exiting database open connection?
> Is there a way to use the dovecot sql API to set the value of field? 

How about doing it via dict API? You can use e.g.
dict_set("private/pin", "value") to update the pin. Then configure a
dict sql mapping, something like:

map {
  pattern = priv/pin
  table = quota
  username_field = username
  value_field = pin
}

See quota-dict and expire plugins how to use dict.