hammant 01/11/04 14:43:04
Modified: apps/db/src/java/org/apache/avalon/db/bcel/parser
LXSQLParser.java
apps/db/src/java/org/apache/avalon/db/driver/lxsql
LXSQLParserHelper.java
apps/db/src/java/org/apache/avalon/db/test Tester.java
Log:
Start of InsertInto implementation
Revision Changes Path
1.6 +1 -9
jakarta-avalon-cornerstone/apps/db/src/java/org/apache/avalon/db/bcel/parser/LXSQLParser.java
Index: LXSQLParser.java
===================================================================
RCS file:
/home/cvs/jakarta-avalon-cornerstone/apps/db/src/java/org/apache/avalon/db/bcel/parser/LXSQLParser.java,v
retrieving revision 1.5
retrieving revision 1.6
diff -u -r1.5 -r1.6
--- LXSQLParser.java 2001/11/04 21:49:42 1.5
+++ LXSQLParser.java 2001/11/04 22:43:04 1.6
@@ -74,7 +74,7 @@
*
*
* @author Paul Hammant <a href="mailto:[EMAIL PROTECTED]">[EMAIL
PROTECTED]</a>
- * @version $Revision: 1.5 $
+ * @version $Revision: 1.6 $
*/
public class LXSQLParser extends BaseBCELParser {
@@ -127,14 +127,6 @@
*
*/
public CreateTable createCreateTableAction(CreateTableRequest request)
throws ActionException {
-
-//<create-table name="Fred">
-// <columns>
-// <column name="wilma" type="varchar" max="20"/>
-// <column name="barney" type="varchar" max="20"/>
-// </columns>
-//</create-table>
-
String docStr = XMLHDR + request.getSql();
System.out.println("docStr=" + docStr);
1.2 +1 -1
jakarta-avalon-cornerstone/apps/db/src/java/org/apache/avalon/db/driver/lxsql/LXSQLParserHelper.java
Index: LXSQLParserHelper.java
===================================================================
RCS file:
/home/cvs/jakarta-avalon-cornerstone/apps/db/src/java/org/apache/avalon/db/driver/lxsql/LXSQLParserHelper.java,v
retrieving revision 1.1
retrieving revision 1.2
diff -u -r1.1 -r1.2
--- LXSQLParserHelper.java 2001/11/04 10:22:13 1.1
+++ LXSQLParserHelper.java 2001/11/04 22:43:04 1.2
@@ -21,7 +21,7 @@
public class LXSQLParserHelper extends AbstractParserHelper {
protected Request getRequest(String sql) throws SQLException {
Request request = null;
- if (sql.startsWith("<insert")) {
+ if (sql.startsWith("<insert-into")) {
request = new InsertRequest(sql);
} else if (sql.startsWith("<update")) {
request = new UpdateRequest(sql);
1.5 +31 -1
jakarta-avalon-cornerstone/apps/db/src/java/org/apache/avalon/db/test/Tester.java
Index: Tester.java
===================================================================
RCS file:
/home/cvs/jakarta-avalon-cornerstone/apps/db/src/java/org/apache/avalon/db/test/Tester.java,v
retrieving revision 1.4
retrieving revision 1.5
diff -u -r1.4 -r1.5
--- Tester.java 2001/11/04 19:00:19 1.4
+++ Tester.java 2001/11/04 22:43:04 1.5
@@ -25,7 +25,37 @@
private void test() throws Exception {
Statement st = mCon.createStatement();
- st.executeUpdate("<create-table name=\"Fred\"><columns><column
name=\"wilma\" type=\"varchar\" max=\"20\"/><column name=\"barney\"
type=\"varchar\" max=\"20\"/></columns></create-table>");
+
+ String createTable = "<create-table name=\"Flintstones\">" +
+ "<columns>" +
+ "<column name=\"forename\" type=\"varchar\"
max=\"20\"/>" +
+ "<column name=\"surname\" type=\"varchar\"
max=\"20\"/>" +
+ "</columns>" +
+ "</create-table>";
+
+ st.executeUpdate(createTable);
+ st.close();
+
+ st = mCon.createStatement();
+ String insertInto = "<insert-into name=\"Flintstones\">" +
+ "<columns astable\"true\"/>" +
+ "<rows>" +
+ "<row>" +
+ "<value>Fred</value>" +
+ "<value>Flintsone</value>" +
+ "</row>" +
+ "<row>" +
+ "<value>Wilma</value>" +
+ "<value>Flintsone</value>" +
+ "</row>" +
+ "<row>" +
+ "<value>Barney</value>" +
+ "<value>Rubble</value>" +
+ "</row>" +
+ "<rows>" +
+ "</insert-into>";
+ st.executeUpdate(insertInto);
+ st.close();
}
private void close() throws Exception {
--
To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
