File: loadxml6.testcase

package info (click to toggle)
spatialite 5.1.0-3
  • links: PTS, VCS
  • area: main
  • in suites: forky, sid, trixie
  • size: 74,240 kB
  • sloc: ansic: 587,051; makefile: 8,583; sh: 4,276; yacc: 1,973; xml: 717
file content (8 lines) | stat: -rw-r--r-- 1,649 bytes parent folder | download | duplicates (5) 
1
2
3
4
5
6
7
8
 
XB_LoadXML - filepath input - valid
:memory: #use in-memory database
SELECT Hex(XB_LoadXML('books.xml'));
1 # rows (not including the header row)
1 # columns
Hex(XB_LoadXML('books.xml'))
3C3F786D6C2076657273696F6E3D22312E302220656E636F64696E673D227574662D38223F3E0A3C426F6F6B7320786D6C6E733A7873693D22687474703A2F2F7777772E77332E6F72672F323030312F584D4C536368656D612D696E7374616E636522207873693A6E6F4E616D657370616365536368656D614C6F636174696F6E3D22626F6F6B732E787364223E3C617574686F722066697273744E616D653D22436861726C657322206C6173744E616D653D224469636B656E73223E0A3C7469746C653E546865205069636B7769636B205061706572733C2F7469746C653E3C7469746C653E4F6C697665722054776973743C2F7469746C653E3C7469746C653E446176696420436F707065726669656C643C2F7469746C653E0A3C7469746C653E41204368726973746D6173204361726F6C3C2F7469746C653E3C7469746C653E486172642054696D65733C2F7469746C653E3C2F617574686F723E0A3C617574686F722066697273744E616D653D224E617468616E69656C22206C6173744E616D653D2248617774686F726E65223E3C7469746C653E54686520536361726C6574204C65747465723C2F7469746C653E3C2F617574686F723E0A3C617574686F722066697273744E616D653D2257696C6C69616D204D616B65706561636522206C6173744E616D653D22546861636B65726179223E3C7469746C653E56616E69747920466169723C2F7469746C653E0A3C7469746C653E546865204C75636B206F66204261727279204C796E646F6E3C2F7469746C653E3C2F617574686F723E3C617574686F722066697273744E616D653D224A6F7365706822206C6173744E616D653D22436F6E726164223E0A3C7469746C653E4C6F7264204A696D3C2F7469746C653E3C7469746C653E54686520536563726574204167656E743C2F7469746C653E3C7469746C653E4865617274206F66204461726B6E6573733C2F7469746C653E0A3C2F617574686F723E3C2F426F6F6B733E0A