aboutsummaryrefslogtreecommitdiffstats
path: root/Source/SPConstants.h
Commit message (Collapse)AuthorAgeFilesLines
* Complete the implementation of supporting MySQL's XML schema format when ↵stuconnolly2010-11-051-0/+7
| | | | exporting. Also, restore our old format and give the user the choice during export (defaults to MySQL schema). Completes the implementation of issue #840.
* Add SPDefaultPasteboardDragType constant.stuconnolly2010-10-281-1/+1
|
* • CSV Import Field Mapper SheetBibiko2010-10-231-0/+1
| | | | | - added the possibility to apply any sql function while importing set via "Add value or expression" sheet eg concat('$2', '$1', length('$3')) whereby $1 $2 $3 are the placeholder for the csv file columns 1 2 3 [first column starts with 1] • fixed ' escaping issue in MCPConnection
* Update indexes controller constants.stuconnolly2010-10-191-0/+7
|
* Remove unused constant.stuconnolly2010-10-071-8/+0
|
* • Filter Table - Set Default OperatorBibiko2010-09-291-0/+2
| | | | - added the chance to define the unmarked default operator
* Remember the width of the server process list tableview columns between ↵stuconnolly2010-09-261-0/+1
| | | | application launches. Implements issue #814.
* Add missing SVN properties and general comments tidy up.stuconnolly2010-09-211-2/+0
|
* • CSV Import into new TABLEBibiko2010-09-041-0/+3
| | | | | - added button "New" - added chance to change encoding and engine of the new table which will be saved in the Prefs
* • added SPFileManagerAdditionsBibiko2010-08-191-1/+3
| | | | | | | | - [(NSString*)applicationSupportDirectoryForSubDirectory:error:] Return the application support folder of the current application for 'subDirectory'. If this folder doesn't exist it will be created. If 'subDirectory' == nil it only returns the application support folder of the current application. • added SPThemesSupportFolder constant
* • added Query Editor color theme manager to the Editor PrefBibiko2010-08-181-0/+1
| | | | | | - themes can be saved/loaded in/from ~/Library/Application Support/Sequel Pro/Themes by using the gear menu items in the Editor Pref - rearrange the GUI - Edit Theme List follows soon
* • added chance to export/import the color theme of the Query Editor in ↵Bibiko2010-08-161-0/+2
| | | | | | | | | | | Prefs > Editor > Gear menu as normal plist file - file extension is spTheme - can also import TextMate theme tmTheme files directly • added the chance to set the selection color in the Query Editor • fixed code for setting the insertion point color • changed the way how the query highlight color will be drawn - now it also supports colors with an alpha value
* Various export enhancements and fixes, including:stuconnolly2010-08-121-0/+8
| | | | | | | | | | | | - A new SPExportFile class, providing an abstract interface to the handling and creation of export files. - Enables the centralisation of all file/file handle creation logic as well as better support for handling situations where files fail to be created, including files that already exist at the export location. - New SPExportFileHandleStatus constants to support the reporting of file handle creation. - Update SPExporter to use the new file class instead of directly using an instance of SPFileHandle. - Add the necessary logic to deal with files that already exist on disk, by providing the user with 3 options: cancel the export, ignore the files in question or overwrite them. We might want to enhance this to make new files sequential in name to prevent overwriting. Fixes issue #742. - New SPExportFileUtilities category, which centralises all the logic relating to writing export type headers as well as dealing with problems occurred during file/file handle creation. - Improve feedback given on the export progress sheet during export initialisation. - Tidy up and improve comments.
* • remember user's last setting for "Resetting AUTO_INC" while deletion of ↵Bibiko2010-08-101-0/+1
| | | | all rows in a table
* In addition to Gzip compression support when exporting SQL dumps add the ↵stuconnolly2010-07-241-0/+8
| | | | | | | | | | | | | | | | | | ability to use Bzip2 compression. Other changes include: + Enable the use of export compression (Gzip and Bzip2) for all export formats. + Move the compression options in the export dialog to the 'Advanced' export settings view. + Simplify the setting of common exporter properties (e.g. the connection, use of compression). + Fix a potential memory leak in the dot exporter. + Update the data importer to recognise Bzip2 compressed files. + Fix several display issues on export dialog. + Restore the default .csv file extension of CSV exports. + Correctly update the default export filename when selecting a output compression type. The addition of Bzip2 compression support implements issue #688.
* - Expose a number of help menu items and help buttons to use localisable ↵rowanbeentje2010-07-181-7/+9
| | | | | | | | strings - Tweak MySQL help search to include a localisable language code for results in requested languages This addresses Issue #743
* Add option to toggle the tab bar visibility.avenjamin2010-06-301-0/+1
| | | | | - Only applies when one tab is present. - Saves last used state to preferences.
* • initial support for open a spfs session file (works rudimentary - ↵Bibiko2010-06-241-0/+1
| | | | | | fine-tuning comes soon) • added constant "SPBundleFileExtension"
* - Convert connection encoding menus to be menu tag based to fix ↵rowanbeentje2010-06-141-0/+24
| | | | | | | | | | localisation errors - Add database encoding retrieval support for MySQL 4.1 - Convert the add table and add database sheets to use encoding menus derived from server supported encodings - Re-layout preferences with larger labels to aid localisation - Fix preference resizing in non-Favorite tabs
* Exporter ehancements:stuconnolly2010-06-131-5/+12
| | | | | | | - Make sure the export button is disabled when the global structure, content and drop options are enabled, but the desellect all button is checked. - Replace the export dialog toolbar with a tabview, reducing the dialogs overall size. - Add the option to SQL dumps to specify when a new INSERT statement should be created, either after a certain amount of data or after a specific number of rows (defaults to every 250KiB). Known issue: incorrect VALUES clause generation of last row when creating a new INSERT after a specific number of rows.
* Exporter enhancements, including:stuconnolly2010-06-091-3/+3
| | | | | | | | - Move the custom filename options view to a drop down view on the main exporter dialog. - Change the export data source matrix to a popup button. - Fix the export button being enabled when no tables are selected to be exported. - Various interface validation fixes.
* Add a 'Translation Feedback' menuitem to the 'Help' menu (currently hidden). ↵stuconnolly2010-06-011-0/+1
| | | | Implements issue #713. When the feedback page is available simply change the constant SPTranslationFeedbackURL to point to it.
* Merge export redesign branch back into trunk.stuconnolly2010-05-241-8/+31
| | | | | | | | | | | | | | | | | | | | | Includes a completely redesign approach to all export data types based on the use of NSOperation subclasses. CSV, SQL, XML and dot export types are currently functional, while the source files for PDF and HTML export types exist they are to be implemented, but are currently hidden from the interface. Also includes the following: - Completely redesigned export interface. - The ability to customize CSV NULL values. - The ability to specify whether the UTF-8 BOM should be used in SQL dumps. - The ability to specify whether BLOB fields are output as hex or plain text during SQL dumps. Defaults to hex. - Exporting currently selected tables via the tables list context menu. Outstanding issues: - Not all progress indicators for all export types are functional (or functioning correctly). - A few issues related to the introduction of only exporting the content and create and drop syntax of specific tables during SQL dumps. Needs some serious testing and benchmarking to ensure it replicates the current export functionality.
* Initial implementation of tabs:rowanbeentje2010-05-231-0/+13
| | | | | | | | - Addition of PSMTabBar framework - Rework away from a document-based TableDocument - Support tabs throughout the application - Add menu items for creating tabs, and add support for dragging tabs to different windows
* - Fix an issue when truncating tables using the right-click menu, by ↵rowanbeentje2010-05-221-7/+7
| | | | | | | | improving the truncation reload code and by removing a problem in TableContent tracking the active table name. This addresses Issue #700 and a number of crash reports. - Rename SPHistoryView* constants to SPTableView* constants and use them more widely rather than hard-coded tab indexes - Fix a problem preventing history navigation if a triggers view was the previous item in the history
* Bunch of improvements to the serve processes panel, including:stuconnolly2010-04-241-1/+2
| | | | | | | | | | - MCPKit's listProcesses (mysql_list_processes) method is now used, instead of running the query ourselves. - The ability to set whether or not the list is auto refreshed. - The ability to set the autorefresh interval, either via the presets or by entering a custom value (the interface for this might need updating). - Get the process list is now performed on a background thread. This completes the implementation of issue #607.
* - Add a new couldCommitCurrentViewActions method to TableDocument, and ↵rowanbeentje2010-04-181-0/+1
| | | | | | | | standardise current view-commit-checks to use that - Add checking of that status to history navigation (fixing http://spbug.com/l/127 ) and window closing (fixing http://spbug.com/lr/263 ) - Improve thread safety/deferred actions in TableContent
* Add a new SPFileHandle class to support gzip compression and writing on a ↵rowanbeentje2010-04-121-1/+2
| | | | | | | | | | | background thread, and integrate for SQL import: - Implement streaming reading of gzip-compressed files for SQL import - Support exporting SQL dumps into a gzip-compressed file - SPFileHandle supports the most-used subset of NSFileHandle commands for easy integration - Integrate zlib 1.2.4 for improved gzip streaming performance (and support for custom buffer sizes and file offset positions) This implements Issue #571 .
* • added "Import from Clipboard" ⌥⇧⌘IBibiko2010-04-101-0/+1
| | | | | | - sheet showing the first 4kB of pasteboard content and the SQL/CSV accessory view - pasteboard content will be saved as temp file and read by using the current table/connection encoding
* More tidy up. Constants and functions.stuconnolly2010-03-311-0/+8
|
* Tidy up imports and fix 'Reverse Sort Order' when sorting connection ↵stuconnolly2010-03-311-1/+1
| | | | favorites (Thanks Hans).
* Add the ability to sort the connection favorites table view in the ↵stuconnolly2010-03-271-0/+10
| | | | preferences. Sort options are by name, host or type as well as the option to be sorted in reverse order. This implements issue #490.
* Bunch of improvements to the server process list viewer, including:stuconnolly2010-03-251-0/+2
| | | | | | | | | | - It is now a separate window like the console to enable monitoring. - It now uses the same window style as the console. - The ability to show or hide the process ID, column. This could possibly be enabled for some of the other columns as well, suggestions? - The ability to enable or disable the use of SHOW FULL PROCESSLIST or just SHOW PROCESSLIST. This implements most of the enhancements requested in issue #607, with the exception of the option to enable auto-refresh, which is still being worked on.
* Add support for selecting the triggers view as the default in the general ↵stuconnolly2010-03-251-0/+1
| | | | preferences pane.
* Add support for the triggers view in the history controller.stuconnolly2010-03-251-2/+4
|
* General tidy up, with a focus on consolidating more constants in ↵stuconnolly2010-03-241-5/+48
| | | | SPConstants.h/m.
* • further work on Navigator (not yet active but workable -> unHide menu item)Bibiko2010-03-191-0/+1
|
* Present a warning to the user when attempting to print the current table's ↵stuconnolly2010-03-181-1/+4
| | | | content view which exceeds a set number of rows. This number is currently set to 1000 which can be changed via the hidden preference key 'PrintWarningRowLimit'. The approach to cancelling the print HTML generation thread may also need to be re-implemented to ensure that it is killed straight away, something that is currently not possible using NSThread. Rowan suggested using pthreads instead, but this should be discussed in terms of potential memory leaks and stability.
* Lots more printing support enhancements, including:stuconnolly2010-03-131-0/+1
| | | | | | | | | - The ability to print the extended table information view using a new template. - The inclusion of NULL values diaplyed as the user's NULL value placeholder when printing a table's sturcture and indexes. - If enabled in the user's preferences, the inclusion of vertical gridlines in the table views. - Dynamic calculation of page margins based on the paper size of the selected printer as opposed to using hard coded values. - Lots of other little style enhancements.
* Various printing support enhancements, including:stuconnolly2010-03-121-0/+4
| | | | | | | | | - Splitting out all printing methods to SPPrintController which is category of TableDocument. - The ability to print table relations. - If present the inclusion of table indexes when printing a table's source. - If the user has use monospaced fonts enables, then the print out's tabular data will be in a monospaced font. - Lots of other style enhancements, including page headings and sections headings.
* Add a 'Keyboard Shortcuts' menu item to the 'Help' menu which opens the page ↵stuconnolly2010-03-101-0/+1
| | | | http://www.sequelpro.com/docs/Keyboard_Shortcuts.
* • outsourced keyword completion and function completion lists to ↵Bibiko2010-03-081-0/+1
| | | | | | | | | | | 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-071-0/+2
| | | | | | 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
* Add a hidden preference to display or hide the MySQL server version in the ↵stuconnolly2010-03-071-0/+1
| | | | window title.
* • CSV Import Field MapperBibiko2010-03-061-0/+1
| | | | | - 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
* • further progress for 'add global source value'Bibiko2010-02-171-0/+1
| | | | | | | | | | | | • 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
* Added preliminary support for triggers. You can access the tab via the bamse162010-01-311-0/+1
| | | | | | | | | | | | | | | | | | | | menu item View > Table Triggers (apple-6). Heavily copied from Relations tab, lots of functionality missing. Just lists the triggers for the table now. M Source/SPTableData.m M Source/SPConstants.h M Source/SPConstants.m A Source/SPTableTriggers.h A Source/SPTableTriggers.m M Source/TableDocument.h M Source/TableDocument.m M Source/SPTableData.h M Interfaces/English.lproj/MainMenu.xib M Interfaces/English.lproj/DBView.xib M sequel-pro.xcodeproj/project.pbxproj
* • CMTextView's colours are set via observer, live changed in editable ↵Bibiko2010-01-301-0/+1
| | | | | | | | textviews • added Preference setting "Table font" in "Table" pane to set the table font/size for all result tables (Content, Custom Query) • added to SPTableView the method setFont: • fixed the initialisation of vars in CMTextView (fixes the displaying of create syntax)
* - With the improved row count support and behaviour, replace the old "Fetch ↵rowanbeentje2010-01-021-1/+9
| | | | correct row count" preference with a new Table row counts query level (never, only for small tables, always), defaulting to only for small tables - boundary currently set to 5MB. This addresses Issue #500
* Replace the main toolbar's #define'd identifier constants with extern's. ↵stuconnolly2009-12-121-16/+12
| | | | This completes the conversion of all constants in SPConstants to extern's.