aboutsummaryrefslogtreecommitdiffstats
path: root/Source/SPDatabaseData.h
Commit message (Collapse)AuthorAgeFilesLines
* Tidy up SPDatabaseData by splitting out the hardcoded list of charcater sets ↵stuconnolly2010-10-081-8/+0
| | | | into SPDatabaseCharacterSets. The struct is now returned by calling SPGetDatabaseCharacterSets().
* Various improvements to server capability/version checking, including:stuconnolly2010-10-071-4/+19
| | | | | | | | | | | | | - Add a new ServerSupport class, for which an instance is created upon each new connection and is then subsequently accessible via SPDatabaseDocument. - Replace the majority of manual version checking with calls to properties in the above new class. - Improve the user manager's compatibility with MySQL 3 and 4 servers. Fixes issue #811 Other changes include: - Disable the encoding popup button when adding a new table or database to servers running pre MySQL 4.1 as it only contains one option, 'Default'. - Fix various potential memory leaks discovered during static analysis. - General tidy up and comments.
* • [SPDatabase getDatabaseCollationsForEncoding:] now uses a cache to ↵Bibiko2010-09-091-0/+1
| | | | | | | | 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
* Speed up SPDatabaseData by obtaining the server version when the connection ↵stuconnolly2010-04-211-0/+4
| | | | is set to prevent multiple calls everytime the list of available storange engines, etc. is requested.
* General tidy up, with a focus on consolidating more constants in ↵stuconnolly2010-03-241-5/+5
| | | | SPConstants.h/m.
* - Upgrade Sequel Pro to be compiled as a 3-way PPC/i386/x86_64 binary for ↵rowanbeentje2010-01-091-1/+1
| | | | | | | release builds, including a large number of 64bit compatibility upgrades and tweaks - Upgrade RegexKitLite to 3.3
* • added to hard-coded encoding list the DESCRIPTION fieldBibiko2009-09-081-2/+3
| | | | | | | | | | | | • fixed issue while retrieving possible encodings/collations from information_schema - in many cases "SHOW TABLES IN information_schema LIKE 'character_sets'" returns NULL whereby "SELECT * FROM `information_schema`.`character_sets`" returns the correct list - change the test query to the latter syntax - if the retrieving of possible encodings fails return an array of the hard-coded list with dictionaries containing the keys for name AND description -- [this fix solves i400 due to the fact that the chosen encoding title from the popup list must be of the format: "description (name)"; otherwise the following regexp returns (null) because it's looking for the content of parentheses]
* Merge framework integration branch back to trunk. Summary of changes:stuconnolly2009-07-211-4/+3
| | | | | | | | | | | | | | | - Includes all custom code from subclasses CMMCPConnection and CMMCPResult, meaning they have subsequently been removed from the project. - All previous Sequel Pro specific code in the above subclasses has been removed in favour of the delegate (currently set to TableDocumet) informing the framework of such information. - All references to CMMCPConnection and CMMCPResult have subsequently been changed to MCPConnection and MCPResult. - Framework includes MySQL 5.1.36 client libraries and source headers. - Framework is now built as a 4-way (32/64 bit, i386/PPC arch) binary. - All import references to <MCPKit_bundled/MCPKit_bundled.h> have been changed to <MCPKit/MCPKit.h>. - New script 'build-mysql-client.sh' can be used to build the MySQL client libraries from the MySQL source. See the script's header for a list of available options or run it with no arguments to display it's usage. Note that there are still a few changes to be made to the framework with regard to removing Sequel Pro specific calls to the delegate. These however can be made later on as they have no effect on functionality and are merely design changes. Also, note that any future development done on the framework should be made to be as 'generic' as possible, with no Sequel Pro specific references. This should allow the framework to be integrated into another project without the need for SP specific code.
* Include a hard coded list of encodings and collations in SPDatabaseData to ↵stuconnolly2009-07-201-0/+7
| | | | remove the depdendency on the information_schema database when its not available or accessible.
* Redesigned table information pane.stuconnolly2009-05-271-0/+51