bodington-developers

[Bodington-developers] sql - versions?

[Alistair Y. <ali...@sm...>]

I'm about to try to find out the schema diffs for upgrades - what  
version should I start with and go where?

2_1_1_stable2? -> ? -> ?

Alistair

Re: [Bodington-developers] sql - versions?

[Matthew B. <mat...@co...>]

Alistair Young wrote:
> I'm about to try to find out the schema diffs for upgrades - what  
> version should I start with and go where?
> 
> 2_1_1_stable2? -> ? -> ?

I would be incline to work the other way and see how it goes.

2.4 -> Current Build of HEAD (2.6).
2.1.0rc4 -> 2.4
2.1.1s2 -> 2.1.0rc4?

If we are still accepting more stuff into HEAD then the end schema for 
2.6 may well change.

-- 
+--Matthew Buckett-----------------------------------------+
| VLE Developer, Learning Technologies Group               |
| Tel: +44 (0) 1865 283660 http://www.oucs.ox.ac.uk/       |
+------------Computing Services, University of Oxford------+

Re: [Bodington-developers] sql - versions?

[Alistair Y. <ali...@sm...>]

> still accepting more stuff into HEAD
so I'll work the other way as it's an upgrade path, so it seems  
logical to do:
2_1_1_stable2 -> 2_4
2_4 -> 2_6

I'll ignore the rc "releases".

Alistair


On 25 Jul 2005, at 10:23, Matthew Buckett wrote:

> Alistair Young wrote:
>
>> I'm about to try to find out the schema diffs for upgrades - what   
>> version should I start with and go where?
>> 2_1_1_stable2? -> ? -> ?
>>
>
> I would be incline to work the other way and see how it goes.
>
> 2.4 -> Current Build of HEAD (2.6).
> 2.1.0rc4 -> 2.4
> 2.1.1s2 -> 2.1.0rc4?
>
> If we are still accepting more stuff into HEAD then the end schema  
> for 2.6 may well change.
>
> -- 
> +--Matthew Buckett-----------------------------------------+
> | VLE Developer, Learning Technologies Group               |
> | Tel: +44 (0) 1865 283660 http://www.oucs.ox.ac.uk/       |
> +------------Computing Services, University of Oxford------+
>
>
> -------------------------------------------------------
> SF.Net email is sponsored by: Discover Easy Linux Migration Strategies
> from IBM. Find simple to follow Roadmaps, straightforward articles,
> informative Webcasts and more! Get everything you need to get up to
> speed, fast. http://ads.osdn.com/?ad_id=7477&alloc_id=16492&op=click
> _______________________________________________
> Bodington-developers mailing list
> Bod...@li...
> https://lists.sourceforge.net/lists/listinfo/bodington-developers
>

Re: [Bodington-developers] sql - versions?

[Alistair Y. <ali...@sm...>]

here's a daft question - is is only the sql files that are required  
or does SetupServlet do hard coded sql?

Alistair

On 25 Jul 2005, at 10:27, Alistair Young wrote:

>> still accepting more stuff into HEAD
>>
> so I'll work the other way as it's an upgrade path, so it seems  
> logical to do:
> 2_1_1_stable2 -> 2_4
> 2_4 -> 2_6
>
> I'll ignore the rc "releases".
>
> Alistair
>
>
> On 25 Jul 2005, at 10:23, Matthew Buckett wrote:
>
>
>> Alistair Young wrote:
>>
>>
>>> I'm about to try to find out the schema diffs for upgrades -  
>>> what  version should I start with and go where?
>>> 2_1_1_stable2? -> ? -> ?
>>>
>>>
>>
>> I would be incline to work the other way and see how it goes.
>>
>> 2.4 -> Current Build of HEAD (2.6).
>> 2.1.0rc4 -> 2.4
>> 2.1.1s2 -> 2.1.0rc4?
>>
>> If we are still accepting more stuff into HEAD then the end schema  
>> for 2.6 may well change.
>>
>> -- 
>> +--Matthew Buckett-----------------------------------------+
>> | VLE Developer, Learning Technologies Group               |
>> | Tel: +44 (0) 1865 283660 http://www.oucs.ox.ac.uk/       |
>> +------------Computing Services, University of Oxford------+
>>
>>
>> -------------------------------------------------------
>> SF.Net email is sponsored by: Discover Easy Linux Migration  
>> Strategies
>> from IBM. Find simple to follow Roadmaps, straightforward articles,
>> informative Webcasts and more! Get everything you need to get up to
>> speed, fast. http://ads.osdn.com/?ad_id=7477&alloc_id=16492&op=click
>> _______________________________________________
>> Bodington-developers mailing list
>> Bod...@li...
>> https://lists.sourceforge.net/lists/listinfo/bodington-developers
>>
>>
>
>
>
> -------------------------------------------------------
> SF.Net email is sponsored by: Discover Easy Linux Migration Strategies
> from IBM. Find simple to follow Roadmaps, straightforward articles,
> informative Webcasts and more! Get everything you need to get up to
> speed, fast. http://ads.osdn.com/?ad_id=7477&alloc_id=16492&op=click
> _______________________________________________
> Bodington-developers mailing list
> Bod...@li...
> https://lists.sourceforge.net/lists/listinfo/bodington-developers
>

