diff options
| author | Bibiko <bibiko@eva.mpg.de> | 2010-01-10 19:23:42 +0000 |
|---|---|---|
| committer | Bibiko <bibiko@eva.mpg.de> | 2010-01-10 19:23:42 +0000 |
| commit | bd1c8a535691781746f1a1ff4ea9d215744061c5 (patch) | |
| tree | 5ee5d4b7f3a7f42b737ec8aa7bc42a7fde4bec0c /Source/TablesList.m | |
| parent | 602633c84982f4e8061cde8a3cb09ada6c4d11bf (diff) | |
| download | sequelpro-bd1c8a535691781746f1a1ff4ea9d215744061c5.tar.gz sequelpro-bd1c8a535691781746f1a1ff4ea9d215744061c5.tar.bz2 sequelpro-bd1c8a535691781746f1a1ff4ea9d215744061c5.zip | |
• first preparations to improve the Custom Query database names/table names/field names + type and encoding completion
- after connecting and updating the table list a background task executed on a different connection will be performed to query the information_schema db (MySQL >= 5 only so far)
- the MCPConnection object holds a NSDictionary with all structural data
Note: not yet active
Diffstat (limited to 'Source/TablesList.m')
| -rw-r--r-- | Source/TablesList.m | 5 |
1 files changed, 4 insertions, 1 deletions
diff --git a/Source/TablesList.m b/Source/TablesList.m index 5a98971b..2846a85a 100644 --- a/Source/TablesList.m +++ b/Source/TablesList.m @@ -86,6 +86,9 @@ // Notify listeners that a query has started [[NSNotificationCenter defaultCenter] postNotificationName:@"SMySQLQueryWillBePerformed" object:tableDocumentInstance]; + // Query the structure of all databases in the background (mainly for completion) + [mySQLConnection performSelector:@selector(queryDbStructure) withObject:nil afterDelay:0.1]; + // Select the table list for the current database. On MySQL versions after 5 this will include // views; on MySQL versions >= 5.0.02 select the "full" list to also select the table type column. theResult = [mySQLConnection queryString:@"SHOW /*!50002 FULL*/ TABLES"]; @@ -105,7 +108,7 @@ } else { [tableTypes addObject:[NSNumber numberWithInteger:SP_TABLETYPE_TABLE]]; } - } + } } // Reorder the tables in alphabetical order |