[Level 3] XML in MySQL. 

#!/usr/bin/bash
createTable() {
  mysql -ujoseph <<EOF
CREATE TABLE persons (
id int auto_increment primary key,
data text
);
EOF
}
#createTable

createUsers(){
  mysql -ujoseph <<EOF
INSERT INTO persons(data) values 
('
<person>
  <name>stanley</name>
  <sex>m</sex>
  <addr>taipei</addr>
  <tels>
    <tel>12340001</tel>
    <tel>12340002</tel>
    <tel>12340003</tel>
  </tels>
</person>
'),
('
<person>
  <name>joseph</name>
  <sex>m</sex>
  <addr>taipei</addr>
  <tels>
    <tel>12350001</tel>
    <tel>12350002</tel>
    <tel>12350003</tel>
  </tels>
</person>
')
;
EOF
}
#createUsers

queryUserTels() {
  mysql -ujoseph <<EOF
select
ExtractValue(data,'//person/tels/tel[1]'),
ExtractValue(data,'/person/tels/tel[2]'),
ExtractValue(data,'person/tels/tel[3]')
from persons
where id=1;
EOF
}
#queryUserTels

updateXML() {
  mysql -ujoseph <<EOF
select
data,
ExtractValue(data,'//person/name'),
UpdateXML(data,'//person/name','<name>christy</name>'),
ExtractValue(UpdateXML(data,'//person/name','<name>christy</name>'),'//person/name')
from persons
where id=1;
EOF
}
#updateXML


Wish this helps.  regards, Stanley Huang













































Comments











Post a Comment



















Popular posts from this blog









[Level 1] Rar tool for Solaris.





















Sometimes we will got a rar compressed file from our friends,  but there is no default tool in OpenSolaris to decompress the rar filess.  We can got a Solaris Intel version from rarlab .   The steps as the following:  1. down load the rar tools from rarlab.  http://www.rarlab.com/rar_add.htm  2. uncompressed the source.  # gunzip ./unrar-sol-intel.gz  3. move it to the location you used to.  # mv /unrar-sol-intel.gz /usr/bin/unrar  4. try to decomprss  # unrar x ./test.rar   Wish this helps.   regards,  Stanley Huang








Read more











[Level 2] iif in Python





















If you want to implement iif in Python,  please refer to the following sample code:  #!/bin/env python def iif(b):   return 'It\'s True' if b else 'It\'s False'  print iif(True) print iif(False) And the following sample, guess what will you get!  #!/bin/env python b = True print 'b: %s' % 'Ture' if b else 'False' b = False print 'b: %s' % 'Ture' if b else 'False' Result:  $ ./iif.py  b: Ture False The second result is "False", not "b: False". Why???  Because the prededence of string concatenation is higher than if.  Therefore you need to use () to make it correct.  #!/bin/env python b = True print 'b: %s' % 'Ture' if b else 'False' b = False print 'b: %s' % ('Ture' if b else 'False') Wish this helps.   regards,  Stanley Huang








Read more