CODEWITHSUNDEEP
xmlhaskellhxthdbc
harshainfo
harshainfo

Reputation: 534

How to Read XML as Objects and Write to MySQL using Haskell

I have several XML files of the following format in path location:

enter image description here

<Group>
  <Group_No>1</Group_No>
  <Group_Name>One</Group_Name>
  <Member_List>
    <Member>
      <Member_No>1</Member_No>
      <Member_Name>Mike</Member_Name>
    </Member>
    <Member>
      <Member_No>2</Member_No>
      <Member_Name>Jacob</Member_Name>
    </Member>
  </Member_List>
</Group>

I want to read all those XML files and create Group and Member data objects and save them to a MySQL DB using Haskell(I know I need to use HXT and HDBC libraries but I am confused as to how I could use them). Though there are examples for reading XML, they do not show how to traverse through the objects to save to DB.

DB structure:

DB name : L group_member_db

Group table:

Group ID:PK , Int, AutoIncrement

Group No: String

Group Name:String

Member Table:

Member ID:PK, Int, AutoIncrement

Member No:String

Member Name:String

Thanks in advance

Upvotes: 0

Views: 54

Answers (0)

Related Questions