TSADBSeriesImport.h

/*  ===================================================================
*
*                 T R A D I N G   S Y S T E M   A P I ™
*    Copyright © 1999 - 2014 by Peter Ritter ( TradingSystemAPI.com )
*                A L L   R I G H T S   R E S E R V E D
*
*     Consult your license regarding permissions and restrictions.
*             You may obtain a copy of the License at:
*     http://www.TradingSystemAPI.com/licenses/LICENSE-TSAPI-3.0.html
*
*  ====================================================================
*/

#ifndef TSA_DBSERIES_IMPORT__INCLUDED
#define TSA_DBSERIES_IMPORT__INCLUDED

#include "TSATypeDef.h"
#include "TSAOS.h"
#include "TSATime.h"

namespace tsa{

    class database;
    /*
    ** ====================================================
    ** >>>         class file_import_rules              <<<
    ** ====================================================
    */

    class file_import_rules__obsolete : public tsa::object
    {
        friend class data_base;
        mutable date_time last_timestamp_imported = date_time::min;
    public:

        os::path file_path;
    public:
        file_import_rules__obsolete(void);
    private:
        void import_to(data_base& db)const;
    public:

        std::string target_table;

        bool create_table = true;

        bool delete_existing_table = false;

        bool skip_first_line = false;

        std::string columns;

        std::string date_format;

        bool auto_clear_overlap = false;

        date_time skip_below = date_time::min;

        date_time skip_above = date_time::max;

        bool timestamp_one_field = true;

        char datetime_separator = ' ';

        char field_separator = 0;

        bool fix_duplicate_timestamps = false;

        mutable size_t buffer_size = 10000;
    };

    /*
    ** ====================================================
    ** >>>         class file_import_params             <<<
    ** ====================================================
    */

    class file_import_params : public tsa::object
    {
        friend class data_base;
        mutable date_time last_timestamp_imported = date_time::min;
    public:

        os::path file_path;
    public:
        file_import_params(void);
    private:
        void import_to(data_base& db)const;
    public:

        std::string target_table;

        bool create_table = true;

        bool delete_existing_table = false;

        bool skip_first_line = false;

        std::string file_columns;

        std::string table_columns;

        //std::string skip_columns;

        std::string date_format;

        bool auto_clear_overlap = false;

        date_time skip_below = date_time::min;

        date_time skip_above = date_time::max;

        char datetime_separator = ' ';

        char field_separator = ',';

        std::string null_string;

        bool fix_duplicate_timestamps = false;


        size_t max_records = tsa::max_size_limit;

        mutable size_t buffer_size = 10000;
    };





    /*
    ** ====================================================
    ** >>>          class table_copy_rules              <<<
    ** ====================================================
    */

    class table_copy_params : public tsa::object
    {
    public:

        table_copy_params(void);

        ~table_copy_params(void);

        date_time copy_from_timestamp = date_time::min;

        date_time copy_to_timestamp = date_time::max;

        bool delete_existing = false;

        bool clear_overlap_in_target = false;

        mutable size_t buffer_size = 100000;

    };


} // namespace tsa


#endif