Re: [CS-Project-devel] Unit Testers for CS-Project

SourceForge Headquarters 1320 Columbia Street Suite 310 San Diego, CA 92101 +1 (858) 422-6466

Lukasz,

None of the afore-mentioned scripts are available, so they'd have to still
be written.  The unit testing suite (simpletest) that is in the lib
directory has a system that simulates a web browser, so I think unit tests
could be written with that which would go through the web-based setup
process along with creating the data.  It might get a little complicated if
form and button names change between versions (not sure on that one).

As far as the upgrade process being complete or not, just check the version
number displayed on the page.  The login page shows a version below the
login form, and after-login pages show that version number below the logo:
just check to make sure that version number has changed to what is expected
(i.e. the version number in the /VERSION file).

Upgrading the checkout itself is as easy as performing the "svn update" (or
"svn switch") command and loading the page again: every time the page loads,
the upgrade system checks the version in /VERSION with what is stored in the
database, and runs scripts as necessary to perform the upgrade.

I'm not sure if I've answered all your questions, so feel free to ask me
again.  Also, can you please start posting to the cs-project-devel list?
That will (hopefully) get others involved as well.  Thanks!

On Fri, Sep 11, 2009 at 9:42 PM, Lukasz Lysik <ll...@gm...> wrote:

> Hi Dan,
>
> I haved fixed the problem I was writting you about. I have a question
> about the update procedure and the script to test it.
>
> As I understood, the script should work like this (following the point
> in one of your previous emails):
> 1. svn checkout
> https://cs-project.svn.sourceforge.net/svnroot/cs-project/releases/1.0
> test_cs-project
> 2. "run script that: builds mutiple users, creates multiple groups (if
> available...?), adds projects, issues, tasks, and notes (a list for
> every available group)" - so basically this is the script, that
> performs the installation process (without following the steps in
> browser) and populates database with sample data. Do you have that
> scripts already? Or they should be made.
> 3. cd test_cs-project; svn up (updates to the latest version in the
> 1.0 line) report errors if there are any
> 4. svn switch
> https://cs-project.svn.sourceforge.net/svnroot/cs-project/releases/1.1
> test_cs-project<https://cs-project.svn.sourceforge.net/svnroot/cs-project/releases/1.1%0Atest_cs-project>- so I overwrite all the old files
> 5. perform upgrade to latest 1.1.x version, report errors - this is
> enigmatic for me. Do you have any scripts to do that? Or how should I
> perform the upgrade. I have overwritten all the old files and logged
> in to the CS-Project. I don't know if upgrade is already done, or not?
> 6. svn switch
> https://cs-project.svn.sourceforge.net/svnroot/cs-project/releases/1.2
> test_cs-project<https://cs-project.svn.sourceforge.net/svnroot/cs-project/releases/1.2%0Atest_cs-project>
> 7. perform upgrade to latest 1.2.x version, report errors - the same
> questions as in point 5.
>
> Regards,
>
> Lukasz
>
> 2009/8/28 Dan Falconer <dan...@gm...>:
> > Am I correct in assuming that you are doing a search for "install"?  I
> was
> > able to recreate the issue by running a search with that criteria; it
> seems
> > the query is attempting to search an integer field for a non-integer
> value
> > ("%install%"), which was apparently OK in PostgreSQL 8.2.  I'll see about
> > fixing it soon.
> >
> > As for the original issue: since you're running PHP successfully on that
> > server for other things, it would be your configuration for cs-project.
> > You'll have to have the "AllowOverride ALL" setting for that host,
> otherwise
> > Apache doesn't know that the "setup" file is actually to be run as PHP.
> If
> > you look at the ".htaccess" file in the public_html folder, you'll see
> > there's a specific entry for the setup file.
> >
> >
> > On Fri, Aug 28, 2009 at 1:28 PM, Lukasz Lysik <ll...@gm...> wrote:
> >>
> >> Thanks for reply,
> >>
> >> PHP is installed properly, cause I am using it with other
> >> applications.I will check it again and send you information.
> >>
> >> 2nd issue: when I enter http://project.crazedsanity.com/extern/helpdesk
> >> this error occure:
> >>
> >> #0  cs_debug_backtrace(1) called at
> >> [/home/crazedsanity/project/lib/mainRecordClass.php:204]
> >> #1  mainRecord->get_records(Array ([keyword] => install,[field] =>
> >> all,[status_id] => Array ([0] => 0,[1] => 1,[2] => 2,[3] =>
> >> 6),[is_helpdesk_issue] => t), ) called at
> >> [/home/crazedsanity/project/lib/helpdeskClass.php:76]
> >> #2  helpdeskClass->get_records(Array ([status_id] => Array ([0] =>
> >> 0,[1] => 1,[2] => 2,[3] => 6)), , Array ([keyword] => install,[field]
> >> => all,[status_id] => ---)) called at
> >> [/home/crazedsanity/project/includes/extern/helpdesk.inc:245]
> >> #3
>  include_once(/home/crazedsanity/project/includes/extern/helpdesk.inc)
> >> called at
> >> [/home/crazedsanity/project/lib/cs-content/contentSystem.class.php:797]
> >> #4  contentSystem->finish() called at
> >> [/home/crazedsanity/project/public_html/extern:19]
> >>
> >> FATAL EXCEPTION ENCOUNTERED:
> >> mainRecord::get_records: no data () or dberror::: ERROR:  operator
> >> does not exist: integer ~~ unknown
> >> LINE 1: ...r(r.name) like '%install%' OR r.leader_contact_id LIKE
> '%ins...
> >>                                                             ^
> >> HINT:  No operator matches the given name and argument type(s). You
> >> might need to add explicit type casts.
> >> SQL::SELECT r.*, record_get_num_children(record_id) as num_children,
> >> s.name as status_text, u.username as assigned, ce.email, c.fname,
> >> c.lname, c.company FROM record_table AS r INNER JOIN status_table AS s
> >> ON (s.status_id=r.status_id) INNER JOIN contact_table AS c ON
> >> (r.creator_contact_id=c.contact_id) INNER JOIN contact_email_table AS
> >> ce ON (c.contact_email_id=ce.contact_email_id) LEFT OUTER JOIN
> >> user_table AS u ON (u.contact_id=r.leader_contact_id) WHERE
> >> is_helpdesk_issue IS true AND (lower(r.name) like '%install%' OR
> >> r.leader_contact_id LIKE '%install%' OR lower(u.username) LIKE
> >> '%install%' OR lower(r.subject) LIKE '%install%') AND s.status_id IN
> >> (0, 1, 2, 6) ORDER BY r.priority ASC, r.status_id ASC, r.name ASC
> >>
> >> Fatal Error
> >>
> >> contentSystem::finish: A fatal error occurred while processing
> >> /includes/extern/helpdesk.inc:
> >> ERROR: mainRecord::get_records: no data () or dberror::: ERROR:
> >> operator does not exist: integer ~~ unknown LINE 1: ...r(r.name) like
> >> '%install%' OR r.leader_contact_id LIKE '%ins... ^ HINT: No operator
> >> matches the given name and argument type(s). You might need to add
> >> explicit type casts. SQL::SELECT r.*,
> >> record_get_num_children(record_id) as num_children, s.name as
> >> status_text, u.username as assigned, ce.email, c.fname, c.lname,
> >> c.company FROM record_table AS r INNER JOIN status_table AS s ON
> >> (s.status_id=r.status_id) INNER JOIN contact_table AS c ON
> >> (r.creator_contact_id=c.contact_id) INNER JOIN contact_email_table AS
> >> ce ON (c.contact_email_id=ce.contact_email_id) LEFT OUTER JOIN
> >> user_table AS u ON (u.contact_id=r.leader_contact_id) WHERE
> >> is_helpdesk_issue IS true AND (lower(r.name) like '%install%' OR
> >> r.leader_contact_id LIKE '%install%' OR lower(u.username) LIKE
> >> '%install%' OR lower(r.subject) LIKE '%install%') AND s.status_id IN
> >> (0, 1, 2, 6) ORDER BY r.priority ASC, r.status_id ASC, r.name ASC
> >>
> >> Lukasz
> >>
> >> 2009/8/28 Dan Falconer <dan...@gm...>:
> >> > Lukasz,
> >> >
> >> > As far as getting only the PHP source, it seems that you either don't
> >> > have
> >> > the PHP module installed into Apache or don't have it registered
> >> > properly.
> >> > I can give some pointers if you let me know what distribution &
> version
> >> > of
> >> > Linux you're using (send me the output of "cat /etc/*-release").
> >> >
> >> > With the error that occurred while logging the problem, can you please
> >> > try
> >> > creating the issue again & send me the output of the fatal error?
> I'll
> >> > try
> >> > tracking it down in the logs as well (I recently upgraded the server
> to
> >> > PostgreSQL 8.3 from 8.2, which I am sure is the cause).
> >> >
> >> > I look forward to hearing from you soon!
> >> >
> >> >
> >> > On Fri, Aug 28, 2009 at 12:38 PM, Lukasz Lysik <ll...@gm...>
> wrote:
> >> >>
> >> >> Hi,
> >> >>
> >> >> I have problem with installing cs-project on my computer. I have
> >> >> downloaded sources from svn (/releases/1.0). .htaccess file is
> already
> >> >> included. But when I enter http://localhost/setup only PHP source is
> >> >> displayed. Do u have any idea what I did wrong?
> >> >>
> >> >> Btw, I posted this as an issue http://project.crazedsanity.com but
> now
> >> >> it seams not to be working. Some Fatal error occurs.
> >> >>
> >> >> Lukasz
> >> >>
> >> >> 2009/8/26 Dan Falconer <dan...@gm...>:
> >> >> > Lukasz,
> >> >> >
> >> >> > When you have a chance, can you just comment on issue #298 on my
> >> >> > install
> >> >> > of
> >> >> > CS-Project?  This will keep you in the loop for now.  Once we've
> got
> >> >> > a
> >> >> > plan
> >> >> > together, I'll get you an account as well.  Thanks.
> >> >> >
> >> >> > On Tue, Aug 25, 2009 at 10:14 AM, Lukasz Lysik <ll...@gm...>
> >> >> > wrote:
> >> >> >>
> >> >> >> OK,
> >> >> >> I will update information on my profile shortly,
> >> >> >>
> >> >> >> Best regards,
> >> >> >> Lukasz
> >> >> >>
> >> >> >> 2009/8/25 Dan Falconer <dan...@gm...>:
> >> >> >> > Lukasz,
> >> >> >> >
> >> >> >> > Eventually I'd like to have as many different environments as
> >> >> >> > possible,
> >> >> >> > but
> >> >> >> > for now I think we can stick with whatever one is available,
> >> >> >> > probably
> >> >> >> > Ubuntu.  The VM that is available through the SVN repository is
> >> >> >> > running
> >> >> >> > Ubuntu JeOS, so that seems like an excellent place to start.
> Once
> >> >> >> > we've
> >> >> >> > got
> >> >> >> > things ironed-out on that system, we can start spreading out to
> >> >> >> > different
> >> >> >> > versions of Linux (and most importantly, testing it on both
> 32-bit
> >> >> >> > and
> >> >> >> > 64-bit systems, since PHP has had issues on 64bit in the past).
> >> >> >> >
> >> >> >> > Thanks for your quick reply.  I look forward to working with
> you.
> >> >> >> >
> >> >> >> > Oh, would you be able to send me some little bit of info
> >> >> >> > explaining
> >> >> >> > what
> >> >> >> > areas you're good with in Linux (i.e. PHP, Bash, PostgreSQL,
> >> >> >> > etc)?  I
> >> >> >> > wanted
> >> >> >> > to look at your skills profile to get an idea, but (at least at
> >> >> >> > the
> >> >> >> > time)
> >> >> >> > you didn't have one setup.
> >> >> >> >
> >> >> >> > On Tue, Aug 25, 2009 at 10:01 AM, Lukasz Lysik <
> ll...@gm...>
> >> >> >> > wrote:
> >> >> >> >>
> >> >> >> >> Hi Dan,
> >> >> >> >>
> >> >> >> >> Thank you for response,
> >> >> >> >>
> >> >> >> >> I during the weekend I will look at that sources and follow the
> >> >> >> >> path
> >> >> >> >> you send me.
> >> >> >> >>
> >> >> >> >> One question: what environments would you like to test on? Do u
> >> >> >> >> have
> >> >> >> >> some specified list prepared or you want to test it in standard
> >> >> >> >> conditions (all environments possible ;-)).
> >> >> >> >>
> >> >> >> >> Will give you feedback during or after the weekend,
> >> >> >> >>
> >> >> >> >> Lukasz
> >> >> >> >>
> >> >> >> >> 2009/8/24 Dan Falconer <dan...@gm...>:
> >> >> >> >> > Lukasz,
> >> >> >> >> >
> >> >> >> >> > I'm looking for help in building a script or suite of scripts
> >> >> >> >> > that
> >> >> >> >> > will
> >> >> >> >> > handle automatic setup for an instance of CS-Project.  The
> >> >> >> >> > system
> >> >> >> >> > needs
> >> >> >> >> > to
> >> >> >> >> > be aware of problems encountered and must be able to
> completely
> >> >> >> >> > destroy
> >> >> >> >> > the
> >> >> >> >> > installation & start from scratch.  The basic idea is to test
> >> >> >> >> > that
> >> >> >> >> > the
> >> >> >> >> > upgrade system is able to take a supported version and
> upgrade
> >> >> >> >> > it
> >> >> >> >> > all
> >> >> >> >> > the
> >> >> >> >> > way from the lowest supported version to the highest
> supported
> >> >> >> >> > version
> >> >> >> >> > in
> >> >> >> >> > succession (i.e. 1.0.0-BETA3 -> 1.0.12 -> 1.1.0 -> 1.1.5 ->
> >> >> >> >> > 1.2.0
> >> >> >> >> > ->
> >> >> >> >> > 1.2.0-ALPHA11).
> >> >> >> >> >
> >> >> >> >> > I've built a new upgrade system, and I need to have an
> >> >> >> >> > automated
> >> >> >> >> > way
> >> >> >> >> > of
> >> >> >> >> > testing this on different systems.  That's where you come in.
> >> >> >> >> > The
> >> >> >> >> > basic
> >> >> >> >> > idea is this:
> >> >> >> >> >
> >> >> >> >> > svn checkout
> >> >> >> >> >
> >> >> >> >> >
> >> >> >> >> >
> >> >> >> >> >
> >> >> >> >> >
> https://cs-project.svn.sourceforge.net/svnroot/cs-project/releases/1.0@(earliest<https://cs-project.svn.sourceforge.net/svnroot/cs-project/releases/1.0@%28earliest>
> >> >> >> >> > released version) test_cs-project
> >> >> >> >> > run script that:
> >> >> >> >> >
> >> >> >> >> > builds mutiple users
> >> >> >> >> > creates multiple groups (if available...?)
> >> >> >> >> > adds projects, issues, tasks, and notes (a list for every
> >> >> >> >> > available
> >> >> >> >> > group)
> >> >> >> >> >
> >> >> >> >> > cd test_cs-project; svn up (updates to the latest version in
> >> >> >> >> > the
> >> >> >> >> > 1.0
> >> >> >> >> > line)
> >> >> >> >> > report errors if there are any
> >> >> >> >> > svn switch
> >> >> >> >> >
> >> >> >> >> >
> >> >> >> >> >
> >> >> >> >> >
> >> >> >> >> >
> https://cs-project.svn.sourceforge.net/svnroot/cs-project/releases/1.1@(earliest<https://cs-project.svn.sourceforge.net/svnroot/cs-project/releases/1.1@%28earliest>
> >> >> >> >> > version of 1.1)
> >> >> >> >> > perform upgrade to latest 1.1.x version, report errors
> >> >> >> >> > svn switch
> >> >> >> >> >
> >> >> >> >> >
> >> >> >> >> >
> >> >> >> >> >
> >> >> >> >> >
> https://cs-project.svn.sourceforge.net/svnroot/cs-project/releases/1.2@(earliest<https://cs-project.svn.sourceforge.net/svnroot/cs-project/releases/1.2@%28earliest>
> >> >> >> >> > version of 1.2)
> >> >> >> >> > perform upgrade to latest 1.2.x version, report errors
> >> >> >> >> >
> >> >> >> >> > The basic idea is pretty easy, but I haven't had time to
> figure
> >> >> >> >> > out
> >> >> >> >> > how
> >> >> >> >> > to
> >> >> >> >> > run through the setup process in an automated fashion.
> >> >> >> >> >
> >> >> >> >> > Things to help get you started:
> >> >> >> >> >
> >> >> >> >> > version numbers are in the form of
> >> >> >> >> > [major].[minor].[maintenance](-[ALPHA|BETA|RC](nn))
> >> >> >> >> >
> >> >> >> >> > i.e. "1.2.0-ALPHA12"::: major=1, minor=2, maintenance=0,
> >> >> >> >> > suffix=ALPHA,
> >> >> >> >> > suffix number=12
> >> >> >> >> >
> >> >> >> >> > all Major.Minor versions are stored in separate folders in
> the
> >> >> >> >> > repository
> >> >> >> >> > under the "releases" folder
> >> >> >> >> >
> >> >> >> >> > "1.1" has the latest of 1.1.x, along with all releases in
> that
> >> >> >> >> > line
> >> >> >> >> > (1.1.0-BETA4 through 1.1.5)
> >> >> >> >> > "1.2" has the latest of 1.2.x along with all releases in that
> >> >> >> >> > line
> >> >> >> >> > (1.2.0-ALPHA8 through 1.2.0-ALPHA11)
> >> >> >> >> >
> >> >> >> >> > releases can always be tracked quickly using the svn log of
> the
> >> >> >> >> > associated
> >> >> >> >> > "VERSION" file (i.e. /releases/1.0/VERSION)
> >> >> >> >> >
> >> >> >> >> > If you have any questions, let me know.  I would suggest
> >> >> >> >> > looking
> >> >> >> >> > through
> >> >> >> >> > the
> >> >> >> >> > logs for all of the VERSION files directly below each folder
> >> >> >> >> > under
> >> >> >> >> > releases.  That should give you a good idea of how things get
> >> >> >> >> > released
> >> >> >> >> > and
> >> >> >> >> > such...
> >> >> >> >> >
> >> >> >> >> >
> >> >> >> >> >
> >> >> >> >> > On Sun, Aug 23, 2009 at 5:59 PM, Lukasz Lysik
> >> >> >> >> > <ll...@us...>
> >> >> >> >> > wrote:
> >> >> >> >> >>
> >> >> >> >> >> Message body follows:
> >> >> >> >> >>
> >> >> >> >> >> Hi,
> >> >> >> >> >>
> >> >> >> >> >> I would like to help. I haven't been involved in open-source
> >> >> >> >> >> project before, but I think it would be nice start. Would
> >> >> >> >> >> you send me more information?
> >> >> >> >> >>
> >> >> >> >> >> I have already downloaded CS-Project.
> >> >> >> >> >>
> >> >> >> >> >> Regards,
> >> >> >> >> >>
> >> >> >> >> >> Lukasz
> >> >> >> >> >>
> >> >> >> >> >> --
> >> >> >> >> >> This message has been sent to you, a registered
> >> >> >> >> >> SourceForge.net
> >> >> >> >> >> user,
> >> >> >> >> >> by another site user, through the SourceForge.net site.
>  This
> >> >> >> >> >> message
> >> >> >> >> >> has been delivered to your SourceForge.net mail alias.  You
> >> >> >> >> >> may
> >> >> >> >> >> reply
> >> >> >> >> >> to this message using the "Reply" feature of your email
> >> >> >> >> >> client,
> >> >> >> >> >> or
> >> >> >> >> >> using the messaging facility of SourceForge.net at:
> >> >> >> >> >> https://sourceforge.net/sendmessage.php?touser=2301675
> >> >> >> >> >>
> >> >> >> >> >
> >> >> >> >> >
> >> >> >> >> >
> >> >> >> >> > --
> >> >> >> >> > Best Regards,
> >> >> >> >> >
> >> >> >> >> >
> >> >> >> >> > Dan Falconer
> >> >> >> >> > http://CrazedSanity.com || http://www.Buzzkill.org
> >> >> >> >> >
> >> >> >> >
> >> >> >> >
> >> >> >> >
> >> >> >> > --
> >> >> >> > Best Regards,
> >> >> >> >
> >> >> >> >
> >> >> >> > Dan Falconer
> >> >> >> > http://CrazedSanity.com || http://www.Buzzkill.org
> >> >> >> >
> >> >> >
> >> >> >
> >> >> >
> >> >> > --
> >> >> > Best Regards,
> >> >> >
> >> >> >
> >> >> > Dan Falconer
> >> >> > http://CrazedSanity.com || http://www.Buzzkill.org
> >> >> >
> >> >
> >> >
> >> >
> >> > --
> >> > Best Regards,
> >> >
> >> >
> >> > Dan Falconer
> >> > http://CrazedSanity.com || http://www.Buzzkill.org
> >> >
> >
> >
> >
> > --
> > Best Regards,
> >
> >
> > Dan Falconer
> > http://CrazedSanity.com || http://www.Buzzkill.org
> >
>

-- 
Best Regards,

Dan Falconer
http://CrazedSanity.com || http://www.Buzzkill.org