generarDocumentoIntelisis.py

"""  Guarda un dato como xml
xml = "<myxmldata/>".encode()
f =  open("myxmlfile.xml", "wb")
f.write(xml)
f.close()
"""

import pyodbc

# Specifying the ODBC driver, server name, database, etc. directly
cnxn = pyodbc.connect('DRIVER={SQL Server};SERVER=localhost;DATABASE=LPGHCONSULTORES;UID=sa;PWD=')

cursor = cnxn.cursor()
cursor.execute("select movid, documento from cfd where timbrado='1' ")
rows = cursor.fetchall()
for row in rows:
    xml = row.documento.encode()
    f = open("C:\\basurero\\%s.xml" % row.movid, "wb")
    f.write(xml)
    f.close()
    print("creado")

"""
from sqlalchemy import create_engine
engine = create_engine('mssql+pymssql://sa:@localhost:52865/LPGCONSULTORES')
conn = engine.connect()
rows = conn.execute("select name FROM sys.databases;")
for row in rows:
    print(row["name"])

"""