Re: [Bodington-developers] sql - versions?

[Alexis O'C. <ale...@co...>]

Alistair Young wrote:
> here's a daft question - is is only the sql files that are required  or 
> does SetupServlet do hard coded sql?
> 
> Alistair
> 

I'm almost certain that SetupServlet only invokes SQL that is contained 
within .sql files.

I believe we're working on Wednesday as the cut-off point, so I'm just 
warning you that there is another .sql to come for Quicklinks. Keep your 
eyes peeled for:

src/org/bodington/server/resources/Quicklink.sql

It should be in by this afternoon.

Alexis

Re: [Bodington-developers] sql - versions?

[Alistair Y. <ali...@sm...>]

no probs Alexis - it'll be a while before I get that far anyway

looks like 2_1_1_stable2 was never released so I'll start at  
2_1_1_stable1 -> 2_4_0

Alistair

On 25 Jul 2005, at 10:44, Alexis O'Connor wrote:

> Alistair Young wrote:
>
>> here's a daft question - is is only the sql files that are  
>> required  or does SetupServlet do hard coded sql?
>> Alistair
>>
>
> I'm almost certain that SetupServlet only invokes SQL that is  
> contained within .sql files.
>
> I believe we're working on Wednesday as the cut-off point, so I'm  
> just warning you that there is another .sql to come for Quicklinks.  
> Keep your eyes peeled for:
>
> src/org/bodington/server/resources/Quicklink.sql
>
> It should be in by this afternoon.
>
> Alexis
>
>
> -------------------------------------------------------
> SF.Net email is sponsored by: Discover Easy Linux Migration Strategies
> from IBM. Find simple to follow Roadmaps, straightforward articles,
> informative Webcasts and more! Get everything you need to get up to
> speed, fast. http://ads.osdn.com/?ad_id=7477&alloc_id=16492&op=click
> _______________________________________________
> Bodington-developers mailing list
> Bod...@li...
> https://lists.sourceforge.net/lists/listinfo/bodington-developers
>

Re: [Bodington-developers] sql - versions?

[Colin T. <col...@co...>]

 > Keep your
 > eyes peeled for:
 >
 > src/org/bodington/server/resources/Quicklink.sql


There'll be more, for NewsFeeds, TextBlocks, ImageBlocks...

Alexis O'Connor wrote:
> Alistair Young wrote:
> 
>> here's a daft question - is is only the sql files that are required  
>> or does SetupServlet do hard coded sql?
>>
>> Alistair
>>
> 
> I'm almost certain that SetupServlet only invokes SQL that is contained 
> within .sql files.
> 
> I believe we're working on Wednesday as the cut-off point, so I'm just 
> warning you that there is another .sql to come for Quicklinks. Keep your 
> eyes peeled for:
> 
> src/org/bodington/server/resources/Quicklink.sql
> 
> It should be in by this afternoon.
> 
> Alexis
> 
> 
> -------------------------------------------------------
> SF.Net email is sponsored by: Discover Easy Linux Migration Strategies
> from IBM. Find simple to follow Roadmaps, straightforward articles,
> informative Webcasts and more! Get everything you need to get up to
> speed, fast. http://ads.osdn.com/?ad_id=7477&alloc_id=16492&op=click
> _______________________________________________
> Bodington-developers mailing list
> Bod...@li...
> https://lists.sourceforge.net/lists/listinfo/bodington-developers
> 

Re: [Bodington-developers] sql - versions?

[Matthew B. <mat...@co...>]

Alistair Young wrote:
>> still accepting more stuff into HEAD
> 
> so I'll work the other way as it's an upgrade path, so it seems  logical 
> to do:
> 2_1_1_stable2 -> 2_4
> 2_4 -> 2_6
> 
> I'll ignore the rc "releases".

Looking at the release notes on sourceforge the 2.1.0 series was the 
stable one and the 2.1.1 was aimed at being shapshots for 
experiments/developers, but I may be wrong as I wasn't around in the 
Bodington community when these versions were released.

-- 
+--Matthew Buckett-----------------------------------------+
| VLE Developer, Learning Technologies Group               |
| Tel: +44 (0) 1865 283660 http://www.oucs.ox.ac.uk/       |
+------------Computing Services, University of Oxford------+

Re: [Bodington-developers] sql - versions?

[Colin T. <col...@co...>]

I think Alistair's starting point is what's deployed at UHI (stable2)?

There were some database schema changes between stable1 and stable2 
(from memory, although I have some notes: Logbook, XML repository)

We had trouble upgrading from stable1 to 2_4, because the code that was 
supposed to run some SQL on the database to drop XML repository related 
tables didn't run, so we've ended up with a broken search tool (only 
finds resources created after the upgrade). It was looking for 
bod.properties identifying the current Bod version, which weren't 
present (and as far as I could tell don't ever get created unless you 
add them manually..)

Colin

Matthew Buckett wrote:
> Alistair Young wrote:
> 
>>> still accepting more stuff into HEAD
>>
>>
>> so I'll work the other way as it's an upgrade path, so it seems  
>> logical to do:
>> 2_1_1_stable2 -> 2_4
>> 2_4 -> 2_6
>>
>> I'll ignore the rc "releases".
> 
> 
> Looking at the release notes on sourceforge the 2.1.0 series was the 
> stable one and the 2.1.1 was aimed at being shapshots for 
> experiments/developers, but I may be wrong as I wasn't around in the 
> Bodington community when these versions were released.
> 

Re: [Bodington-developers] sql - versions?

[Alistair Y. <ali...@sm...>]

My eye breaking research so far:

2.1.1 stable1 -> 2.4.0
log_book_entries - columns added
log_book_pages tables - columns added

xml_tokens - columns added
xml_words - columns added

user_x509s created

Colin - no sign of any tables that were deleted. That's worrying! Why  
do you need to delete tables in 2.4.0?

 From a fresh install, no tables have been removed.

Alistair

On 25 Jul 2005, at 12:15, Colin Tatham wrote:

> I think Alistair's starting point is what's deployed at UHI (stable2)?
>
> There were some database schema changes between stable1 and stable2  
> (from memory, although I have some notes: Logbook, XML repository)
>
> We had trouble upgrading from stable1 to 2_4, because the code that  
> was supposed to run some SQL on the database to drop XML repository  
> related tables didn't run, so we've ended up with a broken search  
> tool (only finds resources created after the upgrade). It was  
> looking for bod.properties identifying the current Bod version,  
> which weren't present (and as far as I could tell don't ever get  
> created unless you add them manually..)
>
> Colin
>
> Matthew Buckett wrote:
>
>> Alistair Young wrote:
>>
>>>> still accepting more stuff into HEAD
>>>>
>>>
>>>
>>> so I'll work the other way as it's an upgrade path, so it seems   
>>> logical to do:
>>> 2_1_1_stable2 -> 2_4
>>> 2_4 -> 2_6
>>>
>>> I'll ignore the rc "releases".
>>>
>> Looking at the release notes on sourceforge the 2.1.0 series was  
>> the stable one and the 2.1.1 was aimed at being shapshots for  
>> experiments/developers, but I may be wrong as I wasn't around in  
>> the Bodington community when these versions were released.
>>
>
>
> -------------------------------------------------------
> SF.Net email is sponsored by: Discover Easy Linux Migration Strategies
> from IBM. Find simple to follow Roadmaps, straightforward articles,
> informative Webcasts and more! Get everything you need to get up to
> speed, fast. http://ads.osdn.com/?ad_id=7477&alloc_id=16492&op=click
> _______________________________________________
> Bodington-developers mailing list
> Bod...@li...
> https://lists.sourceforge.net/lists/listinfo/bodington-developers
>

