Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- /**
- * Select only job without dependent tables
- */
- def selectByWithDeps(jobId: Int): Option[JobDeps] = {
- execute {
- DbSchema.db.withSession {
- implicit session: Session =>
- session.withTransaction {
- // fill the dependent instances with empty data
- val query = for {
- job <- schema.Jobs if job.jobId === jobId && job.isDeleted === Active.value
- jty <- schema.JobTypes if jty.jtyId === job.jtyId && jty.isDeleted === Active.value
- jtm <- schema.JobTemplates if jtm.jtmId === jty.jtmId && jtm.isDeleted === Active.value
- src <- schema.DataSources if src.srcId === jtm.srcId && src.isDeleted === Active.value
- dst <- schema.DataDestinations if dst.destId === jty.destId && dst.isDeleted === Active.value
- } yield (job, jty, jtm, src, dst)
- val f = (JobDeps.apply _).tupled
- query.firstOption.map(t => f(t))
- }
- }
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement