Skip to content

Instantly share code, notes, and snippets.

@mindnuts

mindnuts/gist:205e8dd4338b407022e9011da3292cdc

Forked from Pradnya-Paranjape/gist:147caeebe24fe2f8e05dced841b1908b
Last active April 28, 2017 12:09
Show Gist options
  • Save mindnuts/205e8dd4338b407022e9011da3292cdc to your computer and use it in GitHub Desktop.
Save mindnuts/205e8dd4338b407022e9011da3292cdc to your computer and use it in GitHub Desktop.
Download ZIP

Revisions

  1. mindnuts revised this gist Apr 28, 2017. 1 changed file with 3 additions and 3 deletions.
    6 changes: 3 additions & 3 deletions gistfile1.md
    View file
    Original file line number Diff line number Diff line change
    @@ -8,7 +8,7 @@ CREATE TABLE `admin_settings` (
    `black_box` blob,
    `created_date_time` datetime DEFAULT NULL,
    `modified_date_time` datetime DEFAULT NULL
    ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
    ```
    ## SQL script to create form_data table
    ```sql
    @@ -25,10 +25,10 @@ CREATE TABLE `form_data` (
    `black_box_data` blob,
    `created_date_time` datetime DEFAULT NULL,
    `modified_date_time` datetime DEFAULT NULL
    ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
    ```

    ## Docker command to export activities
    ```sh
    ```bash
    docker run -v /opt/migrations/:/migrations -e "START_DATE=2016-01-01" -e "END_DATE=2017-12-30" -e 'INFLUX_HOST_NAME={{IP_ADDRESS}}' -e 'INFLUX_PORT={{PORT}}' localhost:5000/activity_migrator
    ````
  2. mindnuts revised this gist Apr 28, 2017. 1 changed file with 19 additions and 1 deletion.
    20 changes: 19 additions & 1 deletion gistfile1.md
    View file
    Original file line number Diff line number Diff line change
    @@ -10,7 +10,25 @@ CREATE TABLE `admin_settings` (
    `modified_date_time` datetime DEFAULT NULL
    ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
    ```
    ## Docker command to export activities
    ## SQL script to create form_data table
    ```sql
    CREATE TABLE `form_data` (
    `id` bigint(20) UNSIGNED NOT NULL,
    `record_id` varchar(255) NOT NULL,
    `resource_id` varchar(255) NOT NULL,
    `envelope_id` varchar(255) NOT NULL,
    `application_id` varchar(255) DEFAULT NULL,
    `callback_url` varchar(255) DEFAULT NULL,
    `callback_status` varchar(255) DEFAULT NULL,
    `context` text,
    `black_box` blob,
    `black_box_data` blob,
    `created_date_time` datetime DEFAULT NULL,
    `modified_date_time` datetime DEFAULT NULL
    ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
    ```

    ## Docker command to export activities
    ```sh
    docker run -v /opt/migrations/:/migrations -e "START_DATE=2016-01-01" -e "END_DATE=2017-12-30" -e 'INFLUX_HOST_NAME={{IP_ADDRESS}}' -e 'INFLUX_PORT={{PORT}}' localhost:5000/activity_migrator
    ````
  3. mindnuts renamed this gist Apr 28, 2017. 1 changed file with 0 additions and 0 deletions.
    0 gistfile1.txt → gistfile1.md
    View file
    File renamed without changes.
  4. mindnuts revised this gist Apr 28, 2017. 1 changed file with 16 additions and 1 deletion.
    17 changes: 16 additions & 1 deletion gistfile1.txt
    View file
    Original file line number Diff line number Diff line change
    @@ -1 +1,16 @@
    docker run -v /opt/migrations/:/migrations -e "START_DATE=2016-01-01" -e "END_DATE=2017-12-30" -e 'INFLUX_HOST_NAME={{IP_ADDRESS}}' -e 'INFLUX_PORT={{PORT}}' localhost:5000/activity_migrator
    ## SQL command to create admin_settings table
    ```sql
    CREATE TABLE `admin_settings` (
    `id` bigint(20) UNSIGNED NOT NULL,
    `record_id` varchar(255) NOT NULL,
    `name` varchar(255) DEFAULT NULL,
    `resource_id` varchar(255) NOT NULL,
    `black_box` blob,
    `created_date_time` datetime DEFAULT NULL,
    `modified_date_time` datetime DEFAULT NULL
    ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
    ```
    ## Docker command to export activities
    ```
    docker run -v /opt/migrations/:/migrations -e "START_DATE=2016-01-01" -e "END_DATE=2017-12-30" -e 'INFLUX_HOST_NAME={{IP_ADDRESS}}' -e 'INFLUX_PORT={{PORT}}' localhost:5000/activity_migrator
    ````
  5. @Pradnya-Paranjape Pradnya-Paranjape revised this gist Apr 21, 2017. 1 changed file with 1 addition and 1 deletion.
    2 changes: 1 addition & 1 deletion gistfile1.txt
    View file
    Original file line number Diff line number Diff line change
    @@ -1 +1 @@
    docker run -v /opt/migrations/:/migrations -e 'START_DATE=2016-10-17' -e 'END_DATE=2017-03-10' -e 'INFLUX_HOST_NAME={{HOST}}' -e 'INFLUX_PORT={{PORT}}' localhost:5000/migrator
    docker run -v /opt/migrations/:/migrations -e "START_DATE=2016-01-01" -e "END_DATE=2017-12-30" -e 'INFLUX_HOST_NAME={{IP_ADDRESS}}' -e 'INFLUX_PORT={{PORT}}' localhost:5000/activity_migrator
  6. @Pradnya-Paranjape Pradnya-Paranjape revised this gist Apr 20, 2017. 1 changed file with 1 addition and 1 deletion.
    2 changes: 1 addition & 1 deletion gistfile1.txt
    View file
    Original file line number Diff line number Diff line change
    @@ -1 +1 @@
    docker run -v /opt/migrations/:/migrations -e 'START_DATE=2016-10-17' -e 'END_DATE=2017-03-10' -e 'INFLUX_HOST_NAME={{HOST}}' -e 'INFLUX_PORT={{IP}}' localhost:5000/migrator
    docker run -v /opt/migrations/:/migrations -e 'START_DATE=2016-10-17' -e 'END_DATE=2017-03-10' -e 'INFLUX_HOST_NAME={{HOST}}' -e 'INFLUX_PORT={{PORT}}' localhost:5000/migrator
  7. @Pradnya-Paranjape Pradnya-Paranjape created this gist Apr 20, 2017.
    1 change: 1 addition & 0 deletions gistfile1.txt
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1 @@
    docker run -v /opt/migrations/:/migrations -e 'START_DATE=2016-10-17' -e 'END_DATE=2017-03-10' -e 'INFLUX_HOST_NAME={{HOST}}' -e 'INFLUX_PORT={{IP}}' localhost:5000/migrator