load-tickets
/
Y
N
0.0
0.0
10000
50
50
N
Y
50000
Y
N
1000
-
2010/12/17 19:43:20.254
redmine FROM
127.0.0.1
MYSQL
Native
redmine_dev
3306
redmine
Encrypted 2be98afc86aa7f2e4cb0bab74d39ba1df
EXTRA_OPTION_MYSQL.defaultFetchSize
500
EXTRA_OPTION_MYSQL.useCursorFetch
true
FORCE_IDENTIFIERS_TO_LOWERCASE
N
FORCE_IDENTIFIERS_TO_UPPERCASE
N
IS_CLUSTERED
N
PORT_NUMBER
3306
QUOTE_ALL_FIELDS
N
STREAM_RESULTS
Y
SUPPORTS_BOOLEAN_DATA_TYPE
N
USE_POOLING
N
redmine MIGRATE
127.0.0.1
MYSQL
Native
redmine_migrate
3306
redmine
Encrypted 2be98afc86aa7f2e4cb0bab74d39ba1df
EXTRA_OPTION_MYSQL.defaultFetchSize
500
EXTRA_OPTION_MYSQL.useCursorFetch
true
FORCE_IDENTIFIERS_TO_LOWERCASE
N
FORCE_IDENTIFIERS_TO_UPPERCASE
N
IS_CLUSTERED
N
PORT_NUMBER
3306
QUOTE_ALL_FIELDS
N
STREAM_RESULTS
Y
SUPPORTS_BOOLEAN_DATA_TYPE
N
USE_POOLING
N
redmine TO
127.0.0.1
MYSQL
Native
redmine_sup
3306
redmine
Encrypted 2be98afc86aa7f2e4cb0bab74d39ba1df
EXTRA_OPTION_MYSQL.defaultFetchSize
500
EXTRA_OPTION_MYSQL.useCursorFetch
true
FORCE_IDENTIFIERS_TO_LOWERCASE
N
FORCE_IDENTIFIERS_TO_UPPERCASE
N
IS_CLUSTERED
N
PORT_NUMBER
3306
QUOTE_ALL_FIELDS
N
STREAM_RESULTS
Y
SUPPORTS_BOOLEAN_DATA_TYPE
N
USE_POOLING
N
input tickets author lookup Y author lookup assignee lookup Y assignee lookup ticket output Y ticket output from_to table output Y from_to table output Execute SQL script Y
Execute SQL script
ExecSQL
Y
1
none
redmine TO
Y
Y
update issues set root_id = id where id = ?
id_to
422
586
Y
assignee lookup
DBLookup
Y
1
none
redmine MIGRATE
N
N
0
N
N
assigned_to_id_from
id_from
=
id_to
assigned_to_id
5
Integer
422
318
Y
author lookup
DBLookup
Y
1
none
redmine MIGRATE
N
N
0
N
N
author_id_from
id_from
=
id_to
author_id
5
Integer
419
224
Y
from_to table output
TableOutput
Y
1
none
redmine MIGRATE
1000
Y
N
Y
Y
N
N
Y
N
Y
N
id_from
id_from
id_to
id_to
423
489
Y
input tickets
TableInput
Y
1
none
redmine FROM
SELECT
id as id_from
, case tracker_id when 1 then 3 else 1 end as tracker_id
, 4 as project_id
, subject
, description
, due_date
, null as category_id
, case status_id when 8 then 7 else status_id end as status_id
, assigned_to_id as assigned_to_id_from
, priority_id
, null as fixed_version_id
, author_id as author_id_from
, lock_version
, created_on
, updated_on
, start_date
, done_ratio
, estimated_hours
, parent_id
, null as root_id
, lft
, rgt
FROM issues
where project_id = 3
0
N
N
N
417
127
Y
ticket output
TableOutput
Y
1
none
redmine TO
1000
N
N
N
Y
N
N
Y
N
Y
Y
id_to
tracker_id
tracker_id
project_id
project_id
subject
subject
description
description
due_date
due_date
category_id
category_id
status_id
status_id
priority_id
priority_id
fixed_version_id
fixed_version_id
lock_version
lock_version
created_on
created_on
updated_on
updated_on
start_date
start_date
done_ratio
done_ratio
estimated_hours
estimated_hours
parent_id
parent_id
root_id
root_id
lft
lft
rgt
rgt
author_id
author_id
assigned_to_id
assigned_to_id
423
408
Y
N