(0.1ms) SELECT "schema_migrations"."version" FROM "schema_migrations" ORDER BY "schema_migrations"."version" ASC  (0.1ms) SELECT "schema_migrations"."version" FROM "schema_migrations" ORDER BY "schema_migrations"."version" ASC  (0.1ms) SELECT "schema_migrations"."version" FROM "schema_migrations" ORDER BY "schema_migrations"."version" ASC  (0.0ms) SELECT sqlite_version(*)  (2.1ms) CREATE TABLE "ar_internal_metadata" ("key" varchar NOT NULL PRIMARY KEY, "value" varchar, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)  (0.1ms) SELECT "schema_migrations"."version" FROM "schema_migrations" ORDER BY "schema_migrations"."version" ASC Migrating to AddDeletedAtToProjects (20180528134358)  (0.0ms) begin transaction  (0.2ms) ALTER TABLE "projects" ADD "deleted_at" datetime  (0.1ms) CREATE INDEX "index_projects_on_deleted_at" ON "projects" ("deleted_at") SQL (0.1ms) INSERT INTO "schema_migrations" ("version") VALUES (?) [["version", "20180528134358"]]  (1.4ms) commit transaction ActiveRecord::InternalMetadata Load (0.1ms) SELECT "ar_internal_metadata".* FROM "ar_internal_metadata" WHERE "ar_internal_metadata"."key" = ? LIMIT ? [["key", "environment"], ["LIMIT", 1]]  (0.0ms) begin transaction SQL (0.1ms) INSERT INTO "ar_internal_metadata" ("key", "value", "created_at", "updated_at") VALUES (?, ?, ?, ?) [["key", "environment"], ["value", "test"], ["created_at", "2018-07-03 06:19:28.207749"], ["updated_at", "2018-07-03 06:19:28.207749"]]  (1.0ms) commit transaction  (0.1ms) SELECT "schema_migrations"."version" FROM "schema_migrations" ORDER BY "schema_migrations"."version" ASC  (0.1ms)  SELECT sql FROM sqlite_master WHERE name='index_contacts_on_name_and_email' AND type='index' UNION ALL SELECT sql FROM sqlite_temp_master WHERE name='index_contacts_on_name_and_email' AND type='index'   (0.1ms)  SELECT sql FROM sqlite_master WHERE name='index_payments_on_project_id' AND type='index' UNION ALL SELECT sql FROM sqlite_temp_master WHERE name='index_payments_on_project_id' AND type='index'   (0.1ms)  SELECT sql FROM sqlite_master WHERE name='index_projects_on_deleted_at' AND type='index' UNION ALL SELECT sql FROM sqlite_temp_master WHERE name='index_projects_on_deleted_at' AND type='index'   (0.1ms)  SELECT sql FROM sqlite_master WHERE name='index_projects_users_on_user_id' AND type='index' UNION ALL SELECT sql FROM sqlite_temp_master WHERE name='index_projects_users_on_user_id' AND type='index'   (0.1ms)  SELECT sql FROM sqlite_master WHERE name='index_projects_users_on_project_id' AND type='index' UNION ALL SELECT sql FROM sqlite_temp_master WHERE name='index_projects_users_on_project_id' AND type='index'   (0.1ms)  SELECT sql FROM sqlite_master WHERE name='index_users_on_salary' AND type='index' UNION ALL SELECT sql FROM sqlite_temp_master WHERE name='index_users_on_salary' AND type='index'   (0.1ms)  SELECT sql FROM sqlite_master WHERE name='index_users_on_name' AND type='index' UNION ALL SELECT sql FROM sqlite_temp_master WHERE name='index_users_on_name' AND type='index'   (0.1ms)  SELECT sql FROM sqlite_master WHERE name='index_users_on_account_id' AND type='index' UNION ALL SELECT sql FROM sqlite_temp_master WHERE name='index_users_on_account_id' AND type='index'   (0.1ms) SELECT "schema_migrations"."version" FROM "schema_migrations" ORDER BY "schema_migrations"."version" ASC  (0.1ms) begin transaction ------------------------------------------------------------------------------------------------------------------------------------ TablesHelperTest: test_method_column_is_checked?_returns_true_for_checkbox_status_if_cookie_does_not_contain_hash_key_for_this_table ------------------------------------------------------------------------------------------------------------------------------------  (0.0ms) rollback transaction  (0.0ms) begin transaction ----------------------------------------------------------------------------------------------------------------------------------------- TablesHelperTest: test_method_column_is_checked?_returns_true_for_checkbox_status_if_cookie_does_not_contain_record_for_this_table:column -----------------------------------------------------------------------------------------------------------------------------------------  (0.0ms) rollback transaction  (0.0ms) begin transaction ---------------------------------------------------------------------------------------------------------------------------------- TablesHelperTest: test_method_column_is_checked?_returns_false_for_checkbox_status_if_cookie_contains_record_for_this_table:column ----------------------------------------------------------------------------------------------------------------------------------  (0.0ms) rollback transaction  (0.0ms) begin transaction ---------------------------------------------------------------------------------------------------------------------------- TablesHelperTest: test_method_display_style_column_returns_'display'_if_cookie_does_not_contain_record_for_this_table:column ----------------------------------------------------------------------------------------------------------------------------  (0.0ms) rollback transaction  (0.0ms) begin transaction ------------------------------------------------------------------------------------------------------------------------- TablesHelperTest: test_method_display_style_column_returns_'display:none'_if_cookie_contains_record_for_this_table:column -------------------------------------------------------------------------------------------------------------------------  (0.0ms) rollback transaction  (0.0ms) begin transaction ------------------------ TableTest: test_as_table ------------------------ SQL (0.2ms) DELETE FROM "users"  (0.1ms) SAVEPOINT active_record_1 SQL (0.1ms) INSERT INTO "users" ("name", "created_at", "updated_at") VALUES (?, ?, ?) [["name", "igor"], ["created_at", "2018-07-03 06:19:32.914929"], ["updated_at", "2018-07-03 06:19:32.914929"]]  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.2ms) SELECT COUNT(*) FROM "users"  Load (0.2ms) SELECT "users".* FROM "users" ORDER BY "users"."id" ASC LIMIT ? [["LIMIT", 1]]  (0.1ms) rollback transaction  (0.0ms) begin transaction ------------------------ TableTest: test_truncate ------------------------ SQL (0.1ms) DELETE FROM "users"  (0.0ms) SAVEPOINT active_record_1 SQL (0.1ms) INSERT INTO "users" ("name", "created_at", "updated_at") VALUES (?, ?, ?) [["name", "igor"], ["created_at", "2018-07-03 06:19:32.931125"], ["updated_at", "2018-07-03 06:19:32.931125"]]  (0.0ms) RELEASE SAVEPOINT active_record_1  (0.0ms) SELECT COUNT(*) FROM "users"  (0.0ms) DELETE FROM users;  (0.0ms) SELECT COUNT(*) FROM "users"  (0.1ms) rollback transaction  (0.0ms) begin transaction --------------------------- TableTest: test_primary_key ---------------------------  (0.0ms) rollback transaction  (0.0ms) begin transaction ---------------------- TableTest: test_to_csv ----------------------  (0.0ms) SAVEPOINT active_record_1 SQL (0.1ms) INSERT INTO "users" ("name", "created_at", "updated_at") VALUES (?, ?, ?) [["name", "igor"], ["created_at", "2018-07-03 06:19:32.933834"], ["updated_at", "2018-07-03 06:19:32.933834"]]  (0.0ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SELECT * FROM users  (0.1ms) rollback transaction  (0.0ms) begin transaction ----------------------- TableTest: test_columns -----------------------  (0.0ms) rollback transaction  (0.0ms) begin transaction ---------------------- TableTest: test_delete ---------------------- SQL (0.1ms) DELETE FROM "users"  (0.0ms) SAVEPOINT active_record_1 SQL (0.2ms) INSERT INTO "users" ("name", "created_at", "updated_at") VALUES (?, ?, ?) [["name", "igor"], ["created_at", "2018-07-03 06:19:32.936647"], ["updated_at", "2018-07-03 06:19:32.936647"]]  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.0ms) SAVEPOINT active_record_1 SQL (0.1ms) INSERT INTO "users" ("name", "created_at", "updated_at") VALUES (?, ?, ?) [["name", "john"], ["created_at", "2018-07-03 06:19:32.937966"], ["updated_at", "2018-07-03 06:19:32.937966"]]  (0.0ms) RELEASE SAVEPOINT active_record_1  (0.0ms) SELECT COUNT(*) FROM "users"  (0.0ms) DELETE FROM users WHERE id = 113;  (0.0ms) SELECT COUNT(*) FROM "users"  (0.1ms) SELECT COUNT(*) FROM "users" WHERE "users"."name" = ? [["name", "igor"]]  (0.1ms) SELECT COUNT(*) FROM "users" WHERE "users"."name" = ? [["name", "john"]]  (0.1ms) rollback transaction  (0.0ms) begin transaction ----------------------- RailsDbTest: test_truth -----------------------  (0.0ms) rollback transaction  (0.0ms) begin transaction ------------------------------------ RailsDbTest: test_verify_access_proc ------------------------------------  (0.0ms) rollback transaction  (0.0ms) begin transaction ---------------------------------------------- DashboardControllerTest: test_should_get_index ---------------------------------------------- SQL (0.1ms) DELETE FROM "users" SQL (0.1ms) DELETE FROM "accounts" SQL (0.1ms) DELETE FROM "users" WHERE "users"."type" IN ('Customer')  (0.0ms) SAVEPOINT active_record_1 SQL (0.1ms) INSERT INTO "users" ("name", "created_at", "updated_at") VALUES (?, ?, ?) [["name", "Igor"], ["created_at", "2018-07-03 06:19:32.994530"], ["updated_at", "2018-07-03 06:19:32.994530"]]  (0.0ms) RELEASE SAVEPOINT active_record_1  (0.0ms) SAVEPOINT active_record_1 SQL (0.1ms) INSERT INTO "users" ("name", "created_at", "updated_at") VALUES (?, ?, ?) [["name", "Edit"], ["created_at", "2018-07-03 06:19:32.995448"], ["updated_at", "2018-07-03 06:19:32.995448"]]  (0.0ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_1 SQL (0.1ms) INSERT INTO "users" ("name", "bio", "created_at", "updated_at", "type") VALUES (?, ?, ?, ?, ?) [["name", "Customer 1"], ["bio", "this is bio text"], ["created_at", "2018-07-03 06:19:33.004591"], ["updated_at", "2018-07-03 06:19:33.004591"], ["type", "Customer"]]  (0.0ms) RELEASE SAVEPOINT active_record_1 Started GET "/rails/db" for 127.0.0.1 at 2018-07-02 23:19:33 -0700 Processing by RailsDb::DashboardController#index as HTML Rendering /root/projects/rails_db/app/views/rails_db/dashboard/index.html.erb within layouts/rails_db/application Rendered /root/projects/rails_db/app/views/rails_db/dashboard/index.html.erb within layouts/rails_db/application (306.3ms) Rendered /root/projects/rails_db/app/views/rails_db/shared/_header.html.erb (3.8ms) Rendered /root/projects/rails_db/app/views/rails_db/shared/_sidebar.html.erb (1.4ms) Rendered /root/projects/rails_db/app/views/rails_db/shared/_gems.html.erb (0.7ms) Rendered /root/projects/rails_db/app/views/rails_db/shared/_footer.html.erb (2.7ms) Completed 200 OK in 325ms (Views: 324.1ms | ActiveRecord: 0.1ms) Started GET "/rails/db/tables/users" for 127.0.0.1 at 2018-07-02 23:19:33 -0700 Processing by RailsDb::TablesController#show as HTML Parameters: {"id"=>"users"} Rendering /root/projects/rails_db/app/views/rails_db/tables/show.html.erb within layouts/rails_db/application Rendered /root/projects/rails_db/app/views/rails_db/shared/_exp_col.html.erb (0.6ms)  (0.0ms)  SELECT sql FROM sqlite_master WHERE name='index_users_on_salary' AND type='index' UNION ALL SELECT sql FROM sqlite_temp_master WHERE name='index_users_on_salary' AND type='index'   (0.1ms)  SELECT sql FROM sqlite_master WHERE name='index_users_on_name' AND type='index' UNION ALL SELECT sql FROM sqlite_temp_master WHERE name='index_users_on_name' AND type='index'   (0.0ms)  SELECT sql FROM sqlite_master WHERE name='index_users_on_account_id' AND type='index' UNION ALL SELECT sql FROM sqlite_temp_master WHERE name='index_users_on_account_id' AND type='index'   (0.0ms)  SELECT sql FROM sqlite_master WHERE name='index_users_on_salary' AND type='index' UNION ALL SELECT sql FROM sqlite_temp_master WHERE name='index_users_on_salary' AND type='index'   (0.0ms)  SELECT sql FROM sqlite_master WHERE name='index_users_on_name' AND type='index' UNION ALL SELECT sql FROM sqlite_temp_master WHERE name='index_users_on_name' AND type='index'   (0.0ms)  SELECT sql FROM sqlite_master WHERE name='index_users_on_account_id' AND type='index' UNION ALL SELECT sql FROM sqlite_temp_master WHERE name='index_users_on_account_id' AND type='index'  Rendered /root/projects/rails_db/app/views/rails_db/tables/_show.html.erb (12.5ms) Rendered /root/projects/rails_db/app/views/rails_db/tables/show.html.erb within layouts/rails_db/application (13.1ms) Rendered /root/projects/rails_db/app/views/rails_db/shared/_header.html.erb (0.9ms) Rendered /root/projects/rails_db/app/views/rails_db/shared/_sidebar.html.erb (4.2ms) Rendered /root/projects/rails_db/app/views/rails_db/shared/_gems.html.erb (0.1ms) Rendered /root/projects/rails_db/app/views/rails_db/shared/_footer.html.erb (0.5ms) Completed 200 OK in 22ms (Views: 17.0ms | ActiveRecord: 4.4ms) Started GET "/rails/db/tables/users/data" for 127.0.0.1 at 2018-07-02 23:19:33 -0700 Processing by RailsDb::TablesController#data as HTML Parameters: {"table_id"=>"users"}  (0.1ms) SELECT COUNT(*) FROM "users" Rendering /root/projects/rails_db/app/views/rails_db/tables/data.html.erb within layouts/rails_db/application Rendered /root/projects/rails_db/app/views/rails_db/shared/_exp_col.html.erb (0.0ms) Rendered /root/projects/rails_db/app/views/rails_db/tables/_condition_fields.html.erb (16.6ms) Rendered /root/projects/rails_db/app/views/rails_db/tables/_condition_fields.html.erb (5.4ms)  Load (0.1ms) SELECT "users".* FROM "users" LIMIT ? OFFSET ? [["LIMIT", 30], ["OFFSET", 0]] Rendered /root/projects/rails_db/app/views/rails_db/tables/_row.html.erb (1.8ms) Rendered /root/projects/rails_db/app/views/rails_db/tables/_row.html.erb (1.2ms) Rendered /root/projects/rails_db/app/views/rails_db/tables/_row.html.erb (1.3ms) CACHE (0.0ms) SELECT COUNT(*) FROM "users" CACHE (0.0ms) SELECT COUNT(*) FROM "users" Rendered /root/projects/rails_db/app/views/rails_db/tables/_sql.html.erb (0.3ms) Rendered /root/projects/rails_db/app/views/rails_db/tables/_data.html.erb (51.6ms) Rendered /root/projects/rails_db/app/views/rails_db/tables/data.html.erb within layouts/rails_db/application (52.2ms) Rendered /root/projects/rails_db/app/views/rails_db/shared/_header.html.erb (0.7ms) Rendered /root/projects/rails_db/app/views/rails_db/shared/_sidebar.html.erb (0.7ms) Rendered /root/projects/rails_db/app/views/rails_db/shared/_gems.html.erb (0.1ms) Rendered /root/projects/rails_db/app/views/rails_db/shared/_footer.html.erb (0.5ms) Completed 200 OK in 62ms (Views: 52.9ms | ActiveRecord: 2.5ms) Started GET "/rails/db/sql" for 127.0.0.1 at 2018-07-02 23:19:33 -0700 Processing by RailsDb::SqlController#index as HTML Rendering /root/projects/rails_db/app/views/rails_db/sql/index.html.erb within layouts/rails_db/application Rendered /root/projects/rails_db/app/views/rails_db/shared/_exp_col.html.erb (0.0ms) Rendered /root/projects/rails_db/app/views/rails_db/sql/_history.html.erb (0.2ms) Rendered /root/projects/rails_db/app/views/rails_db/sql/index.html.erb within layouts/rails_db/application (4.7ms) Rendered /root/projects/rails_db/app/views/rails_db/shared/_header.html.erb (0.7ms) Rendered /root/projects/rails_db/app/views/rails_db/shared/_sidebar.html.erb (0.7ms) Rendered /root/projects/rails_db/app/views/rails_db/shared/_gems.html.erb (0.1ms) Rendered /root/projects/rails_db/app/views/rails_db/shared/_footer.html.erb (0.6ms) Completed 200 OK in 9ms (Views: 6.9ms | ActiveRecord: 1.6ms) Started GET "/rails/db/import" for 127.0.0.1 at 2018-07-02 23:19:33 -0700 Processing by RailsDb::SqlController#import as HTML Rendering /root/projects/rails_db/app/views/rails_db/sql/import.html.erb within layouts/rails_db/application Rendered /root/projects/rails_db/app/views/rails_db/sql/_import_sample.html.erb (0.2ms) Rendered /root/projects/rails_db/app/views/rails_db/sql/import.html.erb within layouts/rails_db/application (1.1ms) Rendered /root/projects/rails_db/app/views/rails_db/shared/_header.html.erb (0.7ms) Rendered /root/projects/rails_db/app/views/rails_db/shared/_sidebar.html.erb (0.7ms) Rendered /root/projects/rails_db/app/views/rails_db/shared/_gems.html.erb (0.1ms) Rendered /root/projects/rails_db/app/views/rails_db/shared/_footer.html.erb (0.5ms) Completed 200 OK in 5ms (Views: 4.2ms | ActiveRecord: 0.1ms) Started GET "/rails/db/data-table" for 127.0.0.1 at 2018-07-02 23:19:33 -0700 Processing by RailsDb::DashboardController#data_table as HTML Rendering /root/projects/rails_db/app/views/rails_db/dashboard/data_table.html.erb within layouts/rails_db/application Rendered /root/projects/rails_db/app/views/rails_db/dashboard/data_table.html.erb within layouts/rails_db/application (0.7ms) Rendered /root/projects/rails_db/app/views/rails_db/shared/_header.html.erb (0.7ms) Rendered /root/projects/rails_db/app/views/rails_db/shared/_sidebar.html.erb (0.7ms) Rendered /root/projects/rails_db/app/views/rails_db/shared/_gems.html.erb (0.1ms) Rendered /root/projects/rails_db/app/views/rails_db/shared/_footer.html.erb (0.5ms) Completed 200 OK in 4ms (Views: 3.6ms | ActiveRecord: 0.1ms) Started GET "/" for 127.0.0.1 at 2018-07-02 23:19:33 -0700 Processing by HomeController#index as HTML Rendering home/index.html.erb within layouts/application  (0.1ms) SELECT id, name, users_count FROM accounts ORDER BY users_count desc LIMIT 10 OFFSET 0 Rendered /root/projects/rails_db/app/views/rails_db/shared/_data_table.html.erb (0.6ms)  (0.1ms) select id, name, age from users order by age desc limit 10 Rendered /root/projects/rails_db/app/views/rails_db/shared/_sql_result.html.erb (0.4ms)  (0.0ms) SELECT COUNT(*) FROM "users"  (0.1ms) SELECT COUNT(*) FROM "users" WHERE "users"."type" IN ('Customer')  (0.1ms) SELECT COUNT(*) FROM "accounts" Rendered home/index.html.erb within layouts/application (4.4ms) Completed 200 OK in 7ms (Views: 5.7ms | ActiveRecord: 0.5ms) Started GET "/rails/db/tables/users/data?sort_column=id&sort_order=desc" for 127.0.0.1 at 2018-07-02 23:19:33 -0700 Processing by RailsDb::TablesController#data as HTML Parameters: {"sort_column"=>"id", "sort_order"=>"desc", "table_id"=>"users"}  (0.1ms) SELECT COUNT(*) FROM "users" Rendering /root/projects/rails_db/app/views/rails_db/tables/data.html.erb within layouts/rails_db/application Rendered /root/projects/rails_db/app/views/rails_db/shared/_exp_col.html.erb (0.0ms) Rendered /root/projects/rails_db/app/views/rails_db/tables/_condition_fields.html.erb (7.6ms) Rendered /root/projects/rails_db/app/views/rails_db/tables/_condition_fields.html.erb (6.0ms)  Load (0.1ms) SELECT "users".* FROM "users" LIMIT ? OFFSET ? [["LIMIT", 30], ["OFFSET", 0]] Rendered /root/projects/rails_db/app/views/rails_db/tables/_row.html.erb (1.4ms) Rendered /root/projects/rails_db/app/views/rails_db/tables/_row.html.erb (1.2ms) Rendered /root/projects/rails_db/app/views/rails_db/tables/_row.html.erb (1.2ms) CACHE (0.0ms) SELECT COUNT(*) FROM "users" CACHE (0.0ms) SELECT COUNT(*) FROM "users" Rendered /root/projects/rails_db/app/views/rails_db/tables/_sql.html.erb (0.0ms) Rendered /root/projects/rails_db/app/views/rails_db/tables/_data.html.erb (43.1ms) Rendered /root/projects/rails_db/app/views/rails_db/tables/data.html.erb within layouts/rails_db/application (43.2ms) Rendered /root/projects/rails_db/app/views/rails_db/shared/_header.html.erb (0.7ms) Rendered /root/projects/rails_db/app/views/rails_db/shared/_sidebar.html.erb (0.6ms) Rendered /root/projects/rails_db/app/views/rails_db/shared/_gems.html.erb (0.1ms) Rendered /root/projects/rails_db/app/views/rails_db/shared/_footer.html.erb (0.5ms) Completed 200 OK in 52ms (Views: 44.1ms | ActiveRecord: 2.4ms)  (0.0ms) SELECT COUNT(*) FROM "users" Started GET "/rails/db/tables/users/destroy?pk_id=113" for 127.0.0.1 at 2018-07-02 23:19:33 -0700 Processing by RailsDb::TablesController#destroy as HTML Parameters: {"pk_id"=>"113", "table_id"=>"users"}  (0.1ms) SELECT COUNT(*) FROM "users"  (0.1ms) DELETE FROM users WHERE id = '113'; Redirected to http://www.example.com/rails/db/tables/users/data Completed 302 Found in 7ms (ActiveRecord: 0.4ms)  (0.0ms) SELECT COUNT(*) FROM "users" Started GET "/rails/db/tables/users/csv" for 127.0.0.1 at 2018-07-02 23:19:33 -0700 Processing by RailsDb::TablesController#csv as HTML Parameters: {"table_id"=>"users"}  (0.1ms) SELECT * FROM users Rendering text template Rendered text template (0.0ms) Sent data users.csv (0.9ms) Completed 200 OK in 2ms (Views: 0.8ms | ActiveRecord: 0.3ms) Started GET "/rails/db/standalone" for 127.0.0.1 at 2018-07-02 23:19:33 -0700 Processing by RailsDb::DashboardController#standalone as HTML Rendering /root/projects/rails_db/app/views/rails_db/dashboard/standalone.html.erb within layouts/rails_db/application Rendered /root/projects/rails_db/app/views/rails_db/dashboard/standalone.html.erb within layouts/rails_db/application (0.7ms) Rendered /root/projects/rails_db/app/views/rails_db/shared/_header.html.erb (0.7ms) Rendered /root/projects/rails_db/app/views/rails_db/shared/_sidebar.html.erb (0.7ms) Rendered /root/projects/rails_db/app/views/rails_db/shared/_gems.html.erb (0.1ms) Rendered /root/projects/rails_db/app/views/rails_db/shared/_footer.html.erb (0.4ms) Completed 200 OK in 4ms (Views: 3.7ms | ActiveRecord: 0.1ms) Started GET "/rails/db/tables/users/xlsx.xls" for 127.0.0.1 at 2018-07-02 23:19:33 -0700 Processing by RailsDb::TablesController#xlsx as XLS Parameters: {"table_id"=>"users"} Rendering /root/projects/rails_db/app/views/rails_db/tables/table.xls.axlsx  (0.1ms) SELECT * FROM users Rendered /root/projects/rails_db/app/views/rails_db/tables/table.xls.axlsx (5.9ms) Rendering text template Rendered text template (0.0ms) Sent data users.xlsx (0.3ms) Completed 200 OK in 8ms (Views: 7.4ms | ActiveRecord: 0.4ms) Started GET "/rails/db/sql?sql=select+%2A+from+users+limit+10" for 127.0.0.1 at 2018-07-02 23:19:33 -0700 Processing by RailsDb::SqlController#index as HTML Parameters: {"sql"=>"select * from users limit 10"}  (0.1ms) select * from users limit 10  (0.1ms) EXPLAIN select * from users limit 10 Rendering /root/projects/rails_db/app/views/rails_db/sql/index.html.erb within layouts/rails_db/application Rendered /root/projects/rails_db/app/views/rails_db/shared/_exp_col.html.erb (0.0ms) Rendered /root/projects/rails_db/app/views/rails_db/sql/_history.html.erb (0.2ms) Rendered /root/projects/rails_db/app/views/rails_db/sql/_explain.html.erb (0.3ms) Rendered /root/projects/rails_db/app/views/rails_db/sql/_results.html.erb (1.4ms) Rendered /root/projects/rails_db/app/views/rails_db/sql/index.html.erb within layouts/rails_db/application (6.2ms) Rendered /root/projects/rails_db/app/views/rails_db/shared/_header.html.erb (1.1ms) Rendered /root/projects/rails_db/app/views/rails_db/shared/_sidebar.html.erb (1.0ms) Rendered /root/projects/rails_db/app/views/rails_db/shared/_gems.html.erb (0.1ms) Rendered /root/projects/rails_db/app/views/rails_db/shared/_footer.html.erb (0.5ms) Completed 200 OK in 12ms (Views: 9.4ms | ActiveRecord: 2.0ms) Started POST "/rails/db/sql-csv.csv?sql=select+%2A+from+users+limit+10" for 127.0.0.1 at 2018-07-02 23:19:33 -0700 Processing by RailsDb::SqlController#csv as CSV Parameters: {"sql"=>"select * from users limit 10"}  (0.1ms) select * from users limit 10  (0.1ms) EXPLAIN select * from users limit 10 Rendering text template Rendered text template (0.0ms) Sent data results.csv (0.2ms) Completed 200 OK in 1ms (Views: 0.2ms | ActiveRecord: 0.2ms) Started POST "/rails/db/sql-xls.xls?sql=select+%2A+from+users+limit+10" for 127.0.0.1 at 2018-07-02 23:19:33 -0700 Processing by RailsDb::SqlController#xls as XLS Parameters: {"sql"=>"select * from users limit 10"}  (0.1ms) select * from users limit 10  (0.1ms) EXPLAIN select * from users limit 10 Rendering /root/projects/rails_db/app/views/rails_db/sql/xls.xls.axlsx Rendered /root/projects/rails_db/app/views/rails_db/sql/xls.xls.axlsx (5.8ms) Rendering text template Rendered text template (0.0ms) Sent data results.xlsx (0.3ms) Completed 200 OK in 7ms (Views: 6.8ms | ActiveRecord: 0.2ms) Started GET "/rails/db/tables/users/edit?pk_id=114" for 127.0.0.1 at 2018-07-02 23:19:33 -0700 Processing by RailsDb::TablesController#edit as JS Parameters: {"pk_id"=>"114", "table_id"=>"users"}  (0.1ms) SELECT COUNT(*) FROM "users"  Load (0.1ms) SELECT "users".* FROM "users" WHERE "users"."id" = ? LIMIT ? [["id", 114], ["LIMIT", 1]] Rendering /root/projects/rails_db/app/views/rails_db/tables/edit.js.erb Rendered /root/projects/rails_db/app/views/rails_db/tables/_edit.html.erb (20.7ms) Rendered /root/projects/rails_db/app/views/rails_db/tables/edit.js.erb (22.5ms) Completed 200 OK in 36ms (Views: 22.2ms | ActiveRecord: 2.1ms) Started PUT "/rails/db/tables/users/update?pk_id=114" for 127.0.0.1 at 2018-07-02 23:19:33 -0700 Processing by RailsDb::TablesController#update as JS Parameters: {"record"=>{"name"=>"JOHN"}, "pk_id"=>"114", "table_id"=>"users"}  (0.1ms) SELECT COUNT(*) FROM "users"  Load (0.0ms) SELECT "users".* FROM "users" WHERE "users"."id" = ? LIMIT ? [["id", 114], ["LIMIT", 1]]  (0.1ms) SAVEPOINT active_record_1 SQL (0.1ms) UPDATE "users" SET "name" = ?, "updated_at" = ? WHERE "users"."id" = ? [["name", "JOHN"], ["updated_at", "2018-07-03 06:19:33.622376"], ["id", 114]]  (0.0ms) RELEASE SAVEPOINT active_record_1 Rendering /root/projects/rails_db/app/views/rails_db/tables/update.js.erb Rendered /root/projects/rails_db/app/views/rails_db/tables/_row.html.erb (1.8ms) Rendered /root/projects/rails_db/app/views/rails_db/tables/update.js.erb (2.8ms) Completed 200 OK in 15ms (Views: 2.4ms | ActiveRecord: 1.1ms) User Load (0.0ms) SELECT "users".* FROM "users" WHERE "users"."id" = ? LIMIT ? [["id", 114], ["LIMIT", 1]] Started GET "/rails/db/tables/users/new" for 127.0.0.1 at 2018-07-02 23:19:33 -0700 Processing by RailsDb::TablesController#new as JS Parameters: {"table_id"=>"users"}  (0.1ms) SELECT COUNT(*) FROM "users" Rendering /root/projects/rails_db/app/views/rails_db/tables/new.js.erb Rendered /root/projects/rails_db/app/views/rails_db/tables/_new.html.erb (7.0ms) Rendered /root/projects/rails_db/app/views/rails_db/tables/new.js.erb (11.2ms) Completed 200 OK in 23ms (Views: 10.0ms | ActiveRecord: 1.7ms)  (0.0ms) SELECT COUNT(*) FROM "users" Started POST "/rails/db/tables/users/create" for 127.0.0.1 at 2018-07-02 23:19:33 -0700 Processing by RailsDb::TablesController#create as JS Parameters: {"record"=>{"name"=>"XXX"}, "table_id"=>"users"}  (0.1ms) SELECT COUNT(*) FROM "users"  (0.1ms) SAVEPOINT active_record_1 SQL (0.1ms) INSERT INTO "users" ("name", "created_at", "updated_at") VALUES (?, ?, ?) [["name", "XXX"], ["created_at", "2018-07-03 06:19:33.662675"], ["updated_at", "2018-07-03 06:19:33.662675"]]  (0.1ms) RELEASE SAVEPOINT active_record_1 Rendering /root/projects/rails_db/app/views/rails_db/tables/create.js.erb Rendered /root/projects/rails_db/app/views/rails_db/shared/_exp_col.html.erb (0.2ms) Rendered /root/projects/rails_db/app/views/rails_db/tables/_condition_fields.html.erb (6.2ms) Rendered /root/projects/rails_db/app/views/rails_db/tables/_condition_fields.html.erb (5.4ms)  Load (0.2ms) SELECT "users".* FROM "users" LIMIT ? OFFSET ? [["LIMIT", 30], ["OFFSET", 0]] Rendered /root/projects/rails_db/app/views/rails_db/tables/_row.html.erb (1.4ms) Rendered /root/projects/rails_db/app/views/rails_db/tables/_row.html.erb (1.3ms) Rendered /root/projects/rails_db/app/views/rails_db/tables/_row.html.erb (1.3ms)  (0.1ms) SELECT COUNT(*) FROM "users" CACHE (0.0ms) SELECT COUNT(*) FROM "users" Rendered /root/projects/rails_db/app/views/rails_db/tables/_sql.html.erb (0.3ms) Rendered /root/projects/rails_db/app/views/rails_db/tables/_data.html.erb (37.3ms) Rendered /root/projects/rails_db/app/views/rails_db/tables/create.js.erb (39.0ms) Completed 200 OK in 53ms (Views: 36.9ms | ActiveRecord: 2.8ms)  (0.1ms) SELECT COUNT(*) FROM "users" Started GET "/rails/db/tables/users/edit?pk_id=115" for 127.0.0.1 at 2018-07-02 23:19:33 -0700 Processing by RailsDb::TablesController#edit as JS Parameters: {"pk_id"=>"115", "table_id"=>"users"}  (0.1ms) SELECT COUNT(*) FROM "users"  Load (0.1ms) SELECT "users".* FROM "users" WHERE "users"."id" = ? LIMIT ? [["id", 115], ["LIMIT", 1]] Rendering /root/projects/rails_db/app/views/rails_db/tables/edit.js.erb Rendered /root/projects/rails_db/app/views/rails_db/tables/_edit.html.erb (9.4ms) Rendered /root/projects/rails_db/app/views/rails_db/tables/edit.js.erb (10.3ms) Completed 200 OK in 20ms (Views: 9.1ms | ActiveRecord: 1.8ms) Started PUT "/rails/db/tables/users/update?pk_id=115" for 127.0.0.1 at 2018-07-02 23:19:33 -0700 Processing by RailsDb::TablesController#update as JS Parameters: {"record"=>{"name"=>"STI"}, "pk_id"=>"115", "table_id"=>"users"}  (0.1ms) SELECT COUNT(*) FROM "users"  Load (0.0ms) SELECT "users".* FROM "users" WHERE "users"."id" = ? LIMIT ? [["id", 115], ["LIMIT", 1]]  (0.1ms) SAVEPOINT active_record_1 SQL (0.1ms) UPDATE "users" SET "name" = ?, "updated_at" = ? WHERE "users"."id" = ? [["name", "STI"], ["updated_at", "2018-07-03 06:19:33.741155"], ["id", 115]]  (0.0ms) RELEASE SAVEPOINT active_record_1 Rendering /root/projects/rails_db/app/views/rails_db/tables/update.js.erb Rendered /root/projects/rails_db/app/views/rails_db/tables/_row.html.erb (1.3ms) Rendered /root/projects/rails_db/app/views/rails_db/tables/update.js.erb (1.8ms) Completed 200 OK in 14ms (Views: 1.4ms | ActiveRecord: 1.0ms) Customer Load (0.1ms) SELECT "users".* FROM "users" WHERE "users"."type" IN ('Customer') AND "users"."id" = ? LIMIT ? [["id", 115], ["LIMIT", 1]] Started GET "/admin/tools/db" for 127.0.0.1 at 2018-07-02 23:19:33 -0700 Processing by RailsDb::DashboardController#index as HTML Rendering /root/projects/rails_db/app/views/rails_db/dashboard/index.html.erb within layouts/rails_db/application Rendered /root/projects/rails_db/app/views/rails_db/dashboard/index.html.erb within layouts/rails_db/application (0.3ms) Rendered /root/projects/rails_db/app/views/rails_db/shared/_header.html.erb (0.7ms) Rendered /root/projects/rails_db/app/views/rails_db/shared/_sidebar.html.erb (0.7ms) Rendered /root/projects/rails_db/app/views/rails_db/shared/_gems.html.erb (0.1ms) Rendered /root/projects/rails_db/app/views/rails_db/shared/_footer.html.erb (0.5ms) Completed 200 OK in 4ms (Views: 3.3ms | ActiveRecord: 0.1ms) Started GET "/admin/tools/db/sql" for 127.0.0.1 at 2018-07-02 23:19:33 -0700 Processing by RailsDb::SqlController#index as HTML Rendering /root/projects/rails_db/app/views/rails_db/sql/index.html.erb within layouts/rails_db/application Rendered /root/projects/rails_db/app/views/rails_db/shared/_exp_col.html.erb (0.0ms) Rendered /root/projects/rails_db/app/views/rails_db/sql/_history.html.erb (0.2ms) Rendered /root/projects/rails_db/app/views/rails_db/sql/index.html.erb within layouts/rails_db/application (4.0ms) Rendered /root/projects/rails_db/app/views/rails_db/shared/_header.html.erb (0.7ms) Rendered /root/projects/rails_db/app/views/rails_db/shared/_sidebar.html.erb (0.7ms) Rendered /root/projects/rails_db/app/views/rails_db/shared/_gems.html.erb (0.1ms) Rendered /root/projects/rails_db/app/views/rails_db/shared/_footer.html.erb (0.5ms) Completed 200 OK in 8ms (Views: 5.8ms | ActiveRecord: 1.7ms)  (0.1ms) rollback transaction  (0.0ms) begin transaction ---------------------------------------------------------------------- RailsDbDataTableHelperTest: test_default_rails_db_data_table_sql_works ----------------------------------------------------------------------  (0.0ms) SAVEPOINT active_record_1 SQL (0.2ms) INSERT INTO "users" ("name", "created_at", "updated_at") VALUES (?, ?, ?) [["name", "Igor"], ["created_at", "2018-07-03 06:19:33.760611"], ["updated_at", "2018-07-03 06:19:33.760611"]]  (0.0ms) RELEASE SAVEPOINT active_record_1  (0.1ms) select * from users Rendered /root/projects/rails_db/app/views/rails_db/shared/_sql_result.html.erb (0.7ms)  (0.1ms) rollback transaction  (0.0ms) begin transaction ------------------------------------------------------------------ RailsDbDataTableHelperTest: test_default_rails_db_data_table_works ------------------------------------------------------------------  (0.0ms) SAVEPOINT active_record_1 SQL (0.1ms) INSERT INTO "users" ("name", "created_at", "updated_at") VALUES (?, ?, ?) [["name", "Igor"], ["created_at", "2018-07-03 06:19:33.767604"], ["updated_at", "2018-07-03 06:19:33.767604"]]  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SELECT * FROM users Rendered /root/projects/rails_db/app/views/rails_db/shared/_data_table.html.erb (2.4ms)  (0.1ms) rollback transaction  (0.0ms) begin transaction -------------------------------------------------------------------------------- RailsDbDataTableHelperTest: test_rails_db_data_table_sql_works_with_many_options --------------------------------------------------------------------------------  (0.0ms) SAVEPOINT active_record_1 SQL (0.1ms) INSERT INTO "users" ("name", "created_at", "updated_at") VALUES (?, ?, ?) [["name", "Igor"], ["created_at", "2018-07-03 06:19:33.775466"], ["updated_at", "2018-07-03 06:19:33.775466"]]  (0.0ms) RELEASE SAVEPOINT active_record_1  (0.1ms) select * from users Rendered /root/projects/rails_db/app/views/rails_db/shared/_sql_result.html.erb (0.2ms)  (0.1ms) rollback transaction  (0.0ms) begin transaction ---------------------------------------------------------------------------- RailsDbDataTableHelperTest: test_rails_db_data_table_works_with_many_options ----------------------------------------------------------------------------  (0.0ms) SAVEPOINT active_record_1 SQL (0.1ms) INSERT INTO "users" ("name", "age", "created_at", "updated_at") VALUES (?, ?, ?, ?) [["name", "Igor"], ["age", 9999], ["created_at", "2018-07-03 06:19:33.777714"], ["updated_at", "2018-07-03 06:19:33.777714"]]  (0.0ms) RELEASE SAVEPOINT active_record_1  (0.0ms) SELECT id, name FROM users ORDER BY id asc LIMIT 10 OFFSET 0 Rendered /root/projects/rails_db/app/views/rails_db/shared/_data_table.html.erb (0.2ms)  (0.1ms) rollback transaction  (0.0ms) begin transaction -------------------------- SqlImportTest: test_import --------------------------  (0.1ms) update users set age = 11 where id = 1  (0.0ms) update users set age = 22 where id = 2  (0.0ms) update users set age = 33 where id = 3  (0.1ms)  CREATE TABLE t(x INTEGER, y, z, PRIMARY KEY(x ASC));  (0.1ms) rollback transaction  (0.0ms) begin transaction ------------------------------------ DatabaseTest: test_accessible_tables ------------------------------------  (0.0ms) rollback transaction  (0.0ms) begin transaction -------------------------- DatabaseTest: test_adapter --------------------------  (0.0ms) rollback transaction  (0.0ms) begin transaction ------------------------ DatabaseTest: test_query ------------------------ SQL (0.1ms) DELETE FROM "users"  (0.0ms) SAVEPOINT active_record_1 SQL (0.1ms) INSERT INTO "users" ("name", "created_at", "updated_at") VALUES (?, ?, ?) [["name", "Igor"], ["created_at", "2018-07-03 06:19:33.783135"], ["updated_at", "2018-07-03 06:19:33.783135"]]  (0.0ms) RELEASE SAVEPOINT active_record_1  (0.0ms) select count(*) as users_count from users  (0.1ms) EXPLAIN select count(*) as users_count from users  (0.1ms) rollback transaction  (0.0ms) begin transaction ------------------------- DatabaseTest: test_tables -------------------------  (0.0ms) rollback transaction  (0.0ms) begin transaction ------------------------- DatabaseTest: test_insert -------------------------  (0.1ms) delete from projects_users  (0.0ms) EXPLAIN delete from projects_users SQL (0.0ms) DELETE FROM "users"  (0.0ms) SELECT COUNT(*) FROM projects_users  (0.0ms) insert into projects_users(project_id, user_id) values(1,2)  (0.1ms) EXPLAIN insert into projects_users(project_id, user_id) values(1,2)  (0.0ms) SELECT COUNT(*) FROM projects_users  (0.0ms) rollback transaction  (0.1ms) DROP TABLE IF EXISTS "accounts"  (0.1ms) SELECT sqlite_version(*)  (3.4ms) CREATE TABLE "accounts" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "users_count" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)  (0.1ms) DROP TABLE IF EXISTS "comments"  (3.1ms) CREATE TABLE "comments" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "comment" text, "user_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)  (0.1ms) DROP TABLE IF EXISTS "contacts"  (2.8ms) CREATE TABLE "contacts" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "email" varchar, "message" text, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)  (2.4ms) CREATE INDEX "index_contacts_on_name_and_email" ON "contacts" ("name", "email")  (0.1ms) DROP TABLE IF EXISTS "legacy_accounts"  (2.3ms) CREATE TABLE "legacy_accounts" ("uuid" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar)  (0.2ms) DROP TABLE IF EXISTS "payments"  (2.4ms) CREATE TABLE "payments" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "amount" decimal, "project_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)  (2.4ms) CREATE INDEX "index_payments_on_project_id" ON "payments" ("project_id")  (0.1ms) DROP TABLE IF EXISTS "projects"  (2.6ms) CREATE TABLE "projects" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "description_214636" varchar, "description_881927" varchar, "description_377910" varchar, "description_787561" varchar, "description_397939" varchar, "description_427609" varchar, "description_70125" varchar, "description_68088" varchar, "description_211155" varchar, "description_915979" varchar, "description_198834" varchar, "description_669085" varchar, "description_771" varchar, "description_519606" varchar, "description_500107" varchar, "description_277668" varchar, "description_706655" varchar, "description_617984" varchar, "description_312370" varchar, "description_239866" varchar, "amount_777579" integer, "amount_886090" integer, "amount_11955" integer, "amount_494653" integer, "amount_666834" integer, "amount_297923" integer, "amount_458470" integer, "amount_339355" integer, "amount_539001" integer, "amount_209067" integer, "amount_74088" integer, "amount_736364" integer, "amount_685429" integer, "amount_506310" integer, "amount_440103" integer, "amount_418280" integer, "amount_60289" integer, "amount_433505" integer, "amount_160749" integer, "amount_723751" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "deleted_at" datetime)  (2.8ms) CREATE INDEX "index_projects_on_deleted_at" ON "projects" ("deleted_at")  (0.1ms) DROP TABLE IF EXISTS "projects_users"  (2.6ms) CREATE TABLE "projects_users" ("project_id" integer, "user_id" integer)  (2.6ms) CREATE INDEX "index_projects_users_on_project_id" ON "projects_users" ("project_id")  (0.4ms)  SELECT sql FROM sqlite_master WHERE name='index_projects_users_on_project_id' AND type='index' UNION ALL SELECT sql FROM sqlite_temp_master WHERE name='index_projects_users_on_project_id' AND type='index'   (2.7ms) CREATE INDEX "index_projects_users_on_user_id" ON "projects_users" ("user_id")  (0.1ms) DROP TABLE IF EXISTS "users"  (2.4ms) CREATE TABLE "users" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "age" integer, "salary" decimal, "bio" text, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "account_id" integer, "dob" date, "active" boolean DEFAULT 't', "type" varchar)  (2.3ms) CREATE INDEX "index_users_on_account_id" ON "users" ("account_id")  (0.1ms)  SELECT sql FROM sqlite_master WHERE name='index_users_on_account_id' AND type='index' UNION ALL SELECT sql FROM sqlite_temp_master WHERE name='index_users_on_account_id' AND type='index'   (2.7ms) CREATE INDEX "index_users_on_name" ON "users" ("name")  (0.1ms)  SELECT sql FROM sqlite_master WHERE name='index_users_on_name' AND type='index' UNION ALL SELECT sql FROM sqlite_temp_master WHERE name='index_users_on_name' AND type='index'   (0.1ms)  SELECT sql FROM sqlite_master WHERE name='index_users_on_account_id' AND type='index' UNION ALL SELECT sql FROM sqlite_temp_master WHERE name='index_users_on_account_id' AND type='index'   (2.3ms) CREATE INDEX "index_users_on_salary" ON "users" ("salary")  (2.6ms) CREATE TABLE "schema_migrations" ("version" varchar NOT NULL PRIMARY KEY)  (0.1ms) SELECT "schema_migrations"."version" FROM "schema_migrations" ORDER BY "schema_migrations"."version" ASC  (2.2ms) INSERT INTO "schema_migrations" (version) VALUES (20180528134358)  (2.0ms) INSERT INTO "schema_migrations" (version) VALUES (20151014183823), (20170126124628), (20151014074454), (20151015145740), (20151014184243), (20151013204027), (20151014152932), (20151013203739), (20151013203757), (20151027192250), (20151028191429), (20151027223149), (20151014074655), (20151121125538);   (3.6ms) CREATE TABLE "ar_internal_metadata" ("key" varchar NOT NULL PRIMARY KEY, "value" varchar, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL) ActiveRecord::InternalMetadata Load (0.1ms) SELECT "ar_internal_metadata".* FROM "ar_internal_metadata" WHERE "ar_internal_metadata"."key" = ? LIMIT ? [["key", "environment"], ["LIMIT", 1]]  (0.1ms) begin transaction SQL (0.1ms) INSERT INTO "ar_internal_metadata" ("key", "value", "created_at", "updated_at") VALUES (?, ?, ?, ?) [["key", "environment"], ["value", "test"], ["created_at", "2019-09-07 08:33:32.941136"], ["updated_at", "2019-09-07 08:33:32.941136"]]  (1.9ms) commit transaction ActiveRecord::InternalMetadata Load (0.1ms) SELECT "ar_internal_metadata".* FROM "ar_internal_metadata" WHERE "ar_internal_metadata"."key" = ? LIMIT ? [["key", "environment"], ["LIMIT", 1]]  (0.0ms) begin transaction  (0.0ms) commit transaction  (0.1ms) SELECT "schema_migrations"."version" FROM "schema_migrations" ORDER BY "schema_migrations"."version" ASC  (0.1ms) begin transaction ------------------------------------ DatabaseTest: test_accessible_tables ------------------------------------  (0.1ms) rollback transaction  (0.1ms) begin transaction ------------------------- DatabaseTest: test_insert -------------------------  (0.2ms) delete from projects_users  (0.1ms) EXPLAIN delete from projects_users SQL (0.1ms) DELETE FROM "users"  (0.1ms) SELECT COUNT(*) FROM projects_users  (0.1ms) insert into projects_users(project_id, user_id) values(1,2)  (0.2ms) EXPLAIN insert into projects_users(project_id, user_id) values(1,2)  (0.1ms) SELECT COUNT(*) FROM projects_users  (0.1ms) rollback transaction  (0.0ms) begin transaction ------------------------- DatabaseTest: test_tables -------------------------  (0.0ms) rollback transaction  (0.1ms) begin transaction ------------------------ DatabaseTest: test_query ------------------------ SQL (0.3ms) DELETE FROM "users"  (0.1ms) SAVEPOINT active_record_1 SQL (1.1ms) INSERT INTO "users" ("name", "created_at", "updated_at") VALUES (?, ?, ?) [["name", "Igor"], ["created_at", "2019-09-07 08:33:33.044105"], ["updated_at", "2019-09-07 08:33:33.044105"]]  (0.0ms) RELEASE SAVEPOINT active_record_1  (0.1ms) select count(*) as users_count from users  (0.1ms) EXPLAIN select count(*) as users_count from users  (0.1ms) rollback transaction  (0.0ms) begin transaction -------------------------- DatabaseTest: test_adapter --------------------------  (0.0ms) rollback transaction  (0.0ms) begin transaction ---------------------------------------------- DashboardControllerTest: test_should_get_index ---------------------------------------------- SQL (0.1ms) DELETE FROM "users" SQL (0.1ms) DELETE FROM "accounts" SQL (0.1ms) DELETE FROM "users" WHERE "users"."type" IN ('Customer')  (0.0ms) SAVEPOINT active_record_1 SQL (0.3ms) INSERT INTO "users" ("name", "created_at", "updated_at") VALUES (?, ?, ?) [["name", "Igor"], ["created_at", "2019-09-07 08:33:33.188165"], ["updated_at", "2019-09-07 08:33:33.188165"]]  (0.0ms) RELEASE SAVEPOINT active_record_1  (0.0ms) SAVEPOINT active_record_1 SQL (0.1ms) INSERT INTO "users" ("name", "created_at", "updated_at") VALUES (?, ?, ?) [["name", "Edit"], ["created_at", "2019-09-07 08:33:33.204500"], ["updated_at", "2019-09-07 08:33:33.204500"]]  (0.0ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_1 SQL (0.1ms) INSERT INTO "users" ("name", "bio", "created_at", "updated_at", "type") VALUES (?, ?, ?, ?, ?) [["name", "Customer 1"], ["bio", "this is bio text"], ["created_at", "2019-09-07 08:33:33.214679"], ["updated_at", "2019-09-07 08:33:33.214679"], ["type", "Customer"]]  (0.0ms) RELEASE SAVEPOINT active_record_1 Started GET "/rails/db" for 127.0.0.1 at 2019-09-07 01:33:33 -0700 Processing by RailsDb::DashboardController#index as HTML Rendering /root/projects/rails_db/app/views/rails_db/dashboard/index.html.erb within layouts/rails_db/application Rendered /root/projects/rails_db/app/views/rails_db/dashboard/index.html.erb within layouts/rails_db/application (510.1ms) Rendered /root/projects/rails_db/app/views/rails_db/shared/_header.html.erb (3.8ms) Rendered /root/projects/rails_db/app/views/rails_db/shared/_sidebar.html.erb (1.8ms) Rendered /root/projects/rails_db/app/views/rails_db/shared/_gems.html.erb (0.6ms) Rendered /root/projects/rails_db/app/views/rails_db/shared/_footer.html.erb (2.8ms) Completed 200 OK in 532ms (Views: 530.9ms | ActiveRecord: 0.1ms) Started GET "/rails/db/tables/users" for 127.0.0.1 at 2019-09-07 01:33:33 -0700 Processing by RailsDb::TablesController#show as HTML Parameters: {"id"=>"users"} Rendering /root/projects/rails_db/app/views/rails_db/tables/show.html.erb within layouts/rails_db/application Rendered /root/projects/rails_db/app/views/rails_db/shared/_exp_col.html.erb (0.4ms)  (0.1ms)  SELECT sql FROM sqlite_master WHERE name='index_users_on_salary' AND type='index' UNION ALL SELECT sql FROM sqlite_temp_master WHERE name='index_users_on_salary' AND type='index'   (0.2ms)  SELECT sql FROM sqlite_master WHERE name='index_users_on_name' AND type='index' UNION ALL SELECT sql FROM sqlite_temp_master WHERE name='index_users_on_name' AND type='index'   (0.1ms)  SELECT sql FROM sqlite_master WHERE name='index_users_on_account_id' AND type='index' UNION ALL SELECT sql FROM sqlite_temp_master WHERE name='index_users_on_account_id' AND type='index'   (0.1ms)  SELECT sql FROM sqlite_master WHERE name='index_users_on_salary' AND type='index' UNION ALL SELECT sql FROM sqlite_temp_master WHERE name='index_users_on_salary' AND type='index'   (0.2ms)  SELECT sql FROM sqlite_master WHERE name='index_users_on_name' AND type='index' UNION ALL SELECT sql FROM sqlite_temp_master WHERE name='index_users_on_name' AND type='index'   (0.1ms)  SELECT sql FROM sqlite_master WHERE name='index_users_on_account_id' AND type='index' UNION ALL SELECT sql FROM sqlite_temp_master WHERE name='index_users_on_account_id' AND type='index'  Rendered /root/projects/rails_db/app/views/rails_db/tables/_show.html.erb (15.9ms) Rendered /root/projects/rails_db/app/views/rails_db/tables/show.html.erb within layouts/rails_db/application (16.7ms) Rendered /root/projects/rails_db/app/views/rails_db/shared/_header.html.erb (1.2ms) Rendered /root/projects/rails_db/app/views/rails_db/shared/_sidebar.html.erb (1.1ms) Rendered /root/projects/rails_db/app/views/rails_db/shared/_gems.html.erb (0.1ms) Rendered /root/projects/rails_db/app/views/rails_db/shared/_footer.html.erb (0.6ms) Completed 200 OK in 24ms (Views: 16.1ms | ActiveRecord: 6.7ms) Started GET "/rails/db/tables/users/data" for 127.0.0.1 at 2019-09-07 01:33:33 -0700 Processing by RailsDb::TablesController#data as HTML Parameters: {"table_id"=>"users"}  (0.1ms) SELECT COUNT(*) FROM "users" Rendering /root/projects/rails_db/app/views/rails_db/tables/data.html.erb within layouts/rails_db/application Rendered /root/projects/rails_db/app/views/rails_db/shared/_exp_col.html.erb (0.0ms) Rendered /root/projects/rails_db/app/views/rails_db/tables/_condition_fields.html.erb (40.5ms) Rendered /root/projects/rails_db/app/views/rails_db/tables/_condition_fields.html.erb (13.9ms)  Load (0.2ms) SELECT "users".* FROM "users" LIMIT ? OFFSET ? [["LIMIT", 30], ["OFFSET", 0]] Rendered /root/projects/rails_db/app/views/rails_db/tables/_row.html.erb (3.1ms) Rendered /root/projects/rails_db/app/views/rails_db/tables/_row.html.erb (2.2ms) Rendered /root/projects/rails_db/app/views/rails_db/tables/_row.html.erb (13.1ms) CACHE (0.0ms) SELECT COUNT(*) FROM "users" CACHE (0.0ms) SELECT COUNT(*) FROM "users" Rendered /root/projects/rails_db/app/views/rails_db/tables/_sql.html.erb (0.3ms) Rendered /root/projects/rails_db/app/views/rails_db/tables/_data.html.erb (120.5ms) Rendered /root/projects/rails_db/app/views/rails_db/tables/data.html.erb within layouts/rails_db/application (121.0ms) Rendered /root/projects/rails_db/app/views/rails_db/shared/_header.html.erb (0.8ms) Rendered /root/projects/rails_db/app/views/rails_db/shared/_sidebar.html.erb (0.7ms) Rendered /root/projects/rails_db/app/views/rails_db/shared/_gems.html.erb (0.1ms) Rendered /root/projects/rails_db/app/views/rails_db/shared/_footer.html.erb (0.5ms) Completed 200 OK in 132ms (Views: 120.6ms | ActiveRecord: 4.7ms) Started GET "/rails/db/sql" for 127.0.0.1 at 2019-09-07 01:33:33 -0700 Processing by RailsDb::SqlController#index as HTML Rendering /root/projects/rails_db/app/views/rails_db/sql/index.html.erb within layouts/rails_db/application Rendered /root/projects/rails_db/app/views/rails_db/shared/_exp_col.html.erb (0.0ms) Rendered /root/projects/rails_db/app/views/rails_db/sql/_history.html.erb (0.8ms) Rendered /root/projects/rails_db/app/views/rails_db/sql/index.html.erb within layouts/rails_db/application (8.6ms) Rendered /root/projects/rails_db/app/views/rails_db/shared/_header.html.erb (1.2ms) Rendered /root/projects/rails_db/app/views/rails_db/shared/_sidebar.html.erb (1.2ms) Rendered /root/projects/rails_db/app/views/rails_db/shared/_gems.html.erb (0.1ms) Rendered /root/projects/rails_db/app/views/rails_db/shared/_footer.html.erb (0.8ms) Completed 200 OK in 16ms (Views: 12.2ms | ActiveRecord: 2.9ms) Started GET "/rails/db/import" for 127.0.0.1 at 2019-09-07 01:33:33 -0700 Processing by RailsDb::SqlController#import as HTML Rendering /root/projects/rails_db/app/views/rails_db/sql/import.html.erb within layouts/rails_db/application Rendered /root/projects/rails_db/app/views/rails_db/sql/_import_sample.html.erb (0.2ms) Rendered /root/projects/rails_db/app/views/rails_db/sql/import.html.erb within layouts/rails_db/application (1.9ms) Rendered /root/projects/rails_db/app/views/rails_db/shared/_header.html.erb (1.1ms) Rendered /root/projects/rails_db/app/views/rails_db/shared/_sidebar.html.erb (1.1ms) Rendered /root/projects/rails_db/app/views/rails_db/shared/_gems.html.erb (0.1ms) Rendered /root/projects/rails_db/app/views/rails_db/shared/_footer.html.erb (0.7ms) Completed 200 OK in 8ms (Views: 6.8ms | ActiveRecord: 0.2ms) Started GET "/rails/db/data-table" for 127.0.0.1 at 2019-09-07 01:33:33 -0700 Processing by RailsDb::DashboardController#data_table as HTML Rendering /root/projects/rails_db/app/views/rails_db/dashboard/data_table.html.erb within layouts/rails_db/application Rendered /root/projects/rails_db/app/views/rails_db/dashboard/data_table.html.erb within layouts/rails_db/application (1.4ms) Rendered /root/projects/rails_db/app/views/rails_db/shared/_header.html.erb (1.2ms) Rendered /root/projects/rails_db/app/views/rails_db/shared/_sidebar.html.erb (1.0ms) Rendered /root/projects/rails_db/app/views/rails_db/shared/_gems.html.erb (0.1ms) Rendered /root/projects/rails_db/app/views/rails_db/shared/_footer.html.erb (0.7ms) Completed 200 OK in 7ms (Views: 6.2ms | ActiveRecord: 0.2ms) Started GET "/" for 127.0.0.1 at 2019-09-07 01:33:33 -0700 Processing by HomeController#index as HTML Rendering home/index.html.erb within layouts/application  (0.1ms) SELECT id, name, users_count FROM accounts ORDER BY users_count desc LIMIT 10 OFFSET 0 Rendered /root/projects/rails_db/app/views/rails_db/shared/_data_table.html.erb (1.3ms)  (0.1ms) select id, name, age from users order by age desc limit 10 Rendered /root/projects/rails_db/app/views/rails_db/shared/_sql_result.html.erb (0.9ms)  (0.1ms) SELECT COUNT(*) FROM "users"  (0.1ms) SELECT COUNT(*) FROM "users" WHERE "users"."type" IN ('Customer')  (0.1ms) SELECT COUNT(*) FROM "accounts" Rendered home/index.html.erb within layouts/application (10.9ms) Completed 200 OK in 14ms (Views: 13.0ms | ActiveRecord: 0.8ms) Started GET "/rails/db/tables/users/data?sort_column=id&sort_order=desc" for 127.0.0.1 at 2019-09-07 01:33:33 -0700 Processing by RailsDb::TablesController#data as HTML Parameters: {"sort_column"=>"id", "sort_order"=>"desc", "table_id"=>"users"}  (0.1ms) SELECT COUNT(*) FROM "users" Rendering /root/projects/rails_db/app/views/rails_db/tables/data.html.erb within layouts/rails_db/application Rendered /root/projects/rails_db/app/views/rails_db/shared/_exp_col.html.erb (0.0ms) Rendered /root/projects/rails_db/app/views/rails_db/tables/_condition_fields.html.erb (13.1ms) Rendered /root/projects/rails_db/app/views/rails_db/tables/_condition_fields.html.erb (12.9ms)  Load (0.2ms) SELECT "users".* FROM "users" LIMIT ? OFFSET ? [["LIMIT", 30], ["OFFSET", 0]] Rendered /root/projects/rails_db/app/views/rails_db/tables/_row.html.erb (2.2ms) Rendered /root/projects/rails_db/app/views/rails_db/tables/_row.html.erb (2.0ms) Rendered /root/projects/rails_db/app/views/rails_db/tables/_row.html.erb (2.0ms) CACHE (0.0ms) SELECT COUNT(*) FROM "users" CACHE (0.0ms) SELECT COUNT(*) FROM "users" Rendered /root/projects/rails_db/app/views/rails_db/tables/_sql.html.erb (0.0ms) Rendered /root/projects/rails_db/app/views/rails_db/tables/_data.html.erb (73.1ms) Rendered /root/projects/rails_db/app/views/rails_db/tables/data.html.erb within layouts/rails_db/application (73.3ms) Rendered /root/projects/rails_db/app/views/rails_db/shared/_header.html.erb (0.9ms) Rendered /root/projects/rails_db/app/views/rails_db/shared/_sidebar.html.erb (0.7ms) Rendered /root/projects/rails_db/app/views/rails_db/shared/_gems.html.erb (0.1ms) Rendered /root/projects/rails_db/app/views/rails_db/shared/_footer.html.erb (0.4ms) Completed 200 OK in 88ms (Views: 73.4ms | ActiveRecord: 4.3ms)  (0.0ms) SELECT COUNT(*) FROM "users" Started GET "/rails/db/tables/users/destroy?pk_id=1" for 127.0.0.1 at 2019-09-07 01:33:34 -0700 Processing by RailsDb::TablesController#destroy as HTML Parameters: {"pk_id"=>"1", "table_id"=>"users"}  (0.0ms) SELECT COUNT(*) FROM "users"  (0.0ms) DELETE FROM users WHERE id = '1'; Redirected to http://www.example.com/rails/db/tables/users/data Completed 302 Found in 6ms (ActiveRecord: 0.3ms)  (0.1ms) SELECT COUNT(*) FROM "users" Started GET "/rails/db/tables/users/csv" for 127.0.0.1 at 2019-09-07 01:33:34 -0700 Processing by RailsDb::TablesController#csv as HTML Parameters: {"table_id"=>"users"}  (0.1ms) SELECT * FROM users Rendering text template Rendered text template (0.0ms) Sent data users.csv (0.5ms) Completed 200 OK in 1ms (Views: 0.4ms | ActiveRecord: 0.3ms) Started GET "/rails/db/standalone" for 127.0.0.1 at 2019-09-07 01:33:34 -0700 Processing by RailsDb::DashboardController#standalone as HTML Rendering /root/projects/rails_db/app/views/rails_db/dashboard/standalone.html.erb within layouts/rails_db/application Rendered /root/projects/rails_db/app/views/rails_db/dashboard/standalone.html.erb within layouts/rails_db/application (1.5ms) Rendered /root/projects/rails_db/app/views/rails_db/shared/_header.html.erb (1.4ms) Rendered /root/projects/rails_db/app/views/rails_db/shared/_sidebar.html.erb (1.1ms) Rendered /root/projects/rails_db/app/views/rails_db/shared/_gems.html.erb (0.1ms) Rendered /root/projects/rails_db/app/views/rails_db/shared/_footer.html.erb (0.7ms) Completed 200 OK in 8ms (Views: 7.1ms | ActiveRecord: 0.2ms) Started GET "/rails/db/tables/users/xlsx.xls" for 127.0.0.1 at 2019-09-07 01:33:34 -0700 Processing by RailsDb::TablesController#xlsx as XLS Parameters: {"table_id"=>"users"} Rendering /root/projects/rails_db/app/views/rails_db/tables/table.xls.axlsx  (0.1ms) SELECT * FROM users Rendered /root/projects/rails_db/app/views/rails_db/tables/table.xls.axlsx (9.9ms) Rendering text template Rendered text template (0.0ms) Sent data users.xlsx (0.5ms) Completed 200 OK in 12ms (Views: 11.3ms | ActiveRecord: 0.5ms) Started GET "/rails/db/sql?sql=select+%2A+from+users+limit+10" for 127.0.0.1 at 2019-09-07 01:33:34 -0700 Processing by RailsDb::SqlController#index as HTML Parameters: {"sql"=>"select * from users limit 10"}  (0.1ms) select * from users limit 10  (0.2ms) EXPLAIN select * from users limit 10 Rendering /root/projects/rails_db/app/views/rails_db/sql/index.html.erb within layouts/rails_db/application Rendered /root/projects/rails_db/app/views/rails_db/shared/_exp_col.html.erb (0.0ms) Rendered /root/projects/rails_db/app/views/rails_db/sql/_history.html.erb (0.5ms) Rendered /root/projects/rails_db/app/views/rails_db/sql/_explain.html.erb (0.6ms) Rendered /root/projects/rails_db/app/views/rails_db/sql/_results.html.erb (2.6ms) Rendered /root/projects/rails_db/app/views/rails_db/sql/index.html.erb within layouts/rails_db/application (11.0ms) Rendered /root/projects/rails_db/app/views/rails_db/shared/_header.html.erb (1.2ms) Rendered /root/projects/rails_db/app/views/rails_db/shared/_sidebar.html.erb (1.0ms) Rendered /root/projects/rails_db/app/views/rails_db/shared/_gems.html.erb (0.1ms) Rendered /root/projects/rails_db/app/views/rails_db/shared/_footer.html.erb (0.8ms) Completed 200 OK in 17ms (Views: 13.1ms | ActiveRecord: 3.4ms) Started POST "/rails/db/sql-csv.csv?sql=select+%2A+from+users+limit+10" for 127.0.0.1 at 2019-09-07 01:33:34 -0700 Processing by RailsDb::SqlController#csv as CSV Parameters: {"sql"=>"select * from users limit 10"}  (0.1ms) select * from users limit 10  (0.2ms) EXPLAIN select * from users limit 10 Rendering text template Rendered text template (0.0ms) Sent data results.csv (0.4ms) Completed 200 OK in 1ms (Views: 0.3ms | ActiveRecord: 0.3ms) Started POST "/rails/db/sql-xls.xls?sql=select+%2A+from+users+limit+10" for 127.0.0.1 at 2019-09-07 01:33:34 -0700 Processing by RailsDb::SqlController#xls as XLS Parameters: {"sql"=>"select * from users limit 10"}  (0.2ms) select * from users limit 10  (0.1ms) EXPLAIN select * from users limit 10 Rendering /root/projects/rails_db/app/views/rails_db/sql/xls.xls.axlsx Rendered /root/projects/rails_db/app/views/rails_db/sql/xls.xls.axlsx (7.0ms) Rendering text template Rendered text template (0.0ms) Sent data results.xlsx (0.4ms) Completed 200 OK in 9ms (Views: 8.4ms | ActiveRecord: 0.3ms) Started GET "/rails/db/tables/users/edit?pk_id=2" for 127.0.0.1 at 2019-09-07 01:33:34 -0700 Processing by RailsDb::TablesController#edit as JS Parameters: {"pk_id"=>"2", "table_id"=>"users"}  (0.1ms) SELECT COUNT(*) FROM "users"  Load (0.2ms) SELECT "users".* FROM "users" WHERE "users"."id" = ? LIMIT ? [["id", 2], ["LIMIT", 1]] Rendering /root/projects/rails_db/app/views/rails_db/tables/edit.js.erb Rendered /root/projects/rails_db/app/views/rails_db/tables/_edit.html.erb (24.2ms) Rendered /root/projects/rails_db/app/views/rails_db/tables/edit.js.erb (27.7ms) Completed 200 OK in 48ms (Views: 26.7ms | ActiveRecord: 3.0ms) Started PUT "/rails/db/tables/users/update?pk_id=2" for 127.0.0.1 at 2019-09-07 01:33:34 -0700 Processing by RailsDb::TablesController#update as JS Parameters: {"record"=>{"name"=>"JOHN"}, "pk_id"=>"2", "table_id"=>"users"}  (0.1ms) SELECT COUNT(*) FROM "users"  Load (0.1ms) SELECT "users".* FROM "users" WHERE "users"."id" = ? LIMIT ? [["id", 2], ["LIMIT", 1]]  (0.1ms) SAVEPOINT active_record_1 SQL (0.1ms) UPDATE "users" SET "name" = ?, "updated_at" = ? WHERE "users"."id" = ? [["name", "JOHN"], ["updated_at", "2019-09-07 08:33:34.216184"], ["id", 2]]  (0.0ms) RELEASE SAVEPOINT active_record_1 Rendering /root/projects/rails_db/app/views/rails_db/tables/update.js.erb Rendered /root/projects/rails_db/app/views/rails_db/tables/_row.html.erb (3.0ms) Rendered /root/projects/rails_db/app/views/rails_db/tables/update.js.erb (4.6ms) Completed 200 OK in 24ms (Views: 3.8ms | ActiveRecord: 1.8ms) User Load (0.0ms) SELECT "users".* FROM "users" WHERE "users"."id" = ? LIMIT ? [["id", 2], ["LIMIT", 1]] Started GET "/rails/db/tables/users/new" for 127.0.0.1 at 2019-09-07 01:33:34 -0700 Processing by RailsDb::TablesController#new as JS Parameters: {"table_id"=>"users"}  (0.1ms) SELECT COUNT(*) FROM "users" Rendering /root/projects/rails_db/app/views/rails_db/tables/new.js.erb Rendered /root/projects/rails_db/app/views/rails_db/tables/_new.html.erb (11.4ms) Rendered /root/projects/rails_db/app/views/rails_db/tables/new.js.erb (15.9ms) Completed 200 OK in 33ms (Views: 13.7ms | ActiveRecord: 2.8ms)  (0.1ms) SELECT COUNT(*) FROM "users" Started POST "/rails/db/tables/users/create" for 127.0.0.1 at 2019-09-07 01:33:34 -0700 Processing by RailsDb::TablesController#create as JS Parameters: {"record"=>{"name"=>"XXX"}, "table_id"=>"users"}  (0.1ms) SELECT COUNT(*) FROM "users"  (0.1ms) SAVEPOINT active_record_1 SQL (0.1ms) INSERT INTO "users" ("name", "created_at", "updated_at") VALUES (?, ?, ?) [["name", "XXX"], ["created_at", "2019-09-07 08:33:34.276564"], ["updated_at", "2019-09-07 08:33:34.276564"]]  (0.0ms) RELEASE SAVEPOINT active_record_1 Rendering /root/projects/rails_db/app/views/rails_db/tables/create.js.erb Rendered /root/projects/rails_db/app/views/rails_db/shared/_exp_col.html.erb (0.3ms) Rendered /root/projects/rails_db/app/views/rails_db/tables/_condition_fields.html.erb (34.2ms) Rendered /root/projects/rails_db/app/views/rails_db/tables/_condition_fields.html.erb (13.1ms)  Load (0.2ms) SELECT "users".* FROM "users" LIMIT ? OFFSET ? [["LIMIT", 30], ["OFFSET", 0]] Rendered /root/projects/rails_db/app/views/rails_db/tables/_row.html.erb (2.3ms) Rendered /root/projects/rails_db/app/views/rails_db/tables/_row.html.erb (2.1ms) Rendered /root/projects/rails_db/app/views/rails_db/tables/_row.html.erb (2.0ms)  (0.1ms) SELECT COUNT(*) FROM "users" CACHE (0.0ms) SELECT COUNT(*) FROM "users" Rendered /root/projects/rails_db/app/views/rails_db/tables/_sql.html.erb (0.4ms) Rendered /root/projects/rails_db/app/views/rails_db/tables/_data.html.erb (94.0ms) Rendered /root/projects/rails_db/app/views/rails_db/tables/create.js.erb (97.4ms) Completed 200 OK in 122ms (Views: 93.7ms | ActiveRecord: 4.7ms)  (0.1ms) SELECT COUNT(*) FROM "users" Started GET "/rails/db/tables/users/edit?pk_id=3" for 127.0.0.1 at 2019-09-07 01:33:34 -0700 Processing by RailsDb::TablesController#edit as JS Parameters: {"pk_id"=>"3", "table_id"=>"users"}  (0.1ms) SELECT COUNT(*) FROM "users"  Load (0.1ms) SELECT "users".* FROM "users" WHERE "users"."id" = ? LIMIT ? [["id", 3], ["LIMIT", 1]] Rendering /root/projects/rails_db/app/views/rails_db/tables/edit.js.erb Rendered /root/projects/rails_db/app/views/rails_db/tables/_edit.html.erb (15.4ms) Rendered /root/projects/rails_db/app/views/rails_db/tables/edit.js.erb (18.1ms) Completed 200 OK in 37ms (Views: 16.0ms | ActiveRecord: 2.9ms) Started PUT "/rails/db/tables/users/update?pk_id=3" for 127.0.0.1 at 2019-09-07 01:33:34 -0700 Processing by RailsDb::TablesController#update as JS Parameters: {"record"=>{"name"=>"STI"}, "pk_id"=>"3", "table_id"=>"users"}  (0.1ms) SELECT COUNT(*) FROM "users"  Load (0.1ms) SELECT "users".* FROM "users" WHERE "users"."id" = ? LIMIT ? [["id", 3], ["LIMIT", 1]]  (0.1ms) SAVEPOINT active_record_1 SQL (0.1ms) UPDATE "users" SET "name" = ?, "updated_at" = ? WHERE "users"."id" = ? [["name", "STI"], ["updated_at", "2019-09-07 08:33:34.434316"], ["id", 3]]  (0.0ms) RELEASE SAVEPOINT active_record_1 Rendering /root/projects/rails_db/app/views/rails_db/tables/update.js.erb Rendered /root/projects/rails_db/app/views/rails_db/tables/_row.html.erb (1.5ms) Rendered /root/projects/rails_db/app/views/rails_db/tables/update.js.erb (2.0ms) Completed 200 OK in 14ms (Views: 1.4ms | ActiveRecord: 1.2ms) Customer Load (0.1ms) SELECT "users".* FROM "users" WHERE "users"."type" IN ('Customer') AND "users"."id" = ? LIMIT ? [["id", 3], ["LIMIT", 1]] Started GET "/admin/tools/db" for 127.0.0.1 at 2019-09-07 01:33:34 -0700 Processing by RailsDb::DashboardController#index as HTML Rendering /root/projects/rails_db/app/views/rails_db/dashboard/index.html.erb within layouts/rails_db/application Rendered /root/projects/rails_db/app/views/rails_db/dashboard/index.html.erb within layouts/rails_db/application (0.3ms) Rendered /root/projects/rails_db/app/views/rails_db/shared/_header.html.erb (0.7ms) Rendered /root/projects/rails_db/app/views/rails_db/shared/_sidebar.html.erb (0.6ms) Rendered /root/projects/rails_db/app/views/rails_db/shared/_gems.html.erb (0.0ms) Rendered /root/projects/rails_db/app/views/rails_db/shared/_footer.html.erb (0.4ms) Completed 200 OK in 4ms (Views: 3.3ms | ActiveRecord: 0.1ms) Started GET "/admin/tools/db/sql" for 127.0.0.1 at 2019-09-07 01:33:34 -0700 Processing by RailsDb::SqlController#index as HTML Rendering /root/projects/rails_db/app/views/rails_db/sql/index.html.erb within layouts/rails_db/application Rendered /root/projects/rails_db/app/views/rails_db/shared/_exp_col.html.erb (0.0ms) Rendered /root/projects/rails_db/app/views/rails_db/sql/_history.html.erb (0.3ms) Rendered /root/projects/rails_db/app/views/rails_db/sql/index.html.erb within layouts/rails_db/application (3.8ms) Rendered /root/projects/rails_db/app/views/rails_db/shared/_header.html.erb (0.8ms) Rendered /root/projects/rails_db/app/views/rails_db/shared/_sidebar.html.erb (0.6ms) Rendered /root/projects/rails_db/app/views/rails_db/shared/_gems.html.erb (0.0ms) Rendered /root/projects/rails_db/app/views/rails_db/shared/_footer.html.erb (0.4ms) Completed 200 OK in 7ms (Views: 5.3ms | ActiveRecord: 1.7ms)  (0.1ms) rollback transaction  (0.1ms) begin transaction ---------------------- TableTest: test_delete ---------------------- SQL (0.1ms) DELETE FROM "users"  (0.0ms) SAVEPOINT active_record_1 SQL (0.7ms) INSERT INTO "users" ("name", "created_at", "updated_at") VALUES (?, ?, ?) [["name", "igor"], ["created_at", "2019-09-07 08:33:34.454238"], ["updated_at", "2019-09-07 08:33:34.454238"]]  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_1 SQL (0.1ms) INSERT INTO "users" ("name", "created_at", "updated_at") VALUES (?, ?, ?) [["name", "john"], ["created_at", "2019-09-07 08:33:34.456145"], ["updated_at", "2019-09-07 08:33:34.456145"]]  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SELECT COUNT(*) FROM "users"  (0.1ms) DELETE FROM users WHERE id = 1;  (0.1ms) SELECT COUNT(*) FROM "users"  (0.1ms) SELECT COUNT(*) FROM "users" WHERE "users"."name" = ? [["name", "igor"]]  (0.1ms) SELECT COUNT(*) FROM "users" WHERE "users"."name" = ? [["name", "john"]]  (0.1ms) rollback transaction  (0.0ms) begin transaction --------------------------- TableTest: test_primary_key ---------------------------  (0.0ms) rollback transaction  (0.0ms) begin transaction ------------------------ TableTest: test_as_table ------------------------ SQL (0.1ms) DELETE FROM "users"  (0.0ms) SAVEPOINT active_record_1 SQL (0.2ms) INSERT INTO "users" ("name", "created_at", "updated_at") VALUES (?, ?, ?) [["name", "igor"], ["created_at", "2019-09-07 08:33:34.462221"], ["updated_at", "2019-09-07 08:33:34.462221"]]  (0.0ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SELECT COUNT(*) FROM "users"  Load (0.2ms) SELECT "users".* FROM "users" ORDER BY "users"."id" ASC LIMIT ? [["LIMIT", 1]]  (0.2ms) rollback transaction  (0.0ms) begin transaction ----------------------- TableTest: test_columns -----------------------  (0.0ms) rollback transaction  (0.0ms) begin transaction ---------------------- TableTest: test_to_csv ----------------------  (0.0ms) SAVEPOINT active_record_1 SQL (0.1ms) INSERT INTO "users" ("name", "created_at", "updated_at") VALUES (?, ?, ?) [["name", "igor"], ["created_at", "2019-09-07 08:33:34.480607"], ["updated_at", "2019-09-07 08:33:34.480607"]]  (0.0ms) RELEASE SAVEPOINT active_record_1  (0.2ms) SELECT * FROM users  (0.1ms) rollback transaction  (0.1ms) begin transaction ------------------------ TableTest: test_truncate ------------------------ SQL (0.1ms) DELETE FROM "users"  (0.0ms) SAVEPOINT active_record_1 SQL (0.1ms) INSERT INTO "users" ("name", "created_at", "updated_at") VALUES (?, ?, ?) [["name", "igor"], ["created_at", "2019-09-07 08:33:34.482923"], ["updated_at", "2019-09-07 08:33:34.482923"]]  (0.0ms) RELEASE SAVEPOINT active_record_1  (0.0ms) SELECT COUNT(*) FROM "users"  (0.0ms) DELETE FROM users;  (0.0ms) SELECT COUNT(*) FROM "users"  (0.1ms) rollback transaction  (0.0ms) begin transaction ---------------------------------------------------------------------- RailsDbDataTableHelperTest: test_default_rails_db_data_table_sql_works ----------------------------------------------------------------------  (0.0ms) SAVEPOINT active_record_1 SQL (0.3ms) INSERT INTO "users" ("name", "created_at", "updated_at") VALUES (?, ?, ?) [["name", "Igor"], ["created_at", "2019-09-07 08:33:34.485730"], ["updated_at", "2019-09-07 08:33:34.485730"]]  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.1ms) select * from users Rendered /root/projects/rails_db/app/views/rails_db/shared/_sql_result.html.erb (1.1ms)  (0.1ms) rollback transaction  (0.0ms) begin transaction ------------------------------------------------------------------ RailsDbDataTableHelperTest: test_default_rails_db_data_table_works ------------------------------------------------------------------  (0.1ms) SAVEPOINT active_record_1 SQL (0.2ms) INSERT INTO "users" ("name", "created_at", "updated_at") VALUES (?, ?, ?) [["name", "Igor"], ["created_at", "2019-09-07 08:33:34.494003"], ["updated_at", "2019-09-07 08:33:34.494003"]]  (0.0ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SELECT * FROM users Rendered /root/projects/rails_db/app/views/rails_db/shared/_data_table.html.erb (2.3ms)  (0.1ms) rollback transaction  (0.1ms) begin transaction -------------------------------------------------------------------------------- RailsDbDataTableHelperTest: test_rails_db_data_table_sql_works_with_many_options --------------------------------------------------------------------------------  (0.1ms) SAVEPOINT active_record_1 SQL (0.2ms) INSERT INTO "users" ("name", "created_at", "updated_at") VALUES (?, ?, ?) [["name", "Igor"], ["created_at", "2019-09-07 08:33:34.503719"], ["updated_at", "2019-09-07 08:33:34.503719"]]  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.2ms) select * from users Rendered /root/projects/rails_db/app/views/rails_db/shared/_sql_result.html.erb (0.2ms)  (0.1ms) rollback transaction  (0.0ms) begin transaction ---------------------------------------------------------------------------- RailsDbDataTableHelperTest: test_rails_db_data_table_works_with_many_options ----------------------------------------------------------------------------  (0.0ms) SAVEPOINT active_record_1 SQL (0.1ms) INSERT INTO "users" ("name", "age", "created_at", "updated_at") VALUES (?, ?, ?, ?) [["name", "Igor"], ["age", 9999], ["created_at", "2019-09-07 08:33:34.506962"], ["updated_at", "2019-09-07 08:33:34.506962"]]  (0.0ms) RELEASE SAVEPOINT active_record_1  (0.0ms) SELECT id, name FROM users ORDER BY id asc LIMIT 10 OFFSET 0 Rendered /root/projects/rails_db/app/views/rails_db/shared/_data_table.html.erb (0.2ms)  (0.1ms) rollback transaction  (0.0ms) begin transaction ------------------------------------ RailsDbTest: test_verify_access_proc ------------------------------------  (0.0ms) rollback transaction  (0.0ms) begin transaction ----------------------- RailsDbTest: test_truth -----------------------  (0.0ms) rollback transaction  (0.0ms) begin transaction -------------------------- SqlImportTest: test_import --------------------------  (0.0ms) update users set age = 11 where id = 1  (0.0ms) update users set age = 22 where id = 2  (0.0ms) update users set age = 33 where id = 3  (0.2ms)  CREATE TABLE t(x INTEGER, y, z, PRIMARY KEY(x ASC));  (0.1ms) rollback transaction  (0.0ms) begin transaction ---------------------------------------------------------------------------------------------------------------------------- TablesHelperTest: test_method_display_style_column_returns_'display'_if_cookie_does_not_contain_record_for_this_table:column ----------------------------------------------------------------------------------------------------------------------------  (0.1ms) rollback transaction  (0.0ms) begin transaction ------------------------------------------------------------------------------------------------------------------------- TablesHelperTest: test_method_display_style_column_returns_'display:none'_if_cookie_contains_record_for_this_table:column -------------------------------------------------------------------------------------------------------------------------  (0.0ms) rollback transaction  (0.0ms) begin transaction ---------------------------------------------------------------------------------------------------------------------------------- TablesHelperTest: test_method_column_is_checked?_returns_false_for_checkbox_status_if_cookie_contains_record_for_this_table:column ----------------------------------------------------------------------------------------------------------------------------------  (0.0ms) rollback transaction  (0.0ms) begin transaction ------------------------------------------------------------------------------------------------------------------------------------ TablesHelperTest: test_method_column_is_checked?_returns_true_for_checkbox_status_if_cookie_does_not_contain_hash_key_for_this_table ------------------------------------------------------------------------------------------------------------------------------------  (0.0ms) rollback transaction  (0.0ms) begin transaction ----------------------------------------------------------------------------------------------------------------------------------------- TablesHelperTest: test_method_column_is_checked?_returns_true_for_checkbox_status_if_cookie_does_not_contain_record_for_this_table:column -----------------------------------------------------------------------------------------------------------------------------------------  (0.0ms) rollback transaction  (0.1ms) SELECT "schema_migrations"."version" FROM "schema_migrations" ORDER BY "schema_migrations"."version" ASC  (0.1ms) begin transaction ------------------------- DatabaseTest: test_tables -------------------------  (0.0ms) rollback transaction  (0.0ms) begin transaction ------------------------------------ DatabaseTest: test_accessible_tables ------------------------------------  (0.0ms) rollback transaction  (0.0ms) begin transaction ------------------------- DatabaseTest: test_insert -------------------------  (0.1ms) delete from projects_users  (0.1ms) EXPLAIN delete from projects_users SQL (0.1ms) DELETE FROM "users"  (0.1ms) SELECT COUNT(*) FROM projects_users  (0.1ms) insert into projects_users(project_id, user_id) values(1,2)  (0.3ms) EXPLAIN insert into projects_users(project_id, user_id) values(1,2)  (0.1ms) SELECT COUNT(*) FROM projects_users  (0.1ms) rollback transaction  (0.0ms) begin transaction -------------------------- DatabaseTest: test_adapter --------------------------  (0.0ms) rollback transaction  (0.1ms) begin transaction ------------------------ DatabaseTest: test_query ------------------------ SQL (0.2ms) DELETE FROM "users"  (0.1ms) SAVEPOINT active_record_1 SQL (0.5ms) INSERT INTO "users" ("name", "created_at", "updated_at") VALUES (?, ?, ?) [["name", "Igor"], ["created_at", "2019-09-07 08:35:31.695926"], ["updated_at", "2019-09-07 08:35:31.695926"]]  (0.0ms) RELEASE SAVEPOINT active_record_1  (0.1ms) select count(*) as users_count from users  (0.1ms) EXPLAIN select count(*) as users_count from users  (0.1ms) rollback transaction  (0.0ms) begin transaction ------------------------------------ RailsDbTest: test_verify_access_proc ------------------------------------  (0.0ms) rollback transaction  (0.1ms) begin transaction ----------------------- RailsDbTest: test_truth -----------------------  (0.1ms) rollback transaction  (0.1ms) begin transaction -------------------------- SqlImportTest: test_import --------------------------  (0.2ms) update users set age = 11 where id = 1  (0.1ms) update users set age = 22 where id = 2  (0.0ms) update users set age = 33 where id = 3  (0.2ms)  CREATE TABLE t(x INTEGER, y, z, PRIMARY KEY(x ASC));  (0.1ms) rollback transaction  (0.1ms) begin transaction ------------------------------------------------------------------------------------------------------------------------- TablesHelperTest: test_method_display_style_column_returns_'display:none'_if_cookie_contains_record_for_this_table:column -------------------------------------------------------------------------------------------------------------------------  (0.1ms) rollback transaction  (0.0ms) begin transaction ------------------------------------------------------------------------------------------------------------------------------------ TablesHelperTest: test_method_column_is_checked?_returns_true_for_checkbox_status_if_cookie_does_not_contain_hash_key_for_this_table ------------------------------------------------------------------------------------------------------------------------------------  (0.1ms) rollback transaction  (0.1ms) begin transaction ----------------------------------------------------------------------------------------------------------------------------------------- TablesHelperTest: test_method_column_is_checked?_returns_true_for_checkbox_status_if_cookie_does_not_contain_record_for_this_table:column -----------------------------------------------------------------------------------------------------------------------------------------  (0.1ms) rollback transaction  (0.0ms) begin transaction ---------------------------------------------------------------------------------------------------------------------------------- TablesHelperTest: test_method_column_is_checked?_returns_false_for_checkbox_status_if_cookie_contains_record_for_this_table:column ----------------------------------------------------------------------------------------------------------------------------------  (0.0ms) rollback transaction  (0.2ms) begin transaction ---------------------------------------------------------------------------------------------------------------------------- TablesHelperTest: test_method_display_style_column_returns_'display'_if_cookie_does_not_contain_record_for_this_table:column ----------------------------------------------------------------------------------------------------------------------------  (0.1ms) rollback transaction  (0.0ms) begin transaction ---------------------- TableTest: test_delete ---------------------- SQL (0.1ms) DELETE FROM "users"  (0.0ms) SAVEPOINT active_record_1 SQL (0.2ms) INSERT INTO "users" ("name", "created_at", "updated_at") VALUES (?, ?, ?) [["name", "igor"], ["created_at", "2019-09-07 08:35:31.712017"], ["updated_at", "2019-09-07 08:35:31.712017"]]  (0.0ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_1 SQL (0.2ms) INSERT INTO "users" ("name", "created_at", "updated_at") VALUES (?, ?, ?) [["name", "john"], ["created_at", "2019-09-07 08:35:31.714157"], ["updated_at", "2019-09-07 08:35:31.714157"]]  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.2ms) SELECT COUNT(*) FROM "users"  (0.1ms) DELETE FROM users WHERE id = 1;  (0.1ms) SELECT COUNT(*) FROM "users"  (0.1ms) SELECT COUNT(*) FROM "users" WHERE "users"."name" = ? [["name", "igor"]]  (0.1ms) SELECT COUNT(*) FROM "users" WHERE "users"."name" = ? [["name", "john"]]  (0.1ms) rollback transaction  (0.0ms) begin transaction --------------------------- TableTest: test_primary_key ---------------------------  (0.0ms) rollback transaction  (0.0ms) begin transaction ------------------------ TableTest: test_as_table ------------------------ SQL (0.1ms) DELETE FROM "users"  (0.0ms) SAVEPOINT active_record_1 SQL (0.2ms) INSERT INTO "users" ("name", "created_at", "updated_at") VALUES (?, ?, ?) [["name", "igor"], ["created_at", "2019-09-07 08:35:31.722364"], ["updated_at", "2019-09-07 08:35:31.722364"]]  (0.0ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SELECT COUNT(*) FROM "users"  Load (0.1ms) SELECT "users".* FROM "users" ORDER BY "users"."id" ASC LIMIT ? [["LIMIT", 1]]  (0.1ms) rollback transaction  (0.0ms) begin transaction ----------------------- TableTest: test_columns -----------------------  (0.0ms) rollback transaction  (0.0ms) begin transaction ---------------------- TableTest: test_to_csv ----------------------  (0.1ms) SAVEPOINT active_record_1 SQL (0.2ms) INSERT INTO "users" ("name", "created_at", "updated_at") VALUES (?, ?, ?) [["name", "igor"], ["created_at", "2019-09-07 08:35:31.743939"], ["updated_at", "2019-09-07 08:35:31.743939"]]  (0.0ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SELECT * FROM users  (0.1ms) rollback transaction  (0.0ms) begin transaction ------------------------ TableTest: test_truncate ------------------------ SQL (0.1ms) DELETE FROM "users"  (0.0ms) SAVEPOINT active_record_1 SQL (0.2ms) INSERT INTO "users" ("name", "created_at", "updated_at") VALUES (?, ?, ?) [["name", "igor"], ["created_at", "2019-09-07 08:35:31.747250"], ["updated_at", "2019-09-07 08:35:31.747250"]]  (0.0ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SELECT COUNT(*) FROM "users"  (0.0ms) DELETE FROM users;  (0.1ms) SELECT COUNT(*) FROM "users"  (0.1ms) rollback transaction  (0.1ms) begin transaction ---------------------------------------------- DashboardControllerTest: test_should_get_index ---------------------------------------------- SQL (0.2ms) DELETE FROM "users" SQL (0.1ms) DELETE FROM "accounts" SQL (0.1ms) DELETE FROM "users" WHERE "users"."type" IN ('Customer')  (0.0ms) SAVEPOINT active_record_1 SQL (0.1ms) INSERT INTO "users" ("name", "created_at", "updated_at") VALUES (?, ?, ?) [["name", "Igor"], ["created_at", "2019-09-07 08:35:31.832393"], ["updated_at", "2019-09-07 08:35:31.832393"]]  (0.0ms) RELEASE SAVEPOINT active_record_1  (0.0ms) SAVEPOINT active_record_1 SQL (0.1ms) INSERT INTO "users" ("name", "created_at", "updated_at") VALUES (?, ?, ?) [["name", "Edit"], ["created_at", "2019-09-07 08:35:31.833252"], ["updated_at", "2019-09-07 08:35:31.833252"]]  (0.0ms) RELEASE SAVEPOINT active_record_1  (0.0ms) SAVEPOINT active_record_1 SQL (0.1ms) INSERT INTO "users" ("name", "bio", "created_at", "updated_at", "type") VALUES (?, ?, ?, ?, ?) [["name", "Customer 1"], ["bio", "this is bio text"], ["created_at", "2019-09-07 08:35:31.839301"], ["updated_at", "2019-09-07 08:35:31.839301"], ["type", "Customer"]]  (0.0ms) RELEASE SAVEPOINT active_record_1 Started GET "/rails/db" for 127.0.0.1 at 2019-09-07 01:35:31 -0700 Processing by RailsDb::DashboardController#index as HTML Rendering /root/projects/rails_db/app/views/rails_db/dashboard/index.html.erb within layouts/rails_db/application Rendered /root/projects/rails_db/app/views/rails_db/dashboard/index.html.erb within layouts/rails_db/application (449.5ms) Rendered /root/projects/rails_db/app/views/rails_db/shared/_header.html.erb (3.3ms) Rendered /root/projects/rails_db/app/views/rails_db/shared/_sidebar.html.erb (1.5ms) Rendered /root/projects/rails_db/app/views/rails_db/shared/_gems.html.erb (0.5ms) Rendered /root/projects/rails_db/app/views/rails_db/shared/_footer.html.erb (2.2ms) Completed 200 OK in 468ms (Views: 467.0ms | ActiveRecord: 0.2ms) Started GET "/rails/db/tables/users" for 127.0.0.1 at 2019-09-07 01:35:32 -0700 Processing by RailsDb::TablesController#show as HTML Parameters: {"id"=>"users"} Rendering /root/projects/rails_db/app/views/rails_db/tables/show.html.erb within layouts/rails_db/application Rendered /root/projects/rails_db/app/views/rails_db/shared/_exp_col.html.erb (0.3ms)  (0.1ms)  SELECT sql FROM sqlite_master WHERE name='index_users_on_salary' AND type='index' UNION ALL SELECT sql FROM sqlite_temp_master WHERE name='index_users_on_salary' AND type='index'   (0.1ms)  SELECT sql FROM sqlite_master WHERE name='index_users_on_name' AND type='index' UNION ALL SELECT sql FROM sqlite_temp_master WHERE name='index_users_on_name' AND type='index'   (0.1ms)  SELECT sql FROM sqlite_master WHERE name='index_users_on_account_id' AND type='index' UNION ALL SELECT sql FROM sqlite_temp_master WHERE name='index_users_on_account_id' AND type='index'   (0.1ms)  SELECT sql FROM sqlite_master WHERE name='index_users_on_salary' AND type='index' UNION ALL SELECT sql FROM sqlite_temp_master WHERE name='index_users_on_salary' AND type='index'   (0.1ms)  SELECT sql FROM sqlite_master WHERE name='index_users_on_name' AND type='index' UNION ALL SELECT sql FROM sqlite_temp_master WHERE name='index_users_on_name' AND type='index'   (0.1ms)  SELECT sql FROM sqlite_master WHERE name='index_users_on_account_id' AND type='index' UNION ALL SELECT sql FROM sqlite_temp_master WHERE name='index_users_on_account_id' AND type='index'  Rendered /root/projects/rails_db/app/views/rails_db/tables/_show.html.erb (14.1ms) Rendered /root/projects/rails_db/app/views/rails_db/tables/show.html.erb within layouts/rails_db/application (14.8ms) Rendered /root/projects/rails_db/app/views/rails_db/shared/_header.html.erb (1.1ms) Rendered /root/projects/rails_db/app/views/rails_db/shared/_sidebar.html.erb (1.1ms) Rendered /root/projects/rails_db/app/views/rails_db/shared/_gems.html.erb (0.1ms) Rendered /root/projects/rails_db/app/views/rails_db/shared/_footer.html.erb (0.7ms) Completed 200 OK in 21ms (Views: 14.3ms | ActiveRecord: 6.2ms) Started GET "/rails/db/tables/users/data" for 127.0.0.1 at 2019-09-07 01:35:32 -0700 Processing by RailsDb::TablesController#data as HTML Parameters: {"table_id"=>"users"}  (0.1ms) SELECT COUNT(*) FROM "users" Rendering /root/projects/rails_db/app/views/rails_db/tables/data.html.erb within layouts/rails_db/application Rendered /root/projects/rails_db/app/views/rails_db/shared/_exp_col.html.erb (0.0ms) Rendered /root/projects/rails_db/app/views/rails_db/tables/_condition_fields.html.erb (45.9ms) Rendered /root/projects/rails_db/app/views/rails_db/tables/_condition_fields.html.erb (12.8ms)  Load (0.1ms) SELECT "users".* FROM "users" LIMIT ? OFFSET ? [["LIMIT", 30], ["OFFSET", 0]] Rendered /root/projects/rails_db/app/views/rails_db/tables/_row.html.erb (4.1ms) Rendered /root/projects/rails_db/app/views/rails_db/tables/_row.html.erb (8.0ms) Rendered /root/projects/rails_db/app/views/rails_db/tables/_row.html.erb (3.3ms) CACHE (0.0ms) SELECT COUNT(*) FROM "users" CACHE (0.0ms) SELECT COUNT(*) FROM "users" Rendered /root/projects/rails_db/app/views/rails_db/tables/_sql.html.erb (0.3ms) Rendered /root/projects/rails_db/app/views/rails_db/tables/_data.html.erb (110.5ms) Rendered /root/projects/rails_db/app/views/rails_db/tables/data.html.erb within layouts/rails_db/application (111.6ms) Rendered /root/projects/rails_db/app/views/rails_db/shared/_header.html.erb (1.7ms) Rendered /root/projects/rails_db/app/views/rails_db/shared/_sidebar.html.erb (1.4ms) Rendered /root/projects/rails_db/app/views/rails_db/shared/_gems.html.erb (0.5ms) Rendered /root/projects/rails_db/app/views/rails_db/shared/_footer.html.erb (1.6ms) Completed 200 OK in 129ms (Views: 113.8ms | ActiveRecord: 5.6ms) Started GET "/rails/db/sql" for 127.0.0.1 at 2019-09-07 01:35:32 -0700 Processing by RailsDb::SqlController#index as HTML Rendering /root/projects/rails_db/app/views/rails_db/sql/index.html.erb within layouts/rails_db/application Rendered /root/projects/rails_db/app/views/rails_db/shared/_exp_col.html.erb (0.0ms) Rendered /root/projects/rails_db/app/views/rails_db/sql/_history.html.erb (1.1ms) Rendered /root/projects/rails_db/app/views/rails_db/sql/index.html.erb within layouts/rails_db/application (14.3ms) Rendered /root/projects/rails_db/app/views/rails_db/shared/_header.html.erb (1.8ms) Rendered /root/projects/rails_db/app/views/rails_db/shared/_sidebar.html.erb (2.0ms) Rendered /root/projects/rails_db/app/views/rails_db/shared/_gems.html.erb (1.7ms) Rendered /root/projects/rails_db/app/views/rails_db/shared/_footer.html.erb (3.6ms) Completed 200 OK in 27ms (Views: 21.0ms | ActiveRecord: 5.1ms) Started GET "/rails/db/import" for 127.0.0.1 at 2019-09-07 01:35:32 -0700 Processing by RailsDb::SqlController#import as HTML Rendering /root/projects/rails_db/app/views/rails_db/sql/import.html.erb within layouts/rails_db/application Rendered /root/projects/rails_db/app/views/rails_db/sql/_import_sample.html.erb (0.2ms) Rendered /root/projects/rails_db/app/views/rails_db/sql/import.html.erb within layouts/rails_db/application (2.7ms) Rendered /root/projects/rails_db/app/views/rails_db/shared/_header.html.erb (2.7ms) Rendered /root/projects/rails_db/app/views/rails_db/shared/_sidebar.html.erb (2.4ms) Rendered /root/projects/rails_db/app/views/rails_db/shared/_gems.html.erb (0.1ms) Rendered /root/projects/rails_db/app/views/rails_db/shared/_footer.html.erb (1.6ms) Completed 200 OK in 13ms (Views: 12.5ms | ActiveRecord: 0.1ms) Started GET "/rails/db/data-table" for 127.0.0.1 at 2019-09-07 01:35:32 -0700 Processing by RailsDb::DashboardController#data_table as HTML Rendering /root/projects/rails_db/app/views/rails_db/dashboard/data_table.html.erb within layouts/rails_db/application Rendered /root/projects/rails_db/app/views/rails_db/dashboard/data_table.html.erb within layouts/rails_db/application (2.9ms) Rendered /root/projects/rails_db/app/views/rails_db/shared/_header.html.erb (1.8ms) Rendered /root/projects/rails_db/app/views/rails_db/shared/_sidebar.html.erb (1.8ms) Rendered /root/projects/rails_db/app/views/rails_db/shared/_gems.html.erb (0.5ms) Rendered /root/projects/rails_db/app/views/rails_db/shared/_footer.html.erb (1.3ms) Completed 200 OK in 14ms (Views: 12.9ms | ActiveRecord: 0.2ms) Started GET "/" for 127.0.0.1 at 2019-09-07 01:35:32 -0700 Processing by HomeController#index as HTML Rendering home/index.html.erb within layouts/application  (0.1ms) SELECT id, name, users_count FROM accounts ORDER BY users_count desc LIMIT 10 OFFSET 0 Rendered /root/projects/rails_db/app/views/rails_db/shared/_data_table.html.erb (1.7ms)  (0.1ms) select id, name, age from users order by age desc limit 10 Rendered /root/projects/rails_db/app/views/rails_db/shared/_sql_result.html.erb (1.4ms)  (0.1ms) SELECT COUNT(*) FROM "users"  (0.1ms) SELECT COUNT(*) FROM "users" WHERE "users"."type" IN ('Customer')  (0.1ms) SELECT COUNT(*) FROM "accounts" Rendered home/index.html.erb within layouts/application (11.4ms) Completed 200 OK in 18ms (Views: 15.4ms | ActiveRecord: 1.2ms) Started GET "/rails/db/tables/users/data?sort_column=id&sort_order=desc" for 127.0.0.1 at 2019-09-07 01:35:32 -0700 Processing by RailsDb::TablesController#data as HTML Parameters: {"sort_column"=>"id", "sort_order"=>"desc", "table_id"=>"users"}  (0.1ms) SELECT COUNT(*) FROM "users" Rendering /root/projects/rails_db/app/views/rails_db/tables/data.html.erb within layouts/rails_db/application Rendered /root/projects/rails_db/app/views/rails_db/shared/_exp_col.html.erb (0.8ms) Rendered /root/projects/rails_db/app/views/rails_db/tables/_condition_fields.html.erb (20.6ms) Rendered /root/projects/rails_db/app/views/rails_db/tables/_condition_fields.html.erb (5.9ms)  Load (0.2ms) SELECT "users".* FROM "users" LIMIT ? OFFSET ? [["LIMIT", 30], ["OFFSET", 0]] Rendered /root/projects/rails_db/app/views/rails_db/tables/_row.html.erb (1.2ms) Rendered /root/projects/rails_db/app/views/rails_db/tables/_row.html.erb (1.1ms) Rendered /root/projects/rails_db/app/views/rails_db/tables/_row.html.erb (1.1ms) CACHE (0.0ms) SELECT COUNT(*) FROM "users" CACHE (0.0ms) SELECT COUNT(*) FROM "users" Rendered /root/projects/rails_db/app/views/rails_db/tables/_sql.html.erb (0.0ms) Rendered /root/projects/rails_db/app/views/rails_db/tables/_data.html.erb (55.5ms) Rendered /root/projects/rails_db/app/views/rails_db/tables/data.html.erb within layouts/rails_db/application (55.6ms) Rendered /root/projects/rails_db/app/views/rails_db/shared/_header.html.erb (0.6ms) Rendered /root/projects/rails_db/app/views/rails_db/shared/_sidebar.html.erb (0.9ms) Rendered /root/projects/rails_db/app/views/rails_db/shared/_gems.html.erb (0.1ms) Rendered /root/projects/rails_db/app/views/rails_db/shared/_footer.html.erb (0.5ms) Completed 200 OK in 71ms (Views: 56.6ms | ActiveRecord: 2.7ms)  (0.1ms) SELECT COUNT(*) FROM "users" Started GET "/rails/db/tables/users/destroy?pk_id=1" for 127.0.0.1 at 2019-09-07 01:35:32 -0700 Processing by RailsDb::TablesController#destroy as HTML Parameters: {"pk_id"=>"1", "table_id"=>"users"}  (0.0ms) SELECT COUNT(*) FROM "users"  (0.1ms) DELETE FROM users WHERE id = '1'; Redirected to http://www.example.com/rails/db/tables/users/data Completed 302 Found in 7ms (ActiveRecord: 0.4ms)  (0.1ms) SELECT COUNT(*) FROM "users" Started GET "/rails/db/tables/users/csv" for 127.0.0.1 at 2019-09-07 01:35:32 -0700 Processing by RailsDb::TablesController#csv as HTML Parameters: {"table_id"=>"users"}  (0.1ms) SELECT * FROM users Rendering text template Rendered text template (0.0ms) Sent data users.csv (0.5ms) Completed 200 OK in 1ms (Views: 0.4ms | ActiveRecord: 0.3ms) Started GET "/rails/db/standalone" for 127.0.0.1 at 2019-09-07 01:35:32 -0700 Processing by RailsDb::DashboardController#standalone as HTML Rendering /root/projects/rails_db/app/views/rails_db/dashboard/standalone.html.erb within layouts/rails_db/application Rendered /root/projects/rails_db/app/views/rails_db/dashboard/standalone.html.erb within layouts/rails_db/application (0.7ms) Rendered /root/projects/rails_db/app/views/rails_db/shared/_header.html.erb (0.9ms) Rendered /root/projects/rails_db/app/views/rails_db/shared/_sidebar.html.erb (0.8ms) Rendered /root/projects/rails_db/app/views/rails_db/shared/_gems.html.erb (0.0ms) Rendered /root/projects/rails_db/app/views/rails_db/shared/_footer.html.erb (0.5ms) Completed 200 OK in 5ms (Views: 4.1ms | ActiveRecord: 0.2ms) Started GET "/rails/db/tables/users/xlsx.xls" for 127.0.0.1 at 2019-09-07 01:35:32 -0700 Processing by RailsDb::TablesController#xlsx as XLS Parameters: {"table_id"=>"users"} Rendering /root/projects/rails_db/app/views/rails_db/tables/table.xls.axlsx  (0.1ms) SELECT * FROM users Rendered /root/projects/rails_db/app/views/rails_db/tables/table.xls.axlsx (4.9ms) Rendering text template Rendered text template (0.0ms) Sent data users.xlsx (0.2ms) Completed 200 OK in 6ms (Views: 5.7ms | ActiveRecord: 0.4ms) Started GET "/rails/db/sql?sql=select+%2A+from+users+limit+10" for 127.0.0.1 at 2019-09-07 01:35:32 -0700 Processing by RailsDb::SqlController#index as HTML Parameters: {"sql"=>"select * from users limit 10"}  (0.1ms) select * from users limit 10  (0.1ms) EXPLAIN select * from users limit 10 Rendering /root/projects/rails_db/app/views/rails_db/sql/index.html.erb within layouts/rails_db/application Rendered /root/projects/rails_db/app/views/rails_db/shared/_exp_col.html.erb (0.0ms) Rendered /root/projects/rails_db/app/views/rails_db/sql/_history.html.erb (0.3ms) Rendered /root/projects/rails_db/app/views/rails_db/sql/_explain.html.erb (0.8ms) Rendered /root/projects/rails_db/app/views/rails_db/sql/_results.html.erb (2.4ms) Rendered /root/projects/rails_db/app/views/rails_db/sql/index.html.erb within layouts/rails_db/application (7.9ms) Rendered /root/projects/rails_db/app/views/rails_db/shared/_header.html.erb (0.7ms) Rendered /root/projects/rails_db/app/views/rails_db/shared/_sidebar.html.erb (0.7ms) Rendered /root/projects/rails_db/app/views/rails_db/shared/_gems.html.erb (0.1ms) Rendered /root/projects/rails_db/app/views/rails_db/shared/_footer.html.erb (0.7ms) Completed 200 OK in 12ms (Views: 9.4ms | ActiveRecord: 2.5ms) Started POST "/rails/db/sql-csv.csv?sql=select+%2A+from+users+limit+10" for 127.0.0.1 at 2019-09-07 01:35:32 -0700 Processing by RailsDb::SqlController#csv as CSV Parameters: {"sql"=>"select * from users limit 10"}  (0.2ms) select * from users limit 10  (0.1ms) EXPLAIN select * from users limit 10 Rendering text template Rendered text template (0.0ms) Sent data results.csv (0.2ms) Completed 200 OK in 1ms (Views: 0.2ms | ActiveRecord: 0.2ms) Started POST "/rails/db/sql-xls.xls?sql=select+%2A+from+users+limit+10" for 127.0.0.1 at 2019-09-07 01:35:32 -0700 Processing by RailsDb::SqlController#xls as XLS Parameters: {"sql"=>"select * from users limit 10"}  (0.2ms) select * from users limit 10  (0.1ms) EXPLAIN select * from users limit 10 Rendering /root/projects/rails_db/app/views/rails_db/sql/xls.xls.axlsx Rendered /root/projects/rails_db/app/views/rails_db/sql/xls.xls.axlsx (5.9ms) Rendering text template Rendered text template (0.0ms) Sent data results.xlsx (0.3ms) Completed 200 OK in 7ms (Views: 6.7ms | ActiveRecord: 0.2ms) Started GET "/rails/db/tables/users/edit?pk_id=2" for 127.0.0.1 at 2019-09-07 01:35:32 -0700 Processing by RailsDb::TablesController#edit as JS Parameters: {"pk_id"=>"2", "table_id"=>"users"}  (0.1ms) SELECT COUNT(*) FROM "users"  Load (0.1ms) SELECT "users".* FROM "users" WHERE "users"."id" = ? LIMIT ? [["id", 2], ["LIMIT", 1]] Rendering /root/projects/rails_db/app/views/rails_db/tables/edit.js.erb Rendered /root/projects/rails_db/app/views/rails_db/tables/_edit.html.erb (15.0ms) Rendered /root/projects/rails_db/app/views/rails_db/tables/edit.js.erb (16.4ms) Completed 200 OK in 38ms (Views: 15.6ms | ActiveRecord: 2.0ms) Started PUT "/rails/db/tables/users/update?pk_id=2" for 127.0.0.1 at 2019-09-07 01:35:32 -0700 Processing by RailsDb::TablesController#update as JS Parameters: {"record"=>{"name"=>"JOHN"}, "pk_id"=>"2", "table_id"=>"users"}  (0.0ms) SELECT COUNT(*) FROM "users"  Load (0.0ms) SELECT "users".* FROM "users" WHERE "users"."id" = ? LIMIT ? [["id", 2], ["LIMIT", 1]]  (0.1ms) SAVEPOINT active_record_1 SQL (0.1ms) UPDATE "users" SET "name" = ?, "updated_at" = ? WHERE "users"."id" = ? [["name", "JOHN"], ["updated_at", "2019-09-07 08:35:32.741387"], ["id", 2]]  (0.1ms) RELEASE SAVEPOINT active_record_1 Rendering /root/projects/rails_db/app/views/rails_db/tables/update.js.erb Rendered /root/projects/rails_db/app/views/rails_db/tables/_row.html.erb (1.7ms) Rendered /root/projects/rails_db/app/views/rails_db/tables/update.js.erb (2.6ms) Completed 200 OK in 16ms (Views: 2.2ms | ActiveRecord: 1.0ms) User Load (0.0ms) SELECT "users".* FROM "users" WHERE "users"."id" = ? LIMIT ? [["id", 2], ["LIMIT", 1]] Started GET "/rails/db/tables/users/new" for 127.0.0.1 at 2019-09-07 01:35:32 -0700 Processing by RailsDb::TablesController#new as JS Parameters: {"table_id"=>"users"}  (0.1ms) SELECT COUNT(*) FROM "users" Rendering /root/projects/rails_db/app/views/rails_db/tables/new.js.erb Rendered /root/projects/rails_db/app/views/rails_db/tables/_new.html.erb (9.9ms) Rendered /root/projects/rails_db/app/views/rails_db/tables/new.js.erb (12.2ms) Completed 200 OK in 23ms (Views: 10.5ms | ActiveRecord: 2.2ms)  (0.1ms) SELECT COUNT(*) FROM "users" Started POST "/rails/db/tables/users/create" for 127.0.0.1 at 2019-09-07 01:35:32 -0700 Processing by RailsDb::TablesController#create as JS Parameters: {"record"=>{"name"=>"XXX"}, "table_id"=>"users"}  (0.1ms) SELECT COUNT(*) FROM "users"  (0.1ms) SAVEPOINT active_record_1 SQL (0.1ms) INSERT INTO "users" ("name", "created_at", "updated_at") VALUES (?, ?, ?) [["name", "XXX"], ["created_at", "2019-09-07 08:35:32.787388"], ["updated_at", "2019-09-07 08:35:32.787388"]]  (0.0ms) RELEASE SAVEPOINT active_record_1 Rendering /root/projects/rails_db/app/views/rails_db/tables/create.js.erb Rendered /root/projects/rails_db/app/views/rails_db/shared/_exp_col.html.erb (0.3ms) Rendered /root/projects/rails_db/app/views/rails_db/tables/_condition_fields.html.erb (13.2ms) Rendered /root/projects/rails_db/app/views/rails_db/tables/_condition_fields.html.erb (12.4ms)  Load (0.2ms) SELECT "users".* FROM "users" LIMIT ? OFFSET ? [["LIMIT", 30], ["OFFSET", 0]] Rendered /root/projects/rails_db/app/views/rails_db/tables/_row.html.erb (2.2ms) Rendered /root/projects/rails_db/app/views/rails_db/tables/_row.html.erb (2.0ms) Rendered /root/projects/rails_db/app/views/rails_db/tables/_row.html.erb (2.0ms)  (0.1ms) SELECT COUNT(*) FROM "users" CACHE (0.0ms) SELECT COUNT(*) FROM "users" Rendered /root/projects/rails_db/app/views/rails_db/tables/_sql.html.erb (0.4ms) Rendered /root/projects/rails_db/app/views/rails_db/tables/_data.html.erb (69.5ms) Rendered /root/projects/rails_db/app/views/rails_db/tables/create.js.erb (72.6ms) Completed 200 OK in 96ms (Views: 69.3ms | ActiveRecord: 4.3ms)  (0.1ms) SELECT COUNT(*) FROM "users" Started GET "/rails/db/tables/users/edit?pk_id=3" for 127.0.0.1 at 2019-09-07 01:35:32 -0700 Processing by RailsDb::TablesController#edit as JS Parameters: {"pk_id"=>"3", "table_id"=>"users"}  (0.1ms) SELECT COUNT(*) FROM "users"  Load (0.1ms) SELECT "users".* FROM "users" WHERE "users"."id" = ? LIMIT ? [["id", 3], ["LIMIT", 1]] Rendering /root/projects/rails_db/app/views/rails_db/tables/edit.js.erb Rendered /root/projects/rails_db/app/views/rails_db/tables/_edit.html.erb (17.2ms) Rendered /root/projects/rails_db/app/views/rails_db/tables/edit.js.erb (19.8ms) Completed 200 OK in 36ms (Views: 17.2ms | ActiveRecord: 3.3ms) Started PUT "/rails/db/tables/users/update?pk_id=3" for 127.0.0.1 at 2019-09-07 01:35:32 -0700 Processing by RailsDb::TablesController#update as JS Parameters: {"record"=>{"name"=>"STI"}, "pk_id"=>"3", "table_id"=>"users"}  (0.1ms) SELECT COUNT(*) FROM "users"  Load (0.1ms) SELECT "users".* FROM "users" WHERE "users"."id" = ? LIMIT ? [["id", 3], ["LIMIT", 1]]  (0.1ms) SAVEPOINT active_record_1 SQL (0.1ms) UPDATE "users" SET "name" = ?, "updated_at" = ? WHERE "users"."id" = ? [["name", "STI"], ["updated_at", "2019-09-07 08:35:32.925309"], ["id", 3]]  (0.0ms) RELEASE SAVEPOINT active_record_1 Rendering /root/projects/rails_db/app/views/rails_db/tables/update.js.erb Rendered /root/projects/rails_db/app/views/rails_db/tables/_row.html.erb (2.1ms) Rendered /root/projects/rails_db/app/views/rails_db/tables/update.js.erb (2.8ms) Completed 200 OK in 22ms (Views: 2.2ms | ActiveRecord: 1.4ms) Customer Load (0.1ms) SELECT "users".* FROM "users" WHERE "users"."type" IN ('Customer') AND "users"."id" = ? LIMIT ? [["id", 3], ["LIMIT", 1]] Started GET "/admin/tools/db" for 127.0.0.1 at 2019-09-07 01:35:32 -0700 Processing by RailsDb::DashboardController#index as HTML Rendering /root/projects/rails_db/app/views/rails_db/dashboard/index.html.erb within layouts/rails_db/application Rendered /root/projects/rails_db/app/views/rails_db/dashboard/index.html.erb within layouts/rails_db/application (0.4ms) Rendered /root/projects/rails_db/app/views/rails_db/shared/_header.html.erb (0.8ms) Rendered /root/projects/rails_db/app/views/rails_db/shared/_sidebar.html.erb (0.7ms) Rendered /root/projects/rails_db/app/views/rails_db/shared/_gems.html.erb (0.1ms) Rendered /root/projects/rails_db/app/views/rails_db/shared/_footer.html.erb (0.4ms) Completed 200 OK in 4ms (Views: 3.7ms | ActiveRecord: 0.1ms) Started GET "/admin/tools/db/sql" for 127.0.0.1 at 2019-09-07 01:35:32 -0700 Processing by RailsDb::SqlController#index as HTML Rendering /root/projects/rails_db/app/views/rails_db/sql/index.html.erb within layouts/rails_db/application Rendered /root/projects/rails_db/app/views/rails_db/shared/_exp_col.html.erb (0.0ms) Rendered /root/projects/rails_db/app/views/rails_db/sql/_history.html.erb (0.3ms) Rendered /root/projects/rails_db/app/views/rails_db/sql/index.html.erb within layouts/rails_db/application (4.0ms) Rendered /root/projects/rails_db/app/views/rails_db/shared/_header.html.erb (0.6ms) Rendered /root/projects/rails_db/app/views/rails_db/shared/_sidebar.html.erb (0.6ms) Rendered /root/projects/rails_db/app/views/rails_db/shared/_gems.html.erb (0.1ms) Rendered /root/projects/rails_db/app/views/rails_db/shared/_footer.html.erb (0.5ms) Completed 200 OK in 7ms (Views: 5.3ms | ActiveRecord: 1.6ms)  (0.1ms) rollback transaction  (0.0ms) begin transaction ------------------------------------------------------------------ RailsDbDataTableHelperTest: test_default_rails_db_data_table_works ------------------------------------------------------------------  (0.0ms) SAVEPOINT active_record_1 SQL (0.2ms) INSERT INTO "users" ("name", "created_at", "updated_at") VALUES (?, ?, ?) [["name", "Igor"], ["created_at", "2019-09-07 08:35:32.946127"], ["updated_at", "2019-09-07 08:35:32.946127"]]  (0.0ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SELECT * FROM users Rendered /root/projects/rails_db/app/views/rails_db/shared/_data_table.html.erb (1.5ms)  (0.1ms) rollback transaction  (0.1ms) begin transaction ---------------------------------------------------------------------------- RailsDbDataTableHelperTest: test_rails_db_data_table_works_with_many_options ----------------------------------------------------------------------------  (0.1ms) SAVEPOINT active_record_1 SQL (0.2ms) INSERT INTO "users" ("name", "age", "created_at", "updated_at") VALUES (?, ?, ?, ?) [["name", "Igor"], ["age", 9999], ["created_at", "2019-09-07 08:35:32.952343"], ["updated_at", "2019-09-07 08:35:32.952343"]]  (0.0ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SELECT id, name FROM users ORDER BY id asc LIMIT 10 OFFSET 0 Rendered /root/projects/rails_db/app/views/rails_db/shared/_data_table.html.erb (0.3ms)  (0.1ms) rollback transaction  (0.0ms) begin transaction ---------------------------------------------------------------------- RailsDbDataTableHelperTest: test_default_rails_db_data_table_sql_works ----------------------------------------------------------------------  (0.0ms) SAVEPOINT active_record_1 SQL (0.2ms) INSERT INTO "users" ("name", "created_at", "updated_at") VALUES (?, ?, ?) [["name", "Igor"], ["created_at", "2019-09-07 08:35:32.955554"], ["updated_at", "2019-09-07 08:35:32.955554"]]  (0.0ms) RELEASE SAVEPOINT active_record_1  (0.1ms) select * from users Rendered /root/projects/rails_db/app/views/rails_db/shared/_sql_result.html.erb (1.1ms)  (0.1ms) rollback transaction  (0.1ms) begin transaction -------------------------------------------------------------------------------- RailsDbDataTableHelperTest: test_rails_db_data_table_sql_works_with_many_options --------------------------------------------------------------------------------  (0.0ms) SAVEPOINT active_record_1 SQL (0.2ms) INSERT INTO "users" ("name", "created_at", "updated_at") VALUES (?, ?, ?) [["name", "Igor"], ["created_at", "2019-09-07 08:35:32.963351"], ["updated_at", "2019-09-07 08:35:32.963351"]]  (0.0ms) RELEASE SAVEPOINT active_record_1  (0.1ms) select * from users Rendered /root/projects/rails_db/app/views/rails_db/shared/_sql_result.html.erb (0.2ms)  (0.1ms) rollback transaction  (0.2ms) SELECT "schema_migrations"."version" FROM "schema_migrations" ORDER BY "schema_migrations"."version" ASC  (0.2ms) begin transaction -------------------------- DatabaseTest: test_adapter --------------------------  (0.1ms) rollback transaction  (0.1ms) begin transaction ------------------------------------ DatabaseTest: test_accessible_tables ------------------------------------  (0.0ms) rollback transaction  (0.0ms) begin transaction ------------------------- DatabaseTest: test_insert -------------------------  (0.1ms) delete from projects_users  (0.1ms) EXPLAIN delete from projects_users SQL (0.1ms) DELETE FROM "users"  (0.1ms) SELECT COUNT(*) FROM projects_users  (0.0ms) insert into projects_users(project_id, user_id) values(1,2)  (0.1ms) EXPLAIN insert into projects_users(project_id, user_id) values(1,2)  (0.0ms) SELECT COUNT(*) FROM projects_users  (0.1ms) rollback transaction  (0.0ms) begin transaction ------------------------ DatabaseTest: test_query ------------------------ SQL (0.2ms) DELETE FROM "users"  (0.1ms) SAVEPOINT active_record_1 SQL (0.4ms) INSERT INTO "users" ("name", "created_at", "updated_at") VALUES (?, ?, ?) [["name", "Igor"], ["created_at", "2019-09-07 08:46:31.460025"], ["updated_at", "2019-09-07 08:46:31.460025"]]  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.1ms) select count(*) as users_count from users  (0.1ms) EXPLAIN select count(*) as users_count from users  (0.1ms) rollback transaction  (0.1ms) begin transaction ------------------------- DatabaseTest: test_tables -------------------------  (0.0ms) rollback transaction  (0.0ms) begin transaction -------------------------- SqlImportTest: test_import --------------------------  (0.1ms) update users set age = 11 where id = 1  (0.1ms) update users set age = 22 where id = 2  (0.0ms) update users set age = 33 where id = 3  (0.2ms)  CREATE TABLE t(x INTEGER, y, z, PRIMARY KEY(x ASC));  (0.1ms) rollback transaction  (0.0ms) begin transaction ----------------------- RailsDbTest: test_truth -----------------------  (0.0ms) rollback transaction  (0.0ms) begin transaction ------------------------------------ RailsDbTest: test_verify_access_proc ------------------------------------  (0.0ms) rollback transaction  (0.0ms) begin transaction ---------------------------------------------------------------------- RailsDbDataTableHelperTest: test_default_rails_db_data_table_sql_works ----------------------------------------------------------------------  (0.1ms) SAVEPOINT active_record_1 SQL (0.4ms) INSERT INTO "users" ("name", "created_at", "updated_at") VALUES (?, ?, ?) [["name", "Igor"], ["created_at", "2019-09-07 08:46:31.471400"], ["updated_at", "2019-09-07 08:46:31.471400"]]  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.2ms) select * from users Rendered /root/projects/rails_db/app/views/rails_db/shared/_sql_result.html.erb (1.5ms)  (0.2ms) rollback transaction  (0.1ms) begin transaction ------------------------------------------------------------------ RailsDbDataTableHelperTest: test_default_rails_db_data_table_works ------------------------------------------------------------------  (0.1ms) SAVEPOINT active_record_1 SQL (0.2ms) INSERT INTO "users" ("name", "created_at", "updated_at") VALUES (?, ?, ?) [["name", "Igor"], ["created_at", "2019-09-07 08:46:31.483509"], ["updated_at", "2019-09-07 08:46:31.483509"]]  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SELECT * FROM users Rendered /root/projects/rails_db/app/views/rails_db/shared/_data_table.html.erb (2.0ms)  (0.2ms) rollback transaction  (0.1ms) begin transaction -------------------------------------------------------------------------------- RailsDbDataTableHelperTest: test_rails_db_data_table_sql_works_with_many_options --------------------------------------------------------------------------------  (0.1ms) SAVEPOINT active_record_1 SQL (0.2ms) INSERT INTO "users" ("name", "created_at", "updated_at") VALUES (?, ?, ?) [["name", "Igor"], ["created_at", "2019-09-07 08:46:31.492830"], ["updated_at", "2019-09-07 08:46:31.492830"]]  (0.0ms) RELEASE SAVEPOINT active_record_1  (0.1ms) select * from users Rendered /root/projects/rails_db/app/views/rails_db/shared/_sql_result.html.erb (0.1ms)  (0.1ms) rollback transaction  (0.0ms) begin transaction ---------------------------------------------------------------------------- RailsDbDataTableHelperTest: test_rails_db_data_table_works_with_many_options ----------------------------------------------------------------------------  (0.0ms) SAVEPOINT active_record_1 SQL (0.2ms) INSERT INTO "users" ("name", "age", "created_at", "updated_at") VALUES (?, ?, ?, ?) [["name", "Igor"], ["age", 9999], ["created_at", "2019-09-07 08:46:31.495387"], ["updated_at", "2019-09-07 08:46:31.495387"]]  (0.0ms) RELEASE SAVEPOINT active_record_1  (0.0ms) SELECT id, name FROM users ORDER BY id asc LIMIT 10 OFFSET 0 Rendered /root/projects/rails_db/app/views/rails_db/shared/_data_table.html.erb (0.2ms)  (0.1ms) rollback transaction  (0.0ms) begin transaction ------------------------ TableTest: test_truncate ------------------------ SQL (0.2ms) DELETE FROM "users"  (0.0ms) SAVEPOINT active_record_1 SQL (0.1ms) INSERT INTO "users" ("name", "created_at", "updated_at") VALUES (?, ?, ?) [["name", "igor"], ["created_at", "2019-09-07 08:46:31.498327"], ["updated_at", "2019-09-07 08:46:31.498327"]]  (0.0ms) RELEASE SAVEPOINT active_record_1  (0.0ms) SELECT COUNT(*) FROM "users"  (0.0ms) DELETE FROM users;  (0.0ms) SELECT COUNT(*) FROM "users"  (0.1ms) rollback transaction  (0.0ms) begin transaction ---------------------- TableTest: test_delete ---------------------- SQL (0.2ms) DELETE FROM "users"  (0.1ms) SAVEPOINT active_record_1 SQL (0.2ms) INSERT INTO "users" ("name", "created_at", "updated_at") VALUES (?, ?, ?) [["name", "igor"], ["created_at", "2019-09-07 08:46:31.501399"], ["updated_at", "2019-09-07 08:46:31.501399"]]  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_1 SQL (0.1ms) INSERT INTO "users" ("name", "created_at", "updated_at") VALUES (?, ?, ?) [["name", "john"], ["created_at", "2019-09-07 08:46:31.502994"], ["updated_at", "2019-09-07 08:46:31.502994"]]  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SELECT COUNT(*) FROM "users"  (0.1ms) DELETE FROM users WHERE id = 1;  (0.1ms) SELECT COUNT(*) FROM "users"  (0.1ms) SELECT COUNT(*) FROM "users" WHERE "users"."name" = ? [["name", "igor"]]  (0.1ms) SELECT COUNT(*) FROM "users" WHERE "users"."name" = ? [["name", "john"]]  (0.1ms) rollback transaction  (0.0ms) begin transaction --------------------------- TableTest: test_primary_key ---------------------------  (0.0ms) rollback transaction  (0.1ms) begin transaction ----------------------- TableTest: test_columns -----------------------  (0.0ms) rollback transaction  (0.0ms) begin transaction ------------------------ TableTest: test_as_table ------------------------ SQL (0.1ms) DELETE FROM "users"  (0.1ms) SAVEPOINT active_record_1 SQL (0.1ms) INSERT INTO "users" ("name", "created_at", "updated_at") VALUES (?, ?, ?) [["name", "igor"], ["created_at", "2019-09-07 08:46:31.511405"], ["updated_at", "2019-09-07 08:46:31.511405"]]  (0.0ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SELECT COUNT(*) FROM "users"  Load (0.1ms) SELECT "users".* FROM "users" ORDER BY "users"."id" ASC LIMIT ? [["LIMIT", 1]]  (0.5ms) rollback transaction  (0.2ms) begin transaction ---------------------- TableTest: test_to_csv ----------------------  (0.3ms) SAVEPOINT active_record_1 SQL (0.4ms) INSERT INTO "users" ("name", "created_at", "updated_at") VALUES (?, ?, ?) [["name", "igor"], ["created_at", "2019-09-07 08:46:31.534012"], ["updated_at", "2019-09-07 08:46:31.534012"]]  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SELECT * FROM users  (0.2ms) rollback transaction  (0.1ms) begin transaction ---------------------------------------------- DashboardControllerTest: test_should_get_index ---------------------------------------------- SQL (0.2ms) DELETE FROM "users" SQL (0.1ms) DELETE FROM "accounts" SQL (0.1ms) DELETE FROM "users" WHERE "users"."type" IN ('Customer')  (0.0ms) SAVEPOINT active_record_1 SQL (0.1ms) INSERT INTO "users" ("name", "created_at", "updated_at") VALUES (?, ?, ?) [["name", "Igor"], ["created_at", "2019-09-07 08:46:31.607188"], ["updated_at", "2019-09-07 08:46:31.607188"]]  (0.0ms) RELEASE SAVEPOINT active_record_1  (0.0ms) SAVEPOINT active_record_1 SQL (0.1ms) INSERT INTO "users" ("name", "created_at", "updated_at") VALUES (?, ?, ?) [["name", "Edit"], ["created_at", "2019-09-07 08:46:31.608120"], ["updated_at", "2019-09-07 08:46:31.608120"]]  (0.0ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_1 SQL (0.1ms) INSERT INTO "users" ("name", "bio", "created_at", "updated_at", "type") VALUES (?, ?, ?, ?, ?) [["name", "Customer 1"], ["bio", "this is bio text"], ["created_at", "2019-09-07 08:46:31.613885"], ["updated_at", "2019-09-07 08:46:31.613885"], ["type", "Customer"]]  (0.0ms) RELEASE SAVEPOINT active_record_1 Started GET "/rails/db" for 127.0.0.1 at 2019-09-07 01:46:31 -0700 Processing by RailsDb::DashboardController#index as HTML Rendering /root/projects/rails_db/app/views/rails_db/dashboard/index.html.erb within layouts/rails_db/application Rendered /root/projects/rails_db/app/views/rails_db/dashboard/index.html.erb within layouts/rails_db/application (227.2ms) Rendered /root/projects/rails_db/app/views/rails_db/shared/_header.html.erb (3.4ms) Rendered /root/projects/rails_db/app/views/rails_db/shared/_sidebar.html.erb (1.5ms) Rendered /root/projects/rails_db/app/views/rails_db/shared/_gems.html.erb (0.5ms) Rendered /root/projects/rails_db/app/views/rails_db/shared/_footer.html.erb (2.4ms) Completed 200 OK in 246ms (Views: 245.4ms | ActiveRecord: 0.2ms) Started GET "/rails/db/tables/users" for 127.0.0.1 at 2019-09-07 01:46:31 -0700 Processing by RailsDb::TablesController#show as HTML Parameters: {"id"=>"users"} Rendering /root/projects/rails_db/app/views/rails_db/tables/show.html.erb within layouts/rails_db/application Rendered /root/projects/rails_db/app/views/rails_db/shared/_exp_col.html.erb (0.3ms)  (0.1ms)  SELECT sql FROM sqlite_master WHERE name='index_users_on_salary' AND type='index' UNION ALL SELECT sql FROM sqlite_temp_master WHERE name='index_users_on_salary' AND type='index'   (0.1ms)  SELECT sql FROM sqlite_master WHERE name='index_users_on_name' AND type='index' UNION ALL SELECT sql FROM sqlite_temp_master WHERE name='index_users_on_name' AND type='index'   (0.1ms)  SELECT sql FROM sqlite_master WHERE name='index_users_on_account_id' AND type='index' UNION ALL SELECT sql FROM sqlite_temp_master WHERE name='index_users_on_account_id' AND type='index'   (0.1ms)  SELECT sql FROM sqlite_master WHERE name='index_users_on_salary' AND type='index' UNION ALL SELECT sql FROM sqlite_temp_master WHERE name='index_users_on_salary' AND type='index'   (0.1ms)  SELECT sql FROM sqlite_master WHERE name='index_users_on_name' AND type='index' UNION ALL SELECT sql FROM sqlite_temp_master WHERE name='index_users_on_name' AND type='index'   (0.1ms)  SELECT sql FROM sqlite_master WHERE name='index_users_on_account_id' AND type='index' UNION ALL SELECT sql FROM sqlite_temp_master WHERE name='index_users_on_account_id' AND type='index'  Rendered /root/projects/rails_db/app/views/rails_db/tables/_show.html.erb (36.5ms) Rendered /root/projects/rails_db/app/views/rails_db/tables/show.html.erb within layouts/rails_db/application (38.7ms) Rendered /root/projects/rails_db/app/views/rails_db/shared/_header.html.erb (1.1ms) Rendered /root/projects/rails_db/app/views/rails_db/shared/_sidebar.html.erb (1.0ms) Rendered /root/projects/rails_db/app/views/rails_db/shared/_gems.html.erb (0.1ms) Rendered /root/projects/rails_db/app/views/rails_db/shared/_footer.html.erb (0.7ms) Completed 200 OK in 45ms (Views: 38.2ms | ActiveRecord: 6.0ms) Started GET "/rails/db/tables/users/data" for 127.0.0.1 at 2019-09-07 01:46:31 -0700 Processing by RailsDb::TablesController#data as HTML Parameters: {"table_id"=>"users"}  (0.1ms) SELECT COUNT(*) FROM "users" Rendering /root/projects/rails_db/app/views/rails_db/tables/data.html.erb within layouts/rails_db/application Rendered /root/projects/rails_db/app/views/rails_db/shared/_exp_col.html.erb (0.0ms) Rendered /root/projects/rails_db/app/views/rails_db/tables/_condition_fields.html.erb (29.8ms) Rendered /root/projects/rails_db/app/views/rails_db/tables/_condition_fields.html.erb (12.5ms)  Load (0.2ms) SELECT "users".* FROM "users" LIMIT ? OFFSET ? [["LIMIT", 30], ["OFFSET", 0]] Rendered /root/projects/rails_db/app/views/rails_db/tables/_row.html.erb (2.9ms) Rendered /root/projects/rails_db/app/views/rails_db/tables/_row.html.erb (2.0ms) Rendered /root/projects/rails_db/app/views/rails_db/tables/_row.html.erb (1.4ms) CACHE (0.0ms) SELECT COUNT(*) FROM "users" CACHE (0.0ms) SELECT COUNT(*) FROM "users" Rendered /root/projects/rails_db/app/views/rails_db/tables/_sql.html.erb (0.2ms) Rendered /root/projects/rails_db/app/views/rails_db/tables/_data.html.erb (92.7ms) Rendered /root/projects/rails_db/app/views/rails_db/tables/data.html.erb within layouts/rails_db/application (93.1ms) Rendered /root/projects/rails_db/app/views/rails_db/shared/_header.html.erb (0.7ms) Rendered /root/projects/rails_db/app/views/rails_db/shared/_sidebar.html.erb (0.9ms) Rendered /root/projects/rails_db/app/views/rails_db/shared/_gems.html.erb (0.1ms) Rendered /root/projects/rails_db/app/views/rails_db/shared/_footer.html.erb (0.5ms) Completed 200 OK in 105ms (Views: 92.6ms | ActiveRecord: 4.1ms) Started GET "/rails/db/sql" for 127.0.0.1 at 2019-09-07 01:46:32 -0700 Processing by RailsDb::SqlController#index as HTML Rendering /root/projects/rails_db/app/views/rails_db/sql/index.html.erb within layouts/rails_db/application Rendered /root/projects/rails_db/app/views/rails_db/shared/_exp_col.html.erb (0.0ms) Rendered /root/projects/rails_db/app/views/rails_db/sql/_history.html.erb (0.5ms) Rendered /root/projects/rails_db/app/views/rails_db/sql/index.html.erb within layouts/rails_db/application (4.7ms) Rendered /root/projects/rails_db/app/views/rails_db/shared/_header.html.erb (0.6ms) Rendered /root/projects/rails_db/app/views/rails_db/shared/_sidebar.html.erb (0.6ms) Rendered /root/projects/rails_db/app/views/rails_db/shared/_gems.html.erb (0.0ms) Rendered /root/projects/rails_db/app/views/rails_db/shared/_footer.html.erb (0.4ms) Completed 200 OK in 8ms (Views: 6.4ms | ActiveRecord: 1.6ms) Started GET "/rails/db/import" for 127.0.0.1 at 2019-09-07 01:46:32 -0700 Processing by RailsDb::SqlController#import as HTML Rendering /root/projects/rails_db/app/views/rails_db/sql/import.html.erb within layouts/rails_db/application Rendered /root/projects/rails_db/app/views/rails_db/sql/_import_sample.html.erb (0.2ms) Rendered /root/projects/rails_db/app/views/rails_db/sql/import.html.erb within layouts/rails_db/application (1.1ms) Rendered /root/projects/rails_db/app/views/rails_db/shared/_header.html.erb (0.6ms) Rendered /root/projects/rails_db/app/views/rails_db/shared/_sidebar.html.erb (1.2ms) Rendered /root/projects/rails_db/app/views/rails_db/shared/_gems.html.erb (0.1ms) Rendered /root/projects/rails_db/app/views/rails_db/shared/_footer.html.erb (1.2ms) Completed 200 OK in 6ms (Views: 5.2ms | ActiveRecord: 0.2ms) Started GET "/rails/db/data-table" for 127.0.0.1 at 2019-09-07 01:46:32 -0700 Processing by RailsDb::DashboardController#data_table as HTML Rendering /root/projects/rails_db/app/views/rails_db/dashboard/data_table.html.erb within layouts/rails_db/application Rendered /root/projects/rails_db/app/views/rails_db/dashboard/data_table.html.erb within layouts/rails_db/application (1.3ms) Rendered /root/projects/rails_db/app/views/rails_db/shared/_header.html.erb (13.3ms) Rendered /root/projects/rails_db/app/views/rails_db/shared/_sidebar.html.erb (1.1ms) Rendered /root/projects/rails_db/app/views/rails_db/shared/_gems.html.erb (0.1ms) Rendered /root/projects/rails_db/app/views/rails_db/shared/_footer.html.erb (0.7ms) Completed 200 OK in 19ms (Views: 18.3ms | ActiveRecord: 0.2ms) Started GET "/" for 127.0.0.1 at 2019-09-07 01:46:32 -0700 Processing by HomeController#index as HTML Rendering home/index.html.erb within layouts/application  (0.1ms) SELECT id, name, users_count FROM accounts ORDER BY users_count desc LIMIT 10 OFFSET 0 Rendered /root/projects/rails_db/app/views/rails_db/shared/_data_table.html.erb (0.8ms)  (0.1ms) select id, name, age from users order by age desc limit 10 Rendered /root/projects/rails_db/app/views/rails_db/shared/_sql_result.html.erb (0.5ms)  (0.0ms) SELECT COUNT(*) FROM "users"  (0.1ms) SELECT COUNT(*) FROM "users" WHERE "users"."type" IN ('Customer')  (0.0ms) SELECT COUNT(*) FROM "accounts" Rendered home/index.html.erb within layouts/application (5.9ms) Completed 200 OK in 9ms (Views: 7.3ms | ActiveRecord: 0.8ms) Started GET "/rails/db/tables/users/data?sort_column=id&sort_order=desc" for 127.0.0.1 at 2019-09-07 01:46:32 -0700 Processing by RailsDb::TablesController#data as HTML Parameters: {"sort_column"=>"id", "sort_order"=>"desc", "table_id"=>"users"}  (0.1ms) SELECT COUNT(*) FROM "users" Rendering /root/projects/rails_db/app/views/rails_db/tables/data.html.erb within layouts/rails_db/application Rendered /root/projects/rails_db/app/views/rails_db/shared/_exp_col.html.erb (0.0ms) Rendered /root/projects/rails_db/app/views/rails_db/tables/_condition_fields.html.erb (7.1ms) Rendered /root/projects/rails_db/app/views/rails_db/tables/_condition_fields.html.erb (5.7ms)  Load (0.1ms) SELECT "users".* FROM "users" LIMIT ? OFFSET ? [["LIMIT", 30], ["OFFSET", 0]] Rendered /root/projects/rails_db/app/views/rails_db/tables/_row.html.erb (1.3ms) Rendered /root/projects/rails_db/app/views/rails_db/tables/_row.html.erb (1.2ms) Rendered /root/projects/rails_db/app/views/rails_db/tables/_row.html.erb (1.2ms) CACHE (0.0ms) SELECT COUNT(*) FROM "users" CACHE (0.0ms) SELECT COUNT(*) FROM "users" Rendered /root/projects/rails_db/app/views/rails_db/tables/_sql.html.erb (0.0ms) Rendered /root/projects/rails_db/app/views/rails_db/tables/_data.html.erb (39.9ms) Rendered /root/projects/rails_db/app/views/rails_db/tables/data.html.erb within layouts/rails_db/application (40.0ms) Rendered /root/projects/rails_db/app/views/rails_db/shared/_header.html.erb (0.7ms) Rendered /root/projects/rails_db/app/views/rails_db/shared/_sidebar.html.erb (0.8ms) Rendered /root/projects/rails_db/app/views/rails_db/shared/_gems.html.erb (0.1ms) Rendered /root/projects/rails_db/app/views/rails_db/shared/_footer.html.erb (0.6ms) Completed 200 OK in 49ms (Views: 40.8ms | ActiveRecord: 2.7ms)  (0.1ms) SELECT COUNT(*) FROM "users" Started GET "/rails/db/tables/users/destroy?pk_id=1" for 127.0.0.1 at 2019-09-07 01:46:32 -0700 Processing by RailsDb::TablesController#destroy as HTML Parameters: {"pk_id"=>"1", "table_id"=>"users"}  (0.1ms) SELECT COUNT(*) FROM "users"  (0.1ms) DELETE FROM users WHERE id = '1'; Redirected to http://www.example.com/rails/db/tables/users/data Completed 302 Found in 12ms (ActiveRecord: 0.6ms)  (0.1ms) SELECT COUNT(*) FROM "users" Started GET "/rails/db/tables/users/csv" for 127.0.0.1 at 2019-09-07 01:46:32 -0700 Processing by RailsDb::TablesController#csv as HTML Parameters: {"table_id"=>"users"}  (0.2ms) SELECT * FROM users Rendering text template Rendered text template (0.0ms) Sent data users.csv (0.7ms) Completed 200 OK in 3ms (Views: 0.6ms | ActiveRecord: 0.8ms) Started GET "/rails/db/standalone" for 127.0.0.1 at 2019-09-07 01:46:32 -0700 Processing by RailsDb::DashboardController#standalone as HTML Rendering /root/projects/rails_db/app/views/rails_db/dashboard/standalone.html.erb within layouts/rails_db/application Rendered /root/projects/rails_db/app/views/rails_db/dashboard/standalone.html.erb within layouts/rails_db/application (2.2ms) Rendered /root/projects/rails_db/app/views/rails_db/shared/_header.html.erb (1.3ms) Rendered /root/projects/rails_db/app/views/rails_db/shared/_sidebar.html.erb (1.2ms) Rendered /root/projects/rails_db/app/views/rails_db/shared/_gems.html.erb (0.1ms) Rendered /root/projects/rails_db/app/views/rails_db/shared/_footer.html.erb (0.9ms) Completed 200 OK in 8ms (Views: 7.6ms | ActiveRecord: 0.1ms) Started GET "/rails/db/tables/users/xlsx.xls" for 127.0.0.1 at 2019-09-07 01:46:32 -0700 Processing by RailsDb::TablesController#xlsx as XLS Parameters: {"table_id"=>"users"} Rendering /root/projects/rails_db/app/views/rails_db/tables/table.xls.axlsx  (0.1ms) SELECT * FROM users Rendered /root/projects/rails_db/app/views/rails_db/tables/table.xls.axlsx (9.9ms) Rendering text template Rendered text template (0.0ms) Sent data users.xlsx (0.4ms) Completed 200 OK in 12ms (Views: 11.3ms | ActiveRecord: 0.5ms) Started GET "/rails/db/sql?sql=select+%2A+from+users+limit+10" for 127.0.0.1 at 2019-09-07 01:46:32 -0700 Processing by RailsDb::SqlController#index as HTML Parameters: {"sql"=>"select * from users limit 10"}  (0.1ms) select * from users limit 10  (0.2ms) EXPLAIN select * from users limit 10 Rendering /root/projects/rails_db/app/views/rails_db/sql/index.html.erb within layouts/rails_db/application Rendered /root/projects/rails_db/app/views/rails_db/shared/_exp_col.html.erb (0.0ms) Rendered /root/projects/rails_db/app/views/rails_db/sql/_history.html.erb (0.5ms) Rendered /root/projects/rails_db/app/views/rails_db/sql/_explain.html.erb (0.6ms) Rendered /root/projects/rails_db/app/views/rails_db/sql/_results.html.erb (2.6ms) Rendered /root/projects/rails_db/app/views/rails_db/sql/index.html.erb within layouts/rails_db/application (9.6ms) Rendered /root/projects/rails_db/app/views/rails_db/shared/_header.html.erb (0.8ms) Rendered /root/projects/rails_db/app/views/rails_db/shared/_sidebar.html.erb (0.7ms) Rendered /root/projects/rails_db/app/views/rails_db/shared/_gems.html.erb (0.0ms) Rendered /root/projects/rails_db/app/views/rails_db/shared/_footer.html.erb (0.4ms) Completed 200 OK in 14ms (Views: 11.0ms | ActiveRecord: 2.9ms) Started POST "/rails/db/sql-csv.csv?sql=select+%2A+from+users+limit+10" for 127.0.0.1 at 2019-09-07 01:46:32 -0700 Processing by RailsDb::SqlController#csv as CSV Parameters: {"sql"=>"select * from users limit 10"}  (0.1ms) select * from users limit 10  (0.1ms) EXPLAIN select * from users limit 10 Rendering text template Rendered text template (0.0ms) Sent data results.csv (0.2ms) Completed 200 OK in 1ms (Views: 0.1ms | ActiveRecord: 0.2ms) Started POST "/rails/db/sql-xls.xls?sql=select+%2A+from+users+limit+10" for 127.0.0.1 at 2019-09-07 01:46:32 -0700 Processing by RailsDb::SqlController#xls as XLS Parameters: {"sql"=>"select * from users limit 10"}  (0.1ms) select * from users limit 10  (0.1ms) EXPLAIN select * from users limit 10 Rendering /root/projects/rails_db/app/views/rails_db/sql/xls.xls.axlsx Rendered /root/projects/rails_db/app/views/rails_db/sql/xls.xls.axlsx (17.6ms) Rendering text template Rendered text template (0.0ms) Sent data results.xlsx (0.4ms) Completed 200 OK in 19ms (Views: 18.5ms | ActiveRecord: 0.2ms) Started GET "/rails/db/tables/users/edit?pk_id=2" for 127.0.0.1 at 2019-09-07 01:46:32 -0700 Processing by RailsDb::TablesController#edit as JS Parameters: {"pk_id"=>"2", "table_id"=>"users"}  (0.1ms) SELECT COUNT(*) FROM "users"  Load (0.2ms) SELECT "users".* FROM "users" WHERE "users"."id" = ? LIMIT ? [["id", 2], ["LIMIT", 1]] Rendering /root/projects/rails_db/app/views/rails_db/tables/edit.js.erb Rendered /root/projects/rails_db/app/views/rails_db/tables/_edit.html.erb (23.3ms) Rendered /root/projects/rails_db/app/views/rails_db/tables/edit.js.erb (26.6ms) Completed 200 OK in 50ms (Views: 25.7ms | ActiveRecord: 3.0ms) Started PUT "/rails/db/tables/users/update?pk_id=2" for 127.0.0.1 at 2019-09-07 01:46:32 -0700 Processing by RailsDb::TablesController#update as JS Parameters: {"record"=>{"name"=>"JOHN"}, "pk_id"=>"2", "table_id"=>"users"}  (0.1ms) SELECT COUNT(*) FROM "users"  Load (0.1ms) SELECT "users".* FROM "users" WHERE "users"."id" = ? LIMIT ? [["id", 2], ["LIMIT", 1]]  (0.1ms) SAVEPOINT active_record_1 SQL (0.1ms) UPDATE "users" SET "name" = ?, "updated_at" = ? WHERE "users"."id" = ? [["name", "JOHN"], ["updated_at", "2019-09-07 08:46:32.283565"], ["id", 2]]  (0.0ms) RELEASE SAVEPOINT active_record_1 Rendering /root/projects/rails_db/app/views/rails_db/tables/update.js.erb Rendered /root/projects/rails_db/app/views/rails_db/tables/_row.html.erb (1.6ms) Rendered /root/projects/rails_db/app/views/rails_db/tables/update.js.erb (2.5ms) Completed 200 OK in 16ms (Views: 2.2ms | ActiveRecord: 1.0ms) User Load (0.0ms) SELECT "users".* FROM "users" WHERE "users"."id" = ? LIMIT ? [["id", 2], ["LIMIT", 1]] Started GET "/rails/db/tables/users/new" for 127.0.0.1 at 2019-09-07 01:46:32 -0700 Processing by RailsDb::TablesController#new as JS Parameters: {"table_id"=>"users"}  (0.1ms) SELECT COUNT(*) FROM "users" Rendering /root/projects/rails_db/app/views/rails_db/tables/new.js.erb Rendered /root/projects/rails_db/app/views/rails_db/tables/_new.html.erb (6.5ms) Rendered /root/projects/rails_db/app/views/rails_db/tables/new.js.erb (8.2ms) Completed 200 OK in 18ms (Views: 7.2ms | ActiveRecord: 1.5ms)  (0.1ms) SELECT COUNT(*) FROM "users" Started POST "/rails/db/tables/users/create" for 127.0.0.1 at 2019-09-07 01:46:32 -0700 Processing by RailsDb::TablesController#create as JS Parameters: {"record"=>{"name"=>"XXX"}, "table_id"=>"users"}  (0.0ms) SELECT COUNT(*) FROM "users"  (0.1ms) SAVEPOINT active_record_1 SQL (0.1ms) INSERT INTO "users" ("name", "created_at", "updated_at") VALUES (?, ?, ?) [["name", "XXX"], ["created_at", "2019-09-07 08:46:32.317147"], ["updated_at", "2019-09-07 08:46:32.317147"]]  (0.0ms) RELEASE SAVEPOINT active_record_1 Rendering /root/projects/rails_db/app/views/rails_db/tables/create.js.erb Rendered /root/projects/rails_db/app/views/rails_db/shared/_exp_col.html.erb (0.2ms) Rendered /root/projects/rails_db/app/views/rails_db/tables/_condition_fields.html.erb (5.9ms) Rendered /root/projects/rails_db/app/views/rails_db/tables/_condition_fields.html.erb (5.7ms)  Load (0.2ms) SELECT "users".* FROM "users" LIMIT ? OFFSET ? [["LIMIT", 30], ["OFFSET", 0]] Rendered /root/projects/rails_db/app/views/rails_db/tables/_row.html.erb (2.2ms) Rendered /root/projects/rails_db/app/views/rails_db/tables/_row.html.erb (2.1ms) Rendered /root/projects/rails_db/app/views/rails_db/tables/_row.html.erb (2.0ms)  (0.1ms) SELECT COUNT(*) FROM "users" CACHE (0.0ms) SELECT COUNT(*) FROM "users" Rendered /root/projects/rails_db/app/views/rails_db/tables/_sql.html.erb (0.4ms) Rendered /root/projects/rails_db/app/views/rails_db/tables/_data.html.erb (55.8ms) Rendered /root/projects/rails_db/app/views/rails_db/tables/create.js.erb (58.9ms) Completed 200 OK in 75ms (Views: 55.5ms | ActiveRecord: 4.1ms)  (0.1ms) SELECT COUNT(*) FROM "users" Started GET "/rails/db/tables/users/edit?pk_id=3" for 127.0.0.1 at 2019-09-07 01:46:32 -0700 Processing by RailsDb::TablesController#edit as JS Parameters: {"pk_id"=>"3", "table_id"=>"users"}  (0.1ms) SELECT COUNT(*) FROM "users"  Load (0.1ms) SELECT "users".* FROM "users" WHERE "users"."id" = ? LIMIT ? [["id", 3], ["LIMIT", 1]] Rendering /root/projects/rails_db/app/views/rails_db/tables/edit.js.erb Rendered /root/projects/rails_db/app/views/rails_db/tables/_edit.html.erb (9.0ms) Rendered /root/projects/rails_db/app/views/rails_db/tables/edit.js.erb (9.9ms) Completed 200 OK in 24ms (Views: 8.6ms | ActiveRecord: 1.9ms) Started PUT "/rails/db/tables/users/update?pk_id=3" for 127.0.0.1 at 2019-09-07 01:46:32 -0700 Processing by RailsDb::TablesController#update as JS Parameters: {"record"=>{"name"=>"STI"}, "pk_id"=>"3", "table_id"=>"users"}  (0.1ms) SELECT COUNT(*) FROM "users"  Load (0.1ms) SELECT "users".* FROM "users" WHERE "users"."id" = ? LIMIT ? [["id", 3], ["LIMIT", 1]]  (0.2ms) SAVEPOINT active_record_1 SQL (0.1ms) UPDATE "users" SET "name" = ?, "updated_at" = ? WHERE "users"."id" = ? [["name", "STI"], ["updated_at", "2019-09-07 08:46:32.434047"], ["id", 3]]  (0.0ms) RELEASE SAVEPOINT active_record_1 Rendering /root/projects/rails_db/app/views/rails_db/tables/update.js.erb Rendered /root/projects/rails_db/app/views/rails_db/tables/_row.html.erb (1.9ms) Rendered /root/projects/rails_db/app/views/rails_db/tables/update.js.erb (2.6ms) Completed 200 OK in 27ms (Views: 2.3ms | ActiveRecord: 1.2ms) Customer Load (0.1ms) SELECT "users".* FROM "users" WHERE "users"."type" IN ('Customer') AND "users"."id" = ? LIMIT ? [["id", 3], ["LIMIT", 1]] Started GET "/admin/tools/db" for 127.0.0.1 at 2019-09-07 01:46:32 -0700 Processing by RailsDb::DashboardController#index as HTML Rendering /root/projects/rails_db/app/views/rails_db/dashboard/index.html.erb within layouts/rails_db/application Rendered /root/projects/rails_db/app/views/rails_db/dashboard/index.html.erb within layouts/rails_db/application (0.9ms) Rendered /root/projects/rails_db/app/views/rails_db/shared/_header.html.erb (4.9ms) Rendered /root/projects/rails_db/app/views/rails_db/shared/_sidebar.html.erb (1.2ms) Rendered /root/projects/rails_db/app/views/rails_db/shared/_gems.html.erb (0.1ms) Rendered /root/projects/rails_db/app/views/rails_db/shared/_footer.html.erb (0.7ms) Completed 200 OK in 12ms (Views: 10.8ms | ActiveRecord: 0.1ms) Started GET "/admin/tools/db/sql" for 127.0.0.1 at 2019-09-07 01:46:32 -0700 Processing by RailsDb::SqlController#index as HTML Rendering /root/projects/rails_db/app/views/rails_db/sql/index.html.erb within layouts/rails_db/application Rendered /root/projects/rails_db/app/views/rails_db/shared/_exp_col.html.erb (0.0ms) Rendered /root/projects/rails_db/app/views/rails_db/sql/_history.html.erb (0.5ms) Rendered /root/projects/rails_db/app/views/rails_db/sql/index.html.erb within layouts/rails_db/application (6.1ms) Rendered /root/projects/rails_db/app/views/rails_db/shared/_header.html.erb (1.6ms) Rendered /root/projects/rails_db/app/views/rails_db/shared/_sidebar.html.erb (1.2ms) Rendered /root/projects/rails_db/app/views/rails_db/shared/_gems.html.erb (0.1ms) Rendered /root/projects/rails_db/app/views/rails_db/shared/_footer.html.erb (0.8ms) Completed 200 OK in 12ms (Views: 9.9ms | ActiveRecord: 2.2ms)  (0.1ms) rollback transaction  (0.0ms) begin transaction ------------------------------------------------------------------------------------------------------------------------- TablesHelperTest: test_method_display_style_column_returns_'display:none'_if_cookie_contains_record_for_this_table:column -------------------------------------------------------------------------------------------------------------------------  (0.0ms) rollback transaction  (0.0ms) begin transaction ---------------------------------------------------------------------------------------------------------------------------------- TablesHelperTest: test_method_column_is_checked?_returns_false_for_checkbox_status_if_cookie_contains_record_for_this_table:column ----------------------------------------------------------------------------------------------------------------------------------  (0.1ms) rollback transaction  (0.0ms) begin transaction ----------------------------------------------------------------------------------------------------------------------------------------- TablesHelperTest: test_method_column_is_checked?_returns_true_for_checkbox_status_if_cookie_does_not_contain_record_for_this_table:column -----------------------------------------------------------------------------------------------------------------------------------------  (0.0ms) rollback transaction  (0.0ms) begin transaction ---------------------------------------------------------------------------------------------------------------------------- TablesHelperTest: test_method_display_style_column_returns_'display'_if_cookie_does_not_contain_record_for_this_table:column ----------------------------------------------------------------------------------------------------------------------------  (0.0ms) rollback transaction  (0.0ms) begin transaction ------------------------------------------------------------------------------------------------------------------------------------ TablesHelperTest: test_method_column_is_checked?_returns_true_for_checkbox_status_if_cookie_does_not_contain_hash_key_for_this_table ------------------------------------------------------------------------------------------------------------------------------------  (0.0ms) rollback transaction