[Phpmyadmin-devel] Remember the last way user sorted tables
Marc Delisle
marc at infomarc.info
Sat May 28 13:05:09 CEST 2011
Le 2011-05-27 13:48, Aris Feryanto a écrit :
> Hi Marc,
>
> On 27 Mei 2011, at 23:53, Marc Delisle <marc at infomarc.info> wrote:
>
>> Aris Feryanto a écrit :
>>> Hi,
>>>
>>>
>>>
>>> I pushed changes to my repository. In the repo, I did some
>>> changes regarding the storage for "remember the last way user
>>> sorted tables":
>>>
>>> - For the storage, I created a new table which store per table's
>>> data. The table consist of 4 columns: username, db_name,
>>> table_name, and prefs. I haven't put any limit for the number of
>>> records, as suggested by Piotr. I will do it after all features
>>> regarding table-browsing implemented. - I put new code to load
>>> and store "table sorting" in PMA_Table class.
>>>
>>> To test these changes, you will need to create new table using
>>> script in scripts/create_tables.sql and change the configuration
>>>
>>> $cfg['Servers'][$i]['table_uiprefs'] = 'pma_table_uiprefs';
>>>
>>> (which I think cannot be done in demo server)
>>>
>>> After this setup, you will be able to browse a table, sort them
>>> by clicking table's header, logout, login again, browse to the
>>> table, and the table will remain sorted in the last way you
>>> sorted it. Comments and suggestions are really appreciated.
>>
>> Hi Aris, the feature works fine and I believe it's ready to be
>> merged in origin/master, do you agree?
>>
>
> I agree. Only one thing left to do later: limiting the number of
> records in table_uiprefs table.
>
> My commits for this feature is located in "tablesort" branch in my
> git repo.
>
> -- I don't have any experience in merging to official master and I
> don't know how hard it would be to do merging from my "mixed" master
> repo. So, I separated each feature in each branch, in case you find
> it easier to merge this way.
Merged, thanks. It's probably easier to merge from separate branch,
especially if you add something to this feature later; OTOH, in the long
term these features will need some code from your other features so you
must ensure that they all work together in your master branch.
--
Marc Delisle
http://infomarc.info
More information about the Developers
mailing list