That's right. I did it. Shame on me for not reading carefully the documentation. Thank you guys.
On Thu, Apr 21, 2011 at 10:09 AM, Frederick Cheung < [email protected]> wrote: > > > On 20 Apr 2011, at 20:17, Federico Rota <[email protected]> wrote: > > Well, when I run .databases i see something like an empty grid clearly > indicating that there is no database. > I think i should see my rails' databases (the ones resulting populated from > rails console as i said before). > > > You misunderstand what .databases does. It lists all attached databases, > not all the databases that exist (since a database is just a file anywhere > on disk). If you just run sqlite3 there are no attached databases. If you > run sqlite3 path/to/something.sqlite3 then it will attempt to load that > database, you can also attach extra databases with the attach database > command > > Fred > > This is the first time i use sqlite but i think the command is right. > I don't think i have 2 different instances of sqlite installed (one used by > rails and another one where i use the .databases command). I can't > understand where is my sqlite database populated via rails and how can i > verify my tables via sqlite console queries. > > Thanks again > > Il giorno 20/apr/2011, alle ore 16:09, Bryan Crossland > <<[email protected]> > [email protected]> ha scritto: > > On Tue, Apr 19, 2011 at 4:27 PM, Federico < > <[email protected]><[email protected]> > [email protected]> wrote: > >> Hello guys, >> I've made a very simple application following the footsteps of >> >> <http://guides.rubyonrails.org/getting_started.html><http://guides.rubyonrails.org/getting_started.html> >> http://guides.rubyonrails.org/getting_started.html. >> I managed to insert my objects (i checked the existence of inserted >> objects through the rails console with a simple Foo.all ) but if I run >> sqlite3 from command line and then run .databases I can't see any >> database created. >> I thought I could see the databases set in my database.yml ( database: >> db/development.sqlite3 database: db/test.sqlite3 database: db/ >> production.sqlite3 ) but the .databases command shows nothing. >> >> sqlite3 --version >> 3.5.6 >> rails -v >> 3.0.5 >> O.S. Windows 7 >> >> > You don't see any of the databases you expected to see. What do you see > when you run .databases? > > B. > > -- > You received this message because you are subscribed to the Google Groups > "Ruby on Rails: Talk" group. > To post to this group, send email to <[email protected]> > [email protected]. > To unsubscribe from this group, send email to > <[email protected]> > [email protected]. > For more options, visit this group at > <http://groups.google.com/group/rubyonrails-talk?hl=en> > http://groups.google.com/group/rubyonrails-talk?hl=en. > > -- > You received this message because you are subscribed to the Google Groups > "Ruby on Rails: Talk" group. > To post to this group, send email to [email protected]. > To unsubscribe from this group, send email to > [email protected]. > For more options, visit this group at > http://groups.google.com/group/rubyonrails-talk?hl=en. > > -- > You received this message because you are subscribed to the Google Groups > "Ruby on Rails: Talk" group. > To post to this group, send email to [email protected]. > To unsubscribe from this group, send email to > [email protected]. > For more options, visit this group at > http://groups.google.com/group/rubyonrails-talk?hl=en. > -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.
