I'm thinking about making an Sqlite workflow where you can create, read, update, delete info of an SQLITE database with actions.

I'm thinking about making the different functions as custom actions with fields for input.

I'd like some feedback on if anyone would like this and some ideas on how one might use this. This will help me design it better.

Thanks.
-Tutorial Doctor

@xxfunxx said:

Hello. I wrote something a long time ago that might help you understand programming a bit better:

http://forum.maratis3d.com/viewtopic.php?id=868
and
http://forum.maratis3d.com/viewtopic.php?id=840

I'm interested in using Pythonista to program Alexa skills. Currently I am playing around with a chatbot script I made a while ago and using the speech module to have the iPad talk to Alexa (really fun). I'm wondering if someone has already created a smart home module that can connect to various devices or not.

I did find a video of someone using Python to create skills. https://www.youtube.com/watch?v=cXL8FDUag-s

I feel I am on to something. Anyone done anything with smart home devices? Perhaps HomeKit in Pythonista would be cool? A little program I am playing with below:

import speech

def talk(x):
    speech.say(x,"en-au",.5)
    
commands = {"key":"value",
"end":"end",
"brief":"flash briefing",
"stop":"stop",
"simon":"simon says: What is your favorite animal?",
"1":"volume to 1",
"2":"volume to 2",
"3":"volume to 3",
"4":"volume to 4",
"5":"volume to 5",
"6":"volume to 6",
"7":"volume to 7",
"8":"volume to 8",
"9":"volume to 9",
"10":"volume to 10",
"bible":"play bible app",
"?":"What can you do?",
"weather":"What's the weather like?",
"movies":"What movie's are playing",
"joke":"Tell me a joke.",
"inspire":"Inspire me."
}

def Main():
    running=True
    while running:
        command=input('Type a command :')
        if command != "end" or "the":
            try:
                talk("Alexa, "+commands[command])
            except: talk(command)
        if command=='end':
            return False
        if command=='...':
            talk(command)
            
# FUNCTIONS
#-----------------------------
Main()

I'm getting back into creating Workflows for Editorial and realized I never posted the Bible app I made for Editorial to the forums. Instructions below.

Inside Editorial download the bible app workflow:
http://www.editorial-workflows.com/workflow/5886269255057408/gB6JnYgZBNw

Then, download my GitHub Get workflow:
http://www.editorial-workflows.com/workflow/5825287698776064/0yCN6R61LAQ

By default the GitHub Get workflow is set to download a Github repo that includes the needed bible.db database. Run the Github Get workflow, find the database file inside of the new-found Online Downloads folder in Editorial, and move it to the Documents folder.

Now you can run the Bible 2 workflow!

I'm guessing the newest version of Editorial is supposed to have an asset picker for the sound module. I don't see it? Perhaps this was copied from Pythonista (which does have an asset picker) and was not removed for Editorial documentation. However, Editorial does have an updated sound module.

Any leads?

from sys import argv

filename=input()
target=open(filename,'w') #open it for writing, as opposed to reading.
target.write('hello')
target.close()

No problem. That is a good book though. A few others I used:

https://gist.github.com/TutorialDoctor/980911848cad7217cfc0

Cool. Looking forward to more.

In Python version 3, raw_input was replaced with just input().

I build my UI using the UI designer and then I copy the JSON into a string inside of the code. Then I load the view using ui.load_view_str(). Another way you could do it.
Example: https://github.com/TutorialDoctor/The-Bible-App/blob/master/the_bible.py