Re: [fossil-users] HTSQL for SQLite? Was: ticket lists over json working
On Fri, Feb 4, 2011 at 8:08 AM, Gour g...@atmarama.net wrote: On Thu, 3 Feb 2011 23:43:58 -0500 Ron Wilson wrote: This would make report queries easier to write. Indeed. Indeed indeed. Only one tiny problem: To download the the source code, $ hg clone http://bitbucket.org/prometheus/htsql; we should get them to change to fossil first ;) I believe it's worth doing an experiment with it... Me as well. -- - stephan beal http://wanderinghorse.net/home/stephan/ ___ fossil-users mailing list fossil-users@lists.fossil-scm.org http://lists.fossil-scm.org:8080/cgi-bin/mailman/listinfo/fossil-users
[fossil-users] HTSQL for SQLite? Was: ticket lists over json working
It looks like most of the pieces are place, bar the Htsql(parser?). I like the ability to instrument fossil as shown on the Htsql site, - perhaps using http://www.simile-widgets.org/timeplot/ to track activity over time. But I don't think Htsql is a requirement for this, and extending the reports functionality in the ui to allow for the creation of new views and even templating json. I'm using fossil for project management in addition to scm. S. On Friday, February 4, 2011, Richard Hipp d...@sqlite.org wrote: I just ran across HTSQL (http://htsql.org/) a few moments ago. I haven't looked at it much, yet, but it seems like an intriguing idea. Suppose we did this: (1) Add a small assortment of VIEWs and/or VIRTUAL TABLEs to Fossil that allow things like timelines and branch lists to be queried as if they were plain old tables. (2) Add an HTSQL-like interface to Fossil that returns results in either HTML, XML, or JSON. (3) Add a single command that lets you easily submit any URL request from the command-line. (The http command is close to this already, but it would be better if you could put the URL as an argument on the command-line rather than having to pipe it into standard input.) I'm not exactly sure what problem the above solves, but it seems interesting all the same. Please do not hesitate to expression confirming or contrary opinions... -- D. Richard Hipp d...@sqlite.org -- -- Stephen De Gabrielle stephen.degabrie...@acm.org Telephone +44 (0)20 85670911 Mobile+44 (0)79 85189045 http://www.degabrielle.name/stephen ___ fossil-users mailing list fossil-users@lists.fossil-scm.org http://lists.fossil-scm.org:8080/cgi-bin/mailman/listinfo/fossil-users
Re: [fossil-users] HTSQL for SQLite? Was: ticket lists over json working
On Fri, Feb 4, 2011 at 2:53 AM, Richard Hipp d...@sqlite.org wrote: I just ran across HTSQL (http://htsql.org/) a few moments ago. I haven't looked at it much, yet, but it seems like an intriguing idea. Suppose we did this: ... feature ideas snipped ... I'm not exactly sure what problem the above solves, but it seems interesting all the same. @Richard: i hope you don't mind, but i used the above snippet from your post today as an example (sent to work colleagues) of the differences in FOSS and commercial development mindsets. In all my years, your last line there summarizes it all so well for me, and is the best example i've ever seen demonstrating the difference. i think it would make a good poster or t-shirt, actually. Happy Hacking! -- - stephan beal http://wanderinghorse.net/home/stephan/ ___ fossil-users mailing list fossil-users@lists.fossil-scm.org http://lists.fossil-scm.org:8080/cgi-bin/mailman/listinfo/fossil-users
[fossil-users] Deploying A Web Application with Fossil and FTP
Hi to all, let say we have web site, which sources are managed using fossil. This web site is running on server and document root can be accessed via ftp. Is there some way to use fossil to deploy changed files to server? It meens to upload specified branch to server via ftp? If not, could be some change do it via cgi? Best regards, Ondrej. -- Ondrej Nemecek icq: 250163477 ___ fossil-users mailing list fossil-users@lists.fossil-scm.org http://lists.fossil-scm.org:8080/cgi-bin/mailman/listinfo/fossil-users
Re: [fossil-users] Deploying A Web Application with Fossil and FTP
On Fri, Feb 04, 2011 at 06:12:46PM +0100, Ondrej Nemecek wrote: Hi to all, let say we have web site, which sources are managed using fossil. This web site is running on server and document root can be accessed via ftp. Is there some way to use fossil to deploy changed files to server? It meens to upload specified branch to server via ftp? If not, could be some change do it via cgi? Some time ago I wrote that I'd like a WebDAV fossil interface; I think it would be of great use. It could be implemented gradually. First readonly, and then with versions. But that is hard to do, but it may be a more complete approach than what you suggest. ___ fossil-users mailing list fossil-users@lists.fossil-scm.org http://lists.fossil-scm.org:8080/cgi-bin/mailman/listinfo/fossil-users
[fossil-users] Fossil http plugin Support
Hello everyone. I am really impressed by fossil. I currently like it that much, I even organize my school and work stuff with it. Now my question: Has someone ever tried to implement some sort of plugin interface which allows to extend the http server? Like a generator for mathematical formula pictures and so on. Thank you, Louis ___ fossil-users mailing list fossil-users@lists.fossil-scm.org http://lists.fossil-scm.org:8080/cgi-bin/mailman/listinfo/fossil-users
Re: [fossil-users] Fossil http plugin Support
Do you mean like wiki-text into mathml ? On Friday, February 4, 2011, Louis Hoefler louis.hoef...@gmx.de wrote: Hello everyone. I am really impressed by fossil. I currently like it that much, I even organize my school and work stuff with it. Now my question: Has someone ever tried to implement some sort of plugin interface which allows to extend the http server? Like a generator for mathematical formula pictures and so on. Thank you, Louis ___ fossil-users mailing list fossil-users@lists.fossil-scm.org http://lists.fossil-scm.org:8080/cgi-bin/mailman/listinfo/fossil-users -- -- Stephen De Gabrielle stephen.degabrie...@acm.org Telephone +44 (0)20 85670911 Mobile+44 (0)79 85189045 http://www.degabrielle.name/stephen ___ fossil-users mailing list fossil-users@lists.fossil-scm.org http://lists.fossil-scm.org:8080/cgi-bin/mailman/listinfo/fossil-users
Re: [fossil-users] Deploying A Web Application with Fossil and FTP
I do this myself. I wrote a Perl program to take the output from fossil status, and deploy the files via copy (devtest Samba share as target) or FTP (production). It's pretty straightforward. I have an alias for it, so I just issue fsl-deploy dev or fsl-deploy prod. Just have to remember to deploy before the commit. For the Unix target (prod), it knows to issue a chmod to set *.cgi as executable. -Clark - Original Message From: Ondrej Nemecek ondrej.nemecek.news.fossil.us...@gmail.com To: fossil-users@lists.fossil-scm.org Sent: Fri, February 4, 2011 9:12:46 AM Subject: [fossil-users] Deploying A Web Application with Fossil and FTP Hi to all, let say we have web site, which sources are managed using fossil. This web site is running on server and document root can be accessed via ftp. Is there some way to use fossil to deploy changed files to server? It meens to upload specified branch to server via ftp? If not, could be some change do it via cgi? Best regards, Ondrej. -- Ondrej Nemecek icq: 250163477 ___ fossil-users mailing list fossil-users@lists.fossil-scm.org http://lists.fossil-scm.org:8080/cgi-bin/mailman/listinfo/fossil-users ___ fossil-users mailing list fossil-users@lists.fossil-scm.org http://lists.fossil-scm.org:8080/cgi-bin/mailman/listinfo/fossil-users
Re: [fossil-users] Deploying A Web Application with Fossil and FTP
On 02/04/2011 04:11 PM, Ondrej Nemecek wrote: Is there some simple way to list files changed between two versions? Then can be upload procedure easily scripted (using common command-line ftp client). `fossil update -n VERSION` shows a list of file changes made when updating to VERSION from the current VERSION, but does not actually make any changes. Since you can also 'update' to revisions in the past, you can use this to see the differences between a past revision and the current. (Though you'd have to reverse the add/remove logic if you keep on the current version and parse the output of updating to the past version.) -- Joshua Paine LetterBlock: Web applications built with joy http://letterblock.com/ 301-576-1920 ___ fossil-users mailing list fossil-users@lists.fossil-scm.org http://lists.fossil-scm.org:8080/cgi-bin/mailman/listinfo/fossil-users
Re: [fossil-users] Deploying A Web Application with Fossil and FTP
It's good idea, bud I'd like to deploy any version of source tree independently of commit. Of cource - I must know the version on the server and I must deal with deleted files etc. Dne 4.2.2011 21:57, Clark Christensen napsal(a): I do this myself. I wrote a Perl program to take the output from fossil status, and deploy the files via copy (devtest Samba share as target) or FTP (production). It's pretty straightforward. I have an alias for it, so I just issue fsl-deploy dev or fsl-deploy prod. Just have to remember to deploy before the commit. For the Unix target (prod), it knows to issue a chmod to set *.cgi as executable. -Clark -- Ondrej Nemecek icq: 250163477 ___ fossil-users mailing list fossil-users@lists.fossil-scm.org http://lists.fossil-scm.org:8080/cgi-bin/mailman/listinfo/fossil-users
[fossil-users] How to deal with ,,submodules''?
Hi to all, I have in my project more subdirectories which contains independent code - libraries or independent modules for example. I consider to be nice to have this code in separated repositories. How do it? I tried to open more repositories at once time, but I got message /Already within an open tree rooted at/ Is there some feature as git submodules? Or how deal with it? Best regards, Ondrej. -- Ondrej Nemecek icq: 250163477 ___ fossil-users mailing list fossil-users@lists.fossil-scm.org http://lists.fossil-scm.org:8080/cgi-bin/mailman/listinfo/fossil-users
Re: [fossil-users] Deploying A Web Application with Fossil and FTP
For some personal sites, what I do is I actually have the fossil repo opened in the web directory. It's .htaccess'd off so that you can't get at it, even if you know it's there. Then, I've got a cronjob that once every 15 minutes does a 'fossil update release'. Where 'release' is just a tag that I apply to checkins that I feel are ready. I could probably also have a 'vX.Y.Z' tag so that I could force it backwards too, but, they're just personal sites. :) I could probably also wrap it in a script that did more complicated release logic, if I wanted. Just an alternate solution to your problem. Not suggesting that what you want is wrong or invalid. -B On Fri, Feb 4, 2011 at 1:29 PM, Ondrej Nemecek ondrej.nemecek.news.fossil.us...@gmail.com wrote: It's good idea, bud I'd like to deploy any version of source tree independently of commit. Of cource - I must know the version on the server and I must deal with deleted files etc. Dne 4.2.2011 21:57, Clark Christensen napsal(a): I do this myself. I wrote a Perl program to take the output from fossil status, and deploy the files via copy (devtest Samba share as target) or FTP (production). It's pretty straightforward. I have an alias for it, so I just issue fsl-deploy dev or fsl-deploy prod. Just have to remember to deploy before the commit. For the Unix target (prod), it knows to issue a chmod to set *.cgi as executable. -Clark -- Ondrej Nemecek icq: 250163477 ___ fossil-users mailing list fossil-users@lists.fossil-scm.org http://lists.fossil-scm.org:8080/cgi-bin/mailman/listinfo/fossil-users ___ fossil-users mailing list fossil-users@lists.fossil-scm.org http://lists.fossil-scm.org:8080/cgi-bin/mailman/listinfo/fossil-users
Re: [fossil-users] Deploying A Web Application with Fossil and FTP
On Fri, 4 Feb 2011 13:44:18 -0800 Brian Smith br...@linuxfood.net wrote: For some personal sites, what I do is I actually have the fossil repo opened in the web directory. It's .htaccess'd off so that you can't get at it, even if you know it's there. Any particular reason to keep the repo in the web directory? Wouldn't putting it somewhere outside whatever security wrapper you have on the web server make more sense? Then, I've got a cronjob that once every 15 minutes does a 'fossil update release'. Where 'release' is just a tag that I apply to checkins that I feel are ready. I could probably also have a 'vX.Y.Z' tag so that I could force it backwards too, but, they're just personal sites. :) I've done this kind of thing with perforce for a couple of clients, including automatically syncing to test, q/a and then production servers. I could probably also wrap it in a script that did more complicated release logic, if I wanted. Based on my experience, you don't really need much release logic in the script. While mine was wrapped in a script, most of the script was to parse the output of the update command to find added/changed/deleted files to have the search engine index/reindex/delete them. Just create branches for the various sites in the release process (test, q/a, production or whatever) have each site open on the appropriate branch, with the repo autosyncing so the update command will pull from the master, and then your release process can focus on updating the branches in the master repo properly, and the web sites will follow along automatically. mike -- Mike Meyer m...@mired.org http://www.mired.org/consulting.html Independent Network/Unix/Perforce consultant, email for more information. O ascii ribbon campaign - stop html mail - www.asciiribbon.org ___ fossil-users mailing list fossil-users@lists.fossil-scm.org http://lists.fossil-scm.org:8080/cgi-bin/mailman/listinfo/fossil-users
Re: [fossil-users] Deploying A Web Application with Fossil and FTP
Unfortunately I have no command line access on server and no chance to run cron jobs there :-( Dne 4.2.2011 22:44, Brian Smith napsal(a): For some personal sites, what I do is I actually have the fossil repo opened in the web directory. It's .htaccess'd off so that you can't get at it, even if you know it's there. Then, I've got a cronjob that once every 15 minutes does a 'fossil update release'. Where 'release' is just a tag that I apply to checkins that I feel are ready. I could probably also have a 'vX.Y.Z' tag so that I could force it backwards too, but, they're just personal sites. :) I could probably also wrap it in a script that did more complicated release logic, if I wanted. Just an alternate solution to your problem. Not suggesting that what you want is wrong or invalid. -B -- Ondrej Nemecek icq: 250163477 ___ fossil-users mailing list fossil-users@lists.fossil-scm.org http://lists.fossil-scm.org:8080/cgi-bin/mailman/listinfo/fossil-users
Re: [fossil-users] How to deal with ,,submodules''?
I believe you can do it with a bit of a hack-around, but I'm not sure: In your existing repo, set the ignore-glob to ignore the not-yet-existing directory you're going to put the sub-repo in. fossil open the sub-repo in another dir outside of the existing tree. Move the sub-repo working copy directory to the desired location in the existing repo directory. There won't be any integration between the repos, but I believe that this way they won't step on each other's toes. (But test first!) -- Joshua Paine LetterBlock: Web applications built with joy http://letterblock.com/ 301-576-1920 ___ fossil-users mailing list fossil-users@lists.fossil-scm.org http://lists.fossil-scm.org:8080/cgi-bin/mailman/listinfo/fossil-users
Re: [fossil-users] Deploying A Web Application with Fossil and FTP
On Fri, Feb 4, 2011 at 2:40 PM, Mike Meyer mwm-keyword-fossil.1d1...@mired.org wrote: On Fri, 4 Feb 2011 13:44:18 -0800 Brian Smith br...@linuxfood.net wrote: For some personal sites, what I do is I actually have the fossil repo opened in the web directory. It's .htaccess'd off so that you can't get at it, even if you know it's there. Any particular reason to keep the repo in the web directory? Wouldn't putting it somewhere outside whatever security wrapper you have on the web server make more sense? The sqlite file that contains the artifacts isn't (usually) in the webroot. It's stored elsewhere, but, the webroot is a checkout of the repository, which is necessary so that fossil up will actually update the files. I suppose I could modify it so that it opens and closes a checkout to make it more secure, but, I tend to err on the side of trusting my tool (apache in this case), rather than supposing it'll be compromised at any second. ( Especially when you consider how long apache has been around and it's generally favorable security record, I don't think it's unreasonable to trust it's security wrapper. ) As far as sense goes, I think my setup makes perfect sense. :) Then, I've got a cronjob that once every 15 minutes does a 'fossil update release'. Where 'release' is just a tag that I apply to checkins that I feel are ready. I could probably also have a 'vX.Y.Z' tag so that I could force it backwards too, but, they're just personal sites. :) I've done this kind of thing with perforce for a couple of clients, including automatically syncing to test, q/a and then production servers. I could probably also wrap it in a script that did more complicated release logic, if I wanted. Based on my experience, you don't really need much release logic in the script. While mine was wrapped in a script, most of the script was to parse the output of the update command to find added/changed/deleted files to have the search engine index/reindex/delete them. My solution requires no logic at the moment. I cd into a directory and run 'fossil update release'. What I was alluding to about complicated logic was something that maybe looked at version tags, and updated to the latest version tag that also contained the tag release. Or performed some pre-release actions such as running db schema updates. Just as an example. I won't speak to whether or not it makes sense to automatically run database schema updates. Just create branches for the various sites in the release process (test, q/a, production or whatever) have each site open on the appropriate branch, with the repo autosyncing so the update command will pull from the master, and then your release process can focus on updating the branches in the master repo properly, and the web sites will follow along automatically. As I said, these are personal sites and thus don't require anything other than a single release tag. The way to make an automatic release is: 'fossil tag add release trunk' 'fossil sync'. And, I'm done. A side-effect, that, I haven't tested, is, I could also cancel the release tag, and I'm relatively sure that the site would roll back. It also means that I could also setup any other arbitrary tags that I wanted, such as 'stable', or 'testing', or 'monkeys' (because who doesn't love monkeys?) and the process would be the same. -B ___ fossil-users mailing list fossil-users@lists.fossil-scm.org http://lists.fossil-scm.org:8080/cgi-bin/mailman/listinfo/fossil-users
Re: [fossil-users] How to deal with ,,submodules''?
Hi Joshua, i set ignore-glob and tested it: - It is possible to open repository out of tree and then move files and _FOSSIL_ file to desired directory in tree. It seems it is working, excepted autosync: /Autosync failed. Continue in spite of sync failure (y/N)?/ - It is possible to open repository in subdirectory first and then open repository in top-level directory. But there is the same issue as above. Both methods don't allow to open more than one repository in the same subdirectory. So there is only one possible solution - open and close repossitories as needed (top level repository and subrepositories). Have anybody better idea? Best regards, Ondrej Dne 5.2.2011 00:18, Joshua Paine napsal(a): I believe you can do it with a bit of a hack-around, but I'm not sure: In your existing repo, set the ignore-glob to ignore the not-yet-existing directory you're going to put the sub-repo in. fossil open the sub-repo in another dir outside of the existing tree. Move the sub-repo working copy directory to the desired location in the existing repo directory. There won't be any integration between the repos, but I believe that this way they won't step on each other's toes. (But test first!) -- Ondrej Nemecek icq: 250163477 ___ fossil-users mailing list fossil-users@lists.fossil-scm.org http://lists.fossil-scm.org:8080/cgi-bin/mailman/listinfo/fossil-users
Re: [fossil-users] Deploying A Web Application with Fossil and FTP
On Fri, Feb 4, 2011 at 5:55 PM, Ondrej Nemecek ondrej.nemecek.news.fossil.us...@gmail.com wrote: Unfortunately I have no command line access on server and no chance to run cron jobs there :-( As long as your webserver file tree is a duplicate of your local staging file tree, then you could the output of fossil update in your staging file tree and use that to drive a script (perhaps Perl) that generates FTP commands to put or delete the changed files. ___ fossil-users mailing list fossil-users@lists.fossil-scm.org http://lists.fossil-scm.org:8080/cgi-bin/mailman/listinfo/fossil-users
Re: [fossil-users] How to deal with ,,submodules''?
On Fri, Feb 4, 2011 at 7:01 PM, Ondrej Nemecek ondrej.nemecek.news.fossil.us...@gmail.com wrote: So there is only one possible solution - open and close repossitories as needed (top level repository and subrepositories). Have anybody better idea? If you are running on Linux, BSD or other Unix type OS, you could have symlinks in your main working copy pointing to the working copies of the shared subprojects. If you are using Windows XP or newer, you should be abe to accomplish the same using NTFS Junction Points. ___ fossil-users mailing list fossil-users@lists.fossil-scm.org http://lists.fossil-scm.org:8080/cgi-bin/mailman/listinfo/fossil-users
Re: [fossil-users] value of a just added column
On 02/04/2011 08:01 PM, Ron Wilson wrote: I added a new column to my tickets table, one that I want to use in the WHERE clause of a SELECT. in SQL, anything = NULL is always false. Try where column_name is null -- Joshua Paine LetterBlock: Web applications built with joy http://letterblock.com/ 301-576-1920 ___ fossil-users mailing list fossil-users@lists.fossil-scm.org http://lists.fossil-scm.org:8080/cgi-bin/mailman/listinfo/fossil-users