Project - Modernize Database

brady.miller · March 19, 2020, 5:12am

hi @Gaurav_Kumar and welcome to the OpenEMR project!

Check out the following thread for general starting points on getting involved in the community on github:
OpenEMR is participating in Google Summer of Code 2020!

For this project, a good starting point would be to see what happens (ie. what breaks) when adding back default sql_mode settings during the installation:

github.com

openemr/openemr/blob/master/library/classes/Installer.class.php#L705


    } else {
        $dbh = mysqli_connect($server, $user, $password, $dbname, $port);
    }


    return $dbh;
}


private function set_sql_strict()
{
    // Turn off STRICT SQL
    return $this->execute_sql("SET sql_mode = ''");
}


private function set_collation()
{
    if ($this->collate) {
        return $this->execute_sql("SET NAMES 'utf8'");
    }


    return true;
}