Re: [tryton-dev] Database schema name limit

2015-05-26 Thread Cédric Krier
On 21 May 17:52, Cédric Krier wrote: > So my idea is to have a configuration section which will provide the > table name to use for a Model. > > Example: > > [table] > account.invoice.payment_term.line.relativedelta = acc_inv_pt_l_reldelta > account.payment.sepa.message = acc_payment_sepa_msg He

Re: [tryton-dev] Database schema name limit

2015-05-26 Thread Cédric Krier
On 26 May 16:08, Pierre-Louis Bonicoli wrote: > On 26/05/2015 15:18, Cédric Krier wrote: > > On 26 May 14:35, Nicolas Évrard wrote: > >> * Pierre-Louis Bonicoli [2015-05-26 13:58 +0200]: > >>> If the chosen solution is the mapping one, the documentation (core and > >>> each module) should list the

Re: [tryton-dev] Database schema name limit

2015-05-26 Thread Cédric Krier
On 26 May 15:40, Nicolas Évrard wrote: > If the installation does not crash (can we expect a DBMS to truncate > silently the name of a table? (MySQL maybe)) then there will be no > error so maybe we should raise an error ourselves. How could we know there is a problem if the database doesn't tell

Re: [tryton-dev] Database schema name limit

2015-05-26 Thread Pierre-Louis Bonicoli
On 26/05/2015 15:18, Cédric Krier wrote: > On 26 May 14:35, Nicolas Évrard wrote: >> * Pierre-Louis Bonicoli [2015-05-26 13:58 +0200]: >>> If the chosen solution is the mapping one, the documentation (core and >>> each module) should list the names of the tables. >> >> Why should it? >> >> If it's

Re: [tryton-dev] Database schema name limit

2015-05-26 Thread Nicolas Évrard
* Pierre-Louis Bonicoli [2015-05-26 15:14 +0200]: On 26/05/2015 14:35, Nicolas Évrard wrote: * Pierre-Louis Bonicoli [2015-05-26 13:58 +0200]: On 26/05/2015 09:19, Nicolas Évrard wrote: (It is probably better to use an hexadecimal representation of the hash in order to reduce its length). B

Re: [tryton-dev] Database schema name limit

2015-05-26 Thread Cédric Krier
On 26 May 14:35, Nicolas Évrard wrote: > * Pierre-Louis Bonicoli [2015-05-26 13:58 +0200]: > >If the chosen solution is the mapping one, the documentation (core and > >each module) should list the names of the tables. > > Why should it? > > If it's up to the administrators of the tryton server t

Re: [tryton-dev] Database schema name limit

2015-05-26 Thread Cédric Krier
On 26 May 15:14, Pierre-Louis Bonicoli wrote: > How will an administrator know that the table used by the model > 'account.invoice.payment_term.line.relativedelta' should be mapped ? Easy it will crash otherwise. > Before a new module installation, knowing only the name of a table which > should

Re: [tryton-dev] Database schema name limit

2015-05-26 Thread Pierre-Louis Bonicoli
On 26/05/2015 14:35, Nicolas Évrard wrote: > * Pierre-Louis Bonicoli [2015-05-26 13:58 +0200]: >> On 26/05/2015 09:19, Nicolas Évrard wrote: >>> * Pierre-Louis Bonicoli [2015-05-26 02:33 +0200]: On 26/05/2015 00:55, Cédric Krier wrote: > On 25 May 18:00, Pierre-Louis Bonicoli wrote:

Re: [tryton-dev] Database schema name limit

2015-05-26 Thread Nicolas Évrard
* Pierre-Louis Bonicoli [2015-05-26 13:58 +0200]: On 26/05/2015 09:19, Nicolas Évrard wrote: * Pierre-Louis Bonicoli [2015-05-26 02:33 +0200]: On 26/05/2015 00:55, Cédric Krier wrote: On 25 May 18:00, Pierre-Louis Bonicoli wrote: On 21/05/2015 17:52, Cédric Krier wrote: I'm facing a limita

Re: [tryton-dev] Database schema name limit

2015-05-26 Thread Pierre-Louis Bonicoli
On 26/05/2015 09:20, Jean C wrote: > > 2015-05-26 2:33 GMT+02:00 Pierre-Louis Bonicoli > mailto:pierre-louis.bonic...@ir5.eu>>: > > We keep the current behavior (dots replaced by underscore) and use the > same approach as django (last X characters replaced by > 'hash(name)[:X]'). > >

Re: [tryton-dev] Database schema name limit

2015-05-26 Thread Pierre-Louis Bonicoli
On 26/05/2015 09:19, Nicolas Évrard wrote: > * Pierre-Louis Bonicoli [2015-05-26 02:33 +0200]: >> On 26/05/2015 00:55, Cédric Krier wrote: >>> On 25 May 18:00, Pierre-Louis Bonicoli wrote: On 21/05/2015 17:52, Cédric Krier wrote: > I'm facing a limitation with how trytond generate the tab

Re: [tryton-dev] Database schema name limit

2015-05-26 Thread Cédric Krier
On 26 May 02:33, Pierre-Louis Bonicoli wrote: > On 26/05/2015 00:55, Cédric Krier wrote: > > On 25 May 18:00, Pierre-Louis Bonicoli wrote: > >> On 21/05/2015 17:52, Cédric Krier wrote: > >>> I'm facing a limitation with how trytond generate the table name for a > >>> ModelSQL. Databases have differ

