aboutsummaryrefslogtreecommitdiffstats
path: root/Source
Commit message (Collapse)AuthorAgeFilesLines
* • further progress on the BIT field sheet editorBibiko2010-09-152-23/+82
|
* • Custom Query EditorBibiko2010-09-151-49/+67
| | | | | - Shift Left now also considers leading SPACES (issue 822) - changed approach for Shift Right/Left of a selection: instead to iterate through all lines do a simple find&replace which is much more faster (4x) and additionally it improves the undo behaviour
* • added validation for BIT fields while in-cell-editing; only 1 or 0 are ↵Bibiko2010-09-152-12/+27
| | | | | | allowed to type in • enabled max length and BIT field validation for CustomQuery
* More work on tab creation target and actionavenjamin2010-09-151-3/+3
|
* Add ability to double click the empty area of the tab bar to create a new tab.avenjamin2010-09-151-0/+1
| | | | - Slightly limited in that the addTabButton's target and action must be set for it to work.
* • some further bit field editing preparationsBibiko2010-09-155-223/+437
| | | | | | • re-enabled length checking while editing in FieldEditorSheet • FieldEditorSheet now shows field type declaration • some preparations for BINARY editing in FieldEditorSheet
* Enable column sorting in the server processes window. Implements issue #816.stuconnolly2010-09-151-0/+14
|
* - Fix row count tracking when deleting table rows; this fixes Issue #819rowanbeentje2010-09-141-5/+5
|
* - Remember to manually update the export source when updating the UI ↵stuconnolly2010-09-141-7/+19
| | | | | | | programmatically as doing so does not fire the controls action. Fixes issue #821. - Improve UI validation on the export dialog when switching between export types.
* • (re?)enabled BIT field editing esp. for field types like BIT(9) or ↵Bibiko2010-09-142-2/+8
| | | | | | | BIT(63) since the old _int2bin routine didn't work because we're dealing with a char* containing bytes if BIT(>8) - also for views and CustomQuery editing • started to clean up (VAR)BINARY editing (work in progress)
* - Implement support for MySQL over SSL for both TCP/IP and Socket ↵rowanbeentje2010-09-135-66/+351
| | | | | | | | | | connection modes. - Upgrade the MySQL binaries to version 5.1.50 (was 5.1.46) - Enable SSL support in the MySQL libraries (this leads to a large increase in library size, unfortunately) - Enable more optimisations in the MySQL libraries (especially --enable-assembler for faster in-library string processing and --with-mysqld-ldflags=-all-static) This completes support for Issue #27.
* • fix editing validation and doCommandBySelector: stuff for SPCustomQuery ↵Bibiko2010-09-131-1/+3
| | | | | | class to allow eg entering favorite names, typing search pattern for favs and history etc. - this fixes 813
* • fixed issue for showing the optimized field type; it can return NULL; if ↵Bibiko2010-09-131-2/+2
| | | | so display nothing found message
* * Fix string width as reported by Alexander Vasiliev (ru)dmoagx2010-09-121-1/+1
| | | | * Make the table status tab date formatter use medium style or the string would be too large at smallest window width
* • added to Structure source table's context menu item: "Show optimized ↵Bibiko2010-09-122-0/+50
| | | | field type" which will come up with a suggested field type calculated by PROCEDURE ANALYSE(0,8192)
* • SPTableStructure's source table saves its column widthsBibiko2010-09-101-1/+0
| | | | • SPQueryController: removed unnecessary [table reloadData]
* • SPTableStructureBibiko2010-09-101-1/+1
| | | | - fixed bug for renaming a field name (issue 808)
* • TableStructureBibiko2010-09-101-4/+4
| | | | - fixed monoSpacedFont for index table refresh and setting
* • TableStructureBibiko2010-09-101-160/+113
| | | | | | | | - added basic field type and argument validations like unsigned should not be used for string types, etc. - added field types DEC, FIXED, NUMERIC for validation - simplified addRowToDb code to avoid double-coding - after removing a field preserve the focus on the source table for keyboard navigation - minor code improvements
* • TableStructureBibiko2010-09-101-85/+189
| | | | | | | - added support for field types SERIAL and BOOL(EAN) - added extra setting and support for SERIAL DEFAULT VALUE - fixed several string comparisons based on user input, ie trim it and compare it upper or lower cased resp. - if adding or changing of a field fails display the SQL statement which caused the error in the error sheet for better debugging
* • TableStructureBibiko2010-09-102-17/+91
| | | | | | - moved field type suggestions for combobox as data source to SPTableStructure - applied type combobox lowercased completion while typing - improved DEFAULT handling for any numeric, date, time fields if DEFAULT was set to an empty string '' - if so skip it to avoid unnecessary error messages
* • fixed _supportsEncoding setting to dis/enable safely Database > View ↵Bibiko2010-09-101-1/+6
| | | | Using Encoding
* • for Structure editing: try to save a row being edited _before_ the row ↵Bibiko2010-09-091-0/+7
| | | | selection will change - mainly if user changes something via mouse event on comboboxes or popupbuttons; if saving fails suppress the new row selection
* • Structure editingBibiko2010-09-092-46/+75
| | | | | | | - fixed issue while drag&drop an auto_inc field > ignore DEFAULT - fixed several keyboard navigation issues - further code improvements - fixed encoding editing
* • StructureBibiko2010-09-091-0/+8
| | | | - reset collation if encoding was changed
* • [SPDatabase getDatabaseCollationsForEncoding:] now uses a cache to ↵Bibiko2010-09-093-7/+34
| | | | | | | | reduce the querying of info_schema - this fixes the querying of each reloadData in [SPTableStructure objectValueFor:] • autoreleased mutableCopy in [SPTableStructure loadTable] • fixed drag&drop query in SPTableStructure to copy charset and collation as well
* • TableStructureBibiko2010-09-093-446/+484
| | | | | | | - changed: field information are retrieved via [SPTableData columns]; mainly to get all infos like comment, encoding, and collation - added the chance to edit encoding, collation, and comment for each field Note: This is work is progress - not yet optimized but fully workable. Due to GUI I simply added these three columns - improvements will follow
* - Alter the connection view layout, moving the connection details forms ↵rowanbeentje2010-09-092-2/+34
| | | | | | | into a scrollview. Switch to centering the form in code, which allows better control and automatic scrollview triggering if the window is too small. - Reduce the minimum window size to 700x400, addressing Issue #788, now the connection view is no longer the constraining factor.
* - Add a further UI hint in the form of a accessory view to the SSH key ↵rowanbeentje2010-09-084-14/+23
| | | | | | | location dialogs (Note: r2615 and this commit both shamelessly stole the UI concept from Transmit 4; thanks to Panic for the inspiration!)
* - Add support for SSH identity files (public keys) in custom locationsrowanbeentje2010-09-087-4/+140
| | | | | | - Update localisable strings - Fix initial window position
* • CSV Import into new table:Bibiko2010-09-061-4/+79
| | | | | | | | - do not create a field in beforehand if user set it to "Do Not Import" - added ROUGH field type guessing by parsing the up to 100 first rows distinguishing text versa integer and size: -- for integer distinguishes between INT and BIGINT due to number length -- for text distinguishes between VARCHAR(255), VARCHAR(32767) [for MySQL >= 5 only], and TEXT due to maximum string length
* • CSV Import Mapper sheet:Bibiko2010-09-062-44/+197
| | | | | | | | - added keyboard shortcut ⌘T to show available tables list - added chance to add a new columns to an existing table (⌘⌥A) - added chance to remove currently new added columns (⌘⌫) - context menu; to remove all new columns one can reselect the table Note: New columns will be added after pressing 'Import' and before the import process starts; if an error occurred the sheet keeps open to give the user the chance to correct errors whereby successfully created new columns won't be editable anymore.
* - When refreshing table content view, refresh the status information for ↵rowanbeentje2010-09-051-1/+2
| | | | | | | tables as well; this fixes caching of table row count in certain combinations of table sizes and preference values, and should fix Issue #673. - Add a missing Errors.strings localisable strings table
* - Fix incomplete argument logic when deleting multiple rows without indexes ↵rowanbeentje2010-09-052-21/+26
| | | | | | | | (now rolled into argumentForRow: for centralised logic), addressing Issue #791 - Update table row count at bottom of window when deleting rows in the content view - Update localisable strings
* Minor enhancements to the CSV import dialogs new table info sheet (i.e. ↵stuconnolly2010-09-051-2/+6
| | | | | | | | | table encoding and type): - Make the sheet non-resizable, thus removing the visible resize triangle. - Add a cancel button so the user can discard their selection. - Only save the user's selection when they select 'OK'.
* • CSV Import into new TABLEBibiko2010-09-044-53/+156
| | | | | - added button "New" - added chance to change encoding and engine of the new table which will be saved in the Prefs
* • further improvements for CSV import into new tableBibiko2010-09-033-5/+75
| | | | | | | | | - fixed some RETURN/ENTER logic while editing a table cell - added context menu to table for: -- 'Set all Field Types to:' which sets all types to the current selected one ⌘= -- 'Add Column to Table Target' (not yet implemented) - some minor code issues - added Info button which will come up with a GUI for setting new table encoding and engine (not yet implemented)
* • further progress for CSV import into new tableBibiko2010-09-033-13/+80
| | | | | | - added some GUI validations - in new table mode changed 'type' column into self-learning NSComboBoxCells - fixed issue for closing sheet if user press RETURN, only close it if 'Import' button is enable
* • finished the first implementation of CSV Import into new tableBibiko2010-09-036-18/+220
| | | | note:What else is needed for such an import? table encoding settings? ... has to be discussed
* • first preparations to support a CSV import into a new table (not yet ↵Bibiko2010-09-023-66/+234
| | | | | | | | executable) - changed order of target tables: New Table, Refresh List, separator, list of all names - cleaned code a bit * removed check for available tables in SPDataImport, now if no table in db the CSV Field Mapper opens in "New Table" mode
* • CSV Import Field mapperBibiko2010-09-021-1/+0
| | | | - make sure that after Refresh Table List the mapping table will be updated as well
* • Show/Copy Create Syntax now come up with all create syntaxes of selected ↵Bibiko2010-09-012-110/+111
| | | | | | | items • if Create Syntax is a PROC wrap the output by DELIMITER ;; etc. to simplify a copy&paste • merged code for copyCreateTableSyntax into showCreateTableSyntax distinguished by the sender (if sender == self) then copy otherwise show
* Remove an attempt to obtain a bool value from a var that is already one ↵stuconnolly2010-09-011-1/+1
| | | | resulting in a crash when attempting to remove an index. Fixes log: http://spbug.com/l/1007.
* • removed command to make the CustomQuery's table first responder after ↵Bibiko2010-09-011-1/+0
| | | | | | performing queries for now to avoid exceptions like in 1527 - not sure why, it seems to be a thread issue
* - Ensure previous outstanding performSelector: requests are cancelled to ↵rowanbeentje2010-09-011-0/+4
| | | | avoid calls on released objects; this addresses http://spbug.com/l/1408, http://spbug.com/l/254 and http://spbug.com/l/781
* • fixed AppleScript crash after calling 'open' without any parameterBibiko2010-08-311-8/+29
| | | | | | | | - this should fix the issues 108, 1398, 226 , 1157, 1473 • added AppleScript support for command 'print' - it prints the active view • renamed SP classes in sequel-pro.scriptSuite • AppleScript command 'make new document' opens a new window and connects to default automatically if set
* • fixed in field editing mode the editing of BINARY fieldsBibiko2010-08-312-4/+10
|
* - When a table content page reload loads no data, and so triggers a reload ↵rowanbeentje2010-08-301-0/+1
| | | | of the first page, the previous row count was not correctly reset, thus sometimes triggering an exception. This correctly resets the count, addressing http://spbug.com/l/558
* • added some basic VIEW INFORMATION coming from information.schema.VIEWSBibiko2010-08-303-155/+212
|
* • further improvements for in cell editing of view data in TableContent tablesBibiko2010-08-272-135/+138
| | | | | | | - simplified code - reduced number of queries for edit status - WHERE argument to identify first try to avoid using blob data for speed, if field is not identified with ignoring blob data then use blob data as well
generated by cgit v1.2.3 (git 2.25.1) at 2024-11-28 19:46:00 +0000