Product Idea : Universal Hub for Patient Medical Records – UHPMR

 Idealist: D.R. Vijaykumar
Draft: Version 0.1

Why?
So far, Healthcare industry has been slow to adapt to a technology. Thus, the current healthcare ecosystem comprises in information systems that lack data security, interoperability, standardisation, sharing, collaborating and trust.

Who will do?
    This should avoid if a Single system handles the Patient Medical Records universally to storing all his Records electronically into a CENTRALIZED ARSENAL “CR” like Youtube for videos, which are imperative for seamless health information exchange to any System himself has a talking/collaborating facility and completely handle by Patient only only only.

To Whom?
Let’s begin with a Story!
A boy named Kumar from a South Indian middle class family, he lived with his parents. His father used to collect all his Son used items, photos, videos, dresses and all activities at each and every stage including his son’s school bills rather than medical records as a part of memories, When I asked his father, Why are you keeping school bills?, He replied with caution, School bills may useful if the school says, you didn’t pay your son tuition fees and he pointed out with smile, Not only to me!, most of the families are doing the same. Days went and I started watching his family activities, noted one thing and realize they didn’t keep the medical records as a part of activities.
Every time he took his son Mr. Kumar to the hospital whether Minor/Major problems. They will go like the first time visitor, because he doesn’t keep the medical records in their hand. He gave less important to his son medical records until his son diagnosed with unknown disease. A good doctor named Vijay, stepped into his son problem to analyse when it starts, initially he don’t have clue and faced many problems, Such as
•    When he faced similar kind of problems.
•    Which Physician or Hospital he visits.
•    What Doctors prescribed.
•    What course he went.
•    After what other medical issues faced in-between.
•    Is this a genetically inherited.  
•    Even well educated person will ignore the prescriptions prescribed by doctors on minor problems like cold, cough, headache, rashes, but they don’t aware even a headache is the symptoms for brain cancer and it can route to death.
At last a Good Doctor finds the reason that it is a “genetically inherited” which he got it from his own Mother where she passed away when he was kid. Unfortunately his son died, I was deeply saddened and want to know what happened to him, so I can build Software to overcome these situations between patient and doctor. So I personally contact the Good Doctor and discussed, here are the points he furnished with emotions.
As I am a Doctor, My duty is to cure all patients whoever visiting to our hospital. So we created a healthy ecosystem to give natural immune power to patients. Also we build Software where we can store all the Patient information’s and his visiting histories. But WE LAGGING AND LACKING to get all information’s about Patients. Even though Healthcare industry has grown far, still I am facing a problem, such as.
•    Only I can access the patient information which is stored in my Hospital Database.
#. But that is not sufficient to start prescribing a medicines to patient, because we cannot assure the patient is always visiting our hospital only.

•    Now Hospital Software systems are improved and its starts collaborating between Hospitals to share the Patient Medical Information based on the Patient request and consent approval.
#. But anytime the hospital himself can withdraw the sharing features, because it is not legalize yet.
#. They cannot serve, due to technical failure and it will impact when patient is in urgent.
#. Any changes from either a side will impact the smooth transition of PMR “Patient Medical Record”.
•    Even though Technology has helped the healthcare ecosystem to optimise these complex workflows by connecting the various stakeholders and providing real-time information that helps in delivering enhanced patient care.
#. But still all above problem exists.



What I “CR” do?    
    CENTRALIZED ARSENAL is the only solution where a Patient can keep his/her Medical Records electronically at one place.
•    Patients can upload his PMR at any time anywhere at any point and order it into right folder.
•    Patient can re-order the records at his/her convenient.
•    Global Internal SEO will make sure the patient can filter or search the records at any point.
•    Hospital can push the record via multiple channels to this centralized arsenal after patient consent.
•    No expiry for the records stored inside centralized arsenal.
•    Patient can directly share his MR “Medical Record” to doctor/hospital who installed the same UHPMR app or via web browsers.
•    It will be secure and not allowing Doctor to download.
•    Patient only can download or delete the PMR on his/her records.
•    Patient itself can set the expiry DT while sharing to doctor app.
•    Patient can revert at any time and no need to wait until the expiry DT set previously.


More Points will add @Draft V0.2

Ubuntu - Maven - SSL Error while doing mvn clean install

sudo dpkg --purge --force-depends ca-certificates-java sudo apt-get install ca-certificates-java sudo update-ca-certificates -f

Java Contains Byte String - Back to Original Content String from Byte Array String

Code

