Displaying 5 results from an estimated 5 matches for "sqlite_master".
2006 Mar 26
4
select information from sqlite_master error
...ever lose my papers/revisions....hehe).
I''ve given tepee an oswd css design, and am currently adding a admin page that I want to show the ruby version, sqlite version and db size and db stats information.
I tried running:
@db_stats = ZenDesk::Models::Base.find_by_sql("SELECT * FROM sqlite_master")
to see what information I could gleen from the master table and I got this error:
ZenDesk::Controllers::Admin.GET ActiveRecord::SubclassNotFound The single-table inheritance mechanism failed to locate the subclass: ''table''. This error is raised because the column '...
2009 Feb 20
2
importing data to SQLite database with sqldf
...parate tables
for( fi in list.files(".","txt$") ) {
mydata <- read.delim(fi)
sql(sprintf("create table %s as select * from mydata",sub("\\.txt","",fi)))
}
rm(fi,mydata)
## (4) merge tables
tablenames <- as.character(sql("select * from sqlite_master")$name)
sql(paste("create table myfulltable as",
paste(sprintf("select * from %s",tablenames),
collapse=" union all ")))
## (5) delete separate tables since we have a merged one
for( nm in tablenames ) sql(sprintf("drop table %s"...
2010 May 20
1
sqldf: issues with natural joins
...t; sqldf()
# to create indices on the Tid variable shared across data.frames
> sqldf('create index indA on A(Tid)')
> sqldf('create index indB on B(Tid)')
> sqldf('create index indC on C(Tid)')
# check to make sure everything is there
> sqldf('select * from sqlite_master')
# doing a natural join (implicitly on Tid)
# does not give the expected joins
> sqldf('select * from main.A natural join main.B')
[1] Tid dfName
<0 rows> (or 0-length row.names)
> sqldf('select * from main.A natural join main.C')
[1] Tid dfName
<0 rows>...
2012 Sep 18
2
NoMethodError with rake db:migrate
...(first_time)
** Invoke environment (first_time)
** Execute environment
** Invoke db:load_config (first_time)
** Execute db:load_config
** Execute db:migrate
rake aborted!
NoMethodError: undefined method `to_a'' for
#<SQLite3::Statement:0x9d6a2dc>: SELECT name
FROM sqlite_master
WHERE type = ''table'' AND NOT name = ''sqlite_sequence''
AND name = "schema_migrations"
/var/lib/gems/1.9.1/gems/activerecord-3.2.8/lib/active_record/connection_adapters/sqlite_adapter.rb:248:in
`block in exec_query''
/var/lib/gems/1.9....
2010 Nov 04
9
Delete action is not working and redirects to edit action
Hello,
i have a strange problem here. I have made a teacher controller using
scaffold. All actions work fine but the delete does not. When i click
the delete link, it redirects me to the edit of this teacher. I have
restarted the server and i have tried in firefox (i use chrome) but
problem still remains. Here is the code from my view.
<%= link_to(image_tag("/images/