dbix-class
joining on a subquery with dbix-class?
Given two tables: (incoming greatly reduced/simplified example that exhibits the key problem) app_data represents applications that can be subscribed to[详细]
2023-04-13 01:42 分类:问答DBIx::Class - add a read-only synthesized column (defined by SQL) to a result class?
Is it possible to add a \'synthesized\' column to a DBIx::Class result class? The value of the synthesized column would be defined by a SQL expression of the current row. For example, if a row had the[详细]
2023-04-11 07:03 分类:问答How can I retrieve the newest record in each group in a DBIx::Class resultset search?
I\'m using group_by in a DBIx::Class resultset search. The res开发者_JAVA技巧ult returned for each group is always the row in the group with the lowest id (i.e the oldest row in the group). I\'m looki[详细]
2023-03-30 00:18 分类:问答Using relationships to search in DBIx::Class
I am starting learning DBIx::Class and I have 开发者_Python百科a doubt in searching in a related table:[详细]
2023-03-28 20:28 分类:问答How do I handle errors in methods chains in Perl?
What is the best way to开发者_开发百科 deal with exceptions threw in a method chaining in Perl?[详细]
2023-03-27 23:26 分类:问答Set operations in DBIx::Class
What is the best way to perform set operations using DBIx::Class? I saw that one solution would be to create a Result Source based on my query, but my c开发者_StackOverflowonditions will be defined by[详细]
2023-03-26 13:46 分类:问答use base instead of parent in DBIx::Class
Any idea why the DBIx::Class uses use base instead of use parent? see this for instance. Correct me i\'m wrong, but isn\'t it use base dep开发者_Go百科recated?[详细]
2023-03-26 10:47 分类:问答How do you specify index length when using DBIx::Class?
I\'m using DBIx::Class and am using the sqlt_deploy_hook to: sub { my ($self, $sqlt_table) = @_; $sqlt_table->add_index(name => \'indexes\', fields => [keys %for_indexing]);[详细]
2023-03-23 18:45 分类:问答How do you create foreign keys in attached sqlite databases?
I am trying to create a sqlite3 database as a test environment that mimics the production environment.Due to the way production is setup the tables are in multiple schemas.[详细]
2023-03-20 06:42 分类:问答How do I quote columns using DBIx::Class
I\'m converting a script 开发者_如何学运维from using DBI to DBIx::Class and I\'m having trouble figuring[详细]
2023-03-18 14:38 分类:问答