René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"sqlite3 fails on python3 RISC OS","articleBody":"Please accept my my apologies if this is not the correct place to report a problem with RISC OS Python. \r\nGerph suggested I post this to \"issues\"\r\n\r\n\r\nThe following python script runs to completion on Linux and creates a database file \"test_db\" in the same directory as the script.\r\n\u003cpre\u003e\u003ccode\u003e\r\nimport sqlite3\r\ncon = sqlite3.connect('test_db')\r\ncur = con.cursor()\r\ncur.execute(\"CREATE TABLE tab1 (name, phone)\")\r\ncur.execute(\"INSERT INTO tab1 VALUES('Bob',1234)\")\r\ncon.close()\r\nprint(\"reached end of script\")\r\n\u003c/code\u003e\u003c/pre\u003e\r\nOn RISC OS  Python3 the same code fails with error:-\r\n\u003cpre\u003e\u003ccode\u003e\r\n  File \"testSQL/py\", line 4, in \u003cmodule\u003e\r\n    cur.execute(\"CREATE TABLE tab1 (name, phone)\")\r\n    sqlite3.DatabaseError: file is not a database\r\n\u003c/code\u003e\u003c/pre\u003e\r\n\r\nIt does create a file but it does not put it in the same directory as the python script, but in the parent directory. It also mangles the name.\r\nThe created file has the parent directory name appended to it using a / separator.\r\nEg the script file is \"testSQL/py\" in directory \"sqlite\"\r\nThe new database file is not in \"sqlite\", but in the directory above and has a filename of \"sqlite/test_db\"\r\nIt looks as if the unix to RISC OS file conversion algorithm is going wrong.\r\n\r\n","author":{"url":"https://github.com/riscman","@type":"Person","name":"riscman"},"datePublished":"2021-05-18T17:29:05.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":1},"url":"https://github.com/19/cpython/issues/19"}