Simply, I have two tables.
Orders table stores each unique order as a single row. ProductsInTheOrder table stores each product as a single row for each Order.
A quick preview is:
| Id | Total | Timestamp |
|---|
| #!/bin/bash | |
| # | |
| echo $0 is starting carla | |
| # | |
| pw-jack -s 48000 -p 1024 guitarix & | |
| Sleep 2 | |
| pw-jack -s 48000 -p 1024 calfjackhost -l <PATH TO SAVED FILE> & | |
| Sleep 2 | |
| pw-jack -s 48000 -p 1024 carla "<PATH TO PROJECT FILE>.carxp" & | |
| Sleep 2 |
| class customerSupportIntentHandler(AbstractRequestHandler): | |
| """Handler for Customer Support Project""" | |
| def can_handle(self, handler_input): | |
| return ask_utils.is_intent_name("customerSupportIntent")(handler_input) | |
| def handle(self, handler_input): | |
| # Take answered issue key number as string | |
| issueKey = str(handler_input.request_envelope.request.intent.slots["issueKey"].value) | |
| # In that example, CS is the Project Key for Customer Support. full_key will be CS-1234 while answered slot value is 1234. | |
| full_key = 'CS-%s' % issueKey |
| DROP TABLE IF EXISTS `pk_il`; | |
| CREATE TABLE `pk_il` ( | |
| `il_id` int(2) NOT NULL COMMENT 'plaka kodu', | |
| `il_adi` varchar(255) NOT NULL, | |
| PRIMARY KEY (`il_id`), | |
| KEY `il_adi` (`il_adi`) USING BTREE | |
| ) ENGINE=MyISAM; | |
| -- ---------------------------- |