/usr/share/doc/mailutils-doc/mailutils.html/SQL-Quotas.html

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<!-- Published by the Free Software Foundation,
51 Franklin Street, Fifth Floor
Boston, MA 02110-1301, USA

Copyright (C) 1999-2004, 2008-2012, 2014-2015 Free Software
Foundation, Inc.

Permission is granted to copy, distribute and/or modify this document
under the terms of the GNU Free Documentation License, Version 1.2 or
any later version published by the Free Software Foundation; with no
Invariant Sections, no Front-Cover, and no Back-Cover texts.
A copy of the license is included in the section entitled "GNU Free
Documentation License". -->
<!-- Created by GNU Texinfo 6.1, http://www.gnu.org/software/texinfo/ -->
<head>
<title>GNU Mailutils Manual: SQL Quotas</title>

<meta name="description" content="GNU Mailutils Manual: SQL Quotas">
<meta name="keywords" content="GNU Mailutils Manual: SQL Quotas">
<meta name="resource-type" content="document">
<meta name="distribution" content="global">
<meta name="Generator" content="makeinfo">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<link href="index.html#Top" rel="start" title="Top">
<link href="Function-Index.html#Function-Index" rel="index" title="Function Index">
<link href="index.html#SEC_Contents" rel="contents" title="Table of Contents">
<link href="Mailbox-Quotas.html#Mailbox-Quotas" rel="up" title="Mailbox Quotas">
<link href="Maidag-Scripting.html#Maidag-Scripting" rel="next" title="Maidag Scripting">
<link href="DBM-Quotas.html#DBM-Quotas" rel="prev" title="DBM Quotas">
<style type="text/css">
<!--
a.summary-letter {text-decoration: none}
blockquote.indentedblock {margin-right: 0em}
blockquote.smallindentedblock {margin-right: 0em; font-size: smaller}
blockquote.smallquotation {font-size: smaller}
div.display {margin-left: 3.2em}
div.example {margin-left: 3.2em}
div.lisp {margin-left: 3.2em}
div.smalldisplay {margin-left: 3.2em}
div.smallexample {margin-left: 3.2em}
div.smalllisp {margin-left: 3.2em}
kbd {font-style: oblique}
pre.display {font-family: inherit}
pre.format {font-family: inherit}
pre.menu-comment {font-family: serif}
pre.menu-preformatted {font-family: serif}
pre.smalldisplay {font-family: inherit; font-size: smaller}
pre.smallexample {font-size: smaller}
pre.smallformat {font-family: inherit; font-size: smaller}
pre.smalllisp {font-size: smaller}
span.nolinebreak {white-space: nowrap}
span.roman {font-family: initial; font-weight: normal}
span.sansserif {font-family: sans-serif; font-weight: normal}
ul.no-bullet {list-style: none}
-->
</style>


</head>

<body lang="en">
<a name="SQL-Quotas"></a>
<div class="header">
<p>
Previous: <a href="DBM-Quotas.html#DBM-Quotas" accesskey="p" rel="prev">DBM Quotas</a>, Up: <a href="Mailbox-Quotas.html#Mailbox-Quotas" accesskey="u" rel="up">Mailbox Quotas</a> &nbsp; [<a href="index.html#SEC_Contents" title="Table of contents" rel="contents">Contents</a>][<a href="Function-Index.html#Function-Index" title="Index" rel="index">Index</a>]</p>
</div>
<hr>
<a name="Keeping-Quotas-in-SQL-Database"></a>
<h4 class="subsubsection">2.11.4.2 Keeping Quotas in SQL Database</h4>

<p>Configuration statement <code>quota-query</code> allows to specify a special
query to retrieve the quota from the database.  Currently (as of mailutils
version 2.99.99) it is assumed that this table can be accessed
using the credentials set in &lsquo;<samp>sql</samp>&rsquo; configuration statement
(see <a href="SQL-Statement.html#SQL-Statement">SQL Statement</a>).
</p>
<p>For example, suppose you have the following quota table:
</p>
<div class="example">
<pre class="example">create table mailbox_quota (
  user_name varchar(32) binary not null,
  quota int,
  unique (user_name)
);
</pre></div>


<p>To retrieve user quota the following query can be used:
</p>
<div class="example">
<pre class="example">SELECT quota FROM mailbox_quota WHERE user_name='${user}'
</pre></div>

<p>There are no special provisions for specifying group quotas, similar to
&lsquo;<samp>DEFAULT</samp>&rsquo; in <acronym>DBM</acronym> databases.  This is because group quotas can
easily be implemented using <acronym>SQL</acronym> language.  <code>Maidag</code>
always uses the first tuple from the set returned by mailbox quota
query.  So, you may add a special entry to the <code>mailbox_quota</code>
table that would keep the group quota.  In the discussion below we assume
that the <code>user_name</code> column for this entry is lexicographically
less than any other user name in the table.  Let&rsquo;s suppose the group
quota name is &lsquo;<samp>00DEFAULT</samp>&rsquo;.  Then the following query:
</p>
<div class="example">
<pre class="example">SELECT quota
FROM mailbox_quota
WHERE user_name IN ('${user}','00DEFAULT')
ORDER BY user_name DESC
</pre></div>

<p>will return two tuples if the user is found in
<code>mailbox_quota</code>.  Due to <code>ORDER</code> statement, the first tuple
will contain the quota for the user, which will be used by
<code>maidag</code>.  On the other hand, if the requested user name is not
present in the table, the above query will return a single tuple
containing the group quota.
</p>
<p>The following configuration statement instructs <code>maidag</code> to
use this query for retrieving the user quota:
</p>
<div class="example">
<pre class="example">quota-query &quot;SELECT quota &quot;
            &quot;FROM mailbox_quota &quot;
            &quot;WHERE user_name IN ('${user}','00DEFAULT') &quot;
            &quot;ORDER BY user_name DESC&quot;;
</pre></div>

<hr>
<div class="header">
<p>
Previous: <a href="DBM-Quotas.html#DBM-Quotas" accesskey="p" rel="prev">DBM Quotas</a>, Up: <a href="Mailbox-Quotas.html#Mailbox-Quotas" accesskey="u" rel="up">Mailbox Quotas</a> &nbsp; [<a href="index.html#SEC_Contents" title="Table of contents" rel="contents">Contents</a>][<a href="Function-Index.html#Function-Index" title="Index" rel="index">Index</a>]</p>
</div>



</body>
</html>
mailutils-doc 1:2.99.99-1ubuntu2 / usr / share / doc / mailutils-doc / mailutils.html / SQL-Quotas.html