String str = "hello";
byte [] x = str.getBytes ();
System.out.println ( new String (x) );
String byStr = "104, 101, 108, 108, 111";
String a [] = byStr.split ( "," );
byte xx [] = new byte[a.length];
int count = 0;
for ( String s :  a)
{
xx[count++] = Byte.parseByte ( s.trim () );
}
System.out.println ( new String (xx) );

Output

hello

hello

Python AutoBot - ChatterBot Plugin

 >install python 3.8

> create your app folder

> pip or pip3 install  chatterbot
> pip or pip3 install   chatterbot-corpus

>Program mychat.py

from chatterbot import ChatBot
from chatterbot.trainers import ListTrainer

# Create a new chat bot named ArsenaliT
chatbot = ChatBot('ArsenaliT')

trainer = ListTrainer(chatbot)

trainer.train([
    "Hi",
    "Hi, can I help you?",
    "Sure, I'd like to book a flight to Iceland.",
    "Your flight has been booked."
])

user = "hi";
print("User : ", user)
response = chatbot.get_response(user)
print("Bot : ", response)

user = "I'd like to book a flight ";
print("User : ", user)
response = chatbot.get_response(user)
print("Bot : ", response)

> OUTPUT

User :  hi
Bot :  Hope you are safe and good
User :  I'd like to book a flight
Bot :  Your flight has been booked.

ENJOY

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) [ERROR] [MY-010187] [Server] Could not open file '/var/log/mysql/error.log' for error logging: Permission denied

    sudo rm /var/log/mysqld.log
    systemctl reload apparmor
    touch /var/log/mysqld.log
    chown mysql:mysql /var/log/mysqld.log
    chmod 0644 /var/log/mysqld.log
    systemctl restart mysql

Mysql : replace special characters or any words in perticular column in UPDATE statement

Replace # symbol with empty in the given column.
 

SET SQL_SAFE_UPDATES = 0;

update table_name set col_name = replace (col_name,'#','');

Install HP Printer in Ubuntu 20.04

Goto https://developers.hp.com/hp-linux-imaging-and-printing/gethplip
download the hplib with for your OS.

> cd /home/drvijay/Downloads/

> sudo chmod +x hplip-3.20.6.run
> ./hplip-3.20.6.run

or

> sudo apt install hplip-gui

#if any error, then below command will fix

> sudo apt install $(echo $(apt-cache search hplip | sed 's/ - .*$//g'))


















windows key -> type -> hp tool box

MySQL - Linux Ubuntu Environemnt - which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

please see one of the step will work

Step-1
In your mysql benchmark

SET GLOBAL sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''));

Restart your mysql service.
> service mysql restart

OR

Step-2

In Linux Terminal > sudo vi /etc/mysql/mysql.conf.d/mysqld.cnf Go to last line and add > sql_mode = "" Restart mysql server.
> service mysql restart

Failed to configure SaslClientAuthenticator Caused by: org.apache.kafka.common.KafkaException: Principal could not be determined from Subject, this may be a transient failure due to Kerberos re-login

#php
sasl.mechanisms = PLAIN

#java
//sasl.mechanism = java

props.put ( "ssl.endpoint.identification.algorithm","https");                  
props.put ( "sasl.jaas.config", "org.apache.kafka.common.security.plain.PlainLoginModule required serviceName=\"kafka\" username=\"XX\" password=\"xxx\";" );
props.put ( "sasl.mechanism", "PLAIN" );                //if it is java sasl.mechanism, for php = sasl.mechanisms

Spring Boot Hibernate 5 com.zaxxer.hikari.pool. active Connection is not Release

1. maxpoolsize = 100
2. idle time out = reduced to 10 seconds
3. save method in repo/services classes should close in entityManager
close in finally block {}
4. also told spring to use hibernate5.SpringContext in application.properties

 
4th application.properties
spring.datasource.hikari.leak-detection-threshold=10000
spring.jpa.properties.hibernate.current_session_context_class=org.springframework.orm.hibernate5.SpringSessionContext

1 & 2 in HikariPool Datasource settings

url=xxx
username=xx
password=xx
driverClassName=com.mysql.jdbc.Driver
connectionTimeout=30000
maxPoolSize=100
idleTimeout=10000
minIdle=10
poolName=xxxdb-connection-pool


3rd - EntityManager Connection close
 EntityManager entityManager = entityManagerFactory.createEntityManager ();
        try
        {
            if ( entityManager != null )
            {
                entityManager.getTransaction ().begin ();
                entityManager.merge ( xxx );
                entityManager.getTransaction ().commit ();
            }
        }
        catch ( Exception e )
        {
            System.out.println ( e.getMessage () );
        }
        finally
        {
            if ( entityManager != null )
            {
                entityManager.close ();
            }
        }