You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@turbine.apache.org by jo...@apache.org on 2001/06/07 00:59:07 UTC
cvs commit: jakarta-turbine/xdocs/howto security-howto.xml
jon 01/06/06 15:59:06
Modified: docs proposals.html
docs/howto security-howto.html
xdocs/howto security-howto.xml
Added: docs/proposals sql.html
Log:
when you add something to the xdocs directory, don't forget to check it
into the html directory.
rebuilt the docs
fixed broken link on security-howto
Revision Changes Path
1.20 +1 -0 jakarta-turbine/docs/proposals.html
Index: proposals.html
===================================================================
RCS file: /home/cvs/jakarta-turbine/docs/proposals.html,v
retrieving revision 1.19
retrieving revision 1.20
diff -u -r1.19 -r1.20
--- proposals.html 2001/05/20 01:28:00 1.19
+++ proposals.html 2001/06/06 22:59:03 1.20
@@ -157,6 +157,7 @@
<li><a href="proposals/core-processing.html">Core Processing</a></li>
<li><a href="proposals/i18n.html">i18n</a></li>
<li><a href="proposals/naming-service.html">Naming Service</a></li>
+<li><a href="proposals/sql.html">New Query Model</a></li>
<li><a href="proposals/package-cleanup.html">Package Cleanup</a></li>
<li><a href="proposals/peers.html">Peer</a></li>
<li><a href="proposals/policy-service.html">Policy Service</a></li>
1.7 +1 -1 jakarta-turbine/docs/howto/security-howto.html
Index: security-howto.html
===================================================================
RCS file: /home/cvs/jakarta-turbine/docs/howto/security-howto.html,v
retrieving revision 1.6
retrieving revision 1.7
diff -u -r1.6 -r1.7
--- security-howto.html 2001/05/21 00:09:34 1.6
+++ security-howto.html 2001/06/06 22:59:04 1.7
@@ -172,7 +172,7 @@
The default or core schema can be viewed at;
</p>
<p>
-<ul><a href="turbine-schema.html">Turbine Core Schema</a></ul>
+<ul><a href="../turbine-schema.html">Turbine Core Schema</a></ul>
</p>
<p>
The main tables are TURBINE_GROUP, TURBINE_USER, TURBINE_ROLE and TURBINE_PERMISSION.
1.1 jakarta-turbine/docs/proposals/sql.html
Index: sql.html
===================================================================
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<!-- Content Stylesheet for Site -->
<!-- start the processing -->
<!-- ====================================================================== -->
<!-- Main Page Section -->
<!-- ====================================================================== -->
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"/>
<meta name="author" value="Eric Dobbs">
<meta name="email" value="eric@apache.org">
<title>Turbine - New Query Model</title>
</head>
<body bgcolor="#ffffff" text="#000000" link="#525D76">
<table border="0" width="100%" cellspacing="0">
<!-- TOP IMAGE -->
<tr>
<td align="left">
<a href="http://jakarta.apache.org"><img src="http://jakarta.apache.org/images/jakarta-logo.gif" border="0"/></a>
</td>
<td align="right">
<a href="http://jakarta.apache.org/turbine/"><img src="../images/logo.gif" alt="Turbine" border="0"/></a>
</td>
</tr>
</table>
<table border="0" width="100%" cellspacing="4">
<tr><td colspan="2">
<hr noshade="" size="1"/>
</td></tr>
<tr>
<!-- LEFT SIDE NAVIGATION -->
<td valign="top" nowrap="true">
<p><strong>Essentials</strong></p>
<ul>
<li> <a href="../index.html">Overview</a>
</li>
<li> <a href="../features.html">Features</a>
</li>
<li> <a href="../fsd.html">Specification</a>
</li>
<li> <a href="../getting-started.html">Getting Started</a>
</li>
<li> <a href="../further-reading.html">Further Reading</a>
</li>
</ul>
<p><strong>Get Involved</strong></p>
<ul>
<li> <a href="../contributors.html">Contributors</a>
</li>
<li> <a href="http://jakarta.apache.org/site/cvsindex.html">CVS Repos</a>
</li>
<li> <a href="../faq.html">FAQ</a>
</li>
<li> <a href="http://jakarta.apache.org/site/mail.html">Mailing Lists</a>
</li>
<li> <a href="../powered.html">Powered by Turbine</a>
</li>
<li> <a href="../license.html">License</a>
</li>
<li> <a href="../issue-tracking.html">Issue Tracking</a>
</li>
</ul>
<p><strong>Documentation</strong></p>
<ul>
<li> <a href="../turbine-documentation-project.html">Turbine Documentation</a>
</li>
<li> <a href="../turbine-schema.html">Core Schema</a>
</li>
<li> <a href="../j2ee-integration.html">J2EE Integration</a>
</li>
<li> <a href="../model2+1.html">Model 2+1</a>
</li>
<li> <a href="../pullmodel.html">Pull MVC Model</a>
</li>
<li> <a href="../services.html">Services</a>
</li>
</ul>
<p><strong>Howto Guides</strong></p>
<ul>
<li> <a href="../howto/action-event-howto.html">Action Events Howto</a>
</li>
<li> <a href="../howto/criteria-howto.html">Criteria Howto</a>
</li>
<li> <a href="../howto/jboss-howto.html">JBoss Howto</a>
</li>
<li> <a href="../howto/jsp-howto.html">JSP Howto</a>
</li>
<li> <a href="../howto/oracle-howto.html">Oracle 8i Howto</a>
</li>
<li> <a href="../howto/peers-howto.html">Peers Howto</a>
</li>
<li> <a href="../howto/postgres-howto.html">Postgres Howto</a>
</li>
<li> <a href="../howto/python-howto.html">Python Howto</a>
</li>
<li> <a href="../howto/security-howto.html">Security Howto</a>
</li>
<li> <a href="../howto/sybase-howto.html">Sybase Howto</a>
</li>
<li> <a href="../howto/tdk-howto.html">TDK Howto</a>
</li>
<li> <a href="../howto/torque-howto.html">Torque Howto</a>
</li>
<li> <a href="../howto/velocity-site-howto.html">Velocity Site Howto</a>
</li>
<li> <a href="../howto/context-howto.html">Velocity Context Howto</a>
</li>
<li> <a href="../howto/webmacro-site-howto.html">Webmacro Site Howto</a>
</li>
</ul>
<p><strong>Development</strong></p>
<ul>
<li> <a href="../active-developers.html">Active Developers</a>
</li>
<li> <a href="../changes.html">Changes</a>
</li>
<li> <a href="../code-standards.html">Coding Specification</a>
</li>
<li> <a href="../branches.html">CVS Branches</a>
</li>
<li> <a href="../db-adapters.html">DB Adapters</a>
</li>
<li> <a href="../deprecation.html">Deprecation Rules</a>
</li>
<li> <a href="../project-map.html">Project Map</a>
</li>
<li> <a href="../proposals.html">Proposals</a>
</li>
<li> <a href="../todo.html">Todo</a>
</li>
</ul>
</td>
<td align="left" valign="top">
<table border="0" cellspacing="0" cellpadding="2" width="100%">
<tr><td bgcolor="#525D76">
<font color="#ffffff" face="arial,helvetica,sanserif">
<a name="Preamble"><strong>Preamble</strong></a>
</font>
</td></tr>
<tr><td><br/></td></tr>
<tr><td>
<blockquote>
<p>
The purpose of this document is to capture the discussion
about the new query model.
</p>
<p>
The present (Spring 2001) method for constructing SQL
statements in Turbine is flawed. Symptoms include:
<li>
confusion about use of Criteria, Criterion
</li>
<li>
inability to construct arbitrarily complex WHERE clauses
</li>
</p>
</blockquote>
</p>
</td></tr>
<tr><td><br/></td></tr>
</table>
<table border="0" cellspacing="0" cellpadding="2" width="100%">
<tr><td bgcolor="#525D76">
<font color="#ffffff" face="arial,helvetica,sanserif">
<a name="Classes likely to be effected by this proposal"><strong>Classes likely to be effected by this proposal</strong></a>
</font>
</td></tr>
<tr><td><br/></td></tr>
<tr><td>
<blockquote>
<p>
<li>
org.apache.turbine.util.db.Criteria
</li>
<li>
org.apache.turbine.util.db.SqlExpression
</li>
<li>
org.apache.turbine.util.db.adaptor (all classes in the package)
</li>
<li>
org.apache.turbine.om.peer.BasePeer
</li>
</p>
</blockquote>
</p>
</td></tr>
<tr><td><br/></td></tr>
</table>
<table border="0" cellspacing="0" cellpadding="2" width="100%">
<tr><td bgcolor="#525D76">
<font color="#ffffff" face="arial,helvetica,sanserif">
<a name="Example SQL statements to be generated"><strong>Example SQL statements to be generated</strong></a>
</font>
</td></tr>
<tr><td><br/></td></tr>
<tr><td>
<blockquote>
<pre>
1. simple selects
select * from some_table
where some_id = n
2. multi-table joins
select table1.name,table2.type_name
from table1,
table2,
table3
where table1.description like '%foo%'
and table1.one_id=table3.one_id
and table2.two_id=table3.two_id
3. compound where clauses
select table1.name
from table1
where (table1.age>21 and table1.age<35)
or (table1.age>50 and table1.age<65)
4. functions
select sum(table1.amount) as sum
from table1
where table1.amount<5000
5. group by ... having
select type, sum(price)
from titles
where price <= 5
group by type
having sum(price) > 50
6. sub-queries
select table1.title)
from table1
where table1.price =
(
select min(table1.price)
from table1
)
select distinct pub_name
from publishers
where pub_id not in
(
select pub_id
from titles
where type='business'
)
7. transactions
begin
<statement1>
<statement2>
<statement3>
commit
8. union, intersect, except (minus)
<statement1>
union
<statement2>
9. outer joins
(mysql syntax)
select user.name,preference.name
from user left join preference
where user.user_id = preference.user_id
(postgresql and sql'92 syntax)
select user.name, preference.name
from user left join preference on user.user_id =
preference.user_id
(oracle syntax)
select user.name,preference.name
from user, preference
where user.user_id = preference.user_id (+)
10. stored procedures and functions
execute foo('bar','baz','biz')
select table.type, foo(table.column)
from table
group by table.type
11. prepared statements
(Any of the above, replacing literal values with ? place-holders.
This also calls for some means of passing in the parameters to a
prepared statement)
select user.name
from user
where userid = ?
</pre>
</blockquote>
</p>
</td></tr>
<tr><td><br/></td></tr>
</table>
</td>
</tr>
<!-- FOOTER -->
<tr><td colspan="2">
<hr noshade="" size="1"/>
</td></tr>
<tr><td colspan="2">
<div align="center"><font color="#525D76" size="-1"><em>
Copyright © 1999-2001, Apache Software Foundation
</em></font></div>
</td></tr>
</table>
</body>
</html>
<!-- end the processing -->
1.5 +1 -1 jakarta-turbine/xdocs/howto/security-howto.xml
Index: security-howto.xml
===================================================================
RCS file: /home/cvs/jakarta-turbine/xdocs/howto/security-howto.xml,v
retrieving revision 1.4
retrieving revision 1.5
diff -u -r1.4 -r1.5
--- security-howto.xml 2001/05/21 00:09:28 1.4
+++ security-howto.xml 2001/06/06 22:59:06 1.5
@@ -31,7 +31,7 @@
</p>
<p>
-<ul><a href="turbine-schema.html">Turbine Core Schema</a></ul>
+<ul><a href="../turbine-schema.html">Turbine Core Schema</a></ul>
</p>
<p>
---------------------------------------------------------------------
To unsubscribe, e-mail: turbine-dev-unsubscribe@jakarta.apache.org
For additional commands, e-mail: turbine-dev-help@jakarta.apache.org