NAME

WebSource::DB : For each input execute a query and return the result as output

DESCRIPTION

A DB operator allows to execute a parameterized SQL query for each input. This allows, for example, to populate a database with extracted data.

A typical DB operator declaration is as follows :

  <ws:database name="db" forward-to="format">
    <parameters>
      <param name="db" value="factbook" />
      <param name="user" value="username" />
      <param name="pass" value="password" />
    </parameters>
    <query>
      INSERT INTO country(name, population, coordinates)
      VALUES ('$country','$population','$coordinates')
    </query>
  </ws:database>

When the query is active (results are produced), the operator returns these results. Otherwise, the input is simply forwarded on for further treatment.

SYNOPSIS

  $cache = WebSource::DB->new(wsnode => $node);

  # for the rest it works as a WebSource::Module

METHODS

$source = WebSource->new(desc => $node);

Create a new DB operator;

SEE ALSO

WebSource::Module