Re: [Bodington-developers] sql - versions?

[Colin T. <col...@co...>]

I was referring to schema changes between stable1 and stable2...


Alistair Young wrote:
> My eye breaking research so far:
> 
> 2.1.1 stable1 -> 2.4.0
> log_book_entries - columns added
> log_book_pages tables - columns added
> 
> xml_tokens - columns added
> xml_words - columns added
> 
> user_x509s created
> 
> Colin - no sign of any tables that were deleted. That's worrying! Why  
> do you need to delete tables in 2.4.0?
> 
>  From a fresh install, no tables have been removed.
> 
> Alistair
> 
> On 25 Jul 2005, at 12:15, Colin Tatham wrote:
> 
>> I think Alistair's starting point is what's deployed at UHI (stable2)?
>>
>> There were some database schema changes between stable1 and stable2  
>> (from memory, although I have some notes: Logbook, XML repository)
>>
>> We had trouble upgrading from stable1 to 2_4, because the code that  
>> was supposed to run some SQL on the database to drop XML repository  
>> related tables didn't run, so we've ended up with a broken search  
>> tool (only finds resources created after the upgrade). It was  looking 
>> for bod.properties identifying the current Bod version,  which weren't 
>> present (and as far as I could tell don't ever get  created unless you 
>> add them manually..)
>>
>> Colin
>>
>> Matthew Buckett wrote:
>>
>>> Alistair Young wrote:
>>>
>>>>> still accepting more stuff into HEAD
>>>>>
>>>>
>>>>
>>>> so I'll work the other way as it's an upgrade path, so it seems   
>>>> logical to do:
>>>> 2_1_1_stable2 -> 2_4
>>>> 2_4 -> 2_6
>>>>
>>>> I'll ignore the rc "releases".
>>>>
>>> Looking at the release notes on sourceforge the 2.1.0 series was  the 
>>> stable one and the 2.1.1 was aimed at being shapshots for  
>>> experiments/developers, but I may be wrong as I wasn't around in  the 
>>> Bodington community when these versions were released.
>>>
>>
>>
>> -------------------------------------------------------
>> SF.Net email is sponsored by: Discover Easy Linux Migration Strategies
>> from IBM. Find simple to follow Roadmaps, straightforward articles,
>> informative Webcasts and more! Get everything you need to get up to
>> speed, fast. http://ads.osdn.com/?ad_id=7477&alloc_id=16492&op=click
>> _______________________________________________
>> Bodington-developers mailing list
>> Bod...@li...
>> https://lists.sourceforge.net/lists/listinfo/bodington-developers
>>
> 
> 
> 
> -------------------------------------------------------
> SF.Net email is sponsored by: Discover Easy Linux Migration Strategies
> from IBM. Find simple to follow Roadmaps, straightforward articles,
> informative Webcasts and more! Get everything you need to get up to
> speed, fast. http://ads.osdn.com/?ad_id=7477&alloc_id=16492&op=click
> _______________________________________________
> Bodington-developers mailing list
> Bod...@li...
> https://lists.sourceforge.net/lists/listinfo/bodington-developers
> 

