Menu
▾
▴
adodb-xmlschema-devel — AXMLS developer list.
You can subscribe to this list here.
| 2004 |
Jan
|
Feb
|
Mar
(5) |
Apr
|
May
(1) |
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
|---|
|
From: <ben...@id...> - 2004-05-25 09:38:15
|
Dear Open Source developer I am doing a research project on "Fun and Software Development" in which I kindly invite you to participate. You will find the online survey under http://fasd.ethz.ch/qsf/. The questionnaire consists of 53 questions and you will need about 15 minutes to complete it. With the FASD project (Fun and Software Development) we want to define the motivational significance of fun when software developers decide to engage in Open Source projects. What is special about our research project is that a similar survey is planned with software developers in commercial firms. This procedure allows the immediate comparison between the involved individuals and the conditions of production of these two development models. Thus we hope to obtain substantial new insights to the phenomenon of Open Source Development. With many thanks for your participation, Benno Luthiger PS: The results of the survey will be published under http://www.isu.unizh.ch/fuehrung/blprojects/FASD/. We have set up the mailing list fa...@we... for this study. Please see http://fasd.ethz.ch/qsf/mailinglist_en.html for registration to this mailing list. _______________________________________________________________________ Benno Luthiger Swiss Federal Institute of Technology Zurich 8092 Zurich Mail: benno.luthiger(at)id.ethz.ch _______________________________________________________________________ |
|
From: Dan C. <dc...@ph...> - 2004-03-24 16:43:20
|
Marc ALBER wrote:
> Hello,
>
> Richard Tango-Lowy asked me to send this also to the AXMLS mailing list.
>
> I am using adodb-xmlschema to describe my database, but I wanted to use
> two features from the adodb-datadict that I was unable to use with the
> current version of axmls : the DEFTIMESTAMP and CONSTRAINT field options.
Hi Marc,
I have made a few modifications to the patch you submitted and committed
the results to CVS. I apologise for the oversight in not properly
supporting this syntax, everything should work correctly now.
When using DEFDATE or DEFTIMESTAMP the preferred syntax is:
<field name="created" type="T">
<NOTNULL/>
<DEFTIMESTAMP/>
</field>
Thanks for the patch,
Dan
> I propose a simplified database schema to illustrate my patch, sample.xml :
>
> <?xml version="1.0"?>
> <schema version="0.2">
> <table name="cart">
> <descr>
> A simplified shopping cart.
> </descr>
> <field name="cart_id" type="I">
> <KEY/>
> <AUTOINCREMENT/>
> </field>
> <field name="created" type="T">
> <NOTNULL/>
> </field>
> </table>
> <table name="item">
> <field name="item_id" type="I">
> <KEY/>
> <AUTOINCREMENT/>
> </field>
> <field name="name" type="C" size="50"/>
> <field name="cart_id" type="I">
> <NOTNULL/>
> </field>
> </table>
> </schema>
>
> I wanted to declare *DEFTIMESTAMP* for the *created* field in the cart
> table and add a constraint on the *cart_id* field in the *item* table.
>
> The code parses an *opts* attribute in the field, but I think there is a
> bug in the code near line 382. Is this attribute described in the dtd ?
> The dtd shows a *constraint* element for the *field*, but I think the
> code doesn't parse it. My patch implements the parsing of a *constraint*
> element in a *field*.
>
> The following schema can be parsed with my pactched code (sample1.xml,
> changes in bold) :
>
> <?xml version="1.0"?>
> <schema version="0.2">
> <table name="cart">
> <descr>
> A simplified shopping cart.
> </descr>
> <field name="cart_id" type="I">
> <KEY/>
> <AUTOINCREMENT/>
> </field>
> <field name="created" type="T" *opts="DEFTIMESTAMP"*>
> <NOTNULL/>
> </field>
> </table>
> <table name="item">
> <field name="item_id" type="I">
> <KEY/>
> <AUTOINCREMENT/>
> </field>
> <field name="name" type="C" size="50"/>
> <field name="cart_id" type="I">
> *<constraint>
> REFERENCES cart (cart_id)
> </constraint>*
> <NOTNULL/>
> </field>
> </table>
> </schema>
> Best regards,
>
> Marc ALBER
|
|
From: Marc A. <mar...@fr...> - 2004-03-24 15:23:18
|
Hello,
Richard Tango-Lowy asked me to send this also to the AXMLS mailing list.
I am using adodb-xmlschema to describe my database, but I wanted to use
two features from the adodb-datadict that I was unable to use with the
current version of axmls : the DEFTIMESTAMP and CONSTRAINT field
options.
I propose a simplified database schema to illustrate my patch,
sample.xml :
<?xml version="1.0"?>
<schema version="0.2">
<table name="cart">
<descr>
A simplified shopping cart.
</descr>
<field name="cart_id" type="I">
<KEY/>
<AUTOINCREMENT/>
</field>
<field name="created" type="T">
<NOTNULL/>
</field>
</table>
<table name="item">
<field name="item_id" type="I">
<KEY/>
<AUTOINCREMENT/>
</field>
<field name="name" type="C" size="50"/>
<field name="cart_id" type="I">
<NOTNULL/>
</field>
</table>
</schema>
I wanted to declare DEFTIMESTAMP for the created field in the cart table
and add a constraint on the cart_id field in the item table.
The code parses an opts attribute in the field, but I think there is a
bug in the code near line 382. Is this attribute described in the dtd ?
The dtd shows a constraint element for the field, but I think the code
doesn't parse it. My patch implements the parsing of a constraint
element in a field.
The following schema can be parsed with my pactched code (sample1.xml,
changes in bold) :
<?xml version="1.0"?>
<schema version="0.2">
<table name="cart">
<descr>
A simplified shopping cart.
</descr>
<field name="cart_id" type="I">
<KEY/>
<AUTOINCREMENT/>
</field>
<field name="created" type="T" opts="DEFTIMESTAMP">
<NOTNULL/>
</field>
</table>
<table name="item">
<field name="item_id" type="I">
<KEY/>
<AUTOINCREMENT/>
</field>
<field name="name" type="C" size="50"/>
<field name="cart_id" type="I">
<constraint>
REFERENCES cart (cart_id)
</constraint>
<NOTNULL/>
</field>
</table>
</schema>
The patch inline :
diff -Naur adodb-xmlschema-1.0.1-cvs200403241400/adodb-xmlschema.inc.php adodb-xmlschema-1.0.1-cvs200403241400-mod/adodb-xmlschema.inc.php
--- adodb-xmlschema-1.0.1-cvs200403241400/adodb-xmlschema.inc.php 2004-03-23 18:59:38.000000000 +0100
+++ adodb-xmlschema-1.0.1-cvs200403241400-mod/adodb-xmlschema.inc.php 2004-03-24 14:56:33.000000000 +0100
@@ -293,6 +293,14 @@
switch( $this->currentElement ) {
// Table constraint
case 'CONSTRAINT':
+ if( isset( $this->current_field ) ) {
+ $this->addFieldOpt( $this->current_field
+ , 'CONSTRAINT'
+ , $cdata );
+ } else {
+ $this->addTableOpt( $cdata );
+ }
+ break;
// Table option
case 'OPT':
$this->addTableOpt( $cdata );
@@ -316,6 +324,10 @@
xml_set_object( $parser, $this->parent );
$this->destroy();
break;
+ case 'FIELD':
+ unset($this->current_field);
+ break;
+
}
}
@@ -379,7 +391,7 @@
// Set the field options
if( isset( $opts ) ) {
- $this->fields[$field_id]['OPTS'] = $opts;
+ $this->fields[$field_id]['OPTS'][] = $opts;
}
}
@@ -486,7 +498,7 @@
if( is_array( $opt ) ) {
$key = key( $opt );
$value = $opt[key( $opt )];
- $fldarray[$field_id][$key] = $value;
+ $fldarray[$field_id][$key] .= $value;
// Option doesn't have arguments
} else {
$fldarray[$field_id][$opt] = $opt;
@@ -1961,4 +1973,4 @@
echo '</pre>';
}
}
-?>
\ Pas de fin de ligne à la fin du fichier.
+?>
Best regards,
Marc ALBER
|
|
From: Dan K. <da...@ku...> - 2004-03-23 19:42:23
|
cool. Good work Dan Cech wrote: > Hi guys, > > I just added the RemoveSchema and RemoveSchemaString functions. > > They use an xsl to create a schema to drop the tables in reverse order, > then execute it in the same way as any other schema, seems to work > pretty well. > > Dan > > > > ------------------------------------------------------- > This SF.Net email is sponsored by: IBM Linux Tutorials > Free Linux tutorial presented by Daniel Robbins, President and CEO of > GenToo technologies. Learn everything from fundamentals to system > administration.http://ads.osdn.com/?ad_id=1470&alloc_id=3638&op=click > _______________________________________________ > adodb-xmlschema-devel mailing list > ado...@li... > https://lists.sourceforge.net/lists/listinfo/adodb-xmlschema-devel |
|
From: Dan C. <dc...@ph...> - 2004-03-23 14:18:52
|
Hi guys, I just added the RemoveSchema and RemoveSchemaString functions. They use an xsl to create a schema to drop the tables in reverse order, then execute it in the same way as any other schema, seems to work pretty well. Dan |
|
From: Richard Tango-L. <ri...@ar...> - 2004-03-22 19:55:17
|
Please ignore
--
ars Cognita The Art of Knowledge
---------------------
Richard Tango-Lowy
ri...@ar...
www.arscognita.com
|