Stack Overflow
Stack Overflow

Questions tagged [rose-db-object]

Rose::DB::Object is a Perl module, which is the ORM part of the Rose set.

Overview

Rose::DB::Object is a Perl module, which is part of the Rose set. The Rose set is made of :

Database Support

The current databases supported by Rose::DB::Object are th same as the ones supported by :

Links

25 questions
0
votes
1 answer

Rose::DB masking in query statements

I'm seeking some help on my Rose::DB issue as described below. I have an account object, and this has an integer "accounttype" field. In this example I will use the following accounttype constants: ACCOUNT_TYPE_SPECIAL_MASK =…
ritter
  • 555
  • 4
  • 13
0
votes
1 answer

Rose::DB::Object::Manager and HTML Template

I am using Rose::DB::Object::Manager (get/iterate methods) to source data from a database and HTML::Template for reporting. The HTML report requires a TMPL_LOOP to display entries in a database. My question is how do I create an array reference…
user621092
  • 51
  • 1
  • 6
0
votes
2 answers

Handling UTF8-encoded text in SQLite using Rose::DB::Object

I am using Rose::DB::Object, SQLite, and Chinese text. My classes look like this: package My::DB; use base qw(Rose::DB); __PACKAGE__->use_private_registry; __PACKAGE__->register_db( driver => 'sqlite', database =>…
Weiyan
  • 1,116
  • 3
  • 14
  • 25
0
votes
1 answer

Rose DB subselect (nested query ) on select

I am trying to run a query, that has a subselect in it. I have set up the Manager method, and everything works fine. The only problem is i dont know how to proceed with this query : SELECT * FROM tableA WHERE name = 'Me' AND …
user2583714
  • 1,097
  • 2
  • 11
  • 18
0
votes
1 answer

How to generate list of tables for DB using RoseDB

I have to list the tables for a given database using RoseDB . I know the mysql command for it : SHOW TABLES in DB_NAME; How do I implement this in rose DB ? Pleas help
user2583714
  • 1,097
  • 2
  • 11
  • 18
0
votes
1 answer

Why does $my_item->save fail with Rose::DB::Object?

I am trying to do a simple addition of data to a database table (PostgreSQL). At first, I couldn't even get a simple $my_item = $_item_class->new(...); to work. I discovered I had spelled a field differently in my code from what I had in my…
user1418094
0
votes
1 answer

Perl Rose::DB non-static datasource registration

I'm writing a perl application which uses Rose::DB for persistence abstraction, but I'm running into an issue with initializing my Rose::DB subclass with values from a configuration file. The documentation always presents hardcoded examples, like: #…
André Fernandes
  • 2,335
  • 3
  • 25
  • 33
0
votes
1 answer

How to pass a a string variable as "query" for get Manager call?

I'm trying to make this simple call: DataB::testTable::Manager->get_testTable( query => [ id => $id, name => $name ] ) which works perfectly fine. But is it possible to pass a variable for the query. Something like: $query = "id => $id , name =>…
rsharma
  • 75
  • 1
  • 9
0
votes
2 answers

How do i pass a variable for the query in a get Manager call?

I am trying to make a simple Rose DB call: $id = xyz; $name = "company"; DataB::testTable::Manager->get_testTable( query =>[ id => $id, name => $name ] ); in it possible to not have the whole query written every time, and declare it like a string…
rsharma
  • 75
  • 1
  • 9
0
votes
1 answer

Why isn't Rose::DB::Object sort_by RAND() doing what I expect?

I can't get it to work. I'm using this query: my $user_questions = RoseDB::UserSecurityQuestion::Manager->get_user_security_questions( query => [ 'user.username' => $username, ], …
cliveholloway
  • 368
  • 1
  • 2
  • 13
1
2