Re: [Bodington-developers] sql - versions?

[Alistair Y. <ali...@sm...>]

surely they would have shown up between stable1 and 2.4.0? Does that  
mean that deleted tables in stable2 ended up back in 2.4.0?

Alistair

On 25 Jul 2005, at 12:42, Colin Tatham wrote:

>
> I was referring to schema changes between stable1 and stable2...
>
>
> Alistair Young wrote:
>
>> My eye breaking research so far:
>> 2.1.1 stable1 -> 2.4.0
>> log_book_entries - columns added
>> log_book_pages tables - columns added
>> xml_tokens - columns added
>> xml_words - columns added
>> user_x509s created
>> Colin - no sign of any tables that were deleted. That's worrying!  
>> Why  do you need to delete tables in 2.4.0?
>>  From a fresh install, no tables have been removed.
>> Alistair
>> On 25 Jul 2005, at 12:15, Colin Tatham wrote:
>>
>>> I think Alistair's starting point is what's deployed at UHI  
>>> (stable2)?
>>>
>>> There were some database schema changes between stable1 and  
>>> stable2  (from memory, although I have some notes: Logbook, XML  
>>> repository)
>>>
>>> We had trouble upgrading from stable1 to 2_4, because the code  
>>> that  was supposed to run some SQL on the database to drop XML  
>>> repository  related tables didn't run, so we've ended up with a  
>>> broken search  tool (only finds resources created after the  
>>> upgrade). It was  looking for bod.properties identifying the  
>>> current Bod version,  which weren't present (and as far as I  
>>> could tell don't ever get  created unless you add them manually..)
>>>
>>> Colin
>>>
>>> Matthew Buckett wrote:
>>>
>>>
>>>> Alistair Young wrote:
>>>>
>>>>
>>>>>> still accepting more stuff into HEAD
>>>>>>
>>>>>>
>>>>>
>>>>>
>>>>> so I'll work the other way as it's an upgrade path, so it  
>>>>> seems   logical to do:
>>>>> 2_1_1_stable2 -> 2_4
>>>>> 2_4 -> 2_6
>>>>>
>>>>> I'll ignore the rc "releases".
>>>>>
>>>>>
>>>> Looking at the release notes on sourceforge the 2.1.0 series  
>>>> was  the stable one and the 2.1.1 was aimed at being shapshots  
>>>> for  experiments/developers, but I may be wrong as I wasn't  
>>>> around in  the Bodington community when these versions were  
>>>> released.
>>>>
>>>>
>>>
>>>
>>> -------------------------------------------------------
>>> SF.Net email is sponsored by: Discover Easy Linux Migration  
>>> Strategies
>>> from IBM. Find simple to follow Roadmaps, straightforward articles,
>>> informative Webcasts and more! Get everything you need to get up to
>>> speed, fast. http://ads.osdn.com/?ad_id=7477&alloc_id=16492&op=click
>>> _______________________________________________
>>> Bodington-developers mailing list
>>> Bod...@li...
>>> https://lists.sourceforge.net/lists/listinfo/bodington-developers
>>>
>>>
>> -------------------------------------------------------
>> SF.Net email is sponsored by: Discover Easy Linux Migration  
>> Strategies
>> from IBM. Find simple to follow Roadmaps, straightforward articles,
>> informative Webcasts and more! Get everything you need to get up to
>> speed, fast. http://ads.osdn.com/?ad_id=7477&alloc_id=16492&op=click
>> _______________________________________________
>> Bodington-developers mailing list
>> Bod...@li...
>> https://lists.sourceforge.net/lists/listinfo/bodington-developers
>>
>
>
> -------------------------------------------------------
> SF.Net email is sponsored by: Discover Easy Linux Migration Strategies
> from IBM. Find simple to follow Roadmaps, straightforward articles,
> informative Webcasts and more! Get everything you need to get up to
> speed, fast. http://ads.osdn.com/?ad_id=7477&alloc_id=16492&op=click
> _______________________________________________
> Bodington-developers mailing list
> Bod...@li...
> https://lists.sourceforge.net/lists/listinfo/bodington-developers
>

