Reads data from a CSV delimited file into a SQL Table, the table can be stored in either an existing SQL database or a temporary database will be created.
More...
|
| CreateSqlTableFromCsvFile () |
|
| ~CreateSqlTableFromCsvFile () override |
|
| ~Operation () override |
|
bool | addInput (Input &input, bool modifiedInPlace=false) |
|
bool | addOutput (Output &output) |
|
template<typename T > |
bool | assignInput (const QString &inputName, const T &value) |
|
bool | canSerialize () const override |
|
bool | connectProgressEvents (QProgressBar *progressBar) |
|
virtual Presentation::CustomOperationProperties * | createCustomPropertiesHandler () |
|
virtual void | ensureHasData () |
|
bool | getBroadcastUpdateEvents () const |
|
QColor | getColor () const |
|
virtual QString | getDefaultIconPath () const |
|
QString | getDefaultUiPath () const |
|
QString | getDeprecationMessage () const |
|
const QString & | getDescription () const |
|
SerializedItem | getExtras () |
|
const OperationFactory & | getFactory () const |
|
Operation * | getFromPath (const QString &path, Workspace &relativeTo, QStringList &errors) const override |
|
virtual GraphicsSize | getGraphicsSize () const |
|
virtual QString | getHelpPage () const |
|
QString | getIconPath () const |
|
const QUuid & | getId () const |
|
QString | getIdPath (bool scoped=true) const override |
|
QString | getIdPath (const Workspace &relativeTo) const |
|
difference_type | getIndex (const Input &input, IndexCountingOptions options=SkipNone) const |
|
difference_type | getIndex (const Output &output, IndexCountingOptions options=SkipNone) const |
|
void | getIndexPair (InputScalar &input, difference_type &mainIndex, difference_type &arrayIndex) |
|
Input * | getInput (const QString &name) |
|
const Input * | getInput (const QString &name) const |
|
Input * | getInput (size_type index) |
|
const Input * | getInput (size_type index) const |
|
InputArray * | getInputArray (const QString &name) |
|
const InputArray * | getInputArray (const QString &name) const |
|
IOBaseIteratorRange< Input, false > | getInputs () |
|
IOBaseIteratorRange< Input, true > | getInputs () const |
|
InputScalar * | getInputScalar (const QString &name) |
|
const InputScalar * | getInputScalar (const QString &name) const |
|
template<typename T > |
T & | getInputValue (const QString &inputName) |
|
template<typename T > |
const T & | getInputValue (const QString &inputName) const |
|
const QString & | getLabel () const |
|
QString | getLabelRelativeToRoot () const |
|
Output * | getOutput (const QString &name) |
|
const Output * | getOutput (const QString &name) const |
|
Output * | getOutput (size_type index) |
|
const Output * | getOutput (size_type index) const |
|
IOBaseIteratorRange< Output, false > | getOutputs () |
|
IOBaseIteratorRange< Output, true > | getOutputs () const |
|
template<typename T > |
T & | getOutputValue (const QString &outputName) |
|
template<typename T > |
const T & | getOutputValue (const QString &outputName) const |
|
bool | getProfilingEnabled () const |
|
int | getProgress () const |
|
int | getProgressContribution () const |
|
bool | getProgressResetByNotUpToDate () const |
|
virtual SchedulerFeatures | getRequiredSchedulerFeatures () const |
|
InputScalar * | getScalarInput (size_type mainIndex, difference_type arrayIndex) |
|
QString | getShortLabel () const |
|
QString | getTagName () const |
|
bool | getTerminateExecution () const |
|
QString | getUiPath () const |
|
bool | getUpToDate () const override |
|
virtual bool | hasRequiredSchedulerFeatures () const |
|
void | idPathChanged () override |
|
virtual bool | inputRebuilt (InputScalar &input) |
|
virtual bool | isAsynchronous () const |
|
virtual bool | isAsynchronousProcess () const |
|
virtual bool | isAtomicUpdate () const |
|
bool | isConnectedToAsynchronous () const override |
|
bool | isDeprecated () const |
|
bool | isEditable () const |
|
bool | isIdPathCachingEnabled () const |
|
virtual bool | isPolymorphicType () const |
|
virtual bool | isRunningAsynchronously () const |
|
virtual bool | isThreadSafe () const |
|
template<typename T > |
bool | isType () const |
|
bool | isType (const OperationFactory &type) const |
|
bool | isUpdating () const |
|
virtual bool | isUserConfigurable () |
|
bool | isUsingDefaultColor () const |
|
bool | isUsingDefaultIconPath () const |
|
bool | isUsingDefaultUiPath () const |
|
bool | isWaitingForAsynchronousUpdate () const override |
|
bool | isWorkspaceType () const |
|
bool | load (const SerializedItem &item) override |
|
void | markUpToDateWhereSafe () |
|
bool | matchesType (const Operation &otherOperation) const |
|
size_type | numInputs (IndexCountingOptions=SkipNone) const |
|
size_type | numOutputs (IndexCountingOptions=SkipNone) const |
|
bool | removeInput (const QString &name) |
|
bool | removeInput (Input &input) |
|
bool | removeOutput (const QString &name) |
|
bool | removeOutput (Output &output) |
|
virtual void | resetExecutionDependencies () |
|
bool | save (SerializedItem &item) const override |
|
virtual bool | saveWithData (SerializedItem &item) const |
|
virtual void | setAtomicUpdate (bool atomic) |
|
void | setBroadcastUpdateEvents (bool enable) |
|
void | setColor (const QColor &c) |
|
void | setDescription (const QString &description) |
|
void | setEditable (bool b) |
|
void | setIconPath (const QString &path) |
|
void | setId (const QUuid &id) |
|
virtual void | setIdPathCachingEnabled (bool b) |
|
virtual void | setInputNotUpToDate (InputScalar &input) |
|
virtual void | setIsAsynchronous (bool asynchronous) |
|
virtual void | setIsAsynchronousProcess (bool) |
|
virtual void | setIsRunningAsynchronously (bool asynchronous) |
|
void | setLabel (const QString &label) |
|
virtual void | setOutputNotUpToDate (Output &output) |
|
void | setProfilingEnabled (bool enable) |
|
virtual void | setProgress (int percent) |
|
void | setProgressContribution (int percent) |
|
void | setProgressResetByNotUpToDate (bool b) |
|
virtual void | setRequiredSchedulerFeatures (const SchedulerFeatures &) |
|
void | setTerminateExecution (bool b) |
|
void | setUiPath (const QString &path) |
|
void | setUpToDate (bool b) override |
|
bool | update (Updater *updater=nullptr) override |
|
| ~WorkspaceElement () override |
|
const Workspace * | getWorkspace () const override |
|
Workspace * | getWorkspace () override |
|
virtual void | workspaceChanged (Workspace *oldWorkspace) |
|
| ~Updatable () override |
|
virtual bool | comesFromExternal () const |
|
QString | getEnclosingScope () const |
|
virtual Updatable * | getFromPath (const QString &path, Workspace &relativeTo, QStringList &errors) const =0 |
|
const QString & | getGlobalName () const |
|
virtual QString | getIdPath (bool scoped=true) const =0 |
|
virtual Workspace * | getRootWorkspace () |
|
virtual const Workspace * | getRootWorkspace () const |
|
QString | getScopedGlobalName () const |
|
virtual bool | getUpToDate () const =0 |
|
virtual const Workspace * | getWorkspace () const =0 |
|
virtual Workspace * | getWorkspace ()=0 |
|
virtual void | idPathChanged () |
|
virtual bool | isConnectedToAsynchronous () const =0 |
|
virtual bool | isWaitingForAsynchronousUpdate () const =0 |
|
void | setGlobalName (const QString &name) |
|
virtual void | setUpToDate (bool b)=0 |
|
virtual bool | update (Updater *updater=nullptr)=0 |
|
virtual | ~Observable () |
|
void | attachObserver (Observer &observer) |
|
void | destroy () |
|
void | detachObserver (Observer &observer) |
|
void | notifyEvent (const ObservableEvent &event) |
|
virtual | ~Serialize ()=default |
|
virtual bool | canSerialize () const =0 |
|
virtual bool | load (const SerializedItem &item)=0 |
|
virtual bool | save (SerializedItem &item) const =0 |
|
| TextLogger () |
|
| TextLogger (const DataExecution::IOBase &io) |
|
| TextLogger (const DataExecution::Operation &operation) |
|
| TextLogger (const TextLogger &logger) |
|
| TextLogger (TextLogger &&logger) |
|
virtual | ~TextLogger () |
|
void | logLine (const Application::LogManager::MessageCategory &category, const QString &msg) const |
|
void | logLine (const QString &msg) const |
|
void | logText (const Application::LogManager::MessageCategory &category, const QString &msg) const |
|
void | logText (const QString &msg) const |
|
TextLogger & | operator= (TextLogger) |
|
The CreateSqlTableFromCsvFile operation reads CSV data from a CSV delimited file. The data is stored in SQL Table within a SQL Database. The SQL database can either be supplied as an input parameter to the operation or a temporary database is dynamically created. There are a number of options to this operation: File name is the CSV file to read. Delimiter is the delimiter to use to parse columns. Columns Headers specifies if the first parsed row contains column names - defaults are generated if the file does not contain column headers. Determine datatypes specifics if the columns data types can be determined by the first row only of data values or if the whole file needs to be checked. Skip top number of lines instructs the operation to ignore some number of lines - often CSV files contain some number of lines of metatdata information at the top, such as the name of the company who produced the file or the file’s creation date. Table name is the name of the table to insert the data into. Depending on its value, either a new table is created or an existing table with the same name is used. Option Database is the existing database to use.