diff options
author | Bibiko <bibiko@eva.mpg.de> | 2009-06-09 22:19:15 +0000 |
---|---|---|
committer | Bibiko <bibiko@eva.mpg.de> | 2009-06-09 22:19:15 +0000 |
commit | 6f8253e66be9dac0c3c96e16d9f97fda3fc7e818 (patch) | |
tree | 7848c2b90d9c577da4e5d49be32d2c6c11cd8960 /Source/SPQueryConsole.m | |
parent | 0cf5b0031043c160b002b7bd02f31c9f4e5eb626 (diff) | |
download | sequelpro-6f8253e66be9dac0c3c96e16d9f97fda3fc7e818.tar.gz sequelpro-6f8253e66be9dac0c3c96e16d9f97fda3fc7e818.tar.bz2 sequelpro-6f8253e66be9dac0c3c96e16d9f97fda3fc7e818.zip |
• introduced the method (NSArray *)fetchResultFieldsStructure to CMMCPResult
- it returns an array of dicts containing general information about each field of the result array of the last executed query
dict example so far for:
SELECT ucs_comp AS co FROM comp_ucs3 AS co_table
AUTO_INCREMENT_FLAG = 0;
BINARY_FLAG = 0;
BLOB_FLAG = 0;
ENUM_FLAG = 0;
MULTIPLE_KEY_FLAG = 1;
NOT_NULL_FLAG = 0;
NUM_FLAG = 0;
PART_KEY_FLAG = 1;
PRI_KEY_FLAG = 0;
SET_FLAG = 0;
UNIQUE_KEY_FLAG = 0;
UNSIGNED_FLAG = 0;
ZEROFILL_FLAG = 0;
byte_length = 30;
char_length = 10;
charset_collation = utf8_general_ci;
charset_name = utf8;
charsetnr = 33;
db = test;
decimals = 0;
flags = 16392;
max_byte_length = 4;
max_char_length = 1;
name = co;
org_name = ucs_comp;
org_table = comp_ucs3;
table = co_table;
type = VARCHAR;
typegrouping = string;
Hint: To test that new method one can add the following code after the execution of a mysql query:
NSArray *fStruct = [NSArray arrayWithArray:[theResult fetchResultFieldsStructure]];
Diffstat (limited to 'Source/SPQueryConsole.m')
0 files changed, 0 insertions, 0 deletions