Re: [Bodington-developers] sql - versions?

[Colin T. <col...@co...>]

Yes, you're right. I misread your email. Thought you said stable2 -> 2.4...

The tables are dropped and recreated, but I think the columns change. 
The details are all in org/bodington/installation/upgrade_2_1_to_2_1_1.sql

Colin

Alistair Young wrote:
> surely they would have shown up between stable1 and 2.4.0? Does that  
> mean that deleted tables in stable2 ended up back in 2.4.0?
> 
> Alistair
> 
> On 25 Jul 2005, at 12:42, Colin Tatham wrote:
> 
>>
>> I was referring to schema changes between stable1 and stable2...
>>
>>
>> Alistair Young wrote:
>>
>>> My eye breaking research so far:
>>> 2.1.1 stable1 -> 2.4.0
>>> log_book_entries - columns added
>>> log_book_pages tables - columns added
>>> xml_tokens - columns added
>>> xml_words - columns added
>>> user_x509s created
>>> Colin - no sign of any tables that were deleted. That's worrying!  
>>> Why  do you need to delete tables in 2.4.0?
>>>  From a fresh install, no tables have been removed.
>>> Alistair
>>> On 25 Jul 2005, at 12:15, Colin Tatham wrote:
>>>
>>>> I think Alistair's starting point is what's deployed at UHI  (stable2)?
>>>>
>>>> There were some database schema changes between stable1 and  
>>>> stable2  (from memory, although I have some notes: Logbook, XML  
>>>> repository)
>>>>
>>>> We had trouble upgrading from stable1 to 2_4, because the code  
>>>> that  was supposed to run some SQL on the database to drop XML  
>>>> repository  related tables didn't run, so we've ended up with a  
>>>> broken search  tool (only finds resources created after the  
>>>> upgrade). It was  looking for bod.properties identifying the  
>>>> current Bod version,  which weren't present (and as far as I  could 
>>>> tell don't ever get  created unless you add them manually..)
>>>>
>>>> Colin
>>>>
>>>> Matthew Buckett wrote:
>>>>
>>>>
>>>>> Alistair Young wrote:
>>>>>
>>>>>
>>>>>>> still accepting more stuff into HEAD
>>>>>>>
>>>>>>>
>>>>>>
>>>>>>
>>>>>> so I'll work the other way as it's an upgrade path, so it  seems   
>>>>>> logical to do:
>>>>>> 2_1_1_stable2 -> 2_4
>>>>>> 2_4 -> 2_6
>>>>>>
>>>>>> I'll ignore the rc "releases".
>>>>>>
>>>>>>
>>>>> Looking at the release notes on sourceforge the 2.1.0 series  was  
>>>>> the stable one and the 2.1.1 was aimed at being shapshots  for  
>>>>> experiments/developers, but I may be wrong as I wasn't  around in  
>>>>> the Bodington community when these versions were  released.
>>>>>
>>>>>
>>>>
>>>>
>>>> -------------------------------------------------------
>>>> SF.Net email is sponsored by: Discover Easy Linux Migration  Strategies
>>>> from IBM. Find simple to follow Roadmaps, straightforward articles,
>>>> informative Webcasts and more! Get everything you need to get up to
>>>> speed, fast. http://ads.osdn.com/?ad_id=7477&alloc_id=16492&op=click
>>>> _______________________________________________
>>>> Bodington-developers mailing list
>>>> Bod...@li...
>>>> https://lists.sourceforge.net/lists/listinfo/bodington-developers
>>>>
>>>>
>>> -------------------------------------------------------
>>> SF.Net email is sponsored by: Discover Easy Linux Migration  Strategies
>>> from IBM. Find simple to follow Roadmaps, straightforward articles,
>>> informative Webcasts and more! Get everything you need to get up to
>>> speed, fast. http://ads.osdn.com/?ad_id=7477&alloc_id=16492&op=click
>>> _______________________________________________
>>> Bodington-developers mailing list
>>> Bod...@li...
>>> https://lists.sourceforge.net/lists/listinfo/bodington-developers
>>>
>>
>>
>> -------------------------------------------------------
>> SF.Net email is sponsored by: Discover Easy Linux Migration Strategies
>> from IBM. Find simple to follow Roadmaps, straightforward articles,
>> informative Webcasts and more! Get everything you need to get up to
>> speed, fast. http://ads.osdn.com/?ad_id=7477&alloc_id=16492&op=click
>> _______________________________________________
>> Bodington-developers mailing list
>> Bod...@li...
>> https://lists.sourceforge.net/lists/listinfo/bodington-developers
>>
> 
> 
> 
> -------------------------------------------------------
> SF.Net email is sponsored by: Discover Easy Linux Migration Strategies
> from IBM. Find simple to follow Roadmaps, straightforward articles,
> informative Webcasts and more! Get everything you need to get up to
> speed, fast. http://ads.osdn.com/?ad_id=7477&alloc_id=16492&op=click
> _______________________________________________
> Bodington-developers mailing list
> Bod...@li...
> https://lists.sourceforge.net/lists/listinfo/bodington-developers
>