Displaying 5 results from an estimated 5 matches for "mytestdb".
2006 Jan 29
4
Problems with FireRuby and scaffolding
I am trying to generate some scaffolding using "ruby script/generate
scaffold order order". It always fails with the message "uninitialized
constant CHARACTER_SET". I have an orders table in a Firebird databse
called TARPRILOGISTICS.GDB. The database is in a folder named "database"
in my rails app root folder. I tried FireRuby 0.4 and 0.4.1. My config
file looks
2012 Feb 02
9
sqldf for Very Large Tab Delimited Files
...getting first 10 records
Here is the reproducible code that I am trying:
# Text data file
write.table(iris, "irisNoH.txt", sep = "\t", quote = FALSE,
col.names=FALSE,row.names = FALSE)
# create an empty database (can skip this step if database already exists)
sqldf("attach myTestdbT as new")
f1<-file("irisNoH.txt")
attr(f1, "file.format") <- list(header=FALSE,sep="\t")
# read into table called irisTab in the mytestdb sqlite database
read.csv.sql("irisNoH.txt", sql = "create table main.irisTab1 as select *
from file"...
2009 Jan 23
0
Appending objects created using filehash package
...o an object, basically requires rewriting
the entire object.
Sample code: =================================================
# Setting up the database
library(filehash)
A <- data.frame(a=c("abcde", "fghij", "klmno"), stringsAsFactors=FALSE)
dumpDF( A, dbName="myTestDB")
envTest <- db2env(db="myTestDB")
ls(envTest)
with(envTest, a)
# Appending to object a, but basically rewriting it...
envTest$a <- c(envTest$a, "HELLO", "GOODBYE")
with(envTest, a)
If anyone has a suggestion on how to append to an object without complete...
2006 Aug 18
1
join update seperation?
I have a legacy DB without access to change the user or group table
(must use StoredProcedures to edit those). But I do have access to the
usergroup join so I thought the joins would be pretty much like my other
rails apps where I do HABTM checkboxes. I''ve created a page that just
shows habtm checkboxes for the join and the updates are occuring for the
join but I''m
2006 Apr 22
9
one to many question
1. A category has parent categories.
2. A product is in many categories and a category has many products.
3. Products and category both have images in the same image table. ie. a
product and / or category could have multiple images.<=== my question is
related to this
So among other things I presume I have to do the following:
class Category < ActiveRecord:Base
#...