Scribd
Upload
10 views

SQL Queries For Test

sql queries

Uploaded by

bhaskarascribe
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd
10 views

SQL Queries For Test

sql queries

Uploaded by

bhaskarascribe
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd
You are on page 1/ 4

URL -35.200.164.

184
port -3306
user-test_read
password-test_read

SELECT * FROM cardiotrack_test.patient order by created_on desc;

SELECT count(*) FROM cardiotrack_test.patient where cardiotrack_version =


'C8FD195691F1'order by created_on desc;

SELECT * FROM cardiotrack_test.cardiotrack_device_tbl where


cardiotrack_device_id='ME18ABB005';

select
id,name,age,gender,waist,abdomen,chest,hip,height,bmi,body_fat,bone_mass,muscle_mas
s,body_water,waist_hip_ratio,waist_height_ratio FROM cardiotrack_test.patient
where id = 'CLI015@143@19420193242849252';

select
id,name,age,gender,waist,abdomen,chest,hip,height,bmi,body_fat,bone_mass,muscle_mas
s,body_water,waist_hip_ratio,waist_height_ratio FROM cardiotrack_test.patient
where id = 'CLI015@143@184201919283668527';

select
id,name,age,gender,waist,abdomen,chest,hip,height,bmi,body_fat,bone_mass,muscle_mas
s,body_water,waist_hip_ratio,waist_height_ratio FROM cardiotrack_test.patient
where id = 'CLI015@143@184201910493468887';

cans in latest version - 1.26


select * FROM cardiotrack_test.patient where id ='CLI015@143@23420191441581664';

select count(*) FROM cardiotrack_test.file_content where file_name like


'CLI01808@1@9520191415617742%';
get file count of files uploaded.
SELECT count(*) FROM cardiotrack_test.specialist_patient_table where pat_uid like
'CLI01808@1@9520191415617742%';

describe cardiotrack_test.patient;

select
id,name,age,gender,waist,abdomen,chest,hip,height,bmi,body_fat,bone_mass,muscle_mas
s,body_water,waist_hip_ratio,waist_height_ratio FROM cardiotrack_test.patient
where id = 'CLI015@143@234201914515734094';

ver -1.27

select * FROM cardiotrack_test.patient where id ='CLI01808@1@2642019182676252';


select * FROM cardiotrack_test.patient where id like
'CLI01808@1@205201915134443284%';

select * FROM cardiotrack_test.patient where id like


'CLI015@143@23420191441581664%';
select count(*) FROM cardiotrack_test.file_content where file_name like
'CLI01808@1@115201915372410009%';
SELECT count(*) FROM cardiotrack_test.specialist_patient_table where pat_uid like
'CLI01808@1@9520191415617742%';
select * FROM cardiotrack_test.patient where id like
'CLI01791@1@105201915165226196%';

select count(*) FROM cardiotrack_test.file_content where file_name like


'CLI01791@1@105201915165226196%';

select * FROM cardiotrack_test.file_content where file_name like


'CLI01791@1@105201915165226196%';

SELECT count(*) FROM cardiotrack_test.specialist_patient_table where pat_uid like


'CLI01791@1@105201915165226196%';

SELECT * FROM cardiotrack_test.specialist_patient_table where pat_uid like


'pat031@2019051302560039614491%';

SELECT * FROM cardiotrack_test.ct_patient where patientId like


'pat031@2019051302524924426238%';

select count(*) FROM cardiotrack_test.file_content where file_name like


'pat031@2019051302524924426238%';

select * FROM cardiotrack_test.file_content where file_name like


'pat031@2019051302524924426238%';

SELECT count(*) FROM cardiotrack_test.specialist_patient_table where pat_uid like


'pat031@2019051302524924426238%';

SELECT * FROM cardiotrack_test.specialist_patient_table where pat_uid like


'pat031@2019051302524924426238%';

select * FROM cardiotrack_test.patient where id like


'CLI01791@1@165201917151552013%';

select count(*) FROM cardiotrack_test.file_content where file_name like


'CLI01791@1@165201917151552013%';

select * FROM cardiotrack_test.file_content where file_name like


'CLI01791@1@165201917151552013%';

SELECT * FROM cardiotrack_test.specialist_patient_table where pat_uid like


'CLI01791@1@165201917151552013%';

select * FROM cardiotrack_test.patient where id like


'CLI01793@7@76201915283559013%';

select count(*) FROM cardiotrack_test.file_content where file_name like


'CLI01793@7@76201915283559013%';

select * FROM cardiotrack_test.file_content where file_name like


'CLI01793@7@76201915283559013%';
SELECT * FROM cardiotrack_test.specialist_patient_table where pat_uid like
'CLI01793@7@76201915283559013%';

select * FROM cardiotrack_test.patient where id like


'CLI01793@7@76201915133919240%';

select count(*) FROM cardiotrack_test.file_content where file_name like


'CLI01793@7@76201915133919240%';

select * FROM cardiotrack_test.file_content where file_name like


'CLI01793@7@76201915133919240%';

SELECT * FROM cardiotrack_test.specialist_patient_table where pat_uid like


'CLI01793@7@76201915133919240%';

fetching data for ME90 capturing the device id

select * FROM cardiotrack_test.patient where id like


'CLI01807@3@126201910344834581%';

'CLI01807@3@126201910344834581', 'Test Samsung 9 Ver 28 Jio Fix', '55', 'Female',


