'await' outside function error given when running program

Question

I am trying to create a database with the module databases

This is the code that I have tried

from databases import Database
database = Database('sqlite:///example.db')
await database.connect()

query = """CREATE TABLE HighScores (id INTEGER PRIMARY KEY, name VARCHAR(100), score INTEGER)"""
await database.execute(query=query)

query = "INSERT INTO HighScores(name, score) VALUES (:name, :score)"
values = [
    {"name": "Daisy", "score": 92},
    {"name": "Neil", "score": 87},
    {"name": "Carol", "score": 43},
]
await database.execute_many(query=query, values=values)

query = "SELECT * FROM HighScores"
rows = await database.fetch_all(query=query)
print('High Scores:', rows)

Its returns an error of "SyntaxError: 'await' outside function"

How do I fix this

score 2 · Accepted Answer · answered Apr 21 '21 at 21:28

2

You cannot use await outside an async function.

async myFunc():
    await database.connect()

however, in order to call the await functions, you need to await them. You can do this by making use of the asyncio package. (So import asyncio ;)

import asyncio
loop = asyncio.run(myFunc()) # this will run a coroutine without awaiting.

You can convert this to work for all of the other functions. However, I would suggest putting everything in myFunc instead of making a new function for everything.

See the docs

answered Apr 21 '21 at 21:28

12944qwerty

2,001
1
10
30

No problem! Did this fix it? – 12944qwerty Apr 21 '21 at 21:31
is the myFunc a placeholder for a function, because if so I dont have any functions yet – Cody Brynlund Apr 21 '21 at 21:34
@CodyBrynlund Yes and no. Think of `myFunc` as `main.py` (in this case only). You will just run it in `asyncio.run` outside of the func. You can always rename `myFunc` to whatever you want. – 12944qwerty Apr 21 '21 at 21:36
When I try it, it says invalid syntax :( – Cody Brynlund Apr 21 '21 at 21:40
@CodyBrynlund Can you paste the code you used? – 12944qwerty Apr 21 '21 at 22:06
its to long to paste – Cody Brynlund Apr 22 '21 at 00:25
@CodyBrynlund How about posting it into pastebin? – 12944qwerty Apr 22 '21 at 02:24
You can also paste it in a bunch of other pasting sites (whichever is most accessibly for you is fine :) – 12944qwerty Apr 22 '21 at 02:30
tell me if it doesn't – Cody Brynlund Apr 22 '21 at 02:44
all though, I probably won't be on again until 3pm MDT – Cody Brynlund Apr 22 '21 at 02:44
@CodyBrynlund Let's move to a [chatroom](https://chat.stackoverflow.com/rooms/231440/codys-question) so we don't flood the comments. I'll chat from there – 12944qwerty Apr 22 '21 at 02:46
I need at least 20 reputation to chat there :( – Cody Brynlund Apr 22 '21 at 13:31
@CodyBrynlund Try again – 12944qwerty Apr 22 '21 at 14:32

'await' outside function error given when running program

1 Answers1

Linked