search for: table_info

...own to a call to SQLiteAdapter#table_structure, and the source code suggests what''s happening is that "PRAGMA table_structure(#{table_name})" is returning empty metadata for some reason: def table_structure(table_name) returning structure = execute("PRAGMA table_info(# {table_name})") do raise ActiveRecord::StatementInvalid if structure.empty? end end Now, the sqlite client returns this: sqlite> pragma table_info("users"); cid name type notnull dflt_value pk ---------- --------...

...ve rails does (correct me if im wrong). On pages that query a table, everything is perfect. BUT when I use a view instead of a table everything goes down the tubes. I get 0.0''s for where text should be and all kinds of stuff breaks. I looked into the log and saw that rails did: PRAGMA table_info(my view) So I did that myself to see the results: ALL NUMERIC So I check an actual table: text and integers as it should be. My guess is the problem is in sqlite itself... views dont inherit the correct types of the table data they contain. Then I am guessing activerecord converts everything t...

...ear "drop": syntax error or sqldf("alter table Korea rename column hyr to hyrI", dbname = "mydb") error in statement: near "column": syntax error These are simple commands - am I missing something obvious? I can retrieve data from them, and retrieve their table_info Thanks Peter -- View this message in context: http://r.789695.n4.nabble.com/sqldf-modify-table-tp2291804p2291804.html Sent from the R help mailing list archive at Nabble.com.

...{"commit"=>"Opslaan", "collection"=>{"name"=>"dqsfqds", "description"=>"qfdsqsd"}, "action"=>"create", "controller"=>"collection"} [4;36;1mSQL (0.010000) [0;1mPRAGMA table_info(collections) [4;35;1mSQL (0.000000) INSERT INTO collections ("name", "description", "index_date") VALUES(NULL, NULL, NULL) Redirected to http://localhost:3000/collection/list Completed in 0.17000 (5 reqs/sec) | DB: 0.01000 (5%) | 302 Found [http://localhost/colle...

...3420) SELECT * FROM sections WHERE (parent_id = 0) ORDER BY created_at desc Section Load (0.034256) SELECT * FROM sections WHERE (parent_id > 0) ORDER BY created_at desc LIMIT 7 Rendering actionlistlayoutfalse within layouts/application Rendering story/list SQL (0.004732) PRAGMA table_info(sections) Section Load (0.026646) SELECT * FROM sections WHERE (sections.id = 6) LIMIT 1 Section Load (0.020160) SELECT * FROM sections WHERE (sections.id = 4) LIMIT 1 Section Load (0.092672) SELECT * FROM sections WHERE (sections.id = 3) LIMIT 1 Section Load (0.059666) SE...

Hi all, I want to see if I''m not missing something with associations and eager loading. (I''m currently using Locomotive on OS X and SQLite3.) I have two simple tables/models, set up properly: teams has_many :matches and matches belongs_to :teams. Matches has a match number and a team_id field (along with several other fields) and teams has a team_number field (again, along with

Hi, I think this has already been asked on the list, but I can''t seem to be able to find it again: currently, active record does some weird thing with its sql logs i.e.: [4;33mSQL (0.000000) [1;37mPRAGMA table_info(map_locations) how do I remove the "[4;35m" thx Jean

...gt;{"octet1"=>"129", "octet2"=>"83", "octet3"=>"10", "octet4"=>"0"}}, "action"=>"create_network_segment", "controller"=>"networking"} SQL (0.001979) PRAGMA table_info(network_segments) Completed in 0.00757 (132 reqs/sec) | Rendering: 0.00014 (1%) | DB: 0.00317 (41%) | 200 OK [http://test.host/networking/create_network_segment?network_segment=netmaskoctet40octet1255octet2255octet3254subnetoctet40octet1129octet283octet310range_start10range_end100] NetworkSegme...

...n ID: > Parameters: {"user"=>{"password"=>"bogus", > "email"=>"tmornini@bogus.com"}, "action"=>"attempt_login", > "controller"=>"user"} > [4;36;1mSQL (0.006807) [0;1mPRAGMA table_info(users) > [4;35;1mUser Load (0.000963) SELECT * FROM users WHERE > (users.deleted_at IS NULL) AND (email = ''tmornini@bogus.com'' and > hashed_password = ''5d0527d81f6c2d901a0a2d889cb73f9499402626'' and > verified = ''t'') LIMIT 1...

...;][$i]['host'] = '10.x.x.x'; $cfg['Servers'][$i]['extension'] = 'mysqli'; $cfg['Servers'][$i]['bookmarktable'] = 'pma_bookmark'; $cfg['Servers'][$i]['relation'] = 'pma_relation'; $cfg['Servers'][$i]['table_info'] = 'pma_table_info'; $cfg['Servers'][$i]['table_coords'] = 'pma_table_coords'; $cfg['Servers'][$i]['pdf_pages'] = 'pma_pdf_pages'; $cfg['Servers'][$i]['column_info'] = 'pma_column_info'; $cfg['Servers'][$i]...

Dear R wizards: I decided to take the advice in the R data import/export manual and want to learn how to work with SQL for large data sets. I am trying SQLite with the DBI and RSQLite database interfaces. Speed is nice. Alas, I am struggling to find a tutorial that is geared for the kind of standard operations that I would want in R. Simple things: * how to determine the number of rows in a

Sorry for a bit longer delay than I anticipated, I was stuffed with the work. This is the next iteration of the patch adding some functionality to apcsmart driver, and relying on 'ignorelb' recently added. Follow up from previous thread: http://www.mail-archive.com/nut-upsdev at lists.alioth.debian.org/msg02331.html Main differences is that V3 is split into many small patches, so the

This patch introduces a handful of new options, I mentioned earlier in: http://www.mail-archive.com/nut-upsdev at lists.alioth.debian.org/msg02088.html See the large commit message in the follow-up for the details and rationale. I realize it's a bit larger diff - so if it's required I can split it into few smaller ones. Michal Soltys (1): APC smart driver update and new features.

This is 2nd version of the earlier patch featuring a few new features and fixes to the apcsmart driver, following the remarks in: http://www.mail-archive.com/nut-upsdev at lists.alioth.debian.org/msg02294.html Major changes from v1: - handle battery.charge and battery.runtime checks at main.c level - handle "immutable but writable" conflict gracefully at driver level -

Hi everyone. I can''t get the above(subject line) combination to work. If I use a standard sqlite3 file db for the test db, and spec_server all the specs on my models pass. If I use an in-memory db for the test db, script/spec w/o spec_server, they all pass. But if I use in-memory and spec_server I get the following error: 1) ActiveRecord::StatementInvalid in ''User should be