'2019-06-12 10:34:51', 'Active', '', '', '', '2', '100', '180', '55', '49', '65',
'Positive', 'Positive', '16', '', 'T_1.34', 'D43639DAC83D', '356650102221506',
'5575866866', '1905160179314550', 'DegC', 'Random Blood Glucose', '144',
'Positive', 'Hypertensive Crisis', 'Positive', 'Positive', 'N', NULL, '159', '',
'2019-06-12 05:05:51', '1', 'N', 'Y', 'U', '65', '45', '130', '45', '195', '17.09',
'27.76', '18.74', '72.24', '53.5', '1.44', '0.33'

select count(*) FROM cardiotrack_test.file_content where file_name like


'CLI01807@3@126201910344834581%';

select * FROM cardiotrack_test.file_content where file_name like


'CLI01807@3@126201910344834581%';

# id, file_name, createdon, heart_rate, P_Wave, PR_Segment, PR_Interval,


QRS_Complex, ST_Segment, T_Wave, QT_Interval, QTc_Interval, RR_Interval,
heart_rate_msg, hr_msg_time, QRS_Axis
'435278', 'CLI01807@3@126201910344834581_001.dat', '2019-06-12 10:35:44', '77',
'0', '0', '0', '0', '0', '0', '0', '0', '0', 'ME90', '2019-06-12 10:35:44', ''

SELECT * FROM cardiotrack_test.specialist_patient_table where pat_uid like


'CLI01807@3@126201910344834581%';

# register_id, fname, lname, age, gender, mob_no, email_id, pat_uid, file_name,


push_token, zoom_id, zoom_token, status, concerned_doc, severity, refered_doc_id,
reffered_doc_name, timestamp, request_type, opinion_given_by, upd_time
'4738', 'Test Samsung 9 Ver 28 Jio Fix', 'NA', '55', 'Female', '5575866866', NULL,
'CLI01807@3@126201910344834581', NULL, NULL, NULL, NULL, '~Otherwise normal ECG',
'DOC001', 'Severe', 'CLI01807', 'Bhaskar l', '2019-06-12 05:06:04', 'M', 'DOC001',
'2019-06-12 05:10:06'
scan id -126201910502414626

select * FROM cardiotrack_test.patient where id like


'CLI01807@3@126201910502414626%';

# id, name, age, gender, created_on, status, pdesc, p_email, p_image, lead_type,
p_spo2, p_bp_systalic, p_bp_diastalic, p_teperature, p_body_weight,
p_malaria_test_result, p_hiv_test_result, p_haemoglobin_measurement, p_symptoms,
app_version, cardiotrack_version, android_id, patient_mobile, patient_citzen_id,
temprature_type, blood_sugar_type, blood_sugar, diabetes_test, hypertension_result,
obesity, smoker, cardiologs_status, location, cholesterol, doctor_name,
system_timestamp, total_number_of_file, cardioAI_status, ecg_closed_properly,
zipstatus, waist, abdomen, chest, hip, height, bmi, body_fat, bone_mass,
muscle_mass, body_water, waist_hip_ratio, waist_height_ratio
'CLI01807@3@126201910502414626', 'Test Me90 Android 9 Ver 34', '58', 'Male',
'2019-06-12 10:51:55', 'Active', '', '', '', '2', '99', '180', '80', '49', '85',
'Negative', 'Negative', '14', '1 Fatigue or confusion. 2 Blood in the urine. 3
Pain, numbness, weakness or coldness in the legs or arms', 'T_1.34',
'D43639DAC83D', '356650102221506', '5856958669', '1906120180710502', 'DegC',
'Fasting Blood Glucose', 'low', 'Negative', 'Hypertension Stage 1', 'Negative',
'Negative', 'N', NULL, 'low', '', '2019-06-12 05:23:00', '1', 'N', 'Y', 'U', '52',
'52', '150', '52', '165', '31.22', '34.61', '14.29', '65.39', '51.1', '1', '0.32'

select count(*) FROM cardiotrack_test.file_content where file_name like


'CLI01807@3@126201910502414626%';
select * FROM cardiotrack_test.file_content where file_name like
'CLI01807@3@126201910502414626%';
# id, file_name, createdon, heart_rate, P_Wave, PR_Segment, PR_Interval,
QRS_Complex, ST_Segment, T_Wave, QT_Interval, QTc_Interval, RR_Interval,
heart_rate_msg, hr_msg_time, QRS_Axis
'435279', 'CLI01807@3@126201910502414626_001.dat', '2019-06-12 10:52:55', '73',
'0', '0', '0', '0', '0', '0', '0', '0', '0', 'ME90', '2019-06-12 10:52:55', ''

SELECT * FROM cardiotrack_test.specialist_patient_table where pat_uid like


'CLI01807@3@126201910502414626%';
# register_id, fname, lname, age, gender, mob_no, email_id, pat_uid, file_name,
push_token, zoom_id, zoom_token, status, concerned_doc, severity, refered_doc_id,
reffered_doc_name, timestamp, request_type, opinion_given_by, upd_time
'4739', 'Test Me90 Android 9 Ver 34', 'NA', '58', 'Male', '5856958669', NULL,
'CLI01807@3@126201910502414626', NULL, NULL, NULL, NULL, 'Under Processing',
'DOC024', 'Pending', 'CLI01807', 'Bhaskar l', '2019-06-12 05:35:36', 'M', NULL,
'2019-06-12 05:35:37'

126201910502414626
126201910564856993
126201910582051316
126201910593316377
12620191104717794

You might also like