dhis2-devs team mailing list archive

[Bob Jolliffe <bobjolliffe@xxxxxxxxx>]

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 <knutst@xxxxxxxxx>:
> 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 <larshelge@xxxxxxxxx>
>>
>>
>> 2009/4/16 Saptarshi Purkayastha <sunbiz@xxxxxxxxx>
>>>
>>> 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     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
>> 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     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
> 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();