[Tiki-devel] Attributes and Relations [was Re: [Tikiwiki-cvs/svn] SF.net SVN: tikiwiki:[62110] branches/17.x/db/tiki.sql]

classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

[Tiki-devel] Attributes and Relations [was Re: [Tikiwiki-cvs/svn] SF.net SVN: tikiwiki:[62110] branches/17.x/db/tiki.sql]

Jonny Bradley-4
Hi Victor and Lindon and all

Object attributes let you add any sort of attribute (e.g. colour) to any Tiki object without having to create a new field in our already overcrowded database.

It's used already (since Tiki 5) for things like tracker map icons, geo locations on various objects and so on.

    https://dev.tiki.org/Object+Attributes+and+Relations

You can also make relationships between objects such as the "friend" and/or "follow" status between users, "likes" and "favorites" by users on any objects (needs a better GUI, by the way)

The code lives in attributelib.php and relationlib.php and is pretty easy to implement and we really should be using it more (me included!)

I did recently update the lists on that dev page, maybe that would be a good job for plugin (or maybe a search of some sort)?

HTH

jonny



> On 8 Apr 2017, at 13:28, lindon <[hidden email]> wrote:
>
>>
>> Regarding attributes of groups - maybe I am not aware of this feature
>> yet, what do you mean?
>
> Would be interested in knowing this too.
> Thanks,
> lindon
>
>> On 04/06/2017 06:31 PM, Jonny Bradley wrote:
>>> I'm afraid it's a manual process - unless you can think of a script that would do it. We used to have someone who regularly would take a clean install from tiki.sql and compare that with various upgrades from previous versions having had the installer schema applied and see what the difference were, i never manage to work out how to do it but it would be a useful check for the release process.
>>>
>>> jonny
>>>
>>> p.s. Why didn't you use an attribute for group colour? Would have saved adding a new field ;)
>>>
>>>
>>>> On 6 Apr 2017, at 13:14, Victor Emanouilov <[hidden email]> wrote:
>>>>
>>>> Jonny,
>>>>
>>>> That's me, sorry. Besides adding the migration in installer/schema/,
>>>> should I run any particular command to generate that tiki.sql? Not sure
>>>> why I thought this was done automatically...
>>>>
>>>> Regards,
>>>> Victor
>>>>
>>>>
>>>> On 04/06/2017 01:45 PM, [hidden email] wrote:
>>>>> Revision: 62110
>>>>>          http://sourceforge.net/p/tikiwiki/code/62110
>>>>> Author:   jonnybradley
>>>>> Date:     2017-04-06 10:45:33 +0000 (Thu, 06 Apr 2017)
>>>>> Log Message:
>>>>> -----------
>>>>> [FIX] missing new field in tiki.sql?
>>>>>
>>>>> Modified Paths:
>>>>> --------------
>>>>>    branches/17.x/db/tiki.sql
>>>>>


------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
TikiWiki-devel mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/tikiwiki-devel
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: [Tiki-devel] Attributes and Relations [was Re: [Tikiwiki-cvs/svn] SF.net SVN: tikiwiki:[62110] branches/17.x/db/tiki.sql]

lindon-4
Thanks Jonny, will keep this in mind.
Regards,
lindon

> On Apr 8, 2017, at 9:06 AM, Jonny Bradley <[hidden email]> wrote:
>
> Hi Victor and Lindon and all
>
> Object attributes let you add any sort of attribute (e.g. colour) to any Tiki object without having to create a new field in our already overcrowded database.
>
> It's used already (since Tiki 5) for things like tracker map icons, geo locations on various objects and so on.
>
>    https://dev.tiki.org/Object+Attributes+and+Relations
>
> You can also make relationships between objects such as the "friend" and/or "follow" status between users, "likes" and "favorites" by users on any objects (needs a better GUI, by the way)
>
> The code lives in attributelib.php and relationlib.php and is pretty easy to implement and we really should be using it more (me included!)
>
> I did recently update the lists on that dev page, maybe that would be a good job for plugin (or maybe a search of some sort)?
>
> HTH
>
> jonny
>
>
>
>> On 8 Apr 2017, at 13:28, lindon <[hidden email]> wrote:
>>
>>>
>>> Regarding attributes of groups - maybe I am not aware of this feature
>>> yet, what do you mean?
>>
>> Would be interested in knowing this too.
>> Thanks,
>> lindon
>>
>>> On 04/06/2017 06:31 PM, Jonny Bradley wrote:
>>>> I'm afraid it's a manual process - unless you can think of a script that would do it. We used to have someone who regularly would take a clean install from tiki.sql and compare that with various upgrades from previous versions having had the installer schema applied and see what the difference were, i never manage to work out how to do it but it would be a useful check for the release process.
>>>>
>>>> jonny
>>>>
>>>> p.s. Why didn't you use an attribute for group colour? Would have saved adding a new field ;)
>>>>
>>>>
>>>>> On 6 Apr 2017, at 13:14, Victor Emanouilov <[hidden email]> wrote:
>>>>>
>>>>> Jonny,
>>>>>
>>>>> That's me, sorry. Besides adding the migration in installer/schema/,
>>>>> should I run any particular command to generate that tiki.sql? Not sure
>>>>> why I thought this was done automatically...
>>>>>
>>>>> Regards,
>>>>> Victor
>>>>>
>>>>>
>>>>> On 04/06/2017 01:45 PM, [hidden email] wrote:
>>>>>> Revision: 62110
>>>>>>         http://sourceforge.net/p/tikiwiki/code/62110
>>>>>> Author:   jonnybradley
>>>>>> Date:     2017-04-06 10:45:33 +0000 (Thu, 06 Apr 2017)
>>>>>> Log Message:
>>>>>> -----------
>>>>>> [FIX] missing new field in tiki.sql?
>>>>>>
>>>>>> Modified Paths:
>>>>>> --------------
>>>>>>   branches/17.x/db/tiki.sql
>>>>>>
>
>
> ------------------------------------------------------------------------------
> Check out the vibrant tech community on one of the world's most
> engaging tech sites, Slashdot.org! http://sdm.link/slashdot
> _______________________________________________
> TikiWiki-devel mailing list
> [hidden email]
> https://lists.sourceforge.net/lists/listinfo/tikiwiki-devel


