XML to MS SQL

import pyodbc
import xlrd
import xml.etree.ElementTree as ET

print("Connecting..")
# Establish a connection between Python and SQL Server
conn = pyodbc.connect('Driver={SQL Server};'
                      'Server=TEST;'
                      'Database=test;'
                      'Trusted_Connection=yes;')
print("DB Connected..")

# Get XMLFile
XMLFilePath = open('C:HelloWorld.xml')
x = etree.parse(XBRLFilePath)          # Updated Code line
with open("FileName", "wb") as f:      # Updated Code line
    f.write(etree.tostring(x))         # Updated Code line

# Create Table in DB
CreateTable = """
create table test.dbo.TEMP
(

 XBRLFile XML

)
"""

# execute create table
cursor = conn.cursor()
try:
    cursor.execute(CreateTable)
    conn.commit()
except pyodbc.ProgrammingError:
    pass
print("Table Created..")

InsertQuery = """
INSERT INTO test.dbo.TEMP (
    XBRLFile
) VALUES (?)"""

# Assign values from each row
values = etree.tostring(x) # Updated Code line

# Execute SQL Insert Query
cursor.execute(InsertQuery, values)

# Commit the transaction
conn.commit()

# Close the database connection
conn.close()

Source: stackoverflow.com

Similar codes

0 vote132 views1 answer
Question 2 Let's create a function that turns text into pig latin: a simple text transformation that modifies each word moving the first character to the end and appending "ay" to the end. For example, python ends up as ythonpay.
Python
3 votes183 views1 answer
How to remove integer from string in python
Python
0 vote138 views1 answer
Matplotlib: use colormaps for line plot colors
Python
0 vote104 views1 answer
Create series with number intervals
Python
0 vote148 views1 answer
Remove percentage in python
Python
0 vote151 views1 answer
How to write user input to a file in python
Python
12 votes137 views2 answers
Isinstance float or int
Python
0 vote143 views1 answer
How to select axis value in python
Python
0 vote104 views1 answer
Can i change color of text in jupyter notebook
Python
19 votes135 views2 answers
Pyinstaller single file
Python