• Home
• com.mantledillusion.metrics
• trail-metrics-adaptor-jpa
• 2.0.0.BETA1
• source code
• trail_metrics_v1.x-to-v2.0.sql

×

Project download

Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $

You can buy this project and download/modify it how often you want.

upgrade.trail_metrics_v1.x-to-v2.0.sql Maven / Gradle / Ivy

/** Migrate Consumers **/
INSERT INTO trail_consumer (id, consumer_id, correlation_id)
    SELECT id, consumer_id, correlation_id
    FROM metric_trail;

/** Migrate Events **/
INSERT INTO trail_event (id, identifier, time_stamp, time_zone, trail_consumer_id)
    SELECT id, identifier, time_stamp, time_zone, metric_trail_id
    FROM metric;

/** Migrate Measurements **/
INSERT INTO trail_measurement (id, measurement_key, measurement_type, measurement_value, trail_event_id)
    SELECT id, attribute_key, 'STRING', attribute_value, metric_id
    FROM metric_attribute;