public void TestGenerateSqlForAuditSimple()
{
var qbuilder = new SanteDB.OrmLite.QueryBuilder(m_mapper, new SanteDB.OrmLite.Providers.Firebird.FirebirdSQLProvider());
var sql = qbuilder.CreateQuery <Audit>(o => o.Status == AuditStatusType.New);
Assert.AreEqual("SELECT aud_vrsn_tbl.aud_id,aud_vrsn_tbl.aud_vrsn_id,aud_vrsn_tbl.sts_cd_id,aud_vrsn_tbl.is_alrt,aud_vrsn_tbl.vrsn_seq_id,aud_vrsn_tbl.rplc_vrsn_id,aud_vrsn_tbl.crt_usr_id,aud_vrsn_tbl.obslt_usr_id,aud_vrsn_tbl.crt_utc,aud_vrsn_tbl.obslt_utc,aud_tbl.corr_id,aud_tbl.act_cd_id,aud_tbl.out_cd_id,aud_tbl.evt_cd_id,aud_tbl.evt_utc,aud_tbl.ses_id,aud_tbl.ps_name,aud_tbl.ps_id,aud_tbl.src_id FROM aud_vrsn_tbl AS aud_vrsn_tbl INNER JOIN aud_tbl AS aud_tbl ON (aud_vrsn_tbl.aud_id = aud_tbl.aud_id )WHERE (aud_vrsn_tbl.sts_cd_id = ? )", sql.Build().SQL);
}
public void TestGenerateSqlForAuditWithJoinForParticipant()
{
var e = Guid.Empty;
var qbuilder = new SanteDB.OrmLite.QueryBuilder(m_mapper, new SanteDB.OrmLite.Providers.Postgres.PostgreSQLProvider());
var sql = qbuilder.CreateQuery <Audit>(o => o.OutcomeCode.Mnemonic == "SUCCESS" && o.Participants.Any(p => p.Actor.UserName == "fyfej"));
Assert.AreEqual("SELECT aud_vrsn_tbl.aud_id,aud_vrsn_tbl.aud_vrsn_id,aud_vrsn_tbl.sts_cd_id,aud_vrsn_tbl.is_alrt,aud_vrsn_tbl.vrsn_seq_id,aud_vrsn_tbl.rplc_vrsn_id,aud_vrsn_tbl.crt_usr_id,aud_vrsn_tbl.obslt_usr_id,aud_vrsn_tbl.crt_utc,aud_vrsn_tbl.obslt_utc,aud_tbl.corr_id,aud_tbl.act_cd_id,aud_tbl.out_cd_id,aud_tbl.evt_cd_id,aud_tbl.evt_utc,aud_tbl.ses_id,aud_tbl.ps_name,aud_tbl.ps_id,aud_tbl.src_id FROM aud_vrsn_tbl AS aud_vrsn_tbl INNER JOIN aud_tbl AS aud_tbl ON (aud_vrsn_tbl.aud_id = aud_tbl.aud_id )WHERE aud_tbl.out_cd_id IN (SELECT sq0aud_cd_tbl.cd_id FROM aud_cd_tbl AS sq0aud_cd_tbl WHERE (sq0aud_cd_tbl.mnemonic = ? )) AND aud_vrsn_tbl.aud_id IN (SELECT sq0aud_ptcpt_aud_assoc_tbl.aud_id FROM aud_ptcpt_aud_assoc_tbl AS sq0aud_ptcpt_aud_assoc_tbl WHERE sq0aud_ptcpt_aud_assoc_tbl.ptcpt_id IN (SELECT sq1aud_ptcpt_tbl.ptcpt_id FROM aud_ptcpt_tbl AS sq1aud_ptcpt_tbl WHERE (sq1aud_ptcpt_tbl.usr_name = ? )))", sql.Build().SQL);
}
public void TestGenerateSqlForAuditWithJoinForTerm()
{
var e = Guid.Empty;
var qbuilder = new SanteDB.OrmLite.QueryBuilder(m_mapper, new SanteDB.OrmLite.Providers.Postgres.PostgreSQLProvider());
var sql = qbuilder.CreateQuery <Audit>(o => o.Status == AuditStatusType.New && o.EventIdCodeKey == e && o.OutcomeCode.Mnemonic == "SUCCESS");
Assert.AreEqual("SELECT aud_vrsn_tbl.aud_id,aud_vrsn_tbl.aud_vrsn_id,aud_vrsn_tbl.sts_cd_id,aud_vrsn_tbl.is_alrt,aud_vrsn_tbl.vrsn_seq_id,aud_vrsn_tbl.rplc_vrsn_id,aud_vrsn_tbl.crt_usr_id,aud_vrsn_tbl.obslt_usr_id,aud_vrsn_tbl.crt_utc,aud_vrsn_tbl.obslt_utc,aud_tbl.corr_id,aud_tbl.act_cd_id,aud_tbl.out_cd_id,aud_tbl.evt_cd_id,aud_tbl.evt_utc,aud_tbl.ses_id,aud_tbl.ps_name,aud_tbl.ps_id,aud_tbl.src_id FROM aud_vrsn_tbl AS aud_vrsn_tbl INNER JOIN aud_tbl AS aud_tbl ON (aud_vrsn_tbl.aud_id = aud_tbl.aud_id )WHERE (aud_vrsn_tbl.sts_cd_id = ? ) AND (aud_tbl.evt_cd_id = ? ) AND aud_tbl.out_cd_id IN (SELECT sq0aud_cd_tbl.cd_id FROM aud_cd_tbl AS sq0aud_cd_tbl WHERE (sq0aud_cd_tbl.mnemonic = ? ))", sql.Build().SQL);
}
public void TestGenerateSqlForAuditSourceWithRole()
{
var e = Guid.Empty;
var qbuilder = new SanteDB.OrmLite.QueryBuilder(m_mapper, new SanteDB.OrmLite.Providers.Postgres.PostgreSQLProvider());
var sql = qbuilder.CreateQuery <Audit>(o => o.AuditSource.SourceType.Any(r => r.Mnemonic == "FOOD TRUCK"));
Assert.AreEqual("SELECT aud_vrsn_tbl.aud_id,aud_vrsn_tbl.aud_vrsn_id,aud_vrsn_tbl.sts_cd_id,aud_vrsn_tbl.is_alrt,aud_vrsn_tbl.vrsn_seq_id,aud_vrsn_tbl.rplc_vrsn_id,aud_vrsn_tbl.crt_usr_id,aud_vrsn_tbl.obslt_usr_id,aud_vrsn_tbl.crt_utc,aud_vrsn_tbl.obslt_utc,aud_tbl.corr_id,aud_tbl.act_cd_id,aud_tbl.out_cd_id,aud_tbl.evt_cd_id,aud_tbl.evt_utc,aud_tbl.ses_id,aud_tbl.ps_name,aud_tbl.ps_id,aud_tbl.src_id FROM aud_vrsn_tbl AS aud_vrsn_tbl INNER JOIN aud_tbl AS aud_tbl ON (aud_vrsn_tbl.aud_id = aud_tbl.aud_id )WHERE aud_tbl.src_id IN (SELECT sq0aud_src_tbl.aud_src_id FROM aud_src_tbl AS sq0aud_src_tbl WHERE sq0aud_src_tbl.aud_src_id IN (SELECT sq1aud_src_typ_tbl.aud_src_id FROM aud_src_typ_tbl AS sq1aud_src_typ_tbl WHERE sq1aud_src_typ_tbl.cd_id IN (SELECT sq1aud_cd_tbl.cd_id FROM aud_cd_tbl AS sq1aud_cd_tbl WHERE (sq1aud_cd_tbl.mnemonic = ? ))))", sql.Build().SQL);
}
public void TestGenerateSqlForAuditSourceWithSimpleSource()
{
var e = Guid.Empty;
var qbuilder = new SanteDB.OrmLite.QueryBuilder(m_mapper, new SanteDB.OrmLite.Providers.Postgres.PostgreSQLProvider());
var sql = qbuilder.CreateQuery <Audit>(o => o.AuditSource.EnterpriseSiteId == "FOO");
Assert.AreEqual("SELECT aud_vrsn_tbl.aud_id,aud_vrsn_tbl.aud_vrsn_id,aud_vrsn_tbl.sts_cd_id,aud_vrsn_tbl.is_alrt,aud_vrsn_tbl.vrsn_seq_id,aud_vrsn_tbl.rplc_vrsn_id,aud_vrsn_tbl.crt_usr_id,aud_vrsn_tbl.obslt_usr_id,aud_vrsn_tbl.crt_utc,aud_vrsn_tbl.obslt_utc,aud_tbl.corr_id,aud_tbl.act_cd_id,aud_tbl.out_cd_id,aud_tbl.evt_cd_id,aud_tbl.evt_utc,aud_tbl.ses_id,aud_tbl.ps_name,aud_tbl.ps_id,aud_tbl.src_id FROM aud_vrsn_tbl AS aud_vrsn_tbl INNER JOIN aud_tbl AS aud_tbl ON (aud_vrsn_tbl.aud_id = aud_tbl.aud_id )WHERE aud_tbl.src_id IN (SELECT sq0aud_src_tbl.aud_src_id FROM aud_src_tbl AS sq0aud_src_tbl WHERE (sq0aud_src_tbl.ent_ste_nam = ? ))", sql.Build().SQL);
}
