It doesn't look too daunting.
I've attached output of:
grep -r mysql local/in/ >~/mysql.txt
I guess most of the work will be in the various DBConnection.java
files. And of course the mysqldump.
I'm off till Wednesday though ...
Cheers
Bob
2009/4/17 Knut Staring <[email protected]>:
> Sunny and Bharath,
> Can you describe exactly what the dependencies on Mysql in India are? I
> remember this was discussed during the workshop, but cannot recall the
> details.
> Knut
>
> 2009/4/16 Lars Helge Øverland <[email protected]>
>>
>>
>> 2009/4/16 Saptarshi Purkayastha <[email protected]>
>>>
>>> We were just discussing this yesterday that it would be good to give
>>> these to the states... but then since Indian modules are directly using
>>> MySQL, it will be sometime until we can use this.
>>
>>
>> OK I see.
>>
>> Is the Indian modules very much depending on MySQL specific functions, or
>> could we rewrite this code to use standard SQL only? If so, the
>> org.hisp.dhis.jdbc.StatementBuilder interface (which gives you SQL
>> statements) could be extended and used here. We have a
>> StatementBuilderFactory in the service-jdbc project which will give you an
>> implementation based on which database you are running. I am happy to help
>> out here if you like.
>>
>>
>>
>>
>>
>> _______________________________________________
>> Mailing list: https://launchpad.net/~dhis2-devs
>> Post to : [email protected]
>> Unsubscribe : https://launchpad.net/~dhis2-devs
>> More help : https://help.launchpad.net/ListHelp
>>
>
>
>
> --
> Cheers,
> Knut Staring
>
> _______________________________________________
> Mailing list: https://launchpad.net/~dhis2-devs
> Post to : [email protected]
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help : https://help.launchpad.net/ListHelp
>
>
local/in/dhis-web-reports-national/src/main/java/org/hisp/dhis/reports/util/DBConnection.java:
if ( s.contains( "jdbc:mysql:" ) )
local/in/dhis-web-reports-national/src/main/java/org/hisp/dhis/reports/util/DBConnection.java:
*
"jdbc:mysql://localhost/"+tempS2[tempS2.length-1].substring(0,
local/in/dhis-web-reports-national/src/main/java/org/hisp/dhis/reports/util/DBConnection.java:
// String urlForConnection = "jdbc:mysql://localhost/jh_dhis2";
local/in/dhis-web-reports-national/src/main/java/org/hisp/dhis/reports/util/DBConnection.java:
Class.forName( "com.mysql.jdbc.Driver" ).newInstance();
local/in/dhis-web-mobile/pom.xml: <groupId>mysql</groupId>
local/in/dhis-web-mobile/pom.xml:
<artifactId>mysql-connector-java</artifactId>
local/in/dhis-web-dashboard/src/main/resources/xwork.xml: <param
name="page">/dhis-web-dashboard/mysqlPathConfuration.vm</param>
local/in/dhis-web-dashboard/src/main/webapp/dhis-web-dashboard/mysqlPathConfuration.vm:
<input type="text" id="mysqlPath" name="mysqlPath"
size="60" value="$!mysqlPath" onchange="javscript:formatPath(this);"
onload="javscript:formatPath(this);" />
local/in/dhis-web-dashboard/src/main/java/org/hisp/dhis/dashboard/util/DBConnection.java:
if ( s.contains( "jdbc:mysql:" ) )
local/in/dhis-web-dashboard/src/main/java/org/hisp/dhis/dashboard/util/DBConnection.java:
*
"jdbc:mysql://localhost/"+tempS2[tempS2.length-1].substring(0,
local/in/dhis-web-dashboard/src/main/java/org/hisp/dhis/dashboard/util/DBConnection.java:
// String urlForConnection = "jdbc:mysql://localhost/jh_dhis2";
local/in/dhis-web-dashboard/src/main/java/org/hisp/dhis/dashboard/util/DBConnection.java:
Class.forName( "com.mysql.jdbc.Driver" ).newInstance();
local/in/dhis-web-dashboard/src/main/java/org/hisp/dhis/dashboard/util/MaintenanceIN.java:
public static final String KEY_MYSQLPATH = "mysqlpath";
local/in/dhis-web-dashboard/src/main/java/org/hisp/dhis/dashboard/util/MaintenanceIN.java:
public static final String MYSQL_DEFAULT_PATH = "C:/DHIS2/mysql/bin";
local/in/dhis-web-dashboard/src/main/java/org/hisp/dhis/dashboard/util/DashBoardService.java:
String mysqlPath = null;
local/in/dhis-web-dashboard/src/main/java/org/hisp/dhis/dashboard/util/DashBoardService.java:
mysqlPath = rs1.getString( 1 );
local/in/dhis-web-dashboard/src/main/java/org/hisp/dhis/dashboard/util/DashBoardService.java:
return mysqlPath;
local/in/dhis-web-dashboard/src/main/java/org/hisp/dhis/dashboard/util/DashBoardService.java:
String mysqlKey = null;
local/in/dhis-web-dashboard/src/main/java/org/hisp/dhis/dashboard/util/DashBoardService.java:
String mysqlPath = null;
local/in/dhis-web-dashboard/src/main/java/org/hisp/dhis/dashboard/util/DashBoardService.java:
mysqlKey = rs1.getString( 1 );
local/in/dhis-web-dashboard/src/main/java/org/hisp/dhis/dashboard/util/DashBoardService.java:
mysqlPath = rs1.getString( 2 );
local/in/dhis-web-dashboard/src/main/java/org/hisp/dhis/dashboard/util/DashBoardService.java:
if( mysqlKey == null )
local/in/dhis-web-dashboard/src/main/java/org/hisp/dhis/dashboard/util/DashBoardService.java:
mysqlKey = MaintenanceIN.KEY_MYSQLPATH;
local/in/dhis-web-dashboard/src/main/java/org/hisp/dhis/dashboard/util/DashBoardService.java:
mysqlPath = dbPath;
local/in/dhis-web-dashboard/src/main/java/org/hisp/dhis/dashboard/util/DashBoardService.java:
query = "INSERT INTO maintenancein VALUES
('"+mysqlKey+"','"+mysqlPath+"')";
local/in/dhis-web-dashboard/src/main/java/org/hisp/dhis/dashboard/util/DashBoardService.java:
mysqlPath = dbPath;
local/in/dhis-web-dashboard/src/main/java/org/hisp/dhis/dashboard/util/DashBoardService.java:
query = "UPDATE maintenancein SET mvalue = '"+ mysqlPath +"'
WHERE mkey LIKE '"+ MaintenanceIN.KEY_MYSQLPATH +"'";
local/in/dhis-web-dashboard/src/main/java/org/hisp/dhis/dashboard/util/DashBoardService.java:
String mysqlKey = null;
local/in/dhis-web-dashboard/src/main/java/org/hisp/dhis/dashboard/util/DashBoardService.java:
String mysqlPath = null;
local/in/dhis-web-dashboard/src/main/java/org/hisp/dhis/dashboard/util/DashBoardService.java:
mysqlKey = rs1.getString( 1 );
local/in/dhis-web-dashboard/src/main/java/org/hisp/dhis/dashboard/util/DashBoardService.java:
mysqlPath = rs1.getString( 2 );
local/in/dhis-web-dashboard/src/main/java/org/hisp/dhis/dashboard/util/DashBoardService.java:
if( mysqlKey == null )
local/in/dhis-web-dashboard/src/main/java/org/hisp/dhis/dashboard/util/DashBoardService.java:
mysqlKey = MaintenanceIN.KEY_MYSQLPATH;
local/in/dhis-web-dashboard/src/main/java/org/hisp/dhis/dashboard/util/DashBoardService.java:
mysqlPath = path;
local/in/dhis-web-dashboard/src/main/java/org/hisp/dhis/dashboard/util/DashBoardService.java:
query = "INSERT INTO maintenancein VALUES
('"+mysqlKey+"','"+mysqlPath+"')";
local/in/dhis-web-dashboard/src/main/java/org/hisp/dhis/dashboard/util/DashBoardService.java:
else if( mysqlPath == null || mysqlPath.trim().equals( "" ) )
local/in/dhis-web-dashboard/src/main/java/org/hisp/dhis/dashboard/util/DashBoardService.java:
mysqlPath = path;
local/in/dhis-web-dashboard/src/main/java/org/hisp/dhis/dashboard/util/DashBoardService.java:
query = "UPDATE maintenancein SET mvalue = '"+ mysqlPath +"'
WHERE mkey LIKE '"+ MaintenanceIN.KEY_MYSQLPATH +"'";
local/in/dhis-web-dashboard/src/main/java/org/hisp/dhis/dashboard/util/DashBoardService.java:
return mysqlPath;
local/in/dhis-web-dashboard/src/main/java/org/hisp/dhis/dashboard/maintenance/action/InConfigurationsFormAction.java:
private String mysqlPath;
local/in/dhis-web-dashboard/src/main/java/org/hisp/dhis/dashboard/maintenance/action/InConfigurationsFormAction.java:
return mysqlPath;
local/in/dhis-web-dashboard/src/main/java/org/hisp/dhis/dashboard/maintenance/action/InConfigurationsFormAction.java:
mysqlPath = dashBoardService.getMYSqlPath();
local/in/dhis-web-dashboard/src/main/java/org/hisp/dhis/dashboard/maintenance/action/InConfigurationsFormAction.java:
if( mysqlPath == null )
local/in/dhis-web-dashboard/src/main/java/org/hisp/dhis/dashboard/maintenance/action/InConfigurationsFormAction.java:
mysqlPath = dashBoardService.setMYSqlDefaultPath(
MaintenanceIN.MYSQL_DEFAULT_PATH );
local/in/dhis-web-dashboard/src/main/java/org/hisp/dhis/dashboard/maintenance/action/InConfigurationsResultAction.java:
private String mysqlPath;
local/in/dhis-web-dashboard/src/main/java/org/hisp/dhis/dashboard/maintenance/action/InConfigurationsResultAction.java:
public void setMysqlPath( String mysqlPath )
local/in/dhis-web-dashboard/src/main/java/org/hisp/dhis/dashboard/maintenance/action/InConfigurationsResultAction.java:
this.mysqlPath = mysqlPath;
local/in/dhis-web-dashboard/src/main/java/org/hisp/dhis/dashboard/maintenance/action/InConfigurationsResultAction.java:
dashBoardService.setUserdefinedConfigurations( mysqlPath, rootDataPath
);
local/in/dhis-web-dashboard/src/main/java/org/hisp/dhis/dashboard/maintenance/action/TakeMySqlBackupAction.java:
backupCommand = mySqlPath + "mysqldump -u "+ userName +" "+
dbName +" -r "+backupFilePath;
local/in/dhis-web-dashboard/src/main/java/org/hisp/dhis/dashboard/maintenance/action/TakeMySqlBackupAction.java:
backupCommand = mySqlPath + "mysqldump -u "+ userName +" -p"+
password +" "+ dbName +" -r "+backupFilePath;
local/in/dhis-web-dataentry-linelisting/src/main/java/org/hisp/dhis/den/util/DBConnection.java:
if ( s.contains( "jdbc:mysql:" ) )
local/in/dhis-web-dataentry-linelisting/src/main/java/org/hisp/dhis/den/util/DBConnection.java:
*
"jdbc:mysql://localhost/"+tempS2[tempS2.length-1].substring(0,
local/in/dhis-web-dataentry-linelisting/src/main/java/org/hisp/dhis/den/util/DBConnection.java:
// String urlForConnection = "jdbc:mysql://localhost/jh_dhis2";
local/in/dhis-web-dataentry-linelisting/src/main/java/org/hisp/dhis/den/util/DBConnection.java:
Class.forName( "com.mysql.jdbc.Driver" ).newInstance();
_______________________________________________
Mailing list: https://launchpad.net/~dhis2-devs
Post to : [email protected]
Unsubscribe : https://launchpad.net/~dhis2-devs
More help : https://help.launchpad.net/ListHelp
