SHARE
TWEET

Untitled

a guest Aug 18th, 2018 89 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. <XMLtoDB>
  2.  
  3. <dbinfo dbuser="postgres" dbpass="password" dbsource="dbi:Pg:dbname=peivotes;host=localhost;port=5432" name="peivotesca"/>
  4. <RootElement name="rss"/>
  5. <DocKeyColumn name="guid"/>
  6.  
  7.     <Table name="Candidates" dbname="peivotes" xpath="./channel/item/electionspei:ballotcount">
  8.         <KeyColumn name="GID" order="1"/>
  9.         <KeyColumn name="Poll" order="2"/>
  10.         <KeyColumn name="Dist_no" order="3"/>
  11.         <KeyColumn name="Party" order="4"/>
  12.             <Element xpath="../electionspei:pollname" toColumn="Pollname"/>
  13.             <Element xpath="../electionspei:poll" toColumn="Poll"/>
  14.             <Element xpath="../electionspei:districtname" toColumn="Dist_name"/>
  15.             <Element xpath="../electionspei:districtnumber" toColumn="Dist_no"/>
  16.             <Element xpath="./@party" toColumn="Party" />
  17.             <Element xpath="./@lastname" toColumn="Last_Name" />
  18.             <Element xpath="./@firstname" toColumn="First_Name" />
  19.             <Element xpath="./@pollvotes" toColumn="Pollvotes" />
  20.             <Element xpath="./@totalvotes" toColumn="Totalvotes" />
  21.     </Table>
  22.  
  23. </XMLtoDB>
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top