Class: DatabaseDocumenter::DatabaseComment::MysqlDatabaseComment

Inherits:
BaseDatabaseComment show all
Defined in:
lib/database_documenter/database_comment/mysql_database_comment.rb

Class Method Summary collapse

Methods inherited from BaseDatabaseComment

database_name

Class Method Details

.read_columns_comment(table_name) ⇒ Object 



3
4
5
6
7
8
9
10
11
12
13
 
# File 'lib/database_documenter/database_comment/mysql_database_comment.rb', line 3

def self.read_columns_comment(table_name)
  select_comment = "    SELECT `column_name`, `column_comment`\n    FROM `information_schema`.`COLUMNS`\n    WHERE `table_name` = '\#{table_name}'\n    AND `table_schema` = '\#{database_name}'\n    AND `column_comment` != '';\n  SQL\n\n  ActiveRecord::Base.connection.execute(select_comment).to_h\nend\n"

.read_table_comment(table_name) ⇒ Object 



15
16
17
18
19
20
21
22
23
24
 
# File 'lib/database_documenter/database_comment/mysql_database_comment.rb', line 15

def self.read_table_comment(table_name)
  select_comment = "    SELECT `TABLE_COMMENT`\n    FROM `information_schema`.`TABLES`\n    WHERE `TABLE_NAME` = '\#{table_name}'\n    AND `table_schema` = '\#{database_name}';\n  SQL\n\n  ActiveRecord::Base.connection.execute(select_comment).to_a.try('[]', 0).try('[]', 0)\nend\n"