Mercurial > hg > ltpda
view m-toolbox/classes/@ltpda_uoh/csvexport.m @ 7:1e91f84a4be8 database-connection-manager
Make ltpda_up.retrieve work with java.sql.Connection objects
author | Daniele Nicolodi <nicolodi@science.unitn.it> |
---|---|
date | Mon, 05 Dec 2011 16:20:06 +0100 |
parents | f0afece42f48 |
children |
line wrap: on
line source
% CSVEXPORT Exports the data of an object to a csv file. %%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%% % % FUNCTION: csvexport % % DESCRIPTION: Exports the data of an object to a csv file. % % CALL: csvexport(in-objects) % % INPUTS: in-objects: Input objects which data should be stored to % disc. % % OUTPUTS: success: If storing of the data was successful % % <a href="matlab:utils.helper.displayMethodInfo('ltpda_uoh', 'csvexport')">Parameters Description</a> % % VERSION: $Id: csvexport.m,v 1.7 2011/04/08 08:56:30 hewitson Exp $ % %%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%% function varargout = csvexport(varargin) %%% Check if this is a call for parameters if utils.helper.isinfocall(varargin{:}) varargout{1} = getInfo(varargin{3}); return end [objs, obj_invars, rest] = utils.helper.collect_objects(varargin(:), ''); pli = utils.helper.collect_objects(rest(:), 'plist'); [data, plData] = csvGenerateData(objs); pl = combine(pli, getDefaultPlist); filename = pl.find('filename'); commentChar = pl.find('commentChar'); description = pl.find('description'); % Some plausibility checks if isempty(filename) if ~isempty(rest) && ischar(rest{1}) filename = rest{1}; pl.pset('filename', filename); else error('### No filename is specified'); end end if isempty(description) description = plData.find('DESCRIPTION'); end columns = plData.find('COLUMNS'); nrows = plData.find('NROWS'); ncols = plData.find('NCOLS'); objIDs = plData.find('OBJECT IDS'); objNames = plData.find('OBJECT NAMES'); creator = plData.find('CREATOR'); created = format(time(), 'yyyy-mm-dd HH:MM'); fid = fopen(filename, 'w'); % Check fid if fid == -1 error('### Can not open the file: %s', filename); end %%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%% %%% write header %%% %%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%% fprintf(fid, '%s\n', commentChar); fprintf(fid, '%s DESCRIPTION: %s\n', commentChar, description); fprintf(fid, '%s\n', commentChar); fprintf(fid, '%s COLUMNS: %s\n', commentChar, columns); columnNames = strtrim(regexp(columns, ',', 'split')); maxColNames = max(cellfun(@length, columnNames)); for ii = 1:numel(columnNames) columnDesc = plData.find(columnNames{ii}); if ~isempty(columnDesc) off = ''; off(1:maxColNames-length(columnNames{ii})) = ' '; fprintf(fid, '%s %s%s: %s\n', commentChar, columnNames{ii}, off, columnDesc); end end fprintf(fid, '%s\n', commentChar); fprintf(fid, '%s NROWS: %d\n', commentChar, nrows); fprintf(fid, '%s NCOLS: %d\n', commentChar, ncols); fprintf(fid, '%s OBJECT IDS: %s\n', commentChar, objIDs); fprintf(fid, '%s OBJECT NEAMES: %s\n', commentChar, objNames); fprintf(fid, '%s\n', commentChar); fprintf(fid, '%s CREATION DATE: %s\n', commentChar, created); fprintf(fid, '%s\n', commentChar); fprintf(fid, '%s CREATED BY: %s\n', commentChar, creator); fprintf(fid, '%s\n', commentChar); fprintf(fid, '%s\n', commentChar); %%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%% %%% write data %%% %%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%% for nn=1:nrows for dd = 1:ncols if numel(data{dd}) >= nn fprintf(fid, '%.17f', data{dd}(nn)); end if dd < numel(data) fprintf(fid, ','); end end fprintf(fid, '\n'); end fclose(fid); end %%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%% % Local Functions % %%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%% %%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%% % % FUNCTION: getInfo % % DESCRIPTION: Get Info Object % %%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%% function ii = getInfo(varargin) if nargin == 1 && strcmpi(varargin{1}, 'None') sets = {}; pl = []; else sets = {'Default'}; pl = getDefaultPlist; end % Build info object ii = minfo(mfilename, 'ltpda_uoh', 'ltpda', utils.const.categories.helper, '$Id: csvexport.m,v 1.7 2011/04/08 08:56:30 hewitson Exp $', sets, pl); end %%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%% % % FUNCTION: getDefaultPlist % % DESCRIPTION: Get Default Plist % %%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%% function plout = getDefaultPlist() persistent pl; if exist('pl', 'var')==0 || isempty(pl) pl = buildplist(); end plout = pl; end function plo = buildplist() plo = plist(); p = param({'filename' 'cvs filename.'}, ''); plo.append(p); p = param({'commentChar','The comment character in the file.'}, {1, {'#'}, paramValue.OPTIONAL}); plo.append(p); p = param({'description', 'Description for the file.'}, ''); plo.append(p); end