def convert_xml_to_sql(filename):
config = {'host': 'localhost',
'port': 3306,
'user': '******',
'passwd': 'vistrailspwd',
'db': 'vistrails'}
try:
vistrail = io.open_vistrail_from_xml(filename)
dbConnection = io.open_db_connection(config)
print dbConnection.get_server_info()
print dbConnection.get_host_info()
print dbConnection.stat()
print str(dbConnection)
io.save_vistrail_to_db(vistrail, dbConnection)
io.close_db_connection(dbConnection)
print 'db_id: ', vistrail.db_id
except Exception, e:
print e
def convert_xml_to_sql(filename):
config = {
'host': 'localhost',
'port': 3306,
'user': '******',
'passwd': 'vistrailspwd',
'db': 'vistrails'
}
try:
vistrail = io.open_vistrail_from_xml(filename)
dbConnection = io.open_db_connection(config)
print dbConnection.get_server_info()
print dbConnection.get_host_info()
print dbConnection.stat()
print str(dbConnection)
io.save_vistrail_to_db(vistrail, dbConnection)
io.close_db_connection(dbConnection)
print 'db_id: ', vistrail.db_id
except Exception, e:
print e
def new_open_vistrail_from_zip_xml_old(filename):
"""open_vistrail_from_zip_xml(filename) -> Vistrail
Open a vistrail from a zip compressed format.
It expects that the file inside archive has name vistrail
"""
try:
zf = zipfile.ZipFile(filename, 'r')
except:
raise Exception('Error opening file!\nThe file may be invalid or you\nmay have insufficient permissions.')
getBuilderWindow().startProgress('Opening...')
#######################################################
#Audio and Video
sourceZip = zipfile.ZipFile(filename)
tmp_audio_dir = tempfile.mkdtemp(prefix="VTAudio")
audio_dir = os.path.join(tmp_audio_dir)
tmp_video_dir = tempfile.mkdtemp(prefix="VTVideo")
video_dir = os.path.join(tmp_video_dir)
for name in sourceZip.namelist():
if name.find('.mp3') != -1 or name.find('.wav') != -1 or name.find('.ogg') != -1 or \
name.find('.mpc') != -1 or name.find('.flac') != -1 or name.find('.au') != -1 or \
name.find('.raw') != -1 or name.find('.dct') != -1 or name.find('.aac') != -1 or \
name.find('.m4a') != -1 or name.find('.wma') != -1 or \
name.find('.amr') != -1 or name.find('.awb'):
if name.startswith('audio/VTAudio') == True:
sourceZip.extract(name, tmp_audio_dir)
if name.find('.3g2') != -1 or name.find('.3gp') != -1 or name.find('.amv') != -1 or \
name.find('.asf') != -1 or name.find('.asx') != -1 or name.find('.avi') != -1 or \
name.find('.wmv') != -1 or name.find('.vob') != -1 or name.find('.wwf') != -1 or \
name.find('.rm') != -1 or name.find('.mpg') != -1 or name.find('.mov') != -1 or \
name.find('.flv') != -1 or name.find('.mp4'):
if name.startswith('video/VTVideo') == True:
sourceZip.extract(name, tmp_video_dir)
# Unzip vistrail
(file_, xmlfname) = tempfile.mkstemp(suffix='.xml')
os.close(file_)
file(xmlfname, 'w').write(zf.read('vistrail'))
vistrail = open_vistrail_from_xml(xmlfname)
vistrail.db_audio_dir = os.path.join(tmp_audio_dir)
vistrail.db_video_dir = os.path.join(tmp_video_dir)
os.unlink(xmlfname)
getBuilderWindow().updateProgress(0.3)
# Unzip data file
(bfile_, binfname) = tempfile.mkstemp()
os.close(bfile_)
file(binfname, 'wb').write(zf.read('data'))
vistrail.binary_data = array.array('c')
bsize = os.path.getsize(binfname)
vt_bin_file = open(binfname, 'rb')
vistrail.binary_data.fromfile(vt_bin_file, bsize)
vt_bin_file.close()
os.unlink(binfname)
getBuilderWindow().updateProgress(0.7)
# Unzip save data
namelist = zf.namelist()
vistrail.saved_files = []
for name in namelist:
if name != "vistrail" and name != "data" and \
not name.startswith("audio" + os.sep) and not name.startswith("video" + os.sep) and not name.startswith("audio") and not name.startswith("video"):
# Filename has a '.b' or '.a' appended to it so we know
# how to write it. In Python 2.6 or later, we should just use
# zipFile.extractAll instead of zipFile.read
(basename,ext) = os.path.splitext(name)
sfilename = core.system.temporary_save_file(os.path.basename(basename))
print "sfilename, ", sfilename
print "name, ", name
if ext == ".b":
file(sfilename, 'wb').write(zf.read(name))
else:
file(sfilename, 'w').write(zf.read(name))
vistrail.saved_files.append((sfilename, ext))
getBuilderWindow().endProgress()
temp_audio_Dir = vistrail.db_audio_dir
temp_video_Dir = vistrail.db_video_dir
return vistrail
