dbix-class
Queries to get all ancestors/descendents of a tree in a db?
I have a table (id, parent_id, data) where parent_id points to another row in same table (or is null).[详细]
2023-01-12 05:59 分类:问答How to count the number of queries with DBIx::Class?
I\'m using DBIx::Class in a web context and I\'d like to display the number of SQL querie开发者_开发百科s performed and the time they took for the rendering of a page.[详细]
2023-01-12 05:29 分类:问答How do I do this search and order_by on a DBIx::Class::ResultSet
Problem definition. I have multiple clients with multiple users. Each client needs to be able to associate custom data with a user, search, and order by.[详细]
2023-01-10 19:45 分类:问答How can I model an is-a relationship with DBIx::Class?
With the following (simplified) MySQL table definitions: create table items ( item_idint unsigned auto_increment primary key,[详细]
2023-01-09 11:51 分类:问答When using DBIx::Class Schema Loader, is there a way to maintain custom relationships and methods in separate files?
Currently we use DBIx::Class::Schema::Loader to generate and regenerate (when our db schema changes) a set of Result classes.[详细]
2023-01-09 05:35 分类:问答Retrieving data from a has_many relationship in DBIx::Class
Given a simple case of two tables - Term and Definition - where Term has_many Definitions and Definition belongs_to Term, all terms and the corresponding definitions are to be fetched and displayed so[详细]
2023-01-09 00:20 分类:问答Catalyst: How do I make DBIx::Class::Schema::Loader::make_schema_at() static preserve case?
I\'d like to be able to force the PACK开发者_运维技巧AGE->add_columns() to not lc everything.I know there\'s a preserve_case option, but I can\'t figure out where to put it. Is there a \'myproj_schem[详细]
2023-01-07 05:18 分类:问答How can I store a DateTime::Duration object in my DBI::Class model on a MySQL database?
I currently use the DBIx::Class::InflateColumn::DateTime plugin to inflate my date columns to DateTime objects and deflate my DateTime objects to MySQL date values.[详细]
2023-01-03 20:46 分类:问答Injecting relationships in DBIx::Class
I have a handful of DBIx::Class::Core objects that model various database tables. For some of those models (those that have a \'queue\' column), I have another class inject subs (basically, to \'move[详细]
2022-12-28 03:50 分类:问答Auto Generate Objects in DBIx::Class ORM in Perl
I started learning DBIx::class and I reach the point where you have to create the Objects that represents tables. Should this classes be created manually ( hard coding all the fields and relationships[详细]
2022-12-22 14:48 分类:问答