We're building a rapid development platform for developers called WayScript. Thank you to all of the community members who have tried it out. Today's tutorial can also be viewed as a video here. Of course, you can also find this completed script here as everything you build can be shared publicly or privately.

Introduction

Automation makes our lives easier. Here at WayScript, we want to provide tools to developers that take away the pain points to implement this automation. Database work can be tricky, let's see how we can automate daily SQL queries on our database using WayScript.

Prerequisites

No prerequisites but some content you might find helpful:
Working with databases
Working with CRON

Activating a Script Routinely

To activate any script on WayScript at set intervals, on certain days, or at certain time, we offer the use of the time trigger:

We're able to do anything fancy that you might want to using full CRON syntax to denote when we want to activate our script.

For the purposes of simplicity, let's make our's run everyday at 7AM.

Once we have this, anything contained in this tree will be executed, everyday, at 7AM.

Connecting our Database

To connect our database, we'll need to drag it into our workflow below our time trigger.

Once here, we'll need to provide some information for WayScript to be able to read/write your database. If you need help with setting up your database, our documentation has a full video and text walkthrough. As with anything else, if you get stuck feel free to reach out to us on our discord as well.

Executing your Database Action

Now that we have the database in the workflow, we're able to write SQL statements and execute those against our tables just like how we would locally. Click edit code to the left:

This will give us access to the text editor, in which we can write our own custom code. Let's just put something simple in:

SELECT * FROM table_name

This will give us access to all of the information in our table. We can then use this data throughout our script to trigger other actions. Such as sending emails with this data, alerting us if a value exists, and plenty more.

Questions, Concerns?

If there's any questions feel free to comment below or message us on discord after you sign up. We're happy to help! If you want to see this full script template, you can find it here.