aboutsummaryrefslogtreecommitdiffstats
path: root/Source
Commit message (Collapse)AuthorAgeFilesLines
* - Correctly SQL export views with interdependencies on other views or ↵rowanbeentje2009-06-272-1/+79
| | | | tables, resolving Issue #313
* Improve custom query timing and display:rowanbeentje2009-06-275-17/+21
| | | | | | | - Amend timing using clock() to timing based on mach_absolute_time() (see revision comment on Google code) - Ensure the time returned is for the requested query and not subsequent helper queries - Use NSNumberFormatter to return a localised "< 0.1 ms" rather than the hardcoded Euro-style "< 0,1 ms"
* • fixes for Create Syntax HUD window:Bibiko2009-06-261-1/+1
| | | | | | | - added minimum size to avoid overlapping context and header - now keyboard, mouse events are working for scrolling - bound font to CustomQueryEditorFont • removed tiny double code in TableDocument
* • fixed issue for sorting the Custom Query table via clicking at the ↵Bibiko2009-06-261-2/+4
| | | | header if no ORDER BY statement was found in the original statement
* - Printing of backgrounds is now correctly separated from the WebKit ↵rowanbeentje2009-06-253-3/+18
| | | | preferences, and no longer links SP to Safari
* - Revert r844, making background printing draw from the print accessory ↵rowanbeentje2009-06-252-3/+1
| | | | view again. Improve by setting background printing to on by default, read on startup.
* • some work on SPFieldEditorBibiko2009-06-252-6/+172
|
* • added SPFieldEditor classBibiko2009-06-252-0/+419
| | | | - (not yet fully implemented)
* • trial to improve the Undo behaviour in the Custom Query editorBibiko2009-06-251-1/+3
|
* - Set an appropriate error message if the MySQL connection could not be ↵rowanbeentje2009-06-251-1/+5
| | | | established because the required tunnel isn't available. Resolves Issue #310.
* - Make changes to the table structure flush the appropriate table data cachesrowanbeentje2009-06-244-8/+34
| | | | | | - SPTableData's columnWithName: now updates caches as necessary to avoid issues - Mark the extended table info view (particularly the CREATE TABLE syntax) as requiring update following table structure changes
* - We have always allowed setting "on update CURRENT_TIMESTAMP" for ↵rowanbeentje2009-06-242-0/+17
| | | | timestamp columns - parse out this information, and now also show if it's set in the structure view. Fixes the setting not appearing to work.
* Change the remove relation confirmation dialog to a sheet as opposed to a ↵stuconnolly2009-06-241-34/+48
| | | | modal dialog.
* - Fix default values behaviour - previously, default values weren't being ↵rowanbeentje2009-06-241-15/+15
| | | | saved. They are now.
* • initial trial to make Custom Query's result table sortable by clicking ↵Bibiko2009-06-242-11/+58
| | | | at a column header
* Remove table column from relations table view as its redundant data.stuconnolly2009-06-241-1/+0
|
* • added separate Menu "Context Menu (Table List)" to DBView.xibBibiko2009-06-242-1/+62
| | | | | | - it's used for the contextual menu for the Table List • fixed: contextual menu in Table List
* - Fix some warnings for setTitlebarStatus methodavenjamin2009-06-241-0/+1
|
* - Modified titlebar display of SSH statusavenjamin2009-06-243-12/+41
|
* • Custom Query fixes:Bibiko2009-06-242-61/+69
| | | | | - preserve table width/order after editing - updated data source code to avoid having the data twice in the memory
* • changes in editSheet:Bibiko2009-06-243-12/+75
| | | | | | - generate Hex representation on demand (this speeds up the working with images enormously) - added support to paste image data via the pasteboard (data are stored as TIFF LZW compressed) - if user switched to an other view (text/iamge/hex) that view will be become first responder explicity (fixes an issue that the Open button got the focus sometimes)
* Implement some of the points suggested in issue #309:stuconnolly2009-06-241-14/+14
| | | | | | - All menu items which show a panel of some kind before completing the action need to have "..." after the menu item name. - All menu items which do something destructive (drop table, truncate table) need to default to the CANCEL button in their alert message.
* • tried to unify the displaying of error messages (mainly converted them ↵Bibiko2009-06-242-11/+29
| | | | | | | | into sheets) • changed the alert for "Truncate table" - "Are you sure you want to delete ALL table records in the..." • added BWToolkitFramework copyright notice to credits.rtf
* - Tweak to table relations to allow data refreshing to optionally clear the ↵rowanbeentje2009-06-231-28/+37
| | | | master data cache; removes the duplicate CREATE TABLE command on table load, reducing overall queries and so improving speed further
* • added to SPDataAdditions:Bibiko2009-06-234-67/+48
| | | | | | - (NSString *) shortStringRepresentationUsingEncoding: --mainly used for displaying large blob data in a tableView • tiny speed improvements for tableView:objectValueForTableColumn and tableView:setObjectValueForTableColumn in Content Browser and Custom Query
* • fixed several problems for alerting an error sheet inside of a ↵Bibiko2009-06-234-10/+46
| | | | didEndSelector: of an other sheet
* - Add BWToolkit Framework to allow for better control over some UI elementsavenjamin2009-06-231-49/+49
| | | | | | | - Add TABLE INFORMATION toggle button - shows/hides pane - Used new UI elements in Copy Table Syntax HUD window - Misc other changes - NOTE: more splitview changes to be made
* • fixed issue while editing an field cell in Structure View select an ↵Bibiko2009-06-231-28/+36
| | | | | | | other table • fixed issue while moving a field description row in Structure View that "Extra" field content wasn't moved • fixed issue that "Extra" field content was appended without leading space in "addRowToDB"
* • fixed issue for showing an error alert sheet inside of a endSheet ↵Bibiko2009-06-232-6/+27
| | | | | | | | | selector of an other sheet: - introduced -(void)showErrorSheetWithTitle:(id)error -- error is an array of title and message - this can be called via [self performSelector:@selector(showErrorSheetWithTitle:) withObject: afterDelay:] - this avoids a crash of the current table window
* • added SPDataCellFormatter to data cells of the Custom Query tableBibiko2009-06-232-26/+35
| | | | | | | | • in Content Browser send only the first 255 bytes to the cell formatter (makes it a tick faster) • fixed for editing in Content Browser if row contains binary blob data: - use = instead of LIKE operator in UPDATE statement - binary data will converted into X'...' representation
* • moved dataToHex as dataToFormattedHexString from TableContent to ↵Bibiko2009-06-234-91/+90
| | | | SPDataAdditions in order to you that method in different classes
* • added to the CustomQuery class the multipleLineEditingButton IBOutletBibiko2009-06-231-0/+1
|
* • fixed: make usage of backtickQuotedString to allow table names ↵Bibiko2009-06-233-60/+82
| | | | | | containing a ` • some minor code cleaning and commenting
* - Improve r911 (initial Custom Query editability) to allow editing of rows ↵rowanbeentje2009-06-221-13/+13
| | | | containing NULL values and editing data in tables with names containing backticks
* • first trial to make the result table in the Custom Query editable for ↵Bibiko2009-06-222-45/+225
| | | | such fields which can be identified bijectively by the given table data
* - Improve support for MySQL running in ANSI mode (or ANSI_QUOTES), fixing a ↵rowanbeentje2009-06-221-39/+41
| | | | cause of the content tab not loading for some users
* • improved: "Copy as SQL INSERT" in Custom Query passes the original table ↵Bibiko2009-06-221-6/+23
| | | | name (not that one defined via "AS") if the result columns' table source is the same, otherwise <table>.
* • first steps to synchronize CustomQuery table and ContentTableBibiko2009-06-224-8/+90
| | | | | | - CustomQuery table now allows to copy selected rows as SQL INSERT (table name is set to "<table>" - if a field is a blob display only the first 255 bytes/chars in the CQ table for speed reasons - blob fields in CQ does not listen to the pref setting for "LoadBlobsAsNeeded" because it could happen that no one-to-one relation to their original data will be found
* - Allow connections via SSH tunnels to reattempt using the specified host ↵rowanbeentje2009-06-216-30/+122
| | | | | | | | | if 127.0.0.1 was retried automatically. - Store the SSH debug logs and allow viewing on connection error - Clean up CMMCPConnections on connection failure - Fix connection keepalive instantiation
* • changed: if the current edited field is a "ENUM" fieldBibiko2009-06-211-1/+5
| | | | | - show NULL in the combobox only if NULL value is allowed for the current field - display NULL value according to prefs' setting for NULL value
* • some code cleaning and tiny performance enhancements for various ↵Bibiko2009-06-213-84/+100
| | | | for/while loops
* Issue #305 now fully resolved, remove debug.stuconnolly2009-06-211-3/+1
|
* Sparkle delegate methods doesn't seem to be getting called, so set the ↵stuconnolly2009-06-211-1/+6
| | | | delegate globally.
* Typo, should be the sheet not the window.stuconnolly2009-06-211-2/+2
|
* Fix for issue #305. Close all sheets attached to all open windows just ↵stuconnolly2009-06-211-0/+22
| | | | before Sparkle relaunches the app.
* • some code cleaning and tiny performance enhancements for syntax highlightingBibiko2009-06-212-39/+41
|
* • queryString: code cleaning and processing each encoding equallyBibiko2009-06-193-30/+39
| | | | | | | | - Since we are using mysql_real_query() there is no need to generate a \0 terminated cString. - The disadvantage of using UTF8String is that it returns NULL if the encoding fails. - To process each encoding equally we can now use [NSString dataUsingEncoding:enc allowLossyConversion:lossy]. In oder to avoid the overhead while calling it the following inline function is introduced: NSStringDataUsingLossyEncoding(aStr, enc, lossy) := [aStr dataUsingEncoding:enc allowLossyConversion:lossy] • import of CSV: code cleaned and optimized for speed a little
* • added: SPDataAdditions.mBibiko2009-06-194-68/+146
| | | | | | | - base64EncodingWithLineLength: • improved printing of blobs which contain image data - not it supports PDF preview - set maximum width to 100px or less
* Fix for issue #285. Also tidy up the add/change row method including ↵stuconnolly2009-06-191-42/+83
| | | | friendlier error message dialogs.
* • added to TableContent.m:Bibiko2009-06-193-1/+121
| | | | | | | | - (NSArray * )currentDataResult -- like currentResult but returns "BLOB" for blob data and a base64 encoded string for images à la <IMG SRC="data:image/auto;base64,"> - (NSString * ) base64EncodingOfData:(NSData * )data withLineLength:(unsigned int)lineLength -- it returns a base64 encoded string of data • changed: currentDataResult is now called for printing from the Table Content Browser