I am a new user (as of about 2 hours ago). I have two tables that have a
one-to-one relationship with a third (so, of course, there is a one-to-many
from the third to the other two). The code looks like below. However, I
get the following error message on compile and I do have foreign keys
prese
On 10/24/05 4:07 PM, "John Siracusa" <[EMAIL PROTECTED]> wrote:
> On 10/24/05, Sean Davis <[EMAIL PROTECTED]> wrote:
>> I am a new user (as of about 2 hours ago). I have two tables that have a
>> one-to-one relationship with a third (so, of course, there is a
I've used RDBO for less than 24 hours and I really like it so far. I was
just curious what thoughts folks have about designing reusable "plugins" for
RDBO. I'll admit that I haven't done my homework on this yet except to
glance over CPAN and quickly browse the archives. Such capability is
gettin
Using RDBO 0.78. Schema, class definitions, and class definitions are
below. I get the following errors in executing the test code. Sorry to
post so many questions in such a short period of time.
No Rose::DB::Object-derived class found for catalog '' schema 'public' table
'g_main' at /Library/P
On 10/25/05 11:01 PM, "John Siracusa" <[EMAIL PROTECTED]> wrote:
> On 10/25/05 6:54 AM, Sean Davis wrote:
>> I've used RDBO for less than 24 hours and I really like it so far. I was
>> just curious what thoughts folks have about designing reusable "
Is there support for views in RDBO (as in views in the database acting as
tables, not as in "fake" views done in perl)? I don't see any and was just
curious if I was missing something.
Sean
---
This SF.Net email is sponsored by the JBoss Inc.
On 10/27/05 4:34 PM, "John Siracusa" <[EMAIL PROTECTED]> wrote:
> On 10/27/05, Sean Davis <[EMAIL PROTECTED]> wrote:
>> Is there support for views in RDBO (as in views in the database acting as
>> tables, not as in "fake" views done in perl)? I
On 10/28/05 8:03 AM, "John Siracusa" <[EMAIL PROTECTED]> wrote:
> On 10/28/05 6:31 AM, Sean Davis wrote:
>> On 10/27/05 4:34 PM, "John Siracusa" <[EMAIL PROTECTED]> wrote:
>>> On 10/27/05, Sean Davis <[EMAIL PROTECTED]> wrote:
>>>
On 10/28/05 8:22 AM, "John Siracusa" <[EMAIL PROTECTED]> wrote:
> On 10/28/05 8:11 AM, Sean Davis wrote:
>> Sorry. Re-reading, I did imply that it wasn't possible. What I meant was
>> that one HAS to define the primary key explicitly
>
> Well, unl
On 11/15/05 7:58 PM, "John Siracusa" <[EMAIL PROTECTED]> wrote:
> 0.081 (11.15.2005) - John Siracusa <[EMAIL PROTECTED]>
>
> * Tutorial added.
A package that works is quite nice; one that works as the SPECTACULAR
documentation says is even better!
Thanks for the hard work
Sean
--
I have a loader that loads a class
My::DB::GMain
associated with table g_main and seems to load My::DB::GMain::Manager.
However, when I make this call:
my @gmain = My::DB::GMain::Manager->get_gmains(query=>[gene_id=>672]);
I get:
Can't locate object method "get_gmains" via package "My::DB::GMa
On 11/28/05 11:54 AM, "John Siracusa" <[EMAIL PROTECTED]> wrote:
> On 11/28/05, Sean Davis <[EMAIL PROTECTED]> wrote:
>> I have a loader that loads a class
>>
>> My::DB::GMain
>>
>> associated with table g_main and seems to load My
On 11/28/05 12:16 PM, "John Siracusa" <[EMAIL PROTECTED]> wrote:
> On 11/28/05, Sean Davis <[EMAIL PROTECTED]> wrote:
>> My::DB::GMain is the class name, so I expected gmains. In practice, I
>> looked a the loader code and it is using the ACTUAL table name
John,
Is there a way to pass the make_classes params via RDBO::Loader->new?
Instead of doing:
My $loader = RDBO::Loader->new()
Then
$loader->make_classes(include_tables => 'xyz')
Doing something like:
My $loader = RDBO::Loader->new(make_classes => {exclude_tables => 'xyz'});
$loader->make_c
On 11/28/05 1:21 PM, "John Siracusa" <[EMAIL PROTECTED]> wrote:
> On 11/28/05, Sean Davis <[EMAIL PROTECTED]> wrote:
>> Is there a way to pass the make_classes params via RDBO::Loader->new?
>> Instead of doing:
>>
>> My $loader = RDBO::Lo
On 11/28/05 1:52 PM, "John Siracusa" <[EMAIL PROTECTED]> wrote:
> On 11/28/05, Sean Davis <[EMAIL PROTECTED]> wrote:
>> Ok. To be a bit more transparent, I have been working on a
>> Catalyst::Model::RDBO (for my own use, anyway). I am simply modeling it on
I am looking at needing to create a web-app that includes some scaffolding
of RDBO classes. I would like to use catalyst (though I don't think the
framework in important to the question). So, I have a couple of general
questions--how do you envision integrating a rose::db::object with a
rose::htm
On 12/13/05 6:28 AM, "Davis, Sean (NIH/NHGRI) [E]" <[EMAIL PROTECTED]>
wrote:
> I am looking at needing to create a web-app that includes some scaffolding
> of RDBO classes. I would like to use catalyst (though I don't think the
> framework in important to the question). So, I have a couple o
On 12/13/05 7:55 AM, "John Siracusa" <[EMAIL PROTECTED]> wrote:
> On 12/13/05 6:28 AM, Sean Davis wrote:
>> how do you envision integrating a rose::db::object with a rose::html::object
>> (in particular, a form)? The correspondence between html::object and
>
Title: Loader make_modules problem?
I have to start by saying that I really like the make_modules concept; I dreaded having to hand-edit multiple files for large changes in database schema, but having module code to customize is necessary for many apps; this approach is the best of both worlds.
Sorry about the formatting as this came through. Let me know if you would
like me to simply attach files of interest to reproduce the errors, etc.
On 1/4/06 9:05 AM, "Sean Davis" <[EMAIL PROTECTED]> wrote:
> I have to start by saying that I really like the make_modules c
On 1/4/06 10:12 AM, "John Siracusa" <[EMAIL PROTECTED]> wrote:
> On 1/4/06, Sean Davis <[EMAIL PROTECTED]> wrote:
>> The resulting modules contain references to some modules that do not exist,
>> it seems. For example, the Dog::DB::Dog module looks like
I haven't seen a "find_or_create" method anywhere. I know there is a good
reason why there isn't one (if there isn't one). It seems like a useful
method to have when creating new related objects in multiple tables. Before
I naively write my own, why is there not such a method?
Thanks,
Sean
On 1/4/06 4:50 PM, "John Siracusa" <[EMAIL PROTECTED]> wrote:
> On 1/4/06, Sean Davis <[EMAIL PROTECTED]> wrote:
>> I haven't seen a "find_or_create" method anywhere. I know there is a good
>> reason why there isn't one (if there i
My loader script:
#!/usr/bin/perl
use strict;
use warnings;
use lib '../lib';
use Rose::DB::Object::Loader;
use Dog::DB;
use Dog::DB::Base;
my $loader =
Rose::DB::Object::Loader->new(
db => Dog::DB->new,
class_prefix => 'Dog::DB',
base_classes => 'Dog::DB
I am doing a BAD THING and cross-posting to this list and Catalyst, but it
isn't exactly a catalyst issue, either. Feel free to ignore if too far
astray.
I have the following classes and ApacheAdmin::Model::DB is just for
connecting to the database--nothing unusual there. With the test script at
On 1/12/06 2:42 PM, "Cees Hek" <[EMAIL PROTECTED]> wrote:
> On 1/12/06, Sean Davis <[EMAIL PROTECTED]> wrote:
>> Cannot load ApacheAdmin::Model::User without a primary key (username) with a
>> non-null value or another unique key with at least one non-null
On 1/24/06 10:39 AM, "John Siracusa" <[EMAIL PROTECTED]> wrote:
>
> Anyway, like I said, baby steps. Start by implementing the Rose::DB
> public API in a new Rose::DB::Oracle module. While that's happening,
> it'd be great iif someone could post the various Oracle-isms discussed
> above to th
On 3/8/06 10:24 PM, "John Siracusa" <[EMAIL PROTECTED]> wrote:
> On 3/8/06 10:11 PM, Nilson Santos Figueiredo Junior wrote:
>> It's usually simple glue code and without it, things get less coherent.
>> You get one nice thing, though: $c->model('Artist') (where $c is the
>> Catalyst context obje
On 3/9/06 3:56 PM, "Rob Kinyon" <[EMAIL PROTECTED]> wrote:
> On 3/8/06, John Siracusa <[EMAIL PROTECTED]> wrote:
>> Do many people use the helpers and scaffolding? I always imagined that
>> people might use those to play with, but then write stuff form scratch when
>> creating their first real
I would like to do a large amount of read->parse->store operations. In
short, I have a large text file with one record per line. To speed things
up, I have seen others "reuse" objects rather than allocating new ones for
each record. Can I safely do this with Rose::DB::Objects? Is it as simple
a
I have a simple table description for storing files. I store the files in
the "contents" column. I also have a simple RDBO class that autoinitializes
from the database. The output of the meta->perl_class_definition is given
below the table definition. Why is the type for "contents" a scalar? I
On 3/22/06 1:36 PM, "John Siracusa" <[EMAIL PROTECTED]> wrote:
> On 3/22/06, Sean Davis <[EMAIL PROTECTED]> wrote:
>> Why is the type for "contents" a scalar?
>
> Because that's the default when there is not a more specific RDBO
> column
On 3/22/06 2:39 PM, "Sean Davis" <[EMAIL PROTECTED]> wrote:
>
>
>
> On 3/22/06 1:36 PM, "John Siracusa" <[EMAIL PROTECTED]> wrote:
>
>> On 3/22/06, Sean Davis <[EMAIL PROTECTED]> wrote:
>>> Why is the type for "conte
On 3/22/06 21:31, "John Siracusa" <[EMAIL PROTECTED]> wrote:
> On 3/22/06 8:48 PM, John Siracusa wrote:
>> Looking here:
>>
>> http://www.postgresql.org/docs/8.1/interactive/datatype-binary.html
>>
>> it seems that there's already an ASCII-ified format for bytea columns.
>
> Furthermore, byt
Not sure if this covers it, but did you look at this:
http://search.cpan.org/~jsiracusa/Rose-DB-Object-0.727/lib/Rose/DB/Object/Tu
torial.pod#Auto-joins_and_other_Manager_features
Sean
On 5/25/06 12:46 PM, "Jonathan Vanasco" <[EMAIL PROTECTED]> wrote:
>
> i have the 2 packages below
> Asset
John,
Are you planning on methods for generating DDL from classes? Just curious.
Sean
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based
I can confirm it (Rose::DB), also on Mac OS 10.4.6, so it isn't "just
you"
Sean
On 7/3/06 2:04 PM, "Jonathan Vanasco" <[EMAIL PROTECTED]> wrote:
> I can't get this to build on Mac OSX 10.4
>
> does anyone have any suggestions?
>
> ==
> t/subclass-pg.ok 91/230
> t/subcl
Has anyone built any tools for automating Rose::HTML::Object form classes
from Rose::DB::Object classes? In principle, it shouldn't be too hard to
do, but I just wanted to see if someone had already gone ahead with this,
before I start down the road of making my own.
Thanks,
Sean
--
I have a set of classes and am finding that I need to do an explicit commit
despite a Rose::DB subclass that is given below. Is this a normal behavior,
as from the docs, it appears that the AutoCommit should default to 1 and
even with it set explicitly as below, it still requires a commit to get i
On 7/25/06 12:49 PM, "Sean Davis" <[EMAIL PROTECTED]> wrote:
> I have a set of classes and am finding that I need to do an explicit commit
> despite a Rose::DB subclass that is given below. Is this a normal behavior,
> as from the docs, it appears that the AutoCommi
On 7/25/06 1:00 PM, "John Siracusa" <[EMAIL PROTECTED]> wrote:
> On 7/25/06, Sean Davis <[EMAIL PROTECTED]> wrote:
>> I have a set of classes and am finding that I need to do an explicit commit
>> despite a Rose::DB subclass that is given below. Is this a
I am trying to write some code to access a publicly available data source.
It consists of a few dozen different databases (mysql), all with the same
table structure, pretty much. I would also like to allow users to query a
local mirror of the data source, as well. Therefore, I would like to make
On 8/7/06 1:31 PM, "Sean Davis" <[EMAIL PROTECTED]> wrote:
> I am trying to write some code to access a publicly available data source.
> It consists of a few dozen different databases (mysql), all with the same
> table structure, pretty much. I would also like
On 8/7/06 4:04 PM, "John Siracusa" <[EMAIL PROTECTED]> wrote:
> On 8/7/06 3:40 PM, Sean Davis wrote:
>> On 8/7/06 1:31 PM, "Sean Davis" <[EMAIL PROTECTED]> wrote:
>>> I am trying to write some code to access a publicly available data source.
On 8/7/06 4:27 PM, "John Siracusa" <[EMAIL PROTECTED]> wrote:
> On 8/7/06 4:14 PM, Sean Davis wrote:
>> This is what I thought of first, but the user of a "mirror" or "local"
>> database will want to set up his/her username/password, hostname
On 8/14/06 10:32 PM, "Danial Pearce" <[EMAIL PROTECTED]> wrote:
> Hey all,
>
> Has there been any work done previously with RDBO and Catalyst? I have
> my catalyst jigger up and running with my RDBO model(s) already. But
> Catalyst has so many helpers for scaffolding and such where your model
On Monday 18 September 2006 07:47, James Masters wrote:
> I am rather amateur when it comes to OO methodology. If I don't use Loader
> to define my table classes, then it appears that I have to create a whole
> load of .pm files, one per table. Or if I do use Loader, then I have to
> create a di
On Tuesday 05 December 2006 08:19, Michael Lackhoff wrote:
> Hello,
>
> I need some pseudo-unique numbers like invoice numbers. They start every
> year with 1, so autoincrement won't work. My idea was to use a helper
> table with just just two fields 'year' and 'last_used_number'. Is it
> enough to
On Nov 27, 2007 3:19 PM, Perrin Harkins <[EMAIL PROTECTED]> wrote:
> On Nov 27, 2007 2:41 PM, maxim <[EMAIL PROTECTED]> wrote:
> > its useful when you have XML based framework where your backend is
> > trying to reflect some XML schema and you dont what to remap XML on the DB
> > schema but just us
50 matches
Mail list logo
