Welcome!
This is the community forum for my apps Pythonista and Editorial.
For individual support questions, you can also send an email. If you have a very short question or just want to say hello — I'm @olemoritz on Twitter.
[SHARE CODE] PRAGMA query for sqlite
-
@Tizzy
os.path.join
treats both arguments as full paths. If the second one has a slash at the beginning, it is considered an absolute path (relative to the root directory/
), and the first path is effectively ignored. If you want to join two paths together, the second one must be a relative path. For exampleos.path.join("/usr/bin", "python")
returns"/usr/bin/python"
, butos.path.join("/usr/bin", "/python")
returns"/python"
. -
@dgelessus said:
@Tizzy
os.path.join
treats both arguments as full paths. If the second one has a slash at the beginning, it is considered an absolute path (relative to the root directory/
), and the first path is effectively ignored. If you want to join two paths together, the second one must be a relative path. For exampleos.path.join("/usr/bin", "python")
returns"/usr/bin/python"
, butos.path.join("/usr/bin", "/python")
returns"/python"
.thank you I see what happened there then.
-
-
@Tizzy , did look though your dirs, to see if the db was created somewhere? It's really hard to get it to fail
-
The "temporary" directory during runtime I referred to above doesn't actually appear to be temporary because in subsequent runs, the table i created earlier is said to "already exist." However I can find NO trace of it. searching in xCode (the search tends to be pretty thorough there usually) and in finder, yields NOTHING.
Also worth noting, when run through the simulator all of those relative paths never once surfaced a "scripts" folder in the path, but a "Documents" folder. Scripts is the folder in which my scripts are in. But during runtime it doesn't know scripts exists.
FURTHER: just running the same thing outside of the simulator, the db file IS created and visible as it should be. So to conclude: iOS apps create a different directory structure at runtime, and I can't figure out how to manually access that outside of runtime, but if I pre-create the file will it get moved to the "runtime" "Documents" directory like all the other scripts so I can have a db file initialized before runtime but accessible during runtime using the relative directory stuff?
Does any of that make sense to you guys? I think this might work, initializing it outside of Xcode with the values i need, and then it should (i think) be put into the runtime directory along with the other files. I will report back with further findings.
-
@Tizzy , again I cannot help. But when searching for the database using the finder did you use wild cards, or use the filters for created today etc, also checking if it's visible. If the table reports it exisits , it must be there somewhere
-
I did find it at the absolute url specified in userr/Library/......./
But my takeaway is if you want to setup a sqlite database for use by an Xcode app, do so outside of Xcode if you want it to be in your scripts directory permanently.
-
Ok, I was just trying to test how big a empty database is... Now, I see an issue I was having before. Not sure why. But if you use sqlite3.connect() to create a database file and nothing else, it ends up as zero bytes. A valid sqlite3 db file is suppose to have a valid file header of a 100 bytes.
I did different ways, using with, committing then closing etc. but still made a zero byte file. Maybe this behaviour is expected, but not by me.
So my point being, if you make a db file as a placeholder. Good to check it's a valid sqlite3 db file -
@Phuket2 said:
Ok, I was just trying to test how big a empty database is... Now, I see an issue I was having before. Not sure why. But if you use sqlite3.connect() to create a database file and nothing else, it ends up as zero bytes. A valid sqlite3 db file is suppose to have a valid file header of a 100 bytes.
I did different ways, using with, committing then closing etc. but still made a zero byte file. Maybe this behaviour is expected, but not by me.
So my point being, if you make a db file as a placeholder. Good to check it's a valid sqlite3 db fileI can confirm a newly created .db sqlite3 file is 0Kb. adding a table makes it 8Kb.
-
@Tizzy , but I am glad I tested it. This has being giving me grief. I didn't know why. Now I know why ðŸ˜ðŸ˜±