No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
Hi everyone, i was given a book.xml file which contains all the title,author of the books. Here's how it looks like. <?xml version="1.0" ?> <Books> <Item> <BookID>A001</BookID> <Title>A Tale of Two Cities</Title> <Author>Charles Dickens</Author> <Language>English</Language> <Year>1859</Year> <Quantity>5</Quantity> </Item> <Item> <BookID>A002</BookID> <Title>The Lord of the Rings</Title> <Author>J. R. R. Tolkien</Author> <Language>English</Language> … |
|
Hi everyone here, Can someone please guide me in transforming XML-to-SQL output with Python? I need to create 2 tables (Books and Patrons) into SQL. How much i suppose to start with??? <?xml version="1.0" ?> <Books> <Item> <BookID>A001</BookID> <Title>A Tale of Two Cities</Title> <Author>Charles Dickens</Author> <Language>English</Language> <Year>1859</Year> <Quantity>5</Quantity> </Item> <Item> … |