You cannot post messages because only members can post, and you are not currently a member.
Description:
Discussion and support for users and developers of the Rose::DB::Object Perl module.
|
|
|
update_objects with sort_by
|
| |
Hello, I want to produce this type of sql request : update cc_configuration set version=version+1 where name='foo' order by version desc; In RDBO : Foo::DB::Configuration::Manage r->update_configurations( set => {... more »
|
|
|
database driver from config file revisited - SOLVED
|
| |
Many thanks to the group and, in particular, Peter Karman.
I put my configuration initialization code inside of a BEGIN block. I
am then referencing the config variables using the "main" lexical
scoping:
$main::database_driver, etc.
as parameters to the register_db call. The $main variables is a little... more »
|
|
|
database driver from config file revisited
|
| |
Greetings,
About a month ago I asked about getting the connection parameters for
Rose::DB from a config file. Peter Karman was kind enough to reply
with a solution that he uses. Thanks, Peter.
I would ideally like to set up the connection parameters in the main
section of the program due to using Getopt::Long to override config... more »
|
|
|
database driver from config file
|
| |
Greetings, I have looked at the Rose::DB(::Object) tutorial(s) and also examined the source, but cannot find the preferred way to set the database driver from a config file. I see that in the tutorial the driver is "hard-coded" into the derived Rose::DB derived class. Is there a way to specify the driver from a... more »
|
|
|
Auto-Incremented Oracle PK - Trigger/Sequence
|
| |
I've been working with Oracle auto-incremented PK columns (which in Oracle, you need to create a sequence and a before insert trigger). I noticed gaps in my data and I'd like to point out what I found in case someone else needs the info. Also, I'll note that I'm on Oracle version 11g here. I created the trigger as documented with Rose::DB::Object like so:... more »
|
|
|
How should I reveal all the linked tables for any table?
|
| |
Hello. My current task is to make a web-interface for the DB using Rose::DB::Object. And I have an issue. It's about how to reveal linked tables. I.e., one table is named FRIENDS with fields: - HUMAN_ID -> link to the table HUMANS by ID field - some other fields I create Rose::DB::Object for table FRIENDS with automatic resolving of... more »
|
|
|
Oracle Auto Init PK Sequence - DB user, Not Sequence Owner
|
| |
I've been testing out the auto-init of RDBO objects with an Oracle database. I noticed the sequence value of my primary key column wasn't being populated correctly (the sequence I created follows the naming convention described in the Rose::DB::Object docs for auto-incremented columns). I tracked the problem down to the follow code... more »
|
|
|
Failed using with_map_records twice
|
| |
Hi,
I use Rose-DB-Object version 0.795.
I have a strange behavior using the 'with_map_records' Rose::DB::Object::Manager option.
The objects I'm working with :
* FederationRegistry::Data::Fede ration class
* FederationRegistry::Data::Serv iceprovider and
FederationRegistry::Data::Iden tityprovider classes with many2many... more »
|
|
|
