Update of /cvsroot/oscarmcmaster/oscar_mcmaster/web/WEB-INF/classes/src/oscar/oscarLab
In directory sfp-cvsdas-4.v30.ch3.sourceforge.com:/tmp/cvs-serv30350/web/WEB-INF/classes/src/oscar/oscarLab
Modified Files:
FileUploadCheck.java
Log Message:
first pass at removing MD5 class
Index: FileUploadCheck.java
===================================================================
RCS file: /cvsroot/oscarmcmaster/oscar_mcmaster/web/WEB-INF/classes/src/oscar/oscarLab/FileUploadCheck.java,v
retrieving revision 1.16
retrieving revision 1.17
diff -C2 -d -r1.16 -r1.17
*** FileUploadCheck.java 6 Oct 2010 21:52:14 -0000 1.16
--- FileUploadCheck.java 10 Nov 2010 10:36:45 -0000 1.17
***************
*** 1,3 ****
! /**
* Copyright (c) 2001-2002. Department of Family Medicine, McMaster University. All Rights Reserved. *
* This software is published under the GPL GNU General Public License.
--- 1,3 ----
! /**
* Copyright (c) 2001-2002. Department of Family Medicine, McMaster University. All Rights Reserved. *
* This software is published under the GPL GNU General Public License.
***************
*** 34,139 ****
import java.util.Hashtable;
import org.apache.commons.lang.StringEscapeUtils;
import org.oscarehr.util.MiscUtils;
import oscar.oscarDB.DBHandler;
- import oscar.util.MD5;
/**
- *
* @author Jay Gallagher
*/
! public class FileUploadCheck {
! /*
! CREATE TABLE fileUploadCheck (
! id int(10) NOT NULL auto_increment,
! provider_no varchar(6) NOT NULL default '',
! filename varchar(255) NOT NULL default '',
! md5sum varchar(255),
! date_time datetime NOT NULL,
! PRIMARY KEY (id)
! )
! */
!
! public FileUploadCheck() {
! }
!
! public boolean hasFileBeenUploaded(InputStream is){
! String md5sum = getMd5Sum(is);
! return hasFileBeenUploaded(md5sum);
! }
!
!
! public boolean hasFileBeenUploaded(String md5sum){
! boolean hasFileBeenUploaded = false;
! try{
!
! String sql = "select * from fileUploadCheck where md5sum = '"+md5sum+"' ";
! ResultSet rs = DBHandler.GetSQL(sql);
! if(rs.next()){
! hasFileBeenUploaded = true;
! }
! }catch(Exception e){
! MiscUtils.getLogger().error("Error", e);
! }
! return hasFileBeenUploaded;
! }
!
! public String getMd5Sum(InputStream is){
! String md5sum = null;
! try{
! md5sum = MD5.getHashString(is);
! }catch(Exception e){
! MiscUtils.getLogger().error("Error", e);
! }
! return md5sum;
! }
!
! public Hashtable getFileInfo(String md5sum){
! Hashtable fileInfo = new Hashtable();
! try{
!
! String sql = "select * from fileUploadCheck where md5sum = '"+md5sum+"' ";
! ResultSet rs = DBHandler.GetSQL(sql);
! if(rs.next()){
! fileInfo.put("providerNo",oscar.Misc.getString(rs, "provider_no"));
! fileInfo.put("filename", oscar.Misc.getString(rs, "filename"));
! fileInfo.put("md5sum", oscar.Misc.getString(rs, "md5sum"));
! fileInfo.put("dateTime",oscar.Misc.getString(rs, "date_time"));
! }
! }catch(Exception e){
! MiscUtils.getLogger().error("Error", e);
! }
! return fileInfo;
! }
!
!
! public static final int UNSUCCESSFUL_SAVE = -1;
! /**
! *Used to add a new file to the database, checks to see if it already has been added
! */
! public synchronized int addFile(String name, InputStream is,String provider) throws Exception{
! int fileUploaded = UNSUCCESSFUL_SAVE;
! try{
! String md5sum = getMd5Sum(is);
! if(!hasFileBeenUploaded(md5sum)){
!
! String sql = "insert into fileUploadCheck (provider_no,filename,md5sum,date_time) values ('"+provider+"','"+StringEscapeUtils.escapeSql(name)+"','"+md5sum+"',now())";
! MiscUtils.getLogger().debug(sql);
! DBHandler.RunSQL(sql);
! ResultSet rs = DBHandler.GetSQL("SELECT LAST_INSERT_ID() ");
! if(rs.next()){
! fileUploaded= rs.getInt(1) ;
! }
! }
! }catch(SQLException conE){
! MiscUtils.getLogger().error("Error", conE);
! throw new Exception("Database Is not Running");
! }catch(Exception e){
! MiscUtils.getLogger().error("Error", e);
! }
! MiscUtils.getLogger().debug("returning "+fileUploaded);
! return fileUploaded;
! }
!
}
--- 34,114 ----
import java.util.Hashtable;
+ import org.apache.commons.codec.digest.DigestUtils;
+ import org.apache.commons.io.IOUtils;
import org.apache.commons.lang.StringEscapeUtils;
import org.oscarehr.util.MiscUtils;
import oscar.oscarDB.DBHandler;
/**
* @author Jay Gallagher
*/
! public final class FileUploadCheck {
!
! private FileUploadCheck() {
! // no instantiation allowed
! }
!
! private static boolean hasFileBeenUploaded(String md5sum) {
! boolean hasFileBeenUploaded = false;
! try {
!
! String sql = "select * from fileUploadCheck where md5sum = '" + md5sum + "' ";
! ResultSet rs = DBHandler.GetSQL(sql);
! if (rs.next()) {
! hasFileBeenUploaded = true;
! }
! } catch (Exception e) {
! MiscUtils.getLogger().error("Error", e);
! }
! return hasFileBeenUploaded;
! }
!
! public static Hashtable<String, String> getFileInfo(String md5sum) {
! Hashtable<String, String> fileInfo = new Hashtable<String, String>();
! try {
!
! String sql = "select * from fileUploadCheck where md5sum = '" + md5sum + "' ";
! ResultSet rs = DBHandler.GetSQL(sql);
! if (rs.next()) {
! fileInfo.put("providerNo", oscar.Misc.getString(rs, "provider_no"));
! fileInfo.put("filename", oscar.Misc.getString(rs, "filename"));
! fileInfo.put("md5sum", oscar.Misc.getString(rs, "md5sum"));
! fileInfo.put("dateTime", oscar.Misc.getString(rs, "date_time"));
! }
! } catch (Exception e) {
! MiscUtils.getLogger().error("Error", e);
! }
! return fileInfo;
! }
!
! public static final int UNSUCCESSFUL_SAVE = -1;
!
! /**
! *Used to add a new file to the database, checks to see if it already has been added
! */
! public static synchronized int addFile(String name, InputStream is, String provider) throws Exception {
! int fileUploaded = UNSUCCESSFUL_SAVE;
! try {
! String md5sum = DigestUtils.md5Hex(IOUtils.toByteArray(is));
! if (!hasFileBeenUploaded(md5sum)) {
!
! String sql = "insert into fileUploadCheck (provider_no,filename,md5sum,date_time) values ('" + provider + "','" + StringEscapeUtils.escapeSql(name) + "','" + md5sum + "',now())";
! MiscUtils.getLogger().debug(sql);
! DBHandler.RunSQL(sql);
! ResultSet rs = DBHandler.GetSQL("SELECT LAST_INSERT_ID() ");
! if (rs.next()) {
! fileUploaded = rs.getInt(1);
! }
! }
! } catch (SQLException conE) {
! MiscUtils.getLogger().error("Error", conE);
! throw new Exception("Database Is not Running");
! } catch (Exception e) {
! MiscUtils.getLogger().error("Error", e);
! }
! MiscUtils.getLogger().debug("returning " + fileUploaded);
! return fileUploaded;
! }
!
}
|