Commit Graph

273 Commits

Author SHA1 Message Date
Mark VanLandingham 30fe9289b8 Allow groups to access queries (#36)
* [WIP] group ids saving on new reports

* Add groups to default queries, and added tab connector

* group_ids set to empty array for default queries

* group reports route (in & and) action

* [WIP] created group reports show route/controller

* Find correct query in show route

* Removed empty array for group_ids in query file

* Add report show view, where users can run queries

* Removed unneeded commas from queries.rb

* Allow non-admin group members to access reports

* query-result component dynamic download url based on location

* Removed accidental changes, and corrected tab size

* Group members can add params to queries

* Specs for new QueryController actions

* remove "Inlude query plan" from group reports

* Run prettier

* return and return -> return render

Co-Authored-By: Robin Ward <robin.ward@gmail.com>

* [WIP] changes from review

* Remove weird [-1] group_ids logic, for a simply check for [] in query update action

* Added integration tests for group report access

* Using guardian for securing endpoints, and much improved specs

* Update assets/javascripts/discourse/components/group-reports-nav-item.js.es6

Co-Authored-By: Robin Ward <robin.ward@gmail.com>
2019-09-11 10:09:41 -04:00
Joffrey JAFFEUX 677722d676 FIX: prevents egression mutating read only object 2019-07-25 07:50:31 +02:00
Joffrey JAFFEUX 8f0bd298b1 fixes prettier 2019-07-16 13:15:27 +02:00
Joffrey JAFFEUX b9169ec28e
REFACTOR: old patterns, deprecations and dead code (#35) 2019-07-16 12:46:32 +02:00
Penar Musaraj ed2e0b8c13 Run Prettier 2019-06-14 13:27:41 -04:00
Penar Musaraj 300c862244 Fix eslint 2019-06-14 12:29:06 -04:00
Sam Saffron 29862defaa FEATURE: add support for _url to link to a url
This new feature means that if you name a column `xyz_url` then the return
value will be treated as a URL.

If you would like to name the link use the format `name,https://cnn.com`
2019-05-13 14:44:51 +10:00
Osama Sayegh 859021bb3c
UX: make SQL editor resizable (#33) 2019-04-07 09:05:43 +03:00
Rishabh 0ed53f7c5e DEV: Remove debug statement in explorer-container.js 2019-02-05 16:42:07 +05:30
Rishabh 6a69daf39a UX: Clean up button styles for query pages
- Add a "play" glyph for the Run & SaveRun buttons
- ensure that there's only one primary button on the page i.e. Run
- Remove btn-danger from discard button
- remove redundant button class from create button
- Improve redundant copy by removing the word "Query"
2019-02-05 14:21:52 +05:30
Rishabh 13ab013df2 FIX: Ensure that all query information persists after delete/un-delete operations
https://meta.discourse.org/t/data-explorer-created-by-missing/107195
2019-01-28 12:30:17 +05:30
Rishabh a285a38e9c FIX: Allow the Data Explorer API to set LIMIT to "ALL"
Fixes a bug that prevented returning unlimited rows.

Example request:
{{base_url}}/admin/plugins/explorer/queries/6/run?api_key={{api_key}}&api_username={{api_username}}&limit=ALL

From the PostgreSQL docs: "LIMIT ALL" is treated as no limit
https://www.postgresql.org/docs/current/static/sql-select.html#SQL-LIMIT
2019-01-23 16:18:06 +05:30
Rishabh a96bfdf6d5 DEV: Remove ESLint warnings 🚨 2019-01-22 17:19:01 +05:30
Rishabh 8720c2cd5c DEV: Replace hardcoded result limit with a module constant 2019-01-21 14:21:53 +05:30
Rishabh f1b33cc64e UX: Make the 'or' text in json-file-uploader smaller than the modal title 2019-01-09 15:24:06 +05:30
Joffrey JAFFEUX 0d655221f4 FIX: ensures filteredContent is recomputed when sortBy changes (#30) 2018-12-28 14:58:28 +05:30
Joffrey JAFFEUX 2b6357f8b4
FIX: ember 3 support 2018-12-16 15:22:23 +01:00
Rishabh 0af2453c23 FEATURE: Make searching case-insensitive 2018-11-16 16:13:40 +05:30
Penar Musaraj 061322e53a Finalize FA5 fixes 2018-11-15 11:12:32 -05:00
Penar Musaraj d05fb698d6 FA5 icon fix 2018-11-08 11:37:23 -05:00
Rishabh Nambiar 47f8de9c35 FIX: Show schema info tooltips inline 2018-11-08 12:04:04 +05:30
Rishabh 344f6e357d
FEATURE: Replace combo-box with search filter (#28)
* FEATURE: Replace combo-box with search filter
* Delete unused listname property and css fixes
* Use ES6 syntax and `@computed` decorator
2018-11-02 18:11:20 +05:30
Rishabh Nambiar 9dcba5c6e7 FEATURE: Allow clickable post titles in Data Explorer result view using post_id 2018-10-23 16:17:46 +05:30
Rishabh Nambiar 9d7db064af run Prettier 2018-10-10 17:31:14 +05:30
Rishabh b352e747c7
FEATURE: Ship default queries with the Data Explorer
Load default queries from queries.rb and save when run.
Each time a query is run, it picks up changes from queries.rb.
2018-10-10 16:59:13 +05:30
Rishabh Nambiar f876cf66f1 Increase result limit from 250 to 1000 2018-09-18 11:24:37 +05:30
Rishabh Nambiar 316923f190 FEATURE: Show the number of results after running a query (limit 250) 2018-09-18 11:15:31 +05:30
Rishabh Nambiar 68059b540e UX: Style improvements in query edit & result view 2018-09-12 18:58:54 +05:30
Rishabh Nambiar 90c2be7f82 FIX: Remove inconsistent row-highlight from the recent queries list 2018-09-12 16:38:08 +05:30
Rishabh Nambiar 1ea20132a0 FIX: Remove an unnecessary Handlebars condition 2018-09-12 14:53:29 +05:30
Rishabh Nambiar dc91b7d0cd FIX: Remove useless no_query_hook text and move create & import buttons to top right 2018-09-07 16:06:23 +05:30
Kris 6904e516ae Removing br tags so an empty description doesn't add space 2018-09-05 13:33:06 -04:00
Kris a8742f4c64 UX: Minor style improvements and consistency 2018-09-04 14:53:12 -04:00
Rishabh Nambiar a518ac58fc FIX: Restrict clickable area to the size of heading-toggle 2018-09-04 21:52:44 +05:30
Rishabh Nambiar 9e27d0b8d3 FIX: Update stylesheet to use indented sass syntax 2018-09-03 00:27:44 +05:30
Rishabh Nambiar 5edb8ea7f8 UX: Make Explorer UI similar to User Activity and Groups pages 2018-08-31 23:41:33 +05:30
Rishabh Nambiar 5a75b6c1e1 FIX: Fix ESLint issues and use d-icon instead of <i> tags 2018-08-30 21:35:43 +05:30
Rishabh Nambiar d5d933c2a8 FEATURE: Sort queries by names, last_run_at by clicking table headers 2018-08-30 17:32:52 +05:30
Rishabh Nambiar 80f97d9514 UX: Force refresh model to update last_run_at after a query is run 2018-08-30 14:13:40 +05:30
Rishabh Nambiar 3bdf624ced UX: Improve padding while editing a query and text-field width consistency 2018-08-29 13:21:02 +05:30
Rishabh Nambiar 0673b68a58 FIX: Make entire row clickable 2018-08-28 12:39:33 +05:30
Rishabh Nambiar 6a57f6536d FIX: Render creation date instead of run date if query was never run 2018-08-28 12:14:43 +05:30
Rishabh Nambiar 1fc73a211a FIX: Improved username alignment 2018-08-28 12:00:25 +05:30
Rishabh Nambiar 1b68847d21 FEATURE: Sort queries by last_run_at as default 2018-08-27 20:10:25 +05:30
Rishabh Nambiar feb8a1ce0f FIX: Don't save placeholder text only if description is empty 2018-08-25 23:02:43 +05:30
Rishabh Nambiar 2f0400a7e0 FIX: Don't save placeholder text if description is empty 2018-08-24 12:43:18 +05:30
Rishabh 71845a3d87
Merge pull request #17 from discourse/fix_default_description_text
FIX: Remove bad default query description and add placeholder instead
2018-08-20 14:05:05 +05:30
Rishabh Nambiar 7647b1597f FIX: Use predefined SCSS colors instead of hardcoded colors 2018-08-20 11:32:41 +05:30
Arpit Jalan 4af28311ab hide controls on query page 2018-08-19 16:28:24 +05:30
Rishabh Nambiar 42b6dbbae2 FIX: Remove bad default query description and add placeholder instead 2018-08-19 10:24:53 +05:30
Rishabh Nambiar 86a4957bd1 FIX: Ensure that back button always redirects to index page 2018-08-17 15:30:07 +05:30
Rishabh Nambiar a64ef6c6c7 Added button to go back to query list after visiting a query 2018-08-16 23:14:07 +05:30
Rishabh Nambiar 83b1fcb54b Added User.find() & fixed scroll history bug 2018-08-14 17:38:08 +05:30
Rishabh Nambiar 6e806cc1df Added clickable rows, default query sorting by id and clickable usernames 2018-08-14 17:38:08 +05:30
Rishabh Nambiar e341d5a6fa List all previous queries on Data Explorer homepage 2018-08-14 17:38:08 +05:30
Régis Hanol 7c94f98436 FIX: prevent creation of query with an empty name 2018-05-09 22:23:56 +02:00
Régis Hanol aca7b188f6 UX: better blank state (create vs select a query) 2018-05-09 22:23:49 +02:00
Kris 7077a646c0 Hide none state from dropdown 2018-05-09 15:49:43 -04:00
Kris 41106fed61 class fix 2018-05-09 14:06:39 -04:00
Kris c6f0284529 Adding placeholder for none state 2018-05-09 14:04:14 -04:00
Guo Xiang Tan bcdff915dc Make eslint happy. 2017-08-02 18:05:33 +09:00
Robin Ward e68813e6dc FIX: You don't need to require the route map, it's automatically found 2017-07-05 14:16:40 -04:00
Robin Ward d82109b00b FIX: Adds back removed component 2017-05-11 12:45:15 -04:00
Arpit Jalan 0d6af9d920 FIX: importing query was broken 2017-04-04 14:07:07 +05:30
Robin Ward 4b3e5d547d FIX: Support raw templates in the latest discourse releases 2016-12-27 11:47:50 -05:00
Robin Ward e2ee693f64 This file should be removed 2016-12-01 13:56:09 -05:00
Robin Ward 91815c9f00 FIX: Remove Deprecated Views 2016-12-01 13:54:21 -05:00
Robin Ward 0d62ad73d4 FIX: Don't have CPs perform sets 2016-11-24 15:31:05 -05:00
Robin Ward f9e1177981 FIX: Invalid use of controller in a component 2016-11-09 12:49:25 -05:00
Robin Ward 8d72e979a5 FIX: Old Ember idioms 2016-11-09 11:58:18 -05:00
Guo Xiang Tan 414cda5578 FIX: Import `ajax` instead. 2016-10-31 09:12:01 +08:00
Robin Ward 37fe36778b FIX: Deprecated debounce function 2016-02-17 17:17:43 -05:00
Sam 587e9d917c fixes so it works in no constants mode 2015-11-21 12:49:23 +11:00
Arpit Jalan 34af6a5d54 FIX: group name can have dash and capital letters 2015-11-19 13:30:33 +05:30
Kane York 9956b9833e Add topic,category,group,reltime rendering 2015-09-21 14:43:23 -07:00
Kane York 9145e32162 FIX: Show error message, not exception page, to mods 2015-09-21 11:19:31 -07:00
Kane York 4b3188c111 Fix rendering of columns named topic_id 2015-09-14 16:00:39 -07:00
Kane York 86a3d16ad4 Deprecations fixes 2015-09-14 15:34:57 -07:00
Kane York 7f96ea5632 Looks like it's working 2015-08-25 21:36:39 -07:00
Kane York e0e7022538 WIP commit 2015-08-25 20:48:19 -07:00
Kane York 658d49393a The new window is not used except by name 2015-08-03 15:28:09 -07:00
Kane York 43756ec8b6 Adjust styling of download results 2015-08-03 15:19:31 -07:00
Kane York cb18bb9cd7 make that even bigger 2015-08-03 15:15:04 -07:00
Kane York aff32aefa1 Move around data explorer UI stuff 2015-08-03 15:14:23 -07:00
Kane York 7201823c6b Remove HTTPS warning 2015-08-03 15:09:51 -07:00
Kane York 1601f4f269 Add 'download results as CSV' 2015-08-03 15:07:29 -07:00
Kane York fb42dc483c Add denormalized column info 2015-07-28 11:18:22 -07:00
Kane York ea1d38da57 Add foreign key info, column comment support 2015-07-28 09:59:26 -07:00
Kane York d79f667a9b Use this.site.categories 2015-07-15 16:16:07 -07:00
Kane York 5156ab1f72 Use HTTP status 422 for failures 2015-07-15 12:51:33 -07:00
Kane York 6a61f694ee Fix float type checks 2015-07-15 12:23:56 -07:00
Kane York 45c2636ea0 Fix boolean parameters 2015-07-15 11:00:31 -07:00
Kane York 5b11bbec68 Finish group/category validation, add user lists 2015-07-14 16:49:23 -07:00
Kane York 0672e99da2 Work on new parameter model 2015-07-14 16:01:38 -07:00
Kane York 198c64d86a Don't show the ace editor right away, wait for edit pencil to be clicked 2015-07-14 10:34:23 -07:00
Kane York c7a947542e Allow expanding/collapsing the schema view 2015-07-14 09:44:42 -07:00
Kane York f67d18d503 Fix the resizing (remove debounce on mousemove) 2015-07-14 09:04:18 -07:00
Kane York 2bbe69d67e Include enum values in schema 2015-07-09 15:46:19 -07:00
Kane York a953f83574 Use appEvents for ace resize 2015-07-09 14:10:45 -07:00
Kane York 09398dc8c2 add bottom pad to explorer page 2015-07-09 13:58:22 -07:00
Kane York 7f644019a8 Add resizing 2015-07-09 13:20:21 -07:00
Kane York d748e0dae5 give instructions in hanging tab 2015-07-09 12:45:02 -07:00
Kane York 71c3b73ef8 FEATURE: 'Download Result' removes 250-row limit 2015-07-09 12:03:25 -07:00
Kane York 7b6b4f9222 Fold plugins-explorer-show into main template 2015-07-09 10:50:00 -07:00
Kane York dad55e085b Restyling of data explorer 2015-07-08 16:46:36 -07:00
Kane York 6ac463290e Add DB schema view beside query editor 2015-07-08 13:45:13 -07:00
Kane York a0f38a2d17 Preserve pre-typed query parameters 2015-07-02 09:19:30 -07:00
Kane York d9dbfc8408 Add text for no queries, keep results in query object 2015-07-02 09:15:55 -07:00
Kane York b68ca164dd CSS chnages 2015-07-01 12:31:55 -07:00
Kane York 88d7fa955a Add HTTPS warning 2015-06-30 21:21:14 -07:00
Kane York 1ea74847ae Display errors, convert integers 2015-06-30 19:51:38 -07:00
Kane York baeb747fcb Fix param-extraction 2015-06-30 16:43:43 -07:00
Kane York a81f8495b0 Update URL. Regression - select2 not updating 2015-06-30 15:56:09 -07:00
Kane York c56a40cacd Import the result table and we're live 2015-06-30 15:12:12 -07:00
Kane York dba181d92e Bunch of progress. Tuesday 1PM 2015-06-30 12:52:17 -07:00
Kane York 78dafcc631 Rename the stylesheet 2015-06-30 10:37:48 -07:00
Kane York ee1cc2d96d Tuesday morning, 10AM 2015-06-30 10:20:22 -07:00
Kane York 95a50e1116 Tuesday morning, 9 AM 2015-06-30 09:07:33 -07:00
Kane York a12c906c9a mostly styling change 2015-06-29 12:10:24 -07:00
Kane York c52ac59eee Missed description sections, try to get model to work 2015-06-26 09:16:09 -07:00
Kane York 2c71bc11aa More work on interface, fixes for backend 2015-06-25 14:53:03 -07:00
Kane York 01b38207d9 Start work on JS side 2015-06-25 13:26:31 -07:00
Kane York 174e6d6ecc Initial commit as a clone of discourse-tagging 2015-06-25 09:25:15 -07:00