Python

skmsjh wrote:

the table is not nonexistent

skmsjh wrote:

However, the table is there.

conn = sqlite3.connect('Chef__Order.db')
conn.execute("""CREATE TABLE IF NOT EXISTS "Chef" ( "ChefID" TEXT NOT NULL, "Chefs" TEXT NOT NULL, "Meals cooked No." INTEGER, PRIMARY KEY("ChefID","Chefs") )""")
conn.execute("""CREATE TABLE IF NOT EXISTS "Food" ("FoodID" INTEGER, "Food names" TEXT, "Ratings" INTEGER, "Price" INTEGER, PRIMARY KEY("Price", "Food names", "FoodID"))""")
conn.execute("""CREATE TABLE IF NOT EXISTS "Members" ("ID" TEXT NOT NULL, "Names" TEXT, "Feedback" INTEGER, PRIMARY KEY("ID","Names"))""")
conn.execute("""CREATE TABLE IF NOT EXISTS "Progression" ("OrderNo" INTEGER, "ID" TEXT, "Food" TEXT, "Quantity" INTEGER, "Price" REAL, "Progress" TEXT, FOREIGN KEY("ID") REFERENCES "Members"("ID"))""")

Dave Kreskowiak wrote:

That's not how this works.

Quote:

What is Coding? “Writing code,” “coding,” and “programming” are basically interchangeable terms. Broadly speaking, knowing how to write code is the process of creating instructions that tell a computer what to do, and how to do it. Codes are written in various languages, such as JavaScript, C#, Python, and much more.

Escape Characters — Python Reference (The Right Way) 0.1 documentation[^]:

Unless an ‘r’ or ‘R’ prefix is present, escape sequences in strings are interpreted according to rules similar to those used by Standard C.
...
When an ‘r’ or ‘R’ prefix is present, a character following a backslash is included in the string without change, and all backslashes are left in the string.

Certainly! In Python, the difference between `"C:\\my folder"` and `r"C:\my folder"` lies in how they handle backslashes within strings:

1. **`"C:\\my folder"`:**
   - This is a regular Python string where the backslash `\` is an escape character. When you use `\\`, it represents a single backslash in the resulting string.
   - For example, `"C:\\my folder"` would be interpreted as `"C:\my folder"` when used in code.

2. **`r"C:\my folder"`:**
   - The `r` prefix before the string denotes a raw string in Python. In a raw string, backslashes are treated as literal characters and are not interpreted as escape characters.
   - So, `r"C:\my folder"` represents the string exactly as it is, including the backslash, and results in `"C:\my folder"`.

Yes, you can achieve the same result by using a raw string. Both `"C:\\my folder"` and `r"C:\my folder"` represent the same file path, but using a raw string often makes code more readable and avoids potential confusion with escape sequences.