Schedule a SQL cron task

WayScript allows you to configure your Lair to schedule task execution in minutes.


Use the boilerplate code below to create a file in your Lair’s root directory. See File system for more details on how to manipulate files in your workspace file system.


import os
import mysql.connector
# These credentials can be found via your database credentials page
# For additional help with these values, please visit the docs of where your database is hosted.
mydb = mysql.connector.connect(
# SQL statement to execute
sql = "SELECT * FROM earnings;"
mycursor = mydb.cursor()
myresult = mycursor.fetchall()

Create a requirements.txt file:


Configure cron trigger

Open your Lair’s .triggers file and add a new cron trigger. Create a name for your trigger, input the following run command, and set an interval or custom cron syntax for your task. See Triggers for more details.
Example Cron Trigger Setup

Test your task execution in development environment

Press “Test” to execute the run command and start your task’s process execution. A process tab should open in your Terminal view.
Press Test in your Triggers view to test your cron Trigger. When ready, deploy it to production!
Be sure to install your requirements.txt via your terminal.
pip install -r requirements.txt
pip freeze > requirements.txt

Deploy to a Production environment

Your task will not be scheduled within your Lair’s development environment. Once you have finished testing, Go to the Deploy Panel to deploy a production instance of your task.
In order for your scheduled task to run, you must Deploy the lair!

View Logs

Logs are automatically stored for both Development tests and Production runs of your task.