• TutorialDoctor

    import ui,sqlite3
    database = "database.db"
    con = sqlite3.connect(database)
    cursor = con.cursor()
    users_query = "select * from users"
    user_sections ="SELECT * FROM users INNER JOIN post on post.user_id = user.id"
    user_names = [x[1] for x in cursor.execute(users_query)]
    v = ui.load_view()
    table = v['table']
    table.data_source.items = user_names

    To add accessories:

    user_names = [{"title":x[1],"accessory_type":"disclosure_indicator"} for x in cursor.execute(users_query)]

    posted in Pythonista read more
  • TutorialDoctor

    I completely missed this reply. Sounds like a good challenge to take on. I'll see how far I can get with it.

    posted in Editorial read more
  • TutorialDoctor

    @johnridesabike Wow! Really! Glad it was helpful!

    I am currently working on setting up a Flask template project that will work somewhat similar to Pythonista using Bootstrap for the UI elements. I plan to convert that bible app over to a WebApp and maybe an IOS app one day. I followed you on Github as well by the way.

    - TD

    posted in Pythonista read more
  • TutorialDoctor

    Nice! I know what it takes to make an app that you've been wanting. I made a full bible app myself. I didn't use Jinja though (as I didn't know anything about it then):


    I am currently learning Flask for web app development. All of what I know started with Editorial's drag&drop programming. From there I went to Pythonista and now I am learning Flask.

    Thanks @olemoritz!

    posted in Pythonista read more
  • TutorialDoctor

    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.

    -Tutorial Doctor

    posted in Editorial read more
  • TutorialDoctor

    @xxfunxx said:

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


    posted in Pythonista read more
  • TutorialDoctor

    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):
    commands = {"key":"value",
    "brief":"flash briefing",
    "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():
        while running:
            command=input('Type a command :')
            if command != "end" or "the":
                    talk("Alexa, "+commands[command])
                except: talk(command)
            if command=='end':
                return False
            if command=='...':

    posted in Pythonista read more
  • TutorialDoctor

    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:

    Then, download my GitHub Get workflow:

    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!

    posted in Editorial read more
  • TutorialDoctor

    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?

    posted in Editorial read more
  • TutorialDoctor

    from sys import argv
    target=open(filename,'w') #open it for writing, as opposed to reading.

    posted in Pythonista read more

Internal error.

Oops! Looks like something went wrong!