Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Add support for specific dates (e.g., 9th of every month, June 9th, June 9th 2018 only) #20

Open
deoren opened this issue Jun 9, 2018 · 1 comment
Assignees
Milestone

Comments

@deoren
Copy link
Collaborator

deoren commented Jun 9, 2018

For example, it would be useful to support these variations of June 9th (which is today, a Saturday):

  • 2018_JUNE_09 or 2018_JUNE_9
  • JUNE_09 or JUNE_9

It would also be useful to allow specifying loose days of the month that would apply to each month:

  • 09 or 9

If there was an entry with that frequency it would fire today.

The existing weekly_saturday would also be lumped in, or if performance isn't a consideration, would be a separate query. Later when when support is added for start & repeat values we may have to rethink this slightly.

Example query that could work for this proposal:

SELECT * FROM `event_reminders`.`events` 
WHERE `event_schedule` in (
    '2018_JUNE_09', 
    '2018_JUNE_9',
    'JUNE_09',
    'JUNE_9',
    '09',
    '9',
    'weekly_saturday'
);
@deoren
Copy link
Collaborator Author

deoren commented Jun 18, 2018

Note to self:

May not use the module, but it's worth researching.

@deoren deoren added this to the Future milestone Jun 14, 2019
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

1 participant