def test_reload(session):
from mixer.backend.sqlalchemy import Mixer
mixer = Mixer(session=session, commit=True)
u1 = mixer.blend(User)
u1.name = 'wrong name'
u2 = mixer.reload(u1)
assert u2 == u1
assert u2.name != 'wrong name'
def test_reload(session):
from mixer.backend.sqlalchemy import Mixer
mixer = Mixer(session=session, commit=True)
u1 = mixer.blend(User)
u1.name = 'wrong name'
u2 = mixer.reload(u1)
assert u2 == u1
assert u2.name != 'wrong name'
def test_postgresql():
from mixer.backend.sqlalchemy import TypeMixer
from sqlalchemy.dialects.postgresql import UUID
base = declarative_base()
class Test(base):
__tablename__ = 'test'
id = Column(Integer, primary_key=True)
uuid = Column(UUID, nullable=False)
mixer = TypeMixer(Test)
test = mixer.blend()
assert test.uuid
def test_postgresql():
from mixer.backend.sqlalchemy import TypeMixer
from sqlalchemy.dialects.postgresql import UUID
base = declarative_base()
class Test(base):
__tablename__ = 'test'
id = Column(Integer, primary_key=True)
uuid = Column(UUID, nullable=False)
mixer = TypeMixer(Test)
test = mixer.blend()
assert test.uuid
def test_random():
from mixer.backend.sqlalchemy import mixer
values = ('mixer', 'is', 'fun')
user = mixer.blend(User, name=mixer.RANDOM(*values))
assert user.name in values
# -*- coding: utf-8 -*-
# Copyright 2015-TODAY LasLabs Inc.
# License MIT (https://opensource.org/licenses/MIT).
from mixer.backend.sqlalchemy import mixer
__model__ = 'carepoint.models.cph.fdb_route.FdbRoute'
fdb_route_default = mixer.blend(
__model__,
gcrt='K',
rt='INTRAARTIC',
gcrt2='UI',
gcrt_desc='INTRAARTICULAR',
systemic='S',
update_yn=False,
)
def fdb_route_rnd(cnt):
return mixer.cycle(cnt).blend(__model__)
doctor_default = mixer.blend(
__model__,
md_id=1,
lname='LName',
lname_sdx='LName',
fname='FName',
fname_sdx='FName',
mname='MName',
title_lu='TitlaLu',
suffix_lu='SuffixLu',
degree_lu='DgreeLu',
prescriber_type_cn=1,
email='Email',
url='Url',
pref_meth_contact_cn=1,
best_cont_time='BestContTime',
specialty_cd='SpecialtyCd',
dea_no='DeaNo',
dea_suffix='DeaSuffix',
spin_no='SpinNo',
upin_no='UpinNo',
other_id='OtherId',
fed_tax_id='FedTaxId',
hin_id='HiId',
champus_id='ChampusId',
state_lic_id='StateLicId',
ncpdp_id='NcpdpId',
medicaid_id='MedicaidId',
medicare_id='MedicareId',
blue_shield_id='BlueShieldId',
blue_cross_id='BlueCrossId',
npi_id='NpiId',
practice_org_id=1,
cmt='cmt',
status_cn=1,
conv_code='ConvCode',
app_flags='AppFlags',
timestmp=dt_now,
state_issued_id='StateIssuedId',
sname='Sname',
medicaid_restricted_yn=False,
fac_id=1,
C2Restricted_yn=False,
co_md_id=1,
do_not_refer=1,
deceased_yn=False,
C0restricted_yn=False,
C3restricted_yn=False,
C4restricted_yn=False,
C5restricted_yn=False,
study_drugs_yn=False,
tracking_cn=1,
CTP_no='CTPno',
add_user_id=1,
add_date=False,
chg_user_id=1,
chg_date=False,
)
__model__ = 'carepoint.models.cph.store.Store'
store_default = mixer.blend(
__model__,
store_id=1,
store_type_cn=1,
name='Name',
store_hours='StoreHours',
store_no='StoreNo',
fed_tax_id='FedTaxId',
url='Url',
email='Email',
mgr_cont_id=1,
cont_id=1,
carepoint_acct_no='CarepointAcctNo',
cmt='Cmt',
status_cn=1,
app_flags=1,
nabp='Nabp',
medicaid_no='Medicaid',
timestmp=dt_now,
region_id=1,
NPI='Npi',
pharmacy_service_type_cn=1,
web_refill_yn=False,
add_user_id=1,
add_date=dt_now,
chg_user_id=1,
chg_date=dt_now,
)
presription_default = mixer.blend(
__model__,
rx_id=1,
script_no='ScriptNo',
old_script_no='OldScriptNo',
pat_id=1,
store_id=1,
md_id=1,
ndc='Ndc',
gcn_seqno=1,
mfg='Mfg',
drug_name='DrugName',
input_src_cn=1,
src_pat_meds_cn=1,
start_date=dt_now,
expire_date=dt_now,
stop_date=dt_now,
sig_code='SigCode',
sig_text='SigText',
written_qty=1,
starter_qty=1,
days_supply=1,
pkg_size=1,
units_per_dose=1,
units_entered='UnitsEntered',
awp=1,
udef=1,
ful=1,
mac=1,
aac=1,
freq_entered='FreqEntered',
freq_of_admin=1,
sched_of_admin_cn=1,
daw_yn=False,
refills_orig=1,
refills_left=1,
last_rxdisp_id=1,
last_refill_qty=1,
last_refill_date=dt_now,
refill_date=dt_now,
src_org_id=1,
cmt='Cmt',
exit_state_cn=1,
script_status_cn=1,
sched_date=dt_now,
sched_time=dt_now,
scheduled_yn=False,
drug_dea_class='DrugDeaClass',
manual_add_yn=False,
status_cn=1,
life_date=dt_now,
self_prescribed_yn=False,
last_transfer_type_io='LastTransferType',
last_disp_prod='LastDsipProd',
transfer_cnt=1,
wc_claim_id='WcClaimId',
injury_date=dt_now,
gpi_rx=1,
auth_by='AuthBy',
orig_disp_date=dt_now,
short_term_yn=1,
orig_date=dt_now,
refills_used=1,
wc_emp_id=1,
dose_unit='DoseUnit',
dosage_multiplier=1,
df='Df',
uu='Uu',
app_flags=1,
timestmp=dt_now,
sched2_no='SchedTwo',
orig_expire_date=dt_now,
rxq_status_cn=1,
IVRCmt='IVRCmt',
wc_bodypart='WcBodypart',
comp_ndc='CompNdc',
treatment_yn=False,
ivr_callback='IvrCallback',
autofill_yn=False,
autofill_resume_date=dt_now,
workflow_status_cn=1,
extern_process_cn=1,
md_fac_id=1,
owner_store_id=1,
study_id=1,
min_days_until_refill=1,
sig_text_english='SigTextEnglish',
order_fullfillment_cn=1,
taxable=1,
MAR_flag=1,
FreeFormStrength='FreeFormStrength',
priority_cn=1,
# ecs_yn=False,
# edit_locked_yn=False,
# locked_yn=False,
# locked_id=1,
# locked_user_id=1,
daw_rx_cn=1,
add_user_id=1,
add_date=dt_now,
chg_user_id=1,
chg_date=dt_now,
)
# -*- coding: utf-8 -*-
# Copyright 2015-TODAY LasLabs Inc.
# License MIT (https://opensource.org/licenses/MIT).
from mixer.backend.sqlalchemy import mixer
from datetime import datetime
dt_now = datetime.now()
__model__ = 'carepoint.models.cph.fdb_gcn.FdbGcn'
fdb_gcn_default = mixer.blend(
__model__,
gcn_seqno=1,
gcn=11,
update_yn=False,
)
def fdb_gcn_rnd(cnt):
return mixer.cycle(cnt).blend(__model__)
def test_random():
from mixer.backend.sqlalchemy import mixer
values = ('mixer', 'is', 'fun')
user = mixer.blend(User, name=mixer.RANDOM(*values))
assert user.name in values
# -*- coding: utf-8 -*-
# Copyright 2015-TODAY LasLabs Inc.
# License MIT (https://opensource.org/licenses/MIT).
from mixer.backend.sqlalchemy import mixer
__model__ = 'carepoint.models.cph.fdb_lbl_rid.FdbLblRid'
fdb_lbl_rid_default = mixer.blend(
__model__,
lblrid='A00002',
mfg='ELI LILLY & CO.',
update_yn=False,
)
def fdb_lbl_rid_rnd(cnt):
return mixer.cycle(cnt).blend(__model__)
fdb_ndc_default = mixer.blend(
__model__,
id=1,
ncd=2032902,
lblrid='A00002',
gcn_seqno=8879,
ps=100,
df=1,
ad='PEDIATRIC',
ln='V-CILLIN K 250MG TABLET',
bn='V-CILLIN K',
pndc=777050324,
repndc=66591065141,
ndcfi=1,
daddnc=19820101,
dupdc=20001102,
desi=None, # All Blank in test DB
desdtec=0, # All 0 in test DB
desi2=None, # All Blank in test DB
des2dtec=0, # All 0 in test DB
dea=0, # 0,1,2,3,4 (Scheduled Substance)
cl='F', # T, F in Test DB - likely Bool conversion
gpi=2, # 0,1,2,3
hosp=1, # 0,1
innov=1, # 0,1
ipi=0, # 0,1
mini=1, # 0,1
maint=None, # 1 or NULL
obc='AB',
obsdtec=19971224,
ppi=None, # 1 or NULL
stpk=1, # 0,1
repack=0, # 0,1
top200=0, # 0,1
ud=0, # 0,1
csp=1,
color='WHITE',
flavor='CHERRY',
shape='ELLIPTICAL',
ndl_gdge=0, # 0
ndl_lngth=0, # 0
syr_cpcty=3, # 0,1,2,3
shlf_pck=24,
shipper=1,
skey=200476000000000000000000,
hcfa_fda='AB',
hcfa_unit='TAB',
hcfa_ps=1,
hcfa_appc=19580926,
hcfa_mrkc=19580926,
hcfa_trmc=19971001,
hcfa_typ=2,
hcfa_desc1=19930101,
hcfa_desi1=2,
uu=0, # 0,1
pd='BOTTLE',
ln25='V-CILLIN K 250MG TABLILL',
ln25i=0,
gpidc=19940101,
bbdc=19970108,
home=0, # 0,1
inpcki=0, # 0,1
outpcki=0, # 0,1
obc_exp='AB',
ps_equiv=100,
plblr=0, # 0,1
hcpc='J3260',
top50gen=0,
obc3='AB',
gmi=2, # 0,1,2
gni=3, # 0,1,2,3
gsi=9,
gti=2,
ndcgi1=1,
user_gcdf=None, # All blank
user_str=None, # All blank
real_product_yn=None, # All blank
no_update_yn=None, # All blank
no_prc_update_yn=None, # All blank
user_product_yn=0, # 0 & Blank
cpname_short=None, # All blank
status_cn=None, # All blank
update_yn=None, # All blank
active_yn=0, # 0,1
ln60='DARVOCET-N 50 TABLET',
)
dt_now = datetime.now()
__model__ = 'carepoint.models.cph.address.Address'
address_default = mixer.blend(
__model__,
addr_id=1,
parent_addr_id=None,
inherited_yn=False,
owner_type_cn=1,
alt_name='Alt Name',
addr1='Addr1',
addr2='Addr2',
addr3='Addr3',
city='City',
state_cd='StateCd',
zip='Zip',
zip_plus4='ZipPlus4',
country_cd='CountryCd',
mailing_yn=False,
anote='ANote',
app_flags=1,
timestmp=dt_now,
add_user_id=1,
add_date=dt_now,
chd_user_id=1,
chg_date=dt_now,
)
def addresses_rnd(cnt):
return mixer.cycle(cnt).blend(__model__)
item_default = mixer.blend(
__model__,
ITEMMSTR='ItmeStr',
DESCR='Descr',
TAXABLE='Taxable',
CLASS='Class',
UOFMSALES='UofmSales',
UOFMORDERS='UofmOrders',
FACTOR=1.1,
ONHAND=1,
ONORDER=1,
VENDOR='Vendor',
COST=1,
INQTY=1,
INDATE=dt_now,
OUTQTY=1,
OUTDATE=dt_now,
ADJQTY=1,
ADJDATE=dt_now,
MTD_ISSUE=1,
MTD_RCPTS=1,
MTD_ADJ=1,
COMMENTS='Comments',
IMIN=1,
IMAX=1,
UPCCODE='UpcCode',
POSLOC='PosLoc',
VENDITEMNO='VendItemMo',
EXCLUDE='Exclude',
NDC='Ndc',
SKU='Sku',
AUTO_ORD=1,
FIXED_QTY=1,
ACTIVE_YN=1,
AVG_UNIT_COST=1,
location='location',
item_id=1,
store_id=1,
chemical_id=1,
allocated=1,
machine_id=1,
special_pkg_ind_cn=1,
refrig_cn=1,
order_multiples_of=1,
add_user_id=1,
add_date=dt_now,
chg_user_id=1,
chg_date=dt_now,
)
patient_default = mixer.blend(
__model__,
pat_id=1,
cmt_id=1,
pat_status_cn=1,
pat_type_cn=1,
nh_pat_id="NhPatId",
chart_id="ChartId",
lname="LName",
lname_sdx="LNameSdx",
mname="Mname",
title_lu="TitleLu",
suffix_lu="SuffixLu",
alias="Alias",
mmname="MmName",
alt1_id="AltId",
pref_meth_cont_cn="PrefMeth",
best_cont_time="BestCon",
ssn="Social",
dln="Dln",
dln_state_cd="DlnStateCd",
email="Email",
gender_cd="Gender",
birth_date=dt_now,
death_date=dt_now,
no_safety_caps_yn=False,
generics_yn=False,
label_style_cn=1,
primary_md_id=1,
secondary_md_id=1,
edu_level_cn=1,
ethnicity_cd="Ethnicity",
marital_status_cd="MaritalStatus",
religion_cn=1,
name_spouse="NameSpous",
primary_lang_cd="PrimaryLang",
rec_release_status_cn=1,
rec_release_date=dt_now,
hh_relation_cn=1,
hh_pat_id=1,
fam_relation_cn="FamRelation",
fam_pat_id=1,
primary_store_id=1,
bad_check_yn=False,
price_formula_id=1,
cmt="Cmt",
status_cn=1,
facility_pat_yn=False,
conv_code="ConvCode",
app_flags=1,
timestmp=dt_now,
comp_cn=1,
hp_blnAdmExt=1,
hp_ExtAtt=1,
user_def_1="UserDef",
user_def_2="UserDef",
user_def_3="UserDef",
user_def_4="UserDef",
sc_pat_id=1,
resp_party_id=1,
auto_refill_cn=1,
fill_yn=False,
fill_stop_date=dt_now,
fill_resume_date=dt_now,
fill_stop_reason_cn=1,
fill_stop_user_id=1,
registration_date=dt_now,
anonymous_yn=False,
market_yn=False,
representative="Represent",
discharge_date=dt_now,
do_not_resuscitate_yn=False,
discharge_exp_date=dt_now,
pat_loc_cn=1,
rx_priority_default_cn=1,
ship_cn=1,
residence_cn=1,
add_user_id=1,
add_date=dt_now,
chg_user_id=1,
chg_date=dt_now,
)
dt_now = datetime.now()
__model__ = 'carepoint.models.cph.address.Address'
address_default = mixer.blend(
__model__,
addr_id=1,
parent_addr_id=None,
inherited_yn=False,
owner_type_cn=1,
alt_name='Alt Name',
addr1='Addr1',
addr2='Addr2',
addr3='Addr3',
city='City',
state_cd='StateCd',
zip='Zip',
zip_plus4='ZipPlus4',
country_cd='CountryCd',
mailing_yn=False,
anote='ANote',
app_flags=1,
timestmp=dt_now,
add_user_id=1,
add_date=dt_now,
chd_user_id=1,
chg_date=dt_now,
)
def addresses_rnd(cnt):
return mixer.cycle(cnt).blend(__model__)
presription_default = mixer.blend(
__model__,
rx_id=1,
script_no='ScriptNo',
old_script_no='OldScriptNo',
pat_id=1,
store_id=1,
md_id=1,
ndc='Ndc',
gcn_seqno=1,
mfg='Mfg',
drug_name='DrugName',
input_src_cn=1,
src_pat_meds_cn=1,
start_date=dt_now,
expire_date=dt_now,
stop_date=dt_now,
sig_code='SigCode',
sig_text='SigText',
written_qty=1,
starter_qty=1,
days_supply=1,
pkg_size=1,
units_per_dose=1,
units_entered='UnitsEntered',
awp=1,
udef=1,
ful=1,
mac=1,
aac=1,
freq_entered='FreqEntered',
freq_of_admin=1,
sched_of_admin_cn=1,
daw_yn=False,
refills_orig=1,
refills_left=1,
last_rxdisp_id=1,
last_refill_qty=1,
last_refill_date=dt_now,
refill_date=dt_now,
src_org_id=1,
cmt='Cmt',
exit_state_cn=1,
script_status_cn=1,
sched_date=dt_now,
sched_time=dt_now,
scheduled_yn=False,
drug_dea_class='DrugDeaClass',
manual_add_yn=False,
status_cn=1,
life_date=dt_now,
self_prescribed_yn=False,
last_transfer_type_io='LastTransferType',
last_disp_prod='LastDsipProd',
transfer_cnt=1,
wc_claim_id='WcClaimId',
injury_date=dt_now,
gpi_rx=1,
auth_by='AuthBy',
orig_disp_date=dt_now,
short_term_yn=1,
orig_date=dt_now,
refills_used=1,
wc_emp_id=1,
dose_unit='DoseUnit',
dosage_multiplier=1,
df='Df',
uu='Uu',
app_flags=1,
timestmp=dt_now,
sched2_no='SchedTwo',
orig_expire_date=dt_now,
rxq_status_cn=1,
IVRCmt='IVRCmt',
wc_bodypart='WcBodypart',
comp_ndc='CompNdc',
treatment_yn=False,
ivr_callback='IvrCallback',
autofill_yn=False,
autofill_resume_date=dt_now,
workflow_status_cn=1,
extern_process_cn=1,
md_fac_id=1,
owner_store_id=1,
study_id=1,
min_days_until_refill=1,
sig_text_english='SigTextEnglish',
order_fullfillment_cn=1,
taxable=1,
MAR_flag=1,
FreeFormStrength='FreeFormStrength',
priority_cn=1,
# ecs_yn=False,
# edit_locked_yn=False,
# locked_yn=False,
# locked_id=1,
# locked_user_id=1,
daw_rx_cn=1,
add_user_id=1,
add_date=dt_now,
chg_user_id=1,
chg_date=dt_now,
)
fdb_ndc_cs_ext_default = mixer.blend(
__model__,
ndc='0002032902',
short_name='An item',
lot_no='A lot',
orig_mfg='Orig Mfg',
pref_gen_yn=True,
active_yn=True,
drug_expire_days='Drug Expire Days',
formulary_yn=True,
compound_yn=True,
sup_upd_gen_yn=True,
sup_upd_phys_yn=True,
sup_upd_clin_yn=True,
sup_upd_fin_yn=True,
sup_upd_med_yn=True,
dn_form='TABLET',
dn_str='250 MG',
dn_route='ORAL',
rx_only_yn=True,
manual_yn=True,
brand_ndc='0002032902',
add_user_id=1,
add_date=dt_now,
chg_user_id=1,
app_flags='',
timestmp=dt_now,
comp_yn=True,
dea='Dea Num',
dea_chg_user=1,
dea_chg_date=dt_now,
ln='Ln ',
ln_chg_user=1,
ln_chg_date=dt_now,
fdb_chg_date=dt_now,
ud_svc_code='Ud Svc Code',
gpi='Gpi',
gpi_chg_user=1,
gpi_chg_date=dt_now,
bill_increment=1,
formula_id=1,
alt_iptside1='Alt IptSide1',
alt_iptside2='Alt IptSide2',
dose_multiplier='Dose Multiplier',
default_daw_override='Daw Override',
manual_price_yn=True,
compound_type_cn=1,
refrig_cn=1,
)
dispense_default = mixer.blend(
__model__,
rx_id=1,
store_id=1,
disp_ndc='DispNdc',
disp_drug_name='DispDrugName',
prod_expire_date=dt_now,
mfg='Mfg',
orig_mfg='OrifMfg',
pkg_size=1,
rxdisp_id=1,
fill_no=1,
dispense_date=dt_now,
dispense_qty=1,
disp_days_supply=1,
sig_text='SigText',
sched_of_admin_cn=1,
freq_of_admin=1,
units_per_dose=1,
lot_number='LotNumber',
disp_awp=1,
disp_aac=1,
disp_mac=1,
disp_ful=1,
disp_udef=1,
tech_initals='TechInitials',
rph_initials='RphInitials',
cnsl_initials='CnslInitials',
icd9='Icd',
daw_disp_cn=1,
level_of_service=1,
cmt='cmt',
status_cn=1,
alt_pick_up_id=1,
alt_pick_up_cn=1,
clarification_fill=1,
trip_no=1,
gpi_disp=1,
label_3pty_yn=False,
reject_3pty_yn=False,
pay_type_cn=1,
price_differs_yn=False,
pat_loc_cn=1,
billing_units='BillingUnits',
price_table_id=1,
app_flags=1,
timestmp=dt_now,
price_meth_cn=1,
uu='UU',
p_tbl_override_yn=False,
label_id=1,
billing_hold=1,
post_bal_yn=False,
inv_no='InvNo',
disp_qty_delta=1,
brand_med_nec_yn=False,
Other_coverage_cd=1,
epsdt_yn=False,
exempt_cd=1,
num_labels=1,
location='Location',
qty_override=1,
dur_summary='DurSummary',
cov_overrides=1,
use_secondary_ins_yn=False,
hp_blnRxExtr=1,
item_id=1,
ud_override='UdOverride',
disp_status_cn=1,
order_id=1,
sig_id=1,
counsel_yn=1,
processing_date=dt_now,
hcpcs_mod_cn=1,
acct_id=1,
track_pat_resp_yn=1,
track_org_resp_yn=1,
label_fac_id=1,
extern_process_cn=1,
price_ovr_user_id=1,
price_ovr_reason_cn=1,
wf_status_cn=1,
verify_user_id=1,
verify_timestamp=dt_now,
ar_hold=1,
disp_type_cn=1,
own_use_pricing_yn=1,
pos_processed_yn=1,
prescriber_cn=1,
visit_nbr='VisitNbr',
disp_udef2=1,
SecondaryICD9='SecondaryIcd',
uandc_pricing_used_yn=1,
special_pkg_ind_cn=1,
delay_reason_cn=1,
place_of_service_cn=1,
pat_residence_cn=1,
compound_type_cn=1,
pharmacy_service_type_cn=1,
admin_start_date=dt_now,
ClariFill_2=1,
ClariFill_3=1,
other_coverage_cd_2=1,
pat_assign_ind_yn=1,
prov_assign_ind_yn=1,
route_of_admin_ovr='RouteAdmin',
csr_pickup_id=1,
icd10='icd',
secondaryicd10='secondaryicd',
add_user_id=1,
add_date=dt_now,
chg_user_id=1,
chg_date=dt_now,
)
user_default = mixer.blend(
__model__,
user_id=1,
user_type_cd='UserType',
login_name='LoginName',
lname='Lname',
fname='Fname',
mname='Mname',
title_lu='TitleLu',
suffix_lu='SuffixLu',
degree_lu='Degree',
initials='Initials',
job_title_lu='JobTitle',
anote='Anote',
employee_no='EmployeeNo',
ssn='Social',
last_login_date=dt_now,
email='Email',
db_password='******',
es_password='******',
cmt='Cmt',
system_yn=1,
license_no='LicenseNo',
license_state_cd='LicenseStateCd',
status_cn=1,
app_flags=1,
timestmp=dt_now,
must_change_password_yn=1,
password_date=dt_now,
add_user_id=1,
add_date=dt_now,
chg_user_id=1,
chg_date=dt_now,
)
__model__ = 'carepoint.models.cph.store.Store'
store_default = mixer.blend(
__model__,
store_id=1,
store_type_cn=1,
name='Name',
store_hours='StoreHours',
store_no='StoreNo',
fed_tax_id='FedTaxId',
url='Url',
email='Email',
mgr_cont_id=1,
cont_id=1,
carepoint_acct_no='CarepointAcctNo',
cmt='Cmt',
status_cn=1,
app_flags=1,
nabp='Nabp',
medcaid_no='Medicaid',
timestamp=dt_now,
region_id=1,
NPI='Npi',
pharmacy_service_type_cn=1,
web_refill_yn=False,
add_user_id=1,
add_date=dt_now,
chg_user_id=1,
chg_date=dt_now,
)
store_rnd = lambda cnt: mixer.cycle(cnt).blend(__model__)
# -*- coding: utf-8 -*-
# Copyright 2015-TODAY LasLabs Inc.
# License MIT (https://opensource.org/licenses/MIT).
from mixer.backend.sqlalchemy import mixer
__model__ = 'carepoint.models.cph.fdb_form.FdbForm'
fdb_form_default = mixer.blend(
__model__,
gcdf='0A',
dose='UNIDENT',
gcdf_desc='UNIDENTIFIED',
update_yn=False,
)
def fdb_form_rnd(cnt):
return mixer.cycle(cnt).blend(__model__)
# Copyright 2015-TODAY LasLabs Inc.
# License MIT (https://opensource.org/licenses/MIT).
from mixer.backend.sqlalchemy import mixer
from datetime import datetime
dt_now = datetime.now()
__model__ = 'carepoint.models.cph.fdb_gcn_seq.FdbGcnSeq'
fdb_gcn_seq_default = mixer.blend(
__model__,
gcn_seqno=1,
hic3='A1A',
hicl_seqno=1,
gcdf='TA',
gcrt=1,
str='100 MG',
gtc=38,
tc=74,
dcc=0,
gcnseq_gi=1,
gender=0,
hic3_seqn=139,
str60='100 mg',
update_yn=0,
)
def fdb_gcn_seq_rnd(cnt):
return mixer.cycle(cnt).blend(__model__)
def test_nonincremental_primary_key(session):
from mixer.backend.sqlalchemy import mixer
test = mixer.blend(ProfileNonIncremental, id=42)
assert test.name
def test_random(self):
from mixer.backend.sqlalchemy import mixer
values = ('mixer', 'is', 'fun')
user = mixer.blend(User, name=mixer.random(*values))
self.assertTrue(user.name in values)
user_default = mixer.blend(
__model__,
user_id=1,
user_type_cd='UserType',
login_name='LoginName',
lname='Lname',
fname='Fname',
mname='Mname',
title_lu='TitleLu',
suffix_lu='SuffixLu',
degree_lu='Degree',
initials='Initials',
job_title_lu='JobTitle',
anote='Anote',
employee_no='EmployeeNo',
ssn='Social',
last_login_date=dt_now,
email='Email',
db_password='******',
es_password='******',
cmt='Cmt',
system_yn=1,
license_no='LicenseNo',
license_state_cd='LicenseStateCd',
status_cn=1,
app_flags=1,
timestmp=dt_now,
must_change_password_yn=1,
password_date=dt_now,
add_user_id=1,
add_date=dt_now,
chg_user_id=1,
chg_date=dt_now,
)
def test_default_mixer(self):
from mixer.backend.sqlalchemy import mixer
test = mixer.blend(User)
self.assertTrue(test.name)
# -*- coding: utf-8 -*-
# Copyright 2015-TODAY LasLabs Inc.
# License MIT (https://opensource.org/licenses/MIT).
from mixer.backend.sqlalchemy import mixer
__model__ = 'carepoint.models.cph.fdb_route.FdbRoute'
fdb_route_default = mixer.blend(
__model__,
gcrt='K',
rt='INTRAARTIC',
gcrt2='UI',
gcrt_desc='INTRAARTICULAR',
systemic='S',
update_yn=False,
)
def fdb_route_rnd(cnt):
return mixer.cycle(cnt).blend(__model__)
# -*- coding: utf-8 -*-
# Copyright 2015-TODAY LasLabs Inc.
# License MIT (https://opensource.org/licenses/MIT).
from mixer.backend.sqlalchemy import mixer
__model__ = 'carepoint.models.cph.fdb_form.FdbForm'
fdb_form_default = mixer.blend(
__model__,
gcdf='0A',
dose='UNIDENT',
gcdf_desc='UNIDENTIFIED',
update_yn=False,
)
def fdb_form_rnd(cnt):
return mixer.cycle(cnt).blend(__model__)
patient_default = mixer.blend(
__model__,
pat_id=1,
cmt_id=1,
pat_status_cn=1,
pat_type_cn=1,
nh_pat_id='NhPatId',
chart_id='ChartId',
lname='LName',
lname_sdx='LNameSdx',
mname='Mname',
title_lu='TitleLu',
suffix_lu='SuffixLu',
alias='Alias',
mmname='MmName',
alt1_id='AltId',
pref_meth_cont_cn='PrefMeth',
best_cont_time='BestCon',
ssn='Social',
dln='Dln',
dln_state_cd='DlnStateCd',
email='Email',
gender_cd='Gender',
birth_date=dt_now,
death_date=dt_now,
no_safety_caps_yn=False,
generics_yn=False,
label_style_cn=1,
primary_md_id=1,
secondary_md_id=1,
edu_level_cn=1,
ethnicity_cd='Ethnicity',
maritial_status_cd='MaritalStatus',
religion_cn=1,
name_spouse='NameSpous',
primary_lang_cd='PrimaryLang',
rec_release_status_cn=1,
rec_release_date=dt_now,
hh_relation_cn=1,
hh_pat_id=1,
fam_relation_cn='FamRelation',
fam_pat_id=1,
primary_store_id=1,
bad_check_yn=False,
price_formula_id=1,
cmt='Cmt',
status_cn=1,
facility_pat_yn=False,
conv_code='ConvCode',
app_flags=1,
timestmp=dt_now,
comp_cn=1,
hp_blnAdmExt=1,
hp_ExtAtt=1,
user_def_1='UserDef',
user_def_2='UserDef',
user_def_3='UserDef',
user_def_4='UserDef',
sc_pat_id=1,
resp_party_id=1,
auto_refill_cn=1,
fill_yn=False,
fill_stop_date=dt_now,
fill_resume_date=dt_now,
fill_stop_reason_cn=1,
fill_stop_user_id=1,
registration_date=dt_now,
anonymous_yn=False,
market_yn=False,
representative='Represent',
discharge_date=dt_now,
do_not_resuscitate_yn=False,
discharge_exp_date=dt_now,
pat_loc_cn=1,
rx_priority_default_cn=1,
ship_cn=1,
residence_cn=1,
add_user_id=1,
add_date=dt_now,
chg_user_id=1,
chg_date=dt_now,
)
item_default = mixer.blend(
__model__,
ITEMMSTR='ItmeStr',
DESCR='Descr',
TAXABLE='Taxable',
CLASS='Class',
UOFMSALES='UofmSales',
UOFMORDERS='UofmOrders',
FACTOR=1.1,
ONHAND=1,
ONORDER=1,
VENDOR='Vendor',
COST=1,
INQTY=1,
INDATE=dt_now,
OUTQTY=1,
OUTDATE=dt_now,
ADJQTY=1,
ADJDATE=dt_now,
MTD_ISSUE=1,
MTD_RCPTS=1,
MTD_ADJ=1,
COMMENTS='Comments',
IMIN=1,
IMAX=1,
UPCCODE='UpcCode',
POSLOC='PosLoc',
VENDITEMNO='VendItemMo',
EXCLUDE='Exclude',
NDC='Ndc',
SKU='Sku',
AUTO_ORD=1,
FIXED_QTY=1,
ACTIVE_YN=1,
AVG_UNIT_COST=1,
location='location',
item_id=1,
store_id=1,
chemical_id=1,
allocated=1,
machine_id=1,
special_pkg_ind_cn=1,
refrig_cn=1,
order_multiples_of=1,
add_user_id=1,
add_date=dt_now,
chg_user_id=1,
chg_date=dt_now,
)
# -*- coding: utf-8 -*-
# Copyright 2015-TODAY LasLabs Inc.
# License MIT (https://opensource.org/licenses/MIT).
from mixer.backend.sqlalchemy import mixer
__model__ = 'carepoint.models.cph.fdb_lbl_rid.FdbLblRid'
fdb_lbl_rid_default = mixer.blend(
__model__,
lblrid='A00002',
mfg='ELI LILLY & CO.',
update_yn=False,
)
def fdb_lbl_rid_rnd(cnt):
return mixer.cycle(cnt).blend(__model__)
def test_random(self):
from mixer.backend.sqlalchemy import mixer
values = ('mixer', 'is', 'fun')
user = mixer.blend(User, name=mixer.random(*values))
self.assertTrue(user.name in values)
def test_default_mixer():
from mixer.backend.sqlalchemy import mixer
test = mixer.blend(User)
assert test.name
# -*- coding: utf-8 -*-
# Copyright 2015-TODAY LasLabs Inc.
# License MIT (https://opensource.org/licenses/MIT).
from mixer.backend.sqlalchemy import mixer
from datetime import datetime
dt_now = datetime.now()
__model__ = 'carepoint.models.cph.store_param.StoreParam'
store_param_default = mixer.blend(
__model__,
store_id=1,
param_code='SC_MOD_RD_PROD_IMAGE_DIR',
descr='SC_MOD_RD_PROD_IMAGE_DIR',
data_value='\\GRXServer\images',
app_flags=0,
timestmp=dt_now
)
def store_param_rnd(cnt):
return mixer.cycle(cnt).blend(__model__)
def test_mix22(session):
from mixer.backend.sqlalchemy import Mixer
mixer = Mixer(session=session, commit=True)
role = mixer.blend(Role, name=mixer.MIX.user.name)
assert role.name == role.user.name
patient_default = mixer.blend(
__model__,
pat_id=1,
cmt_id=1,
pat_status_cn=1,
pat_type_cn=1,
nh_pat_id='NhPatId',
chart_id='ChartId',
lname='LName',
lname_sdx='LNameSdx',
mname='Mname',
title_lu='TitleLu',
suffix_lu='SuffixLu',
alias='Alias',
mmname='MmName',
alt1_id='AltId',
pref_meth_cont_cn='PrefMeth',
best_cont_time='BestCon',
ssn='Social',
dln='Dln',
dln_state_cd='DlnStateCd',
email='Email',
gender_cd='Gender',
birth_date=dt_now,
death_date=dt_now,
no_safety_caps_yn=False,
generics_yn=False,
label_style_cn=1,
primary_md_id=1,
secondary_md_id=1,
edu_level_cn=1,
ethnicity_cd='Ethnicity',
marital_status_cd='MaritalStatus',
religion_cn=1,
name_spouse='NameSpous',
primary_lang_cd='PrimaryLang',
rec_release_status_cn=1,
rec_release_date=dt_now,
hh_relation_cn=1,
hh_pat_id=1,
fam_relation_cn='FamRelation',
fam_pat_id=1,
primary_store_id=1,
bad_check_yn=False,
price_formula_id=1,
cmt='Cmt',
status_cn=1,
facility_pat_yn=False,
conv_code='ConvCode',
app_flags=1,
timestmp=dt_now,
comp_cn=1,
hp_blnAdmExt=1,
hp_ExtAtt=1,
user_def_1='UserDef',
user_def_2='UserDef',
user_def_3='UserDef',
user_def_4='UserDef',
sc_pat_id=1,
resp_party_id=1,
auto_refill_cn=1,
fill_yn=False,
fill_stop_date=dt_now,
fill_resume_date=dt_now,
fill_stop_reason_cn=1,
fill_stop_user_id=1,
registration_date=dt_now,
anonymous_yn=False,
market_yn=False,
representative='Represent',
discharge_date=dt_now,
do_not_resuscitate_yn=False,
discharge_exp_date=dt_now,
pat_loc_cn=1,
rx_priority_default_cn=1,
ship_cn=1,
residence_cn=1,
add_user_id=1,
add_date=dt_now,
chg_user_id=1,
chg_date=dt_now,
)
def test_default_mixer(self):
from mixer.backend.sqlalchemy import mixer
test = mixer.blend(User)
self.assertTrue(test.name)
dispense_default = mixer.blend(
__model__,
rx_id=1,
store_id=1,
disp_ndc='DispNdc',
disp_drug_name='DispDrugName',
prod_expire_date=dt_now,
mfg='Mfg',
orig_mfg='OrifMfg',
pkg_size=1,
rxdisp_id=1,
fill_no=1,
dispense_date=dt_now,
dispense_qty=1,
disp_days_supply=1,
sig_text='SigText',
sched_of_admin_cn=1,
freq_of_admin=1,
units_per_dose=1,
lot_number='LotNumber',
disp_awp=1,
disp_aac=1,
disp_mac=1,
disp_ful=1,
disp_udef=1,
tech_initials='TechInitials',
rph_initials='RphInitials',
cnsl_initials='CnslInitials',
icd9='Icd',
daw_disp_cn=1,
level_of_service=1,
cmt='cmt',
status_cn=1,
alt_pick_up_id=1,
alt_pick_up_cn=1,
clarification_fill=1,
trip_no=1,
gpi_disp=1,
label_3pty_yn=False,
reject_3pty_yn=False,
pay_type_cn=1,
price_differs_yn=False,
pat_loc_cn=1,
billing_units='BillingUnits',
price_table_id=1,
app_flags=1,
timestmp=dt_now,
price_meth_cn=1,
uu='UU',
p_tbl_override_yn=False,
label_id=1,
billing_hold=1,
post_bal_yn=False,
inv_no='InvNo',
disp_qty_delta=1,
brand_med_nec_yn=False,
Other_coverage_cd=1,
epsdt_yn=False,
exempt_cd=1,
num_labels=1,
location='Location',
qty_override=1,
dur_summary='DurSummary',
cov_overrides=1,
use_secondary_ins_yn=False,
hp_blnRxExtr=1,
item_id=1,
ud_override='UdOverride',
disp_status_cn=1,
order_id=1,
sig_id=1,
counsel_yn=1,
processing_date=dt_now,
hcpcs_mod_cn=1,
acct_id=1,
track_pat_resp_yn=1,
track_org_resp_yn=1,
label_fac_id=1,
extern_process_cn=1,
price_ovr_user_id=1,
price_ovr_reason_cn=1,
wf_status_cn=1,
verify_user_id=1,
verify_timestamp=dt_now,
ar_hold=1,
disp_type_cn=1,
own_use_pricing_yn=1,
pos_processed_yn=1,
prescriber_cn=1,
visit_nbr='VisitNbr',
disp_udef2=1,
SecondaryICD9='SecondaryIcd',
uandc_pricing_used_yn=1,
special_pkg_ind_cn=1,
delay_reason_cn=1,
place_of_service_cn=1,
pat_residence_cn=1,
compound_type_cn=1,
pharmacy_service_type_cn=1,
admin_start_date=dt_now,
ClariFill_2=1,
ClariFill_3=1,
other_coverage_cd_2=1,
pat_assign_ind_yn=1,
prov_assign_ind_yn=1,
route_of_admin_ovr='RouteAdmin',
csr_pickup_id=1,
icd10='icd',
secondaryicd10='secondaryicd',
add_user_id=1,
add_date=dt_now,
chg_user_id=1,
chg_date=dt_now,
)
def test_default_mixer():
from mixer.backend.sqlalchemy import mixer
test = mixer.blend(User)
assert test.name
def test_nonincremental_primary_key(session):
from mixer.backend.sqlalchemy import mixer
test = mixer.blend(ProfileNonIncremental, id=42)
assert test.name
def test_mix22(session):
from mixer.backend.sqlalchemy import Mixer
mixer = Mixer(session=session, commit=True)
role = mixer.blend(Role, name=mixer.MIX.user.name)
assert role.name == role.user.name
from mixer.backend.sqlalchemy import mixer
from datetime import datetime
dt_now = datetime.now()
__model__ = 'carepoint.models.cph.fdb_gcn_seq.FdbGcnSeq'
fdb_gcn_seq_default = mixer.blend(
__model__,
gcn_seqno=1,
hic3='A1A',
hicl_seqno=1,
gcdf='TA',
gcrt=1,
str='100 MG',
gtc=38,
tc=74,
dcc=0,
gcnseq_gi=1,
gender=0,
hic3_seqn=139,
str60='100 mg',
update_yn=0,
)
def fdb_gcn_seq_rnd(cnt):
return mixer.cycle(cnt).blend(__model__)
