Databases
StackOverflow2013
Postsdbo
POHow should I arrange my models and cron rake task to send emails on intervals with different start dates?
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POHow should I arrange my models and cron rake task to send emails on intervals with different start dates?
    primarykey
    data
    text
    <p>I'm re-evaluating my model and way I am trying to solve a particular problem. I have Contacts that can belong to a Campaign, which is a series of activities such as phone calls and emails, each with a number of days assigned as an attribute determining when it should get sent.</p> <p>I want the cron job to look and see emails which are due today (or maybe overdue) and fire off those emails.</p> <p>Contacts all have their own separate start-dates.</p> <p>Sometime a Call, which needs to take place, say, 6 days from the start, doesn't get done until 10 days. That means the email in the same campaign, set to be done 8 days from the start, needs to be delayed by 4 more days, to 12 days from the start, but only for that particular contact if the delayed Call was for the Contact.</p> <p>I would like from people how they would approaching modeling this and, in particular, come up with on any given day, the right Emails to send.</p> <p>Some challenges I have encountered with my approach:</p> <p>1) When there is no email to send, I error out with nil. I try to catch it, wondering if there's a better way to check. How do people handle that?</p> <p>2) How do you calculate the cascade delay? I use a complicated way of first checking the last date of everything that was completed (completed items have their own record in ContactEmail or ContactCalls for example). I then find the difference in the interval against the attribute 'days.' Then I add that interval to the date that last item was completed.</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. This table or related slice is empty.
    1. USAngela
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    3. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POHow should I arrange my models and cron rake task to send emails on intervals with different start dates?
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. POHow should I arrange my models and cron rake task to send emails on intervals with different start dates?
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. POHow should I arrange my models and cron rake task to send emails on intervals with different start dates?
      1. USstephenmurdoch
      1. VTFavorite
    1. COCan you rephrase your problem or at least break it down into smaller pieces? From what i can gather, you may have to restructure your tables so that your table relationships can help you. For example you say A call has_one/many follow-up tasks so when saving the call (with its new date) you could have a delay_related_tasks method that you call using after_save?
      singulars
      1. POHow should I arrange my models and cron rake task to send emails on intervals with different start dates?
      1. USgcahill
    2. COyeah, thanks -- I was keeping it high because I was afraid that my current structure was just way off in thinking....sounds like you are suggesting that I have a table with the actual to-do-tasks and the dates, and if there are changes, delay the later tasks upon each save....?
      singulars
      1. POHow should I arrange my models and cron rake task to send emails on intervals with different start dates?
      1. USAngela
    3. CODo you have a complete set of functional tests or specs that you can run to determine whether your solution works? If so, the header line of the specs or names of the test might make it easier for people to understand the problem.
      singulars
      1. POHow should I arrange my models and cron rake task to send emails on intervals with different start dates?
      1. USSteve Ross
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload