aboutsummaryrefslogtreecommitdiffstats
Commit message (Collapse)AuthorAgeFilesLines
* • initial work to give the chance to reset the table's AUTO_INCREMENT valueBibiko2010-02-224-45/+593
| | | | - not yet active
* • this commit should fix the displaying the correct read file size and the ↵Bibiko2010-02-211-6/+6
| | | | | | | file size while importing very large CSV/SQL - replaced deprecated method fileAttributesAtPath:traverseLink: by attributesOfItemAtPath:error: - fix for i549
* • CSV Import Field MapperBibiko2010-02-216-84/+711
| | | | | - 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-202-13/+134
| | | | | | - specified first responder to avoid pressing ↩ twice before closing sheet - ESC also closes that sheet - fixed tab behaviour for keyboard navigation
* • applied new SPTableData keys "PRIMARY" and "UNIQUE" information to the ↵Bibiko2010-02-201-10/+12
| | | | | | mapping table - set tokenField to noWrap
* • added to method informationForTable: Bibiko2010-02-201-12/+37
| | | | | | - the root dict key "primarykeyfield" = <field name> - the key "isprimarykey" for corresponding table field - the key "unique" = 1 if corresponding table field has a UNIQUE KEY
* • removed initial transition of insertion NSNull into table's dataSource ↵Bibiko2010-02-192-11/+8
| | | | from last commit r1824 since that part should be moved maybe into SPTableTextFieldCell
* • fixed color setting for editing a table cell which is set to NULL if ↵Bibiko2010-02-192-9/+15
| | | | | | | | table columns are reordered by the user • initial transition to insert via - up to now - ^⇧N a [NSNull null] object into the table's data source directly without parsing a possible @"NULL" string - it's a first test - and works only for CMCopyTable subclassed tables
* • fixed bug for Content Filter Editor, now $CURRENT_FIELD will be replaced ↵Bibiko2010-02-191-3/+2
| | | | correctly if no ${} argument is passed
* • added the chance to the user-defined Content Filter Editor to specify ↵Bibiko2010-02-194-33/+226
| | | | whether the leading <field> placeholder should be suppressed or not in order to be able to write a filter like "LENGTH($CURRENT_FIELD)>${}"
* • CMTextView completionBibiko2010-02-191-1/+7
| | | | - if user types foo. while completion list is open and no suggestion is found re-invoke completion automatically due to the fact that it's very likely that the user wants to insert either a table or field
* • CSV Import Field MapperBibiko2010-02-192-16/+74
| | | | | | | - 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
* - Fix a data storage incorrect reassignment after a realloc - cause of ↵rowanbeentje2010-02-191-5/+4
| | | | source view changes/content view update crashes, and almost certainly memory leaks and other crashes
* • fixed threading issue if user performs query in Custom Query all the ↵Bibiko2010-02-182-9/+3
| | | | | | | time by holding down ⌘R for a long time caused by updating the history - removed unnecessary updating of the historyButton - updating of all docs is now performedOnMainThread:waitUntilDone:NO
* • CSV Import Field MapperBibiko2010-02-183-44/+119
| | | | | - 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-182-85/+84
| | | | | | | | | - 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-1/+1
| | | | - fixed bug, detect if csvimportarray contains global vars correctly
* • CSV Import Field MapperBibiko2010-02-185-63/+185
| | | | | - 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-173-40/+92
| | | | | | | | - 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-176-113/+841
| | | | | | | | | | | | • 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-175-15/+90
| | | | | | - 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-163-25/+104
| | | | | - 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-163-18/+73
| | | | | | - added target table field primary key info - added to align the csv fields by 'file order' and 'reversed file order'
* • csv field mapperBibiko2010-02-163-31/+125
| | | | | | - added target table field type and default info - disable Import button if no target table fields are available
* • removed arrowsBibiko2010-02-163-42/+30
| | | | • fixed spellings
* • improved csv field mapper GUI a bitBibiko2010-02-161-22/+153
|
* • field mapper controllerBibiko2010-02-164-33/+513
| | | | | | | | | | - 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-166-1438/+672
| | | | | | | | | | | | | | | | | | - 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-153-81/+118
|
* • corrected regexp for parsing text macro snippetsBibiko2010-02-151-3/+3
|
* Made Available Privs table not enabled unless a schema is selected.mltownsend2010-02-142-10/+13
|
* • improved text macro snippet behaviourBibiko2010-02-134-48/+90
| | | | | | • improved the ability to run bash commands inside of snippets • ignore most of the syntax highlighting inside snippet declarations • fixed issue in CMTextView to use obj class variables only to generalise this object
* - Implement result view saving in a more general way within CustomQuery; ↵rowanbeentje2010-02-112-20/+102
| | | | now when editing custom query results *and* sorting custom query results, scroll position and selection index are preserved
* - Tweak SPFavoriteTextFieldCell, releasing the hostname on dealloc and ↵rowanbeentje2010-02-111-1/+4
| | | | retaining on copyWithZone: to avoid issues
* Made it so that the host can't be null. Goes to '%' by default.mltownsend2010-02-103-1/+13
|
* Fix a number of memory leaks, and over-releases, as both a result of manual ↵rowanbeentje2010-02-1013-42/+55
| | | | inspection of leaks and Clang static analysis.
* Fixed some issues with the drop user/drop host commands in the user managermltownsend2010-02-094-7/+28
|
* - Save and restore content table sorting, filter criteria, scroll position ↵rowanbeentje2010-02-093-1/+57
| | | | | | | and selection when switching tables and databases. This implements Issue #469. - Fix history bug causing column sorts to always be restored ascending
* Fix bug where adding a user, setting name and password, then immediately ↵mltownsend2010-02-083-16/+43
| | | | hitting Apply didn't end editing in the password field.
* Disable the addition of triggers on versions of MySQL less than 5.0.2 when ↵stuconnolly2010-02-072-14/+40
| | | | support for them was initially added.
* Make the add new trigger sheet resizable to accommodate complex trigger ↵stuconnolly2010-02-071-37/+44
| | | | statements.
* - Trigger a full table reload when the table type is changed; makes ↵rowanbeentje2010-02-063-51/+58
| | | | relations etc immeadiately available on changes to InnoDB, and updates a number of status variables
* Localize delete relation context menu item, update Localizable.strings and ↵stuconnolly2010-02-063-3/+3
| | | | use of multiple keys.
* Complete the implementation of the management of table triggers (accessible ↵stuconnolly2010-02-066-290/+1026
| | | | via Cmd+6). Note, that better support for entering the trigger statement in terms of escaping and delimiter support most likely needs to be added.
* - Tweak the background colours of the NSTableView behind the table filter ↵rowanbeentje2010-02-061-15/+20
| | | | so that background windows have a uniform background colour
* - Restore a missing link between TableDocument and TableRelationsInstance. ↵rowanbeentje2010-02-061-362/+77
| | | | Resolves #559 and #562
* • initial implementation of bash execution inside ${x:…} snippetsBibiko2010-02-061-25/+52
| | | | | | - eg SELECT "${2:$(curl 'http://www.sequelpro.com/index.html' | perl -pe 's/\"/\\"/g')}" - testing phase! - each bash task can be interrupted by ⌘.
* • further preparations to allow to run any bash command(s) incl. any ↵Bibiko2010-02-062-0/+59
| | | | | | | | | scripts like Perl, Ruby, AppleScript etc inside the text macro snippets of the query favorites and insert the result for such a bash command as snippet à la: SELECT ${1:$(cat ~/Desktop/foo.txt)} or ${1:$(open 'http://www.sequelpro.com')} - such a task can be interrupted by pressing ⌘ + . anytime - if the task doesn't exit successfully the error will be written into the the standard Console log - not yet activate
* • improved completion behaviour of suggestions containing spaces; a second ↵Bibiko2010-02-052-5/+12
| | | | space will cancel the list to allow a more natural typing
* • some further work at the new field mapper sheetBibiko2010-02-055-146/+183
|