17:17 <apt-get_> hey, I'm trying to interact with a database

17:17 <apt-get_> https://gist.github.com/Sarkynin/3f2226fd968fa63829b9

17:17 <apt-get_> however, I'm getting this error

17:17 <apt-get_> /home/apt-get/ASBot/plugins/asblearn.rb:9:in `initialize': unable to open database file (SQLite3::CantOpenException)

17:17 <apt-get_> any reason why this is happening?

17:22 <onewheelskyward> It's probably a relative pathing or permissions problem.

17:23 <onewheelskyward> Or you haven't initialized that db file yet.

17:24 <apt-get_> nah it's there

17:25 <apt-get_> my permissions are correct, too :/

17:26 <onewheelskyward> hmm

17:26 <onewheelskyward> you're running the script as the user that owns the db file?

17:27 <apt-get_> ye

17:27 <apt-get_> actually, I think it might be relative pathing-related

17:27 <apt-get_> running the file in the same directory works

17:30 <onewheelskyward> yeah, that stuff can get weird.

17:30 <onewheelskyward> If you can, specify the full file path.

17:31 <apt-get_> meh

17:31 <apt-get_> I run it from heroku

17:31 <onewheelskyward> Ah.

17:42 <apt-get_> yeah, it's getting annoying

17:57 <apt-get_> onewheelskyward: doesn't work with the full path either :s

17:57 <apt-get_> @db = SQLite3::Database.new File.expand_path("../utils/pokedex.sqlite")

17:57 <apt-get_> same error

18:02 <leftylink> the reason I'm not surprised by that is that that still expands relative to CWD, whatever that may be. therefore I would attempt to make it relative to the file, not relative to CWD

18:04 <apt-get_> leftylink: cwd...?

18:05 <apt-get_> oh, current working directory

18:05 <apt-get_> so like

18:05 <apt-get_> move into the directory with the db?

18:06 <apt-get_> tbh the dirty method to do this

18:06 <apt-get_> would be to put a global variable containing the db

18:06 <apt-get_> in utils.rb in the utils folder

18:06 <apt-get_> but I'd rather not do that

18:12 <onewheelskyward> nah you need to figure out there Database.open's cwd is.

18:12 <onewheelskyward> s/there/where/

18:14 <apt-get_> the Database.open's directory

18:14 <apt-get_> is in the plugins folder

18:14 <apt-get_> at the root of my project

18:14 <apt-get_> I mean database.open's file

18:15 <onewheelskyward> Does it work locally ok?

18:15 <apt-get_> in the same folder as the database?

18:15 <apt-get_> yeah it works

19:23 <apt-get_> is it safe to move into another directory

19:23 <apt-get_> while using cinch?

19:23 <apt-get_> in a plugin I mean

19:23 <apt-get_> or will that cause problems

21:25 <dominikh> Cinch doesn't care what the current working directory is

21:26 <dominikh> your code is probably funky if you need to change it, but Cinch won't care

21:32 <apt-get_> dominikh: it's more of sqlite being funky

21:32 <apt-get_> than my code

21:33 <dominikh> I don't see how sqlite is involved in this. File.expand_path is a) relative to cwd b) unnecessary – and relative paths are usually relative to the current working directory

21:34 <dominikh> that's why either you either have a configuration option with an absolute path to the db, or a wrapper that cd's, then starts the bot

21:47 <apt-get_> wait

21:47 <apt-get_> oh, dominikh

21:47 <apt-get_> I just got where the error is coming from

21:48 <apt-get_> the initialize method of a plugin is ran by the directory the main bot file is in

21:48 <apt-get_> not in the plugin's directory

21:48 <apt-get_> yeah that fixes the whole issue

21:50 <dominikh> it's run in the directory in which you were when you ran `ruby my_bot.rb`

21:51 <dominikh> if you are in / and do `ruby /foo/bar.rb`, then cwd will be /

21:51 <apt-get_> yeah

21:51 <apt-get_> then that was me being dumb