<html><head></head><body><div>DBIC by default follows the convention that table names reflect the entity name in singular. If It detects table names in plural It uses a Lingua::* module to deduce the apropriate singular name, and names the clases with It.<br/>
<br/>
In your case, the table names IS "people", but the generated class name IS "Person", the singular for people.<br/>
<br/>
Admittedly yours IS a bit of an extreme case :-)<br/>
<br/>
This behaviour can be changed, see the docs for DBIC::Schema::Loader and search for an option named like "*inflect*" or something similar (I'm on my cellphone and can't search at the moment :-)<br/>
<br/>
BR<br/>
J.<br/>
<br/>
-- <br/>
<b>Jorge González Villalonga</b><br/>
Ingeniero de Sistemas / Systems Engineer<br/>
Red Hat Certified Engineer #140-183-666<br/>
Móvil / Cell: (+34) 672 173 200<br/><br/>-----Original Message-----<br/>From: Rajeev Prasad <rp.neuli@yahoo.com><br/>To: "DBIx::Class User and Developer List" <dbix-class@lists.scsys.co.uk>, "dbi-users@perl.org" <dbi-users@perl.org>, Mysql Mailing List <mysql@lists.mysql.com>, "mysql-index@lists.mysql.com" <mysql-index@lists.mysql.com><br/>Sent: vie., 10 mar. 2017 17:49<br/>Subject: [Dbix-class] Strangely does DBIx change table names from MySQL?<br/><br/></div><div style="color:#000; background-color:#fff; font-family:HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif;font-size:14px"><div id="yui_3_16_0_ym19_1_1489164132761_4070"><div>Hello,</div><div><br></div><div id="yui_3_16_0_ym19_1_1489164132761_4271">Note: this question is also posted on Stack Overflow, a few minutes back.</div><div id="yui_3_16_0_ym19_1_1489164132761_4283"><br></div>
</div>
<td id="yui_3_16_0_ym19_1_1489164132761_4075"><br></td><td id="yui_3_16_0_ym19_1_1489164132761_4081"><div id="yui_3_16_0_ym19_1_1489164132761_4082"><div id="yui_3_16_0_ym19_1_1489164132761_4083" itemprop="text"><div id="yui_3_16_0_ym19_1_1489164132761_4084">While using ./create-schema-mydb.pl I realized that the table name
"People" is changed to "Person" in DBIx. I am not sure how? or why?</div><div id="yui_3_16_0_ym19_1_1489164132761_4304"><br></div>
<div id="yui_3_16_0_ym19_1_1489164132761_4085">It is not even a reserved word.</div><div id="yui_3_16_0_ym19_1_1489164132761_4305"><br></div><div id="yui_3_16_0_ym19_1_1489164132761_4306"><br></div>
<div id="yui_3_16_0_ym19_1_1489164132761_4086">in MySQL:</div>
<pre id="yui_3_16_0_ym19_1_1489164132761_4087" style=""><code id="yui_3_16_0_ym19_1_1489164132761_4088"><span id="yui_3_16_0_ym19_1_1489164132761_4089">people innoDB utf8</span></code></pre>
<div id="yui_3_16_0_ym19_1_1489164132761_4090"><br></div><div id="yui_3_16_0_ym19_1_1489164132761_4307"><br></div><div id="yui_3_16_0_ym19_1_1489164132761_4309">create-schema script:</div>
<pre id="yui_3_16_0_ym19_1_1489164132761_4091" style=""><code id="yui_3_16_0_ym19_1_1489164132761_4092"><span id="yui_3_16_0_ym19_1_1489164132761_4093">$ cat </span><span id="yui_3_16_0_ym19_1_1489164132761_4094">./</span><span id="yui_3_16_0_ym19_1_1489164132761_4095">create</span><span id="yui_3_16_0_ym19_1_1489164132761_4096">-</span><span id="yui_3_16_0_ym19_1_1489164132761_4097">schema</span><span id="yui_3_16_0_ym19_1_1489164132761_4098">-</span><span id="yui_3_16_0_ym19_1_1489164132761_4099">mydb</span><span id="yui_3_16_0_ym19_1_1489164132761_4100">.</span><span id="yui_3_16_0_ym19_1_1489164132761_4101">pl
</span><span id="yui_3_16_0_ym19_1_1489164132761_4102">#!/usr/bin/perl</span><span id="yui_3_16_0_ym19_1_1489164132761_4103">
</span><span id="yui_3_16_0_ym19_1_1489164132761_4104">use</span><span id="yui_3_16_0_ym19_1_1489164132761_4105"> strict</span><span id="yui_3_16_0_ym19_1_1489164132761_4106">;</span><span id="yui_3_16_0_ym19_1_1489164132761_4107">
</span><span id="yui_3_16_0_ym19_1_1489164132761_4108">use</span><span id="yui_3_16_0_ym19_1_1489164132761_4109"> warnings</span><span id="yui_3_16_0_ym19_1_1489164132761_4110">;</span><span id="yui_3_16_0_ym19_1_1489164132761_4111">
</span><span id="yui_3_16_0_ym19_1_1489164132761_4112">use</span><span id="yui_3_16_0_ym19_1_1489164132761_4113"> </span><span id="yui_3_16_0_ym19_1_1489164132761_4114">DBIx</span><span id="yui_3_16_0_ym19_1_1489164132761_4115">::</span><span id="yui_3_16_0_ym19_1_1489164132761_4116">Class</span><span id="yui_3_16_0_ym19_1_1489164132761_4117">::</span><span id="yui_3_16_0_ym19_1_1489164132761_4118">Schema</span><span id="yui_3_16_0_ym19_1_1489164132761_4119">::</span><span id="yui_3_16_0_ym19_1_1489164132761_4120">Loader</span><span id="yui_3_16_0_ym19_1_1489164132761_4121"> qw</span><span id="yui_3_16_0_ym19_1_1489164132761_4122">/</span><span id="yui_3_16_0_ym19_1_1489164132761_4123">make_schema_at</span><span id="yui_3_16_0_ym19_1_1489164132761_4124">/;</span><span id="yui_3_16_0_ym19_1_1489164132761_4125">
make_schema_at</span><span id="yui_3_16_0_ym19_1_1489164132761_4126">(</span><span id="yui_3_16_0_ym19_1_1489164132761_4127">
</span><span id="yui_3_16_0_ym19_1_1489164132761_4128">"Mydb::Schema"</span><span id="yui_3_16_0_ym19_1_1489164132761_4129">,</span><span id="yui_3_16_0_ym19_1_1489164132761_4130">
</span><span id="yui_3_16_0_ym19_1_1489164132761_4131">{</span><span id="yui_3_16_0_ym19_1_1489164132761_4132">debug </span><span id="yui_3_16_0_ym19_1_1489164132761_4133">=></span><span id="yui_3_16_0_ym19_1_1489164132761_4134"> </span><span id="yui_3_16_0_ym19_1_1489164132761_4135">0</span><span id="yui_3_16_0_ym19_1_1489164132761_4136">,</span><span id="yui_3_16_0_ym19_1_1489164132761_4137"> dump_directory </span><span id="yui_3_16_0_ym19_1_1489164132761_4138">=></span><span id="yui_3_16_0_ym19_1_1489164132761_4139"> </span><span id="yui_3_16_0_ym19_1_1489164132761_4140">"../db/"</span><span id="yui_3_16_0_ym19_1_1489164132761_4141">,</span><span id="yui_3_16_0_ym19_1_1489164132761_4142">
generate_pod </span><span id="yui_3_16_0_ym19_1_1489164132761_4143">=></span><span id="yui_3_16_0_ym19_1_1489164132761_4144"> </span><span id="yui_3_16_0_ym19_1_1489164132761_4145">0</span><span id="yui_3_16_0_ym19_1_1489164132761_4146">,},</span><span id="yui_3_16_0_ym19_1_1489164132761_4147">
</span><span id="yui_3_16_0_ym19_1_1489164132761_4148">[</span><span id="yui_3_16_0_ym19_1_1489164132761_4149">"dbi:mysql:mydb:localhost:3306"</span><span id="yui_3_16_0_ym19_1_1489164132761_4150">,</span><span id="yui_3_16_0_ym19_1_1489164132761_4151"> </span><span id="yui_3_16_0_ym19_1_1489164132761_4152">'mydb'</span><span id="yui_3_16_0_ym19_1_1489164132761_4153">,</span><span id="yui_3_16_0_ym19_1_1489164132761_4154"> </span><span id="yui_3_16_0_ym19_1_1489164132761_4155">'password'</span><span id="yui_3_16_0_ym19_1_1489164132761_4156">],</span><span id="yui_3_16_0_ym19_1_1489164132761_4157">
</span><span id="yui_3_16_0_ym19_1_1489164132761_4158">);<br><br><br></span></code></pre>
<div id="yui_3_16_0_ym19_1_1489164132761_4159">It shows up like this after create-schema... <strong id="yui_3_16_0_ym19_1_1489164132761_4160">note the change in name from <span style="background-color: rgb(253, 239, 43);">People</span> to <span style="background-color: rgb(253, 239, 43);"><span id="yui_3_16_0_ym19_1_1489164132761_4515">Person</span>,</span> but inside the .pm file table name is retained as People !!!<br></strong></div>
<pre id="yui_3_16_0_ym19_1_1489164132761_4161" style=""><code id="yui_3_16_0_ym19_1_1489164132761_4162"><span id="yui_3_16_0_ym19_1_1489164132761_4163">Result$</span><span id="yui_3_16_0_ym19_1_1489164132761_4164"> cat </span><span id="yui_3_16_0_ym19_1_1489164132761_4165">Person</span><span id="yui_3_16_0_ym19_1_1489164132761_4166">.</span><span id="yui_3_16_0_ym19_1_1489164132761_4167">pm
</span><span id="yui_3_16_0_ym19_1_1489164132761_4168">use</span><span id="yui_3_16_0_ym19_1_1489164132761_4169"> utf8</span><span id="yui_3_16_0_ym19_1_1489164132761_4170">;</span><span id="yui_3_16_0_ym19_1_1489164132761_4171">
</span><span id="yui_3_16_0_ym19_1_1489164132761_4172">package</span><span id="yui_3_16_0_ym19_1_1489164132761_4173"> </span><span id="yui_3_16_0_ym19_1_1489164132761_4174">Mydb</span><span id="yui_3_16_0_ym19_1_1489164132761_4175">::</span><span id="yui_3_16_0_ym19_1_1489164132761_4176">Schema</span><span id="yui_3_16_0_ym19_1_1489164132761_4177">::</span><span id="yui_3_16_0_ym19_1_1489164132761_4178">Result</span><span id="yui_3_16_0_ym19_1_1489164132761_4179">::</span><span id="yui_3_16_0_ym19_1_1489164132761_4180">Person</span><span id="yui_3_16_0_ym19_1_1489164132761_4181">;</span><span id="yui_3_16_0_ym19_1_1489164132761_4182">
</span><span id="yui_3_16_0_ym19_1_1489164132761_4183"># Created by DBIx::Class::Schema::Loader</span><span id="yui_3_16_0_ym19_1_1489164132761_4184">
</span><span id="yui_3_16_0_ym19_1_1489164132761_4185"># DO NOT MODIFY THE FIRST PART OF THIS FILE</span><span id="yui_3_16_0_ym19_1_1489164132761_4186">
</span><span id="yui_3_16_0_ym19_1_1489164132761_4187">use</span><span id="yui_3_16_0_ym19_1_1489164132761_4188"> strict</span><span id="yui_3_16_0_ym19_1_1489164132761_4189">;</span><span id="yui_3_16_0_ym19_1_1489164132761_4190">
</span><span id="yui_3_16_0_ym19_1_1489164132761_4191">use</span><span id="yui_3_16_0_ym19_1_1489164132761_4192"> warnings</span><span id="yui_3_16_0_ym19_1_1489164132761_4193">;</span><span id="yui_3_16_0_ym19_1_1489164132761_4194">
</span><span id="yui_3_16_0_ym19_1_1489164132761_4195">use</span><span id="yui_3_16_0_ym19_1_1489164132761_4196"> </span><span id="yui_3_16_0_ym19_1_1489164132761_4197">base</span><span id="yui_3_16_0_ym19_1_1489164132761_4198"> </span><span id="yui_3_16_0_ym19_1_1489164132761_4199">'DBIx::Class::Core'</span><span id="yui_3_16_0_ym19_1_1489164132761_4200">;</span><span id="yui_3_16_0_ym19_1_1489164132761_4201">
__PACKAGE__</span><span id="yui_3_16_0_ym19_1_1489164132761_4202">-></span><span id="yui_3_16_0_ym19_1_1489164132761_4203">table</span><span id="yui_3_16_0_ym19_1_1489164132761_4204">(</span><span id="yui_3_16_0_ym19_1_1489164132761_4205">"<span id="yui_3_16_0_ym19_1_1489164132761_4557" style="background-color: rgb(253, 239, 43);">people</span>"</span><span id="yui_3_16_0_ym19_1_1489164132761_4206">);</span><span id="yui_3_16_0_ym19_1_1489164132761_4207">
__PACKAGE__</span><span id="yui_3_16_0_ym19_1_1489164132761_4208">-></span><span id="yui_3_16_0_ym19_1_1489164132761_4209">add_columns</span><span id="yui_3_16_0_ym19_1_1489164132761_4210">(</span><span id="yui_3_16_0_ym19_1_1489164132761_4211">
</span><span id="yui_3_16_0_ym19_1_1489164132761_4212">"pplid"</span><span id="yui_3_16_0_ym19_1_1489164132761_4213">,</span><span id="yui_3_16_0_ym19_1_1489164132761_4214">
</span><span id="yui_3_16_0_ym19_1_1489164132761_4215">{</span><span id="yui_3_16_0_ym19_1_1489164132761_4216">
data_type </span><span id="yui_3_16_0_ym19_1_1489164132761_4217">=></span><span id="yui_3_16_0_ym19_1_1489164132761_4218"> </span><span id="yui_3_16_0_ym19_1_1489164132761_4219">"smallint"</span><span id="yui_3_16_0_ym19_1_1489164132761_4220">,</span><span id="yui_3_16_0_ym19_1_1489164132761_4221">
extra </span><span id="yui_3_16_0_ym19_1_1489164132761_4222">=></span><span id="yui_3_16_0_ym19_1_1489164132761_4223"> </span><span id="yui_3_16_0_ym19_1_1489164132761_4224">{</span><span id="yui_3_16_0_ym19_1_1489164132761_4225"> </span><span id="yui_3_16_0_ym19_1_1489164132761_4226">unsigned</span><span id="yui_3_16_0_ym19_1_1489164132761_4227"> </span><span id="yui_3_16_0_ym19_1_1489164132761_4228">=></span><span id="yui_3_16_0_ym19_1_1489164132761_4229"> </span><span id="yui_3_16_0_ym19_1_1489164132761_4230">1</span><span id="yui_3_16_0_ym19_1_1489164132761_4231"> </span><span id="yui_3_16_0_ym19_1_1489164132761_4232">},</span><span id="yui_3_16_0_ym19_1_1489164132761_4233">
is_auto_increment </span><span id="yui_3_16_0_ym19_1_1489164132761_4234">=></span><span id="yui_3_16_0_ym19_1_1489164132761_4235"> </span><span id="yui_3_16_0_ym19_1_1489164132761_4236">1</span><span id="yui_3_16_0_ym19_1_1489164132761_4237">,</span><span id="yui_3_16_0_ym19_1_1489164132761_4238">
is_nullable </span><span id="yui_3_16_0_ym19_1_1489164132761_4239">=></span><span id="yui_3_16_0_ym19_1_1489164132761_4240"> </span><span id="yui_3_16_0_ym19_1_1489164132761_4241">0</span><span id="yui_3_16_0_ym19_1_1489164132761_4242">,</span><span id="yui_3_16_0_ym19_1_1489164132761_4243">
</span><span id="yui_3_16_0_ym19_1_1489164132761_4244">},</span><span id="yui_3_16_0_ym19_1_1489164132761_4245">
</span><span id="yui_3_16_0_ym19_1_1489164132761_4246">...</span><span id="yui_3_16_0_ym19_1_1489164132761_4247">
</span><span id="yui_3_16_0_ym19_1_1489164132761_4248">...<br><br>only relevant portion shown above...<br><br><br>Thank you.<br><br>Rajeev<br></span></code></pre><div dir="ltr">
</div></div></div></td></div></body></html>