As you know, I’ve been working on branches this long holiday weekend. Today, I managed to get the display of a port on a branch to correctly. Along the way, I discovered a downside to storing raw data in the database. Take for example this output: This is the output of make -V RUN_DEPENDS. You […]
A downside of storing the exact results of ‘make -V’ Read More »
In my two previous posts I talked about creating a new port and copying a port from head to a branch. The goal of this post is the creation of a new function: CreatePortOnBranch($category_name, $port_name, $CommitBranch) The failed start I started out with this stored procedure: Running it gave this message: # select CreatePort(‘sysutils’, ‘bacula-server’,
A single function for creating a new port Read More »
In my previous post, I wrote about the need to copy a port from head to a branch in some circumstances, specifically when a master-port is updated and the slave ports do not already exist in the FreshPorts database on that branch. This is a side-effect of FreshPorts only taking action for commits, and not
Copying a port from head to a branch Read More »
FreshPorts is not magic. It grabs the stuff it needs by running make -V with a number of parameters. New fields are added from time to time, usually at the prompting of a user. Recently, the following fields were added to the dev website: FETCH_DEPENDS PATCH_DEPENDS EXTRACT_DEPENDS USES More information on these fields can be
Fetch, Patch, & Extract dependencies and Uses Read More »
I noticed the server load was high. I saw that several instances of search by date where still running. Looking at the query in question: The analysis for this query is available at http://explain.depesz.com/s/uCT I redesigned the query to make use of explicit JOINs: The analysis for that query is at http://explain.depesz.com/s/p3wn. I’ll let readers
Improving date search Read More »
FreshPorts processes commits via email. That is, email coming in from the mailing list are received by FreshPorts, parsed, and the resulting data loaded into the database. Today a problem arose. I received these error messages: This List-Id/Message-Id combination is not known to this script. List-Id=’SVN commit messages for the ports tree for head ‘
Variation in ListId values Read More »
Yesterday, I wrote about some great progress on getting FreshPorts to work with multiple repositories to cater for the branches of the FreeBSD ports tree. At the end of that post, I talked briefly about wanting global settings or variables for my stored procedures. Shortly after posting that, I found a solution in the form
Session variables! Almost. Not quite. Read More »
Today I managed to make quite a bit of progress trying to incorporate multiple ports trees into the commit processing. The diff is about 985 lines long. It’s not as complex as it sounds. I just have to pass $CommitBranch around to various functions. The result: I have the commits going into the database, but
Multiple repos – good progress Read More »
In a recent post, I said: That second patch uses the same string you saw above in the previous patch. Yes, it would be better to have added that string to just one place. I welcome patches for that change. Today I will show you that code. With help from Matthias Andree on IRC, I
Adding code, removing more code to reduce duplication Read More »
As mentioned in my previous post, if FreshPorts is to display commits from every branch, it is going to need one check-out of each branch of the ports tree. Tonight I started looking into that and hit a snag in an unexpected area: name length. I do most of my development work from within jails.
Multiple ports trees for FreshPorts Read More »