similar to: Selective Tests w/ in-memory db

On Wed, Aug 26, 2020 at 06:57:43PM +0200, Pino Toscano wrote: > Fedora 33 switched the DB of RPM to SQLite, so no more Packages/Name/etc > files. Because any missing file exception is ignored when checking for > --if-newer, the lack of the Package files was not properly noticed, so > the appliance was always considered out out date. > > Check for the SQLite-based DB first,

On Wednesday, 26 August 2020 21:15:36 CEST Richard W.M. Jones wrote: > On Wed, Aug 26, 2020 at 06:57:43PM +0200, Pino Toscano wrote: > > Fedora 33 switched the DB of RPM to SQLite, so no more Packages/Name/etc > > files. Because any missing file exception is ignored when checking for > > --if-newer, the lack of the Package files was not properly noticed, so > > the

HI, I got the problem. I use the following query to read table individually, how can I read all tables autimatically rather than typing "week42" "week33" in dbReadTable? library(RSQLite) library(sqldf) drv <- dbDriver("SQLite") con<-dbConnect(drv, "sqlite.db") dbListTables(con) #dbRemoveTable(con, "week39") dbDisconnect(con)

I''m just starting out learning. So far, all I''ve done is little test apps starting from scratch -- ie, ones in which rails creates an empty database, then I make up some classes and views and controllers and such. Nice system. But what if I have an SQlite database file created elsewhere: (how) can I import this into ruby "easily"? I have not tried yet because it just

Fedora 33 switched the DB of RPM to SQLite, so no more Packages/Name/etc files. Because any missing file exception is ignored when checking for --if-newer, the lack of the Package files was not properly noticed, so the appliance was always considered out out date. Check for the SQLite-based DB first, falling back to the old format. Signed-off-by: Pino Toscano <ptoscano@redhat.com> ---

Hi all, My question is related to the sqlite db I''m using with my rails app. I was thinking if its possible to save the file (ROR_DIR/db/development.sqlite) and then if somehow the db gets erased or if I do a rollback and then a migrate can I retrieve my information by copying the file back to the same location ? Since I''m hosting the app from my linux box and most of colleagues

Hello The DB() application is fine as long as we don't need more than one value pointed to by a key, ie. the way SleepyCat works. Problem is, for each phone number, I'd like to map more than one column, eg. name, e-mail, fax, etc. Is there a way to have DB() use SQLite instead of AST, or a way to keep both in sync (ie. export data from AST to SQLite automatically)? Thank you.

Hi. I have a problem with the association methods which passed to a model through a belongs_to declaration. Here''s an illustration of the issue: GIVEN: # migration class CreateArticlesAndAuthorsTables < ActiveRecord::Migration   def self.up     create_table :articles do |t|       t.text     :title       t.integer :author_id     end     create_table :authors do |t|       t.text

I am having a very strange issue with Dovecot + Sqlite + SELinux in enforcing. I am able to log in via IMAPS if SELinux is in permissive, but not able to do so when in enforcing. I do not see any SELinux denials even with dontaudit's enabled. I am running Centos 5 on x86_64 with a customized kernel build and SElinux Strict policy. The log dumps below are in the following order:? 1. My syslog

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

Just wondering if anyone is using a backend database other than sqlite, and if so, how easy/hard it was to configure. I''m constantly receiving "SQLite3::BusyException: database is locked..." which I presume is due to sqlite''s relatively coarse locking method. Cheers, James -- Senior Linux Platform Engineer Midrange Services AXA Technology Services - Asia Pacific

Hello, $ ruby script/generate model balance plus:integer minus:integer equal:integer $ cat app/models/balance.rb class Balance < ActiveRecord::Base def save self.equal = self.plus - self.minus super end end $ cat test/fixtures/balances.yml _10-1: plus: 10 minus: 1 $ rake db:fixtures:load $ sqlite3 db/development.sqlite3 sqlite> select * from balances; //=>

Hi, I''d like to make a demo version of my app available, but I''m not ready to get into database stuff, yet. Has anyone ever deployed with sqlite (what I used to develop my app)? If so, what hosting service(s) would you recommend? Thanks, Lille -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this

Hi, I came across the strangest issue I have no idea how it happened. In my development environment, I created a new migration and model that uses a couple of decimal column types (among others). Everything works great with sqlite and the development environment, business as usual. However, I deployed to production and for some completely unknown reason, this particular table (only this one)

Hello, I followed the instructions on http://wiki2.dovecot.org/Plugins/Expire to configure the expire plugin, but when I move a message to the Trash folder, I get the following error messages in my logfile: dovecot: dict: Error: sqlite: exec(INSERT INTO expires (expire_stamp,username,mailbox) VALUES ('1292525469','christoph','Trash')) failed: unable to open database

I am writing a library module to handle certain StatementInvalid type AR exceptions. I wish to catch the case where the db adapter in use is not supported by the module. I would like to test this situation and have only a vague idea as to how to proceed. My exception handling method selects the parsing method based on the adapter_name value. def hll_ar_exception(exception) raise

All; I'm working on a project (using Asterisk 1.8, but 11 would probably work just as well) where so far I've been able to originate over 1,000 concurrent outbound faxes. I have no problem with that so far. Where I have the problem is that Asterisk is dumping core after the faxes are sent. Now two things happen after the faxes are sent. (1) A fax log similar to a CDR is written to

As I think I previously mentioned, there is an incompatibility with rails 1.2.1 and sqlite3 3.3.8. see: http://weblog.rubyonrails.org/2007/1/29/using-sqlite3-with-rails and: http://weblog.rubyonrails.org/2007/2/6/rails-1-2-2-sqlite3-gems- singular-resources Sqlite is now at 3.3.13. Because of this, if a developer is trying to create a patch for rspec_on_rails, he will have one of the

I believe that Asterisk 1.8 and older uses the BerkeleyDB for Asterisk's internal database (AKA the Astdb) and in newer versions use SQLite. However, the basic functionality is the same. Whether you use the Astdb or MySQL really depends on what you want to do with it. The AstDB is not a relational database like MySQL, it simply a key/value store. If you can get away with that, and you need

1. That was a part of a private email exchange. It has been suggested that more people may be interested. 2. I did use various databases (significant part of my job) for the last 15 years. Some with R for the last 3 years as a hobby. Some comments on the ones used below. Sorry, no links - I am time-constrained at the moment - please google if interested in details. The remarks are from the point