Hi All [and John],
I'm exploring Rose::DB::Object et al.. I'm familiar with Class::DBI
and have messed around a bit (and decided not to adopt) with
DBIX::Class.
I'm working with a fairly large database that contains data handed to
me as XML with minimal documentation.
I've reverse engineered
George Hartzell writes:
Hi All [and John],
[...]
It looks like I might be able to figure out how to get RDO::Manager to
express the query, but it would be quicker (at least as a first cut to
be able to do something like
Foo::DB::Moose::Manager-get_iterator_from_sql
John Siracusa writes:
[...]
All of that said, adding iterator options to get_objects_from_sql()
and make_manager_method_from_sql() is pretty simple. If you really
want it, I'll throw it in the next release :)
It'd help a bunch. I may take a stab at it, but if you get it going,
I'd love
John Siracusa writes:
On 11/28/06, George Hartzell [EMAIL PROTECTED] wrote:
John Siracusa writes:
[...]
All of that said, adding iterator options to get_objects_from_sql()
and make_manager_method_from_sql() is pretty simple. If you really
want it, I'll throw it in the next
Ask Bjørn Hansen writes:
On Dec 5, 2006, at 9:00, George Hartzell wrote:
On the other hand the hoops that they jump through to try to
automagically generate queries and hide the relational database
mystifies me, I find that I end up double checking the sql that they
generate
Danial Pearce writes:
depending on your database support, I think the best solution would
be to use a DB trigger on insert , that would just populate all of
the fields
As John says somewhere in the documentation. If you are putting
triggers on your DB, why wouldn't you put them in
I have a bunch of classes that are created automagically for me by
Rose::DB::Object::Loader.
In one of those classes I'd like to use load_or_insert from
Rose::DB::Object::Helpers.
I'm not sure how to do it politely.
Just for grins, I tried this:
use Rose::DB::Object::Loader;
package
George Hartzell writes:
I have a bunch of classes that are created automagically for me by
Rose::DB::Object::Loader.
In one of those classes I'd like to use load_or_insert from
Rose::DB::Object::Helpers.
I'm not sure how to do it politely.
Just for grins, I tried
Hi John (and everyone),
I just figured out why I wasn't getting an automatically generated
add_ method in one of my classes. It turned out that Loader wasn't
generating the appropriate relationship.
Long story short, I had a table named set, and another named
set_member, one set can have many
Hi all,
I think we may have gone over this, but I can't find it in the list.
I'm using current versions of Rose::DB::Object and friends on a
Freebsd -STABLE system. I'm using sqlite 3.3.17 and DBD::SQLite 1.13.
When I new up an object and save it, I get the following message:
closing dbh
The following little fragment of sql does what I'd like it to do,
inserts the current timestamp into the created_date column.
create table mooses (
id integer primary key autoincrement,
name text,
created_date datetime not null default current_timestamp
);
insert
John Siracusa writes:
On 8/7/07 5:12 PM, George Hartzell wrote:
If I change Rose::DB::SQLite::validate_datetime_keyword so that it'll
accept 'current_timestamp'
Yeah, I should do that...
then the value gets inserted literally into the table.
it probably also needs
John Siracusa writes:
On 8/14/07, George Hartzell [EMAIL PROTECTED] wrote:
The default value of now does work when used in the RDBO perl
module. The problem is that since I'm using RDBO::Loader, the only
way to get that value in there is to use it in the SQL, where it
doesn't do
I have a many-to-many relationship between a pair of tables, using a
mapping table, that Rose::DB::Object::Loader sets up properly for me.
I can use (e.g.) $widget-add_colors($a_color) to add colors to the
widget, so I think it's working right.
I'd like to get a count of the number of colors
Back in December '06 there was a thread about How to do locking in
RDBO. It started here:
http://osdir.com/ml/lang.perl.modules.dbi.rose-db-object/2006-12/msg00028.html
I'm trying to solve a very similar problem and while I have several
versions of things that limp along, I'm sure that I
John Siracusa writes:
On 10/10/07, George Hartzell [EMAIL PROTECTED] wrote:
- As written, it almost works. I'm clearly running around behind
the back of RDBO's copy of that row's values, $new_num-counter is
still zero even though the row has been updated. What's
16 matches
Mail list logo