class-dbi

How can I clear Class::DBI's internal cache?

I'm currently working on a large implementation of Class::DBI for an existing database structure, and am running into a problem with clearing the cache from Class::DBI. This is a mod_perl implementation, so an instance of a class can be quite old between times that it is accessed. From the man pages I found two options: Music::DBI->cle...

How do you insert binary data into a BLOB column with Class::DBI?

I want to create a new object using Class::DBI. One of the fields of this object is a BLOB type. I have a filehandle I want to use for this data, but apparently, just doing this doesn't work: my $item = My::Class::DBI::Class->insert({ foo => $bar, biz => $baz, blob => $my_filehandle ...

Where is detailed documentation on Class::DBI's sth_to_objects() method?

How do I find detailed documentation on the behavior of the sth_to_objects() method in the Class::DBI module? ...

How do I use add_to in Class::DBI?

I'm trying to use Class::DBI with a simple one parent -> may chidren relationships: Data::Company->table('Companies'); Data::Company->columns(All => qw/CompanyId Name Url/); Data::Company->has_many(offers => 'Data::Offer'=>'CompanyId'); # =>'CompanyId' and Data::Offer->table('Offers'); Data::Offer->columns(All => qw/OfferId CompanyId...

How do I override autogenerated accessors in Perl's Class::DBI?

Hello, I followed the example at http://wiki.class-dbi.com/wiki/Overriding_autogenerated_accessors I want to modify the URL before it is inserted to the database: package Hosting::Company; use base 'Class::DBI'; my $class = __PACKAGE__; $class->table('Companies'); $class->columns(Primary => 'CompanyId'); $class->columns(Others => qw...

How can I do an update in Class::DBI without selecting a record first?

Hello, To do an insert with Class::DBI, you can simply do: my $object = Object::DB->insert({ a => 1, b => 2, c => 3, ...}); But there is no such thing for update. The best I could come up with is selecting the record first then updating it: my $object = Object::DB->retrieve($id); my $object->set( a => 1, b => 2, c => 3, ...}; $objec...

Is there a way to caching mechanism for Class::DBI?

I have a set of rather complex ORM modules that inherit from Class::DBI. Since the data changes quite infrequently, I am considering using a Caching/Memoization layer on top of this to speed things up. I found a module: Class::DBI::Cacheable but no rating or any reviews on RT. I would appreciate hearing from people who have used this or ...

What is the future of Class::DBI?

Does anyone know what is the status of Class::DBI? I see that it was last updated on 4 October 2007, is anyone still working on this project or is it just left to die? Thank you. ...

Is it possible to obtain the SQL statements generated by Class::DBI?

I want to find the exact SQL statements that are generated by a Perl ORM package such as Class::DBI. I am not looking for SQL generated for simple inserts and deletes, but for row modifications that result from slightly complicated object manipulations (inserting rows in a table which is a child of a row in a parent table, for example) ...

Moving from Class::DBI to DBIx::Class

I'm currently doing some research on DBIx::Class in order to migrate my current application from Class::DBI. Honestly I'm a bit disappointed about the DBIx::Class when it comes to configuring the result classes, with Class::DBI I could setup metadata on models just by calling the on function without a code generator and so on my questio...