Re: [tryton-dev] Database schema name limit

2015-05-26 Thread Jean C
2015-05-26 2:33 GMT+02:00 Pierre-Louis Bonicoli < pierre-louis.bonic...@ir5.eu>: > We keep the current behavior (dots replaced by underscore) and use the > same approach as django (last X characters replaced by > 'hash(name)[:X]'). > Problem is, tryton sometimes relies on finding the table in the

Re: [tryton-dev] Database schema name limit

2015-05-26 Thread Nicolas Évrard
* Pierre-Louis Bonicoli [2015-05-26 02:33 +0200]: On 26/05/2015 00:55, Cédric Krier wrote: On 25 May 18:00, Pierre-Louis Bonicoli wrote: On 21/05/2015 17:52, Cédric Krier wrote: I'm facing a limitation with how trytond generate the table name for a ModelSQL. Databases have different length li

Re: [tryton-dev] Database schema name limit

2015-05-25 Thread Pierre-Louis Bonicoli
On 26/05/2015 00:55, Cédric Krier wrote: > On 25 May 18:00, Pierre-Louis Bonicoli wrote: >> On 21/05/2015 17:52, Cédric Krier wrote: >>> I'm facing a limitation with how trytond generate the table name for a >>> ModelSQL. Databases have different length limitation for schema name. >>> For example,

Re: [tryton-dev] Database schema name limit

2015-05-25 Thread Cédric Krier
On 25 May 18:00, Pierre-Louis Bonicoli wrote: > On 21/05/2015 17:52, Cédric Krier wrote: > > I'm facing a limitation with how trytond generate the table name for a > > ModelSQL. Databases have different length limitation for schema name. > > For example, > > PostgreSQL has the limit to 64 when Orac

Re: [tryton-dev] Database schema name limit

2015-05-25 Thread Cédric Krier
On 25 May 08:34, Raimon Esteve wrote: > 2015-05-21 17:52 GMT+02:00 Cédric Krier : > > > > Hi, > > > > I'm facing a limitation with how trytond generate the table name for a > > ModelSQL. Databases have different length limitation for schema name. > > For example, > > PostgreSQL has the limit to 64

Re: [tryton-dev] Database schema name limit

2015-05-25 Thread Cédric Krier
On 25 May 13:07, Mathias Behrle wrote: > * Cédric Krier: " Re: [tryton-dev] Database schema name limit" (Sat, 23 May > 2015 12:18:32 +0200): > > > On 23 May 11:01, Mathias Behrle wrote: > > > * Cédric Krier: " [tryton-dev] Database schema name limit&quo

Re: [tryton-dev] Database schema name limit

2015-05-25 Thread Oscar Andres Alvarez Montero
I am not expert but, I agree with Raimon 2015-05-25 1:34 GMT-05:00 Raimon Esteve : > 2015-05-21 17:52 GMT+02:00 Cédric Krier : > > > > Hi, > > > > I'm facing a limitation with how trytond generate the table name for a > > ModelSQL. Databases have different length limitation for schema name. > > F

Re: [tryton-dev] Database schema name limit

2015-05-25 Thread Pierre-Louis Bonicoli
On 21/05/2015 17:52, Cédric Krier wrote: > I'm facing a limitation with how trytond generate the table name for a > ModelSQL. Databases have different length limitation for schema name. > For example, > PostgreSQL has the limit to 64 when Oracle has the limit to 30 > (yes I'm working on an Oracle b

Re: [tryton-dev] Database schema name limit

2015-05-25 Thread Mathias Behrle
* Cédric Krier: " Re: [tryton-dev] Database schema name limit" (Sat, 23 May 2015 12:18:32 +0200): > On 23 May 11:01, Mathias Behrle wrote: > > * Cédric Krier: " [tryton-dev] Database schema name limit" (Thu, 21 May 2015 > > 17:52:57 +0200): > > >

Re: [tryton-dev] Database schema name limit

2015-05-24 Thread Raimon Esteve
2015-05-21 17:52 GMT+02:00 Cédric Krier : > > Hi, > > I'm facing a limitation with how trytond generate the table name for a > ModelSQL. Databases have different length limitation for schema name. > For example, > PostgreSQL has the limit to 64 when Oracle has the limit to 30 > (yes I'm working on

Re: [tryton-dev] Database schema name limit

2015-05-23 Thread Cédric Krier
On 23 May 11:01, Mathias Behrle wrote: > * Cédric Krier: " [tryton-dev] Database schema name limit" (Thu, 21 May 2015 > 17:52:57 +0200): > > > Hi, > > > > I'm facing a limitation with how trytond generate the table name for a > > ModelSQL. Datab

Re: [tryton-dev] Database schema name limit

2015-05-23 Thread Mathias Behrle
* Cédric Krier: " [tryton-dev] Database schema name limit" (Thu, 21 May 2015 17:52:57 +0200): > Hi, > > I'm facing a limitation with how trytond generate the table name for a > ModelSQL. Databases have different length limitation for schema name. > For example, &g

[tryton-dev] Database schema name limit

2015-05-23 Thread Cédric Krier
Hi, I'm facing a limitation with how trytond generate the table name for a ModelSQL. Databases have different length limitation for schema name. For example, PostgreSQL has the limit to 64 when Oracle has the limit to 30 (yes I'm working on an Oracle backend). I don't want that we change our nami