New User Setup - Naming Conventions for tables and columns #88

New issue

Open

opened 2020-05-22 10:07:35 +02:00 by jeffslofish · 1 comment

jeffslofish commented

2020-05-22 10:07:35 +02:00

(Migrated from github.com)

Hello, I would like to contribute to this project and I am having a little trouble getting set up.

I noticed that in the code the database table names are lowercase singular like 'block' and 'claim' while in the database SQL file https://github.com/lbryio/block-explorer/blob/master/sql/lbryexplorer.ddl.sql that is supposed to be used to populate the database schema, the table names are capital and plural, like 'Blocks' and 'Claims'.

Also, similar things are going on for the column names such as 'TransactionHashes' in the database and 'transaction_hashes' in the code.

Is there something I am missing to get CakePHP to convert from one to the other automatically? Also, it seems that this is exactly opposite of their recommended conventions.

Any help would be appreciated. =)

Hello, I would like to contribute to this project and I am having a little trouble getting set up. I noticed that in the code the database table names are lowercase singular like 'block' and 'claim' while in the database SQL file https://github.com/lbryio/block-explorer/blob/master/sql/lbryexplorer.ddl.sql that is supposed to be used to populate the database schema, the table names are capital and plural, like 'Blocks' and 'Claims'. Also, similar things are going on for the column names such as 'TransactionHashes' in the database and 'transaction_hashes' in the code. Is there something I am missing to get CakePHP to convert from one to the other automatically? Also, it seems that this is exactly opposite of their recommended conventions. Any help would be appreciated. =)

jeffslofish commented

2020-05-22 10:11:25 +02:00

(Migrated from github.com)

Here is an example of one of the errors I am getting:

Here is an example of one of the errors I am getting: ![Screen Shot 2020-05-22 at 1 10 28 AM](https://user-images.githubusercontent.com/1240484/82646257-1f0e8b00-9bc9-11ea-96e9-7e1632d0354a.png)

No milestone

No project

No assignees

1 participant

Notifications

Due date

The due date is invalid or out of range. Please use the format "yyyy-mm-dd".

No due date set.

Dependencies

No dependencies set.

Reference: LBRYCommunity/block-explorer#88

No description provided.