aboutsummaryrefslogtreecommitdiffstats
path: root/Interfaces
Commit message (Collapse)AuthorAgeFilesLines
* • fixed printing of Extended Table Info if Create Table Syntax view has focusBibiko2010-03-131-34/+43
| | | | | - regardless of focus it prints the table info sheet - only if user selects something then the create syntax will be printed
* Add a 'Keyboard Shortcuts' menu item to the 'Help' menu which opens the page ↵stuconnolly2010-03-101-239/+51
| | | | http://www.sequelpro.com/docs/Keyboard_Shortcuts.
* Uppercase various menu items.stuconnolly2010-03-102-924/+109
|
* • shortened SP_ASLIST_ALL_FIELDS_FROM_SELECTED_TABLE to ↵Bibiko2010-03-091-52/+109
| | | | | | SP_ASLIST_ALL_FIELDS since it's too long • some GUI improvements for Query Fav Editor's "Insert placeholder"
* • changed key shortcuts for Show Completion Lists to ⌥⌘1,2,3 since ↵Bibiko2010-03-091-64/+15
| | | | ^1,2,3 doesn't close an already displayed completion list window (instead an 'h' will be inserted??)
* Fix an exception in the user manager caused by sorting the users list by ↵stuconnolly2010-03-091-23/+22
| | | | making the user manager KVO compliant for the sort descriptors array. Also, add a bunch of comments and general tidy up on SPUserManager.m.
* • added $SP_ASLIST_ALL_FIELDS_FROM_SELECTED_TABLE as pre-defined snippet listBibiko2010-03-092-22/+248
| | | | | • added Show Completion List submenu to the Custom Query Editor gear menu with the items all dbs ^1, all tables ^2, all fields ^3 • if dbStructure is available show these pre-defined completion lists with all info like the completion it does, otherwise fall back to plain style
* • fixed bug in snippet list - now it inserts the chosen item correctly ↵Bibiko2010-03-091-3/+199
| | | | | | | | | | | | | after narrow-down the list • added chance to invoke the snippet list in fuzzy search mode by the template ¦¦a¦b¦¦ • added new snippet placeholders: ¦$SP_ASLIST_ALL_TABLES¦ displays a list of all tables incl. views from the current db ¦$SP_ASLIST_ALL_DATABASES¦ displays a list of all dbs from the current connection This makes it possible to write eg a query fav: USE ¦¦$SP_ASLIST_ALL_DATABASES¦¦; to search via fuzzy mode for a db and to use it
* • improved tooltip behaviour of SPNarrowDownCompletion's tableViewBibiko2010-03-091-2/+261
| | | | • added "Filter Tables…" ^⌥⌘F" to main menu > Table which sets the focus to TablesList's search field if visible
* • added possibility to define a snippet via ¦a¦b¦ – such a snippet ↵Bibiko2010-03-081-32/+58
| | | | | | | | will be shown as completion list with the items “a” and “b” • set auto-completion default Pref setting to true • fixed some auto-completion issues like do not insert common prefix automatically and some others • applied ¦a¦b¦ template to CompletionTokens.plist and some tiny corrections and improvements
* • Favorite Query Editor Bibiko2010-03-082-32/+322
| | | | - added the possibility to insert defined placeholder via a popup button similar to Content Filter Editor to give an hint to user what's possible
* Until we can find a better way of doing this and to prevent a conflict with ↵stuconnolly2010-03-081-5/+7
| | | | the query favourites menu popup, change the 'Filter Content...' menu item's shortcut to control+cmd+F.
* Tidy up the add/remove schema privileges buttons.stuconnolly2010-03-081-55/+50
|
* Fix user manager splitview maximum and minimum sizes.stuconnolly2010-03-081-14/+23
|
* Various user manager improvements including a new outline view contextual menu.stuconnolly2010-03-081-134/+271
|
* Add a new 'Filter Content...' menu item to the 'Table' menu that switches to ↵stuconnolly2010-03-081-9/+100
| | | | the content view and places the focus on the filter field.
* • outsourced keyword completion and function completion lists to ↵Bibiko2010-03-081-5/+61
| | | | | | | | | | | CompletionTokens.plist • SPQueryController manages keyword and function completion lists now; this reduces the memory usage a bit and the list is easier to edit • added pre-defined function argument snippets to CompletionTokens.plist (auto-generated from mysql's HELP) • added Preference option for Editor whether a function completion should insert () and if found the function argument snippets automatically or not - last ) will be linked as autopaired then • changed behaviour for wrapping a selection into `"'() etc. - now it re-selects the original selection after wrapping and in addition last wrap character is now marked as autopair-linked • improved logic for popping up the auto-completion list
* • added to CustomQuery's CMTextView the option to set auto-completion ↵Bibiko2010-03-072-30/+477
| | | | | | on/off, settable in Prefs and gear menu - if inserted completion is marked as function it inserts snippet (${}1:) so far; function parameters as snippets follows soon
* • CSV Import Field MapperBibiko2010-03-061-7/+77
| | | | | - added to INSERT advanced option "Skip existing rows" This option allows to insert only those source file rows which primary keys do not exist. It executes INSERT INTO … ON DUPLICATE KEY UPDATE `pri_key_name` = `pri_key_name`. This statement suppresses all warnings/errors regarding to duplicates pri keys etc. BUT it gives an error if an INSERT… statement of a remaining row was erroneous.
* • CSV Import Field MapperBibiko2010-03-061-26/+239
| | | | | - fixed some issues for displaying the default values for auto_increment and time_stamp • added possibility to change the tab stop width in each CMTextView via Preference setting in Editor window
* • CSV Import Field MapperBibiko2010-03-051-44/+56
| | | | | | - improved some validation logic - added "Match Field" to source file field popup to be consistent if UPDATE is chosen - the label "Advanced" is now clickable as well
* • CSV Import Field MapperBibiko2010-03-051-834/+985
| | | | | | | | | | | - removed Advanced sheet, instead resize the main sheet and display these settings in it - added advanced options LOW/HIGH_PRIORITY - improved logic for adv. settings, disabling UPDATE if target table has less than 2 fields, etc. - fixed URL for displaying the source file name - removed Help text since it's too large - should be go to the general help • CMTextView - fixed bug if ESC Completion is invoked if caret position is 0 • fixed document URL handling to come up with the correct icons etc.
* • CSV Import Field MapperBibiko2010-03-031-69/+142
| | | | - further work on UPDATE (not yet activated)
* Localise SPExtendedTableInfo.m and remove use of multiple comments for ↵stuconnolly2010-03-031-0/+0
| | | | localised strings.
* - Addition and enabling of crash reporting and exception reporting, ↵rowanbeentje2010-03-031-1/+11
| | | | submitting to a new online repository. Integrates the FeedbackReporter framework.
* • REPAIR, OPTIMIZE, ANALYZE, FLUSH, CHECKSUM now can be applied to more ↵Bibiko2010-02-261-34/+88
| | | | | | | | than one selected item in the TablesList; if no error alert OK, if not or for CHECKSUM list the output in a table view - while sheet is open showing the accessory table user can press ⌘C for copying it - added missing NSLocalizeStrings • fixed a tiny issue for $SP_SELECTED_TABLES
* • Query Favorites:Bibiko2010-02-251-127/+861
| | | | | | | | - added snippet variable $SP_SELECTED_TABLES which inserts `table1`,`table2`, etc. (ONLY tables) • improved "Check Table" - now one can select more than one table to execute "CHECK TABLE table1,table2,… ; if all tables passed successfully alert OK, if not show the result as accessory table in the sheet note: OPTIMIZE, REPAIR, FLUSH, CHECKSUM, ANALYZE follow
* • fixed GUI resize behaviour of the auto_inc value input fieldBibiko2010-02-231-1/+1
|
* • Reset AUTO_INCREMENT in Table Info Pane uses inline entering of the new ↵Bibiko2010-02-231-33/+416
| | | | | | | | | | value (no sheet) • "Delete all records" confirmation sheet shows a checkbox "Reset AUTO_INCREMENT after deletion" if PRI key is given for that table • minimized table data querying for auto_inc • optimized auto_inc change notification • if user changes tabVIew to Table Info Pane update data in beforehand • TRUNCATE query updates auto_inc value as well in TABLE INFORMATION
* • implemented chance to reset AUTO_INCREMENT of the PRIMARY KEY field in ↵Bibiko2010-02-221-55/+356
| | | | | | | | Table Info Pane via Advanced popup button and sheet (not yet optimal GUI solution) • SPAlertSheets - ensure that this sheet becomes the keyWindow
* • implemented chance to reset AUTO_INCREMENT of the PRIMARY KEY field in ↵Bibiko2010-02-221-11/+32
| | | | | | Structure Pane via right-click at the index tableView - implementation in the Table Info follows soon
* • initial work to give the chance to reset the table's AUTO_INCREMENT valueBibiko2010-02-221-45/+544
| | | | - not yet active
* • CSV Import Field MapperBibiko2010-02-211-74/+573
| | | | | - added Advanced sheet for setting IGNORE, DELAYED, ON DUPLICATE KEY UPDATE '<string>' for INSERT/REPLACE INTO • if during import CSV Import an error occurred show SP Console
* • fixed keyboard behaviour of "Create Sytax Sheet"Bibiko2010-02-201-13/+131
| | | | | | - specified first responder to avoid pressing ↩ twice before closing sheet - ESC also closes that sheet - fixed tab behaviour for keyboard navigation
* • added the chance to the user-defined Content Filter Editor to specify ↵Bibiko2010-02-191-15/+180
| | | | whether the leading <field> placeholder should be suppressed or not in order to be able to write a filter like "LENGTH($CURRENT_FIELD)>${}"
* • CSV Import Field MapperBibiko2010-02-191-9/+29
| | | | | | | - added to csv field popup menu: "Ignore all fields", "Import all fields" - if user changed a matching pair field change the "Align fields by:" to "custom order" to make it more transparent - if user inserts a just added global var to a field which was set to "Ignore field" set it to "Import field" - unified some messages
* • CSV Import Field MapperBibiko2010-02-181-28/+97
| | | | | - some tiny improvements like "Add global value…" adds a new value automatically; if checkbox "Use current value" is ticked use that value in mapping array automatically to speed up defining global vars - some code cosmetics
* • CSV Import Field MapperBibiko2010-02-181-83/+57
| | | | | | | | | - added the csv source field popu: "Ignore field" to set the current field to doNotImport "Add global value…" which opens the global value sheet - removed "Add global value" button Note: still not the optimal solution - further work is needed. esp. avoid jittering if user selects "Ignore field" or "Add value…"
* • CSV Import Field MapperBibiko2010-02-181-60/+124
| | | | | - allow to define a list of global variables (incl. a true NULL value) - such a global variable will be inserted into the mapped table target field for all rows imported
* • TableDumpBibiko2010-02-171-15/+74
| | | | | | | | - introduced new method: - (void)showErrorSheetWithMessage:(NSString*)message to unify it and made all error sheets doc-modal (not app-modal) - Close button of the errorSheet now also listens at ESC
* • further progress for 'add global source value'Bibiko2010-02-171-18/+584
| | | | | | | | | | | | • remember last chosen field alignment in csv field mapper in the prefs • improved 'matching names' algorithm; now it can handle this: csv: a b c table: c d a b → c - c d a - a b - b
* • csv file import mapperBibiko2010-02-171-4/+62
| | | | | | - added button "Go Back" ⌥← to go back to the file chooser (mainly for correcting delimiter etc.) - improved selecting csv file columns for the case that column was set as 'Do not import'; now if set to 'Do not import' the value is hidden, click the user on it the popup menu appears and the operator is set to 'Do import' automatically • TableDump now remembers the last chosen csv file name
* • csv field mapperBibiko2010-02-161-20/+51
| | | | | - added chance to align the csv field and table field names via 'matching names' which uses the Levenshtein distance [first approach] if csv file's first line is an header
* • csv field mapperBibiko2010-02-161-15/+39
| | | | | | - added target table field primary key info - added to align the csv fields by 'file order' and 'reversed file order'
* • csv field mapperBibiko2010-02-161-25/+80
| | | | | | - added target table field type and default info - disable Import button if no target table fields are available
* • removed arrowsBibiko2010-02-161-35/+11
| | | | • fixed spellings
* • improved csv field mapper GUI a bitBibiko2010-02-161-22/+153
|
* • field mapper controllerBibiko2010-02-161-24/+494
| | | | | | | | | | - fixed precocious releasing of mapper settings - fixed boolean binding for displaying "1 of first 100 records" - added further gui elements (not yet activated) - sheet dimensions are now auto-saved - bound keystroke ⇢ and ⇠ to row stepper - renamed some stuff - added clarification notes
* • re-factored and outsourced the entire CSV import field mapper sheetBibiko2010-02-162-1157/+296
| | | | | | | | | | | | | | | | | | - changed the way to choose whether a source field should be imported or not by introducing a new table column 'operators' - clicking at the 'operator's header toggles all operators to 'Import' or 'Do not import' - added tooltips for each table cell; if file's first line are the headers show them in the tooltips as well - added checkbox "First line contains fields names" since it'll be clear in this pane whether a file has a header line or not (will be sync with prefs) - added the possibility to choose the import method: INSERT INTO or REPLACE INTO • deleted all old field mapper stuff from TableDump and DBView.xib Notes: - tests are needed to be sure that this change does not cause mismatches while importing - symbols for Do (not) import are tendative - maybe use images - a further import method UPDATE plus an operator '=' will be added soon - chance to add a new global source variable will come soon - displaying of source field types will come soon - semi-automatically matching of source field names and header names will come soon - the GUI needs some improvements afterwards
* • some further progress for the new csv import field mapper sheetBibiko2010-02-151-75/+73
|
generated by cgit v1.2.3 (git 2.25.1) at 2024-11-08 18:07:20 +0000