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

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:

Screen Shot 2020-05-22 at 1 10 28 AM

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)
Sign in to join this conversation.
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.