dhis2-devs team mailing list archive
-
dhis2-devs team
-
Mailing list archive
-
Message #27646
[Branch ~dhis2-devs-core/dhis2/trunk] Rev 13760: Add more information in log file when to convert fixed attributes to dynamic attributes.
------------------------------------------------------------
revno: 13760
committer: Tran Chau <tran.hispvietnam@xxxxxxxxx>
branch nick: dhis2
timestamp: Fri 2014-01-17 10:52:27 +0700
message:
Add more information in log file when to convert fixed attributes to dynamic attributes.
modified:
dhis-2/dhis-services/dhis-service-patient/src/main/java/org/hisp/dhis/patient/startup/TableAlteror.java
--
lp:dhis2
https://code.launchpad.net/~dhis2-devs-core/dhis2/trunk
Your team DHIS 2 developers is subscribed to branch lp:dhis2.
To unsubscribe from this branch go to https://code.launchpad.net/~dhis2-devs-core/dhis2/trunk/+edit-subscription
=== modified file 'dhis-2/dhis-services/dhis-service-patient/src/main/java/org/hisp/dhis/patient/startup/TableAlteror.java'
--- dhis-2/dhis-services/dhis-service-patient/src/main/java/org/hisp/dhis/patient/startup/TableAlteror.java 2014-01-16 06:21:47 +0000
+++ dhis-2/dhis-services/dhis-service-patient/src/main/java/org/hisp/dhis/patient/startup/TableAlteror.java 2014-01-17 03:52:27 +0000
@@ -509,7 +509,7 @@
// Gender
// ---------------------------------------------------------------------
- log.info( "Inserting dynamic atribute called Gender..." );
+ log.info( "Inserting dynamic atribute called Gender" );
max++;
String uid = CodeGenerator.generateCode();
@@ -525,7 +525,7 @@
log.info( "Inserted Gender attribute successfully." );
- log.info( "Inserting data into Gender attribute..." );
+ log.info( "Inserting data into Gender attribute" );
Integer maxOpt = jdbcTemplate.queryForObject(
"select max(patientattributeoptionid) from patientattributeoption", Integer.class );
@@ -565,7 +565,7 @@
// Death date
// ---------------------------------------------------------------------
- log.info( "Inserting dynamic atribute called Death date..." );
+ log.info( "Inserting dynamic atribute called Death date" );
max++;
uid = CodeGenerator.generateCode();
@@ -578,7 +578,7 @@
+ "','Death date', 'Death date','"
+ PatientAttribute.TYPE_DATE + "', false, false, false)" );
- log.info( "Inserting data into Death date attribute..." );
+ log.info( "Inserting data into Death date attribute" );
executeSql( "INSERT INTO patientattributevalue (patientid, patientattributeid, value ) SELECT patientid,"
+ max + ",deathDate from patient where deathDate is not null" );
@@ -591,7 +591,7 @@
// registrationDate
// ---------------------------------------------------------------------
- log.info( "Inserting dynamic atribute called registration date..." );
+ log.info( "Inserting dynamic atribute called registration date" );
max++;
uid = CodeGenerator.generateCode();
@@ -605,7 +605,7 @@
+ PatientAttribute.TYPE_DATE
+ "', false, false, false)" );
- log.info( "Inserting data into registration date registration date..." );
+ log.info( "Inserting data into registration date registration date" );
executeSql( "INSERT INTO patientattributevalue (patientid, patientattributeid, value ) SELECT patientid,"
+ max + ",registrationDate from patient where registrationDate is not null" );
@@ -618,7 +618,7 @@
// isDead
// ---------------------------------------------------------------------
- log.info( "Inserting dynamic atribute called isDead..." );
+ log.info( "Inserting dynamic atribute called isDead" );
max++;
uid = CodeGenerator.generateCode();
@@ -631,7 +631,7 @@
+ "','Is Dead', 'Is Dead','"
+ PatientAttribute.TYPE_TRACKER_ASSOCIATE + "', false, false, false)" );
- log.info( "Inserting data into isDead..." );
+ log.info( "Inserting data into isDead" );
executeSql( "INSERT INTO patientattributevalue (patientid, patientattributeid, value ) SELECT patientid,"
+ max + ",isDead from patient where isDead is not null" );
@@ -644,7 +644,7 @@
// underAge
// ---------------------------------------------------------------------
- log.info( "Inserting dynamic atribute called underAge..." );
+ log.info( "Inserting dynamic atribute called underAge" );
max++;
uid = CodeGenerator.generateCode();
@@ -657,7 +657,7 @@
+ "','Is under age', 'Is under age','"
+ PatientAttribute.TYPE_TRACKER_ASSOCIATE + "', false, false, false)" );
- log.info( "Inserting data into underAge..." );
+ log.info( "Inserting data into underAge" );
executeSql( "INSERT INTO patientattributevalue (patientid, patientattributeid, value ) SELECT patientid,"
+ max + ",isDead from patient where underAge=true" );
@@ -685,7 +685,7 @@
executeSql( "INSERT INTO patientattributevalue (patientid, patientattributeid, value ) SELECT patientid,"
+ max + ",dobType from patient where dobType is not null" );
- log.info( "Inserting data into DobType ..." );
+ log.info( "Inserting data into DobType" );
maxOpt++;
executeSql( "INSERT INTO patientattributeoption (patientattributeoptionid, name, patientattributeid ) VALUES ('"
@@ -719,7 +719,7 @@
// Birthdate
// -------------------------------------------------------------
- log.info( "Inserting dynamic atribute called Birthdate..." );
+ log.info( "Inserting dynamic atribute called Birthdate" );
max++;
uid = CodeGenerator.generateCode();
@@ -732,7 +732,7 @@
+ "','Birth date', 'Birth date','"
+ PatientAttribute.TYPE_DATE + "', false, false, false)" );
- log.info( "Inserting data into Birthdate ..." );
+ log.info( "Inserting data into Birthdate" );
executeSql( "INSERT INTO patientattributevalue (patientid, patientattributeid, value ) SELECT patientid,"
+ max + ",birthdate from patient where birthdate is not null and dobType in ('D','V') " );
@@ -745,7 +745,7 @@
// Age
// -------------------------------------------------------------
- log.info( "Inserting dynamic atribute called age..." );
+ log.info( "Inserting dynamic atribute called age" );
max++;
uid = CodeGenerator.generateCode();
@@ -758,7 +758,7 @@
+ "','Age', 'Age','"
+ PatientAttribute.TYPE_AGE + "', false, false, false)" );
- log.info( "Inserting data into age ..." );
+ log.info( "Inserting data into age" );
executeSql( "INSERT INTO patientattributevalue (patientid, patientattributeid, value ) SELECT patientid,"
+ max + ",birthdate from patient where birthdate is not null and dobType='A' " );
@@ -771,7 +771,7 @@
// Phone number
// -------------------------------------------------------------
- log.info( "Inserting dynamic atribute called Phone number ..." );
+ log.info( "Inserting dynamic atribute called Phone number" );
max++;
uid = CodeGenerator.generateCode();
@@ -784,7 +784,7 @@
+ "','Phone number', 'Phone number','"
+ PatientAttribute.TYPE_PHONE_NUMBER + "', false, false, false)" );
- log.info( "Inserting data into Phone number ..." );
+ log.info( "Inserting data into Phone number" );
executeSql( "INSERT INTO patientattributevalue (patientid, patientattributeid, value ) SELECT patientid,"
+ max + ",phoneNumber from patient where phoneNumber is not null" );
@@ -805,7 +805,7 @@
// Patient full name
// -------------------------------------------------------------
- log.info( "Inserting dynamic atribute called Full name ..." );
+ log.info( "Inserting dynamic atribute called Full name" );
uid = CodeGenerator.generateCode();
executeSql( "INSERT INTO patientattribute (patientattributeid, uid, lastUpdated, name, description, valueType, mandatory, inherit, displayOnVisitSchedule ) VALUES ("
@@ -817,7 +817,7 @@
+ "','Full name', 'Full name','"
+ PatientAttribute.TYPE_STRING + "', false, false, false)" );
- log.info( "Inserting data into Full name ..." );
+ log.info( "Inserting data into Full name" );
executeSql( "INSERT INTO patientattributevalue (patientid, patientattributeid, value ) SELECT patientid,"
+ max + ",name from patient where name is not null" );
@@ -832,7 +832,7 @@
// User Associate
// -------------------------------------------------------------
- log.info( "Inserting dynamic atribute called Staff ..." );
+ log.info( "Inserting dynamic atribute called Staff" );
uid = CodeGenerator.generateCode();
executeSql( "INSERT INTO patientattribute (patientattributeid, uid, lastUpdated, name, description, valueType, mandatory, inherit, displayOnVisitSchedule ) VALUES ("
@@ -844,7 +844,7 @@
+ "','Staff', 'Staff','"
+ PatientAttribute.TYPE_USERS + "', false, false, false)" );
- log.info( "Inserting data into Staff ..." );
+ log.info( "Inserting data into Staff" );
executeSql( "INSERT INTO patientattributevalue (patientid, patientattributeid, value ) SELECT patientid,"
+ max
@@ -853,18 +853,38 @@
// Update custom entry form
removeFixedAttributeInCustomRegistrationForm( "associate", uid );
- log.info( "Dropping fixed properties of person ..." );
+ log.info( "Dropping fixed properties of person" );
executeSql( "ALTER TABLE patient DROP COLUMN gender" );
+ log.info( "Dropped gender column" );
+
executeSql( "ALTER TABLE patient DROP COLUMN deathDate" );
+ log.info( "Dropped deathDate column" );
+
executeSql( "ALTER TABLE patient DROP COLUMN registrationDate" );
+ log.info( "Dropped registrationdate column" );
+
executeSql( "ALTER TABLE patient DROP COLUMN isDead" );
+ log.info( "Dropped isdead column" );
+
executeSql( "ALTER TABLE patient DROP COLUMN underAge" );
+ log.info( "Dropped underage column" );
+
executeSql( "ALTER TABLE patient DROP COLUMN dobType" );
+ log.info( "Dropped dobType column" );
+
executeSql( "ALTER TABLE patient DROP COLUMN birthdate" );
+ log.info( "Dropped birthdate column" );
+
executeSql( "ALTER TABLE patient DROP COLUMN phoneNumber" );
+ log.info( "Dropped phoneNumber column" );
+
executeSql( "ALTER TABLE patient DROP COLUMN name" );
+ log.info( "Dropped name column" );
+
executeSql( "ALTER TABLE patient DROP COLUMN healthworkerid" );
+ log.info( "Dropped healthworkerid column" );
+
}
}
