| Commit message (Collapse) | Author | Age | Files | Lines |
|---|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
potentially comprising the last of 1.0.2:
- r4066: Fix query status and error message title to not always suggest an error has occurred, addressing Issue #1670
- r4067: Fix validation of the "Add to Favorites" File menu item when editing past favorites; Fix the action of the "Add to Favorites" File menu item to correctly create the new favorite; These address Issue #1666
- r4068: Move the SPBeginWaitingAlertSheet function to a beginWaitingAlertSheetWithTitle:... class method on a new SPAlertSheets class, allowing us to use invocation forwarding to ensure the entire function is executing on the main thread. This allows runloop processing to happen on the main thread, addressing Issue #1676
- r4069: Fix newline warnings
- r4070: Issue #1601: Fix menu items not being validated properly once a connection is established
- r4071: Split the process list controller's table view data source and delegate methods into their own category
- r4072: Fix process list kill query/connection actions not using the correct ID if the list was filtered
- r4074: Correctly link the SSH name field, fixing issues editing and automatically filling in connection names on the SSH tab, addressing Issue #1686
- r4075: Specify the NULL status of fields when creating view placeholders on export, fixing problems with invalid timestamp NULL defaults, addressing Issue #1688
- r4076: Add a spotlight comment to allow easy location of Sequel Pro with other search terms than the name
- r4077: Fix string type detection, addressing errors when converting string types to blob or binary fields (addressing Issue #1453)
- r4078: Composite Foreign Keys will now show all columns in Relation view (workaround)
- r4079: Changed a query (addressing issue #1687); Make some strings localizable
- r4087: Fix another issue causing ALTER statements to error for binary column types being edited, further addressing Issue #1265
- r4088: Update version number to 1.0.2
|
| |
|
|
|
|
|
|
| |
- r4062: Fix build warning
- r4064: Combine the "Run All" and "Run Current/Previous/Selection" buttons into a single button with dropdown menu with ability to change the default action: Create a new SPComboPopupButton class; this subclasses NSPopupButton to retain the ability to show the popup menu, but only when the right-hand side of the button is pressed, allowing the rest of the button to perform the click action; Combine the previous two "Run" buttons on the Custom Query view into a new SPComboPopupButton; Move the Run menu items from the gear menu into the Run button popup menu so they can be discovered more easily (and the shortcuts seen more easily) ; Add a menu item to switch the button's default action, which also swaps all associated shortcuts; Clean up associated logic. This implements Issue #1569
- r4065: Alter the SPComboPopupButton to ignore clicks started in the left-hand part of the button but ended in the right-hand part of the button; Change the button to use "Run All" instead of "Run All Queries" to avoid localisation issues
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
- r4034: End editing for deleting content filter or query favourites, addressing exceptions and Issue #1648
- r4035: Apply schlabberdog's fix for log #3969, addressing Issue #1647
- r4036: Fix an error parsing SQL inside an unterminated delimiter statement causing an off-by-one error in positioning, addressing Issue #1643
- r4037: If date-type fields are cleared, and allow NULLs, save the cell value as NULL; this implements Issue #1638
- r4038: Alter the content filter manager and the query favourite manager to import items from a file into the Global group if the document is untitled, improving import UX and addressing Issue #1616 and Issue #1645. Also select and scroll to the newly imported items for clarity.
- r4039: Fix crashes in the User Manager when fields don't validate but a save/cancel/tab switch is still triggered, addressing Issue #1627
- r4041: Tweak and improve the User Manager: Rework how data to populate the user manager is retrieved from the server, speeding up display of lots of users by a large factor; Fix support for schema permissions for the Anonymous user, and add support for '%' and '' hostnames (only showing if already set once), fixing Issue #1620; Highlight databases in the user manager that have permissions set for the selected user; Switch to using the centrally provided database list to reduce queries and remove the information_schema and performance_schema "databases"; Speed up a number of operations by tweaking the logic and queries used
- r4042: Fix release builds after r4041; Update localizable strings
- r4043: Set Sequel Pro to always run on Integrated Graphics on machines with both integrated and discrete, improving power consumption if nothing else is triggering the discrete GPU. This addresses Issue #1609
- r4044: Make the theme background apply to the query favourites editor
- r4045: If the Custom Query editor view is active on window open, correctly set the focus in it, addressing Issue #1590
- r4046: Add support for querying the server default charset and collation; Move a bit of redundant code into a method
- r4047: Restore tab bar label when cancelling a connection
- r4048: Fix format string error in QueryKit
- r4049: Alter the preferences favourite minimum version to avoid issues with previous runs of nightlies, which may partially address Issue #1588; Remove the old favourites key from the preferences now imports have succeeded
- r4050: Allow Favorites import to read favorites from an old preferences .plist file, further addressing Issue #1588
- r4051: Change the string '=' and '!=' to be case- and collation-insensitive by default, using the Shift key (as documented in the tooltip) to trigger a BINARY exact match. This addresses Issue #1578
- r4052: When adding a database the servers default charset is now shown
- r4053: Adjust keywords list to fix auto capitalisation of "ON"
- r4054: Add a new SPMySQLEmptyResult class to SPMySQLFramework, returning it instead of nil if a query produces no result set. This allows per-result-set properties to be preserved, fixing issues where information like query execution time was lost - addressing Issue #1577
- r4056: Improve startup when loading from file, preventing overwrite of details read from a spf/spfs during startup. This addresses Issue #1619
- r4057: Correctly reset document state for setting it from file/when duplicating tab, further addressing Issue #1619
- r4058: Add a stub override to fix exceptions when code receiving a SPMySQLEmptyResult expects a SPMySQLStreamingResult/SPMySQLFastStreamingResult (Exception #3988)
- r4060: Make some small tweaks to string BINARY handling: Correctly send the binary state/collation when reordering fields, addressing Issue #1265; Allow unticking of the binary box to save correctly, allowing conversion of fields to non-binary collations again
- r4061: Fix errors when editing or moving columns on server vesions which do not support character sets/collations, addressing Issue #1629; Fix needless collation queries on those servers; Disable field enums and table encoding dropdown on those servers
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
- r4021: Add a check for SPNotLoaded values when automatically generating new tables when importing CSVs, fixing Issue #1621 (SPNotLoaded values are generated when rows shorter than the header row are seen)
- r4022: Fix crashes when importing favorites on the connection view, addressing Issue #1556; Select and scroll to newly created favorites after import
- r4023: Default to disabling SSH multiplexing to avoid connection issues as per Issue #1457; leave multiplexing code present, but behind a preference. Run `defaults write com.sequelpro.SequelPro SSHMultiplexingEnabled -boolean YES` to re-enable
- r4024: Fix handling of double-dash style comments within field names, addressing Issue #1554
- r4025: When favorites in the connection view gave no password, no longer set the focus to the password field as soon as they're selected; instead, make the password field the next responder for tab keys. This addresses Issue #1555
- r4028: Fix escaping of backlsashes in non-LIKE clauses, addressing string matching with the = and RegExp operators - addresses Issue #1563
- r4029: Fix handling of primary keys listing multiple fields of which an early field has a specified length, addressing Issue #1641
- r4030: Alter the database creation sheet to correctly use the selected new database encoding; Clean up the database creation logic and remove redundant selection logic; Correctly reset and detect the database encoding when creating and switching databases
- r4031: Fix blurry text in a number of text views in 1.0.x (Possibly caused by IB mangling; recreated new text views with the same settings to address). This fixes Issue #1560
- r4032: Detect deleted or non-writable folders for export targets and give appropriate errors (particularly for saved paths), addressing Issue #1566
- r4033: Add support for export path tokens containing non-alphanumeric characters, automatically grouping and tokenising as required for both dragged and typed tokens. This addresses Issue #1567
|
| |
|
|
|
|
|
| |
edge cases, addressing Issue #1547
- Bump the version number to 1.0.1
|
| | |
|
| |
|
|
| |
preparation for upcoming release
|
| |
|
|
|
|
|
|
|
| |
thanks to Panic, Inc), recompressed for smaller file size and 10.5 compatibility
- Add document icons to match
- Amend the Info.plist to fix Sequel Pro being able to edit old .spf files etc
- Add .mysql file support (Issue #1366)
|
| |
|
|
|
|
|
|
|
|
| |
passwords *
- Change the bundle identifier from com.google.code.sequel-pro to com.sequelpro.SequelPro
- Change the code signing process to use a new identity and requirement, to add Developer ID support on 10.7+ but to also maintain functionality on 10.5+
- Add a preference migration routine to copy the old application defaults to the new bundle identifier's defaults
- Re-order the default keys to alphabetical to more easily locate values
|
| | |
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
the functionality required from MCPKit and is based around its interface for relatively easy integration.
Externally visible changes as a result of this merge:
- Speed improvements, particularly when loading large data sets
- Stability improvements, particularly related to connection state after the connection is dropped (eg Issue #1256)
- Improved support for new MySQL data types, which should address Issue #1052.
- Database structure retrieval and query cancellation now use a single persistent helper connection instead of lots of connections on-demand. This should help Issue #1097.
- More internal commands now use queries instead of MySQL functions; for example USE queries are now used to trigger database selection, improving transcripts. This addresses Issue #1247.
- Improved internal encoding work; while this needs support within the UI, it lays the foundation for issues like Issue #1280.
Code improvements:
- Much improved class layouts including extensive category usage
- Improved documentation across framework methods
- Support for fast enumeration across result objects
- Rewrite fixes use of a number of deprecate functions
- Much less code duplication across result set types
- Improved encapsultation within the framework, limiting the number of methods exposed, and also not exposing all the MySQL headers
From the Readme file:
The SPMySQL Framework is intended to provide a stable MySQL connection framework, with the ability to run text-based queries and rapidly retrieve result sets with conversion from MySQL data types to Cocoa objects.
SPMySQL.framework has an interface loosely based around that provided by MCPKit by Serge Cohen and Bertrand Mansion (http://mysql-cocoa.sourceforge.net/), and in particular the heavily modified Sequel Pro version (http://www.sequelpro.com/). It is a full rewrite of the original framework, although it includes code from patches implementing the following Sequel Pro functionality, largely contributed by Hans-Jörg Bibiko, Stuart Connolly, Jakob Egger, and Rowan Beentje:
- Connection locking (Jakob et al)
- Ping & keepalive (Rowan et al)
- Query cancellation (Rowan et al)
- Delegate setup (Stuart et al)
- SSL support (Rowan et al)
- Connection checking (Rowan et al)
- Version state (Stuart et al)
- Maximum packet size control (Hans et al)
- Result multithreading and streaming (Rowan et al)
- Improved encoding support & switching (Rowan et al)
- Database structure; moved to inside the app (Hans et al)
- Query reattempts and error-handling approach (Rowan et al)
- Geometry result class (Hans et al)
- Connection proxy (Stuart et al)
|
| | |
|
| |
|
|
| |
both backslash and double-character escaping. This will mean the vast majroty of CSVs selected for import will be read correctly by default, fixing issues such as Issue #1252
|
| |
|
|
| |
time (currently in milliseconds). Implements issue #944
|
| | |
|
| | |
|
| |
|
|
| |
resolves issue #1133. (http://spbug.com/1133)
|
| |
|
|
|
| |
- Add German and Russian localisations
|
| |
|
|
| |
panel. Fixes issue #1036.
|
| |
|
|
| |
• improved "Format SQL" connection detection
|
| |
|
|
|
| |
- instead of using \t as indention string the user can choose how many spaces should be used instead
- addresses issue 956
|
| |
|
|
| |
- perform a check only if the revision number is greater as the last recorded one, in other words if an updated version of Sequel Pro was installed and runs for the very first time
|
| |
|
|
| |
• improved Bundle Editor to store only modified Bundles
|
| |
|
|
|
| |
- enabled WebInspector in context menu for debugging
- alert the user about JavaScript parsing errors and exceptions with some debug info
|
| |
|
|
|
|
|
|
|
| |
- used embedded icon image via cid and mime type image/tiff
- sql view now wraps long lines
- improved general stability
- QL now runs on main thread
note: there're still some issues for which QL crashed mostly due NSAutoReleasePool releases - more investigations are needed; most of this issues are releted to long lines, icon caching, releasing ...
|
| |
|
|
|
|
|
| |
temp file SP_BUNDLE_INPUT_FILE since stdin and shell vars are difficult to handle for a large amount of data
• fixed AppleScript class definition since it was renamed
• added support for the URL scheme 'sequel' to allow to interact with Sequel Pro eg via bash: open 'sequelpro://executequery=select%205' [not yet implemented ;)]
|
| | |
|
| | |
|
| |
|
|
| |
- added the chance to define the unmarked default operator
|
| |
|
|
| |
Quicklook preview which also causes a doc-like icon (icon will come soon)
|
| |
|
|
|
|
|
|
|
|
|
| |
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
|
| |
|
|
| |
all rows in a table
|
| | |
|
| |
|
|
| |
dependency
|
| |
|
|
|
|
| |
- Uniform Type Identifier (UTI) for extensions spf, spfs in order to support QuickLook in future
- added plain text QuickLook support for sql files to be able to read them in QL mode
|
|
|
structure.
|
