module AldyDebugKitSqlite3
Constants
- VERSION
Public Class Methods
getTables()
click to toggle source
# File lib/aldy_debug_kit_sqlite3.rb, line 9 def self.getTables table_names = ActiveRecord::Base.connection.tables models = [] table_names.each do |table_name| model_name = table_name.classify if !["ArInternalMetadatum", "SchemaMigration"].include?(model_name) begin model_object = model_name.constantize rescue => exception next end column_names = model_object.column_names rows = model_object.all model = {"table_name": table_name, "model_name": model_name, "column_names": column_names, "rows": rows} models.push(model) end end return models end
greet()
click to toggle source
Your code goes hereā¦
# File lib/aldy_debug_kit_sqlite3.rb, line 5 def self.greet 'Hey! I am Tsukasa Maruyama! Call me Aldy!' end
setUp()
click to toggle source
# File lib/aldy_debug_kit_sqlite3.rb, line 29 def self.setUp template = %Q{ <!DOCTYPE html> <html> <head> <meta charset="utf-8" /> <title>Show Tables</title> <link rel="stylesheet" type="text/css" href="https://stackpath.bootstrapcdn.com/bootstrap/4.2.1/css/bootstrap.min.css"> <script src="//ajax.googleapis.com/ajax/libs/jquery/1.11.1/jquery.min.js"></script> <script src="https://stackpath.bootstrapcdn.com/bootstrap/4.2.1/js/bootstrap.min.js"></script> <style> body { margin: 3% 5% } </style> </head> <body > <% @models.each do |model| %> <div class="page-header"> <h1> <%= model[:table_name] %> <a class="btn btn-primary" data-toggle="collapse" href="#collapseExample_<%= model[:model_name] %>" role="button" aria-expanded="false" aria-controls="collapseExample"> Show/Hidden </a> </h1> </div> <div class="collapse" id="collapseExample_<%= model[:model_name] %>"> <table class="table table-bordered table-striped table-sm"> <thead class="thead-dark"> <tr> <% model[:column_names].each do |column_name| %> <th scope="col"><%= column_name %></th> <% end %> </tr> </thead> <tbody> <% model[:rows].each do |row| %> <tr> <% model[:column_names].each do |column_name| %> <td><%= row[column_name] %></td> <% end %> </tr> <% end %> </tbody> </table> </div> <% end %> </body> </html> } File.open("views/aldy_show_sqlite3_tables.erb","w") do |text| template.each_line do |line| text.puts(line) end end action_text = %Q{ get '/models' do @models = AldyDebugKitSqlite3.getTables erb :aldy_show_sqlite3_tables end } File.open("show_table_action.rb","w") do |text| action_text.each_line do |line| text.puts(line) end end puts "Setup finished!" end