------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
TikiWiki-devel mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/tikiwiki-devel
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: [Tiki-devel] Attributes and Relations [was Re: [Tikiwiki-cvs/svn] SF.net SVN: tikiwiki:[62110] branches/17.x/db/tiki.sql]

Victor Emanouilov
In reply to this post by Jonny Bradley-4
Hi Jonny,

That's something to explore and I will keep it in mind for future
attribute-like additions.

Thanks,
Victor


On 04/08/2017 04:06 PM, Jonny Bradley wrote:

> Hi Victor and Lindon and all
>
> Object attributes let you add any sort of attribute (e.g. colour) to any Tiki object without having to create a new field in our already overcrowded database.
>
> It's used already (since Tiki 5) for things like tracker map icons, geo locations on various objects and so on.
>
>      https://dev.tiki.org/Object+Attributes+and+Relations
>
> You can also make relationships between objects such as the "friend" and/or "follow" status between users, "likes" and "favorites" by users on any objects (needs a better GUI, by the way)
>
> The code lives in attributelib.php and relationlib.php and is pretty easy to implement and we really should be using it more (me included!)
>
> I did recently update the lists on that dev page, maybe that would be a good job for plugin (or maybe a search of some sort)?
>
> HTH
>
> jonny
>
>
>
>> On 8 Apr 2017, at 13:28, lindon <[hidden email]> wrote:
>>
>>> Regarding attributes of groups - maybe I am not aware of this feature
>>> yet, what do you mean?
>> Would be interested in knowing this too.
>> Thanks,
>> lindon
>>
>>> On 04/06/2017 06:31 PM, Jonny Bradley wrote:
>>>> I'm afraid it's a manual process - unless you can think of a script that would do it. We used to have someone who regularly would take a clean install from tiki.sql and compare that with various upgrades from previous versions having had the installer schema applied and see what the difference were, i never manage to work out how to do it but it would be a useful check for the release process.
>>>>
>>>> jonny
>>>>
>>>> p.s. Why didn't you use an attribute for group colour? Would have saved adding a new field ;)
>>>>
>>>>
>>>>> On 6 Apr 2017, at 13:14, Victor Emanouilov <[hidden email]> wrote:
>>>>>
>>>>> Jonny,
>>>>>
>>>>> That's me, sorry. Besides adding the migration in installer/schema/,
>>>>> should I run any particular command to generate that tiki.sql? Not sure
>>>>> why I thought this was done automatically...
>>>>>
>>>>> Regards,
>>>>> Victor
>>>>>
>>>>>
>>>>> On 04/06/2017 01:45 PM, [hidden email] wrote:
>>>>>> Revision: 62110
>>>>>>           http://sourceforge.net/p/tikiwiki/code/62110
>>>>>> Author:   jonnybradley
>>>>>> Date:     2017-04-06 10:45:33 +0000 (Thu, 06 Apr 2017)
>>>>>> Log Message:
>>>>>> -----------
>>>>>> [FIX] missing new field in tiki.sql?
>>>>>>
>>>>>> Modified Paths:
>>>>>> --------------
>>>>>>     branches/17.x/db/tiki.sql
>>>>>>
>
> ------------------------------------------------------------------------------
> Check out the vibrant tech community on one of the world's most
> engaging tech sites, Slashdot.org! http://sdm.link/slashdot
> _______________________________________________
> TikiWiki-devel mailing list
> [hidden email]
> https://lists.sourceforge.net/lists/listinfo/tikiwiki-devel



------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
TikiWiki-devel mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/tikiwiki-devel
Loading...