Today gonna talk about Rails Complex Query for ordering. Here’s a simple query order by status
@events = @events.order("status DESC")
But what happen if you want to make the query to order the status in a specific sequence. Here’s the example:
@events = @events.order("
WHEN events.status = 'NEW' THEN 0
WHEN events.status = 'OPEN' THEN 1
WHEN events.status = 'UPDATED' THEN 2
WHEN events.status = 'WAITING' THEN 3
WHEN events.status = 'ABANDONED' THEN 4
Recently just got some time to do my own stuff. So I just extract a simple rails Ajax crud js file from the project I done before and published it. More details on Simple Rails AJAX CRUD. Which only has 52 lines. Hope u like it~
Was thinking to write a todo to rewrite it into using PJAX. But realised that push state wouldn’t be too useful for CRUD actions. As storing navigation history after deleting a record wouldn’t be fun.
Following are some experience that I wanna share on how to have free hosting of Redmine for project management and Integrity for CI on Heroku.
Warn: don’t do it unless u are bored like me.
Problems of running Redmine on Heroku:
Integrate Redmine with S3 for files
Solution: Redmine_S3 plugin
Integrate Github Repo
At the root of the Redmine repository, cd repositories/xxxx.git
git reset –soft FETCH_HEAD
git add -A
git ci -m ‘update repository’
git push heroku master
heroku run:console Repository.fetch_changesets
Problems of running Integrity on Heroku:
Bundler not found.
Because Heroku’s Bundler is installed in the system path. But after bundle install, the GEM_HOME is set to /.bundle which doesn’t contain Bundler. And need the hack of putting the bundler into .bundle/ manually.
Gem not found
As Rake tasks are running at the tmp folder(e.g. tmp/1) And looking for Gems at the GEM_HOME /.bundle. Therefore, I have to install Test environment gems on Integrity.
In the current age, there are many ways to create your own website for free. And most of them are web-based and basically using like a blog, since that is the most easy way for people do not have any programming background. So what you need to do is to create your site or blog in one of the website. Then register your domain. At the end is simply link this two together. In this post, I am going to show the steps how to achieve these by some popular blog hosting websites such as WordPress, Google blogger, Google site, squarespace and Typepad. But the last two is not free, they only purvey a trial version for about 14 days.
The first one I want to talk about is the one I am using – WordPress. It provides free blog hosting service. What you need to do is to sign up an account. Then you will have a xxx.wordpress.com for your blog. If you want to have your own domain, WordPress provides $5 USD for registration your domain name and 10 dollar for mapping it together then done! They also provides custom CSS and other features, but that would cost you extra dollars.
Google site and Google blogger is similar to WordPress. They are totally free, albeit they would not provide as much features as WordPress do and has more ads.
TypePad and Spacesquare provides more custom UI(User Interface) design, you can drag and drop items to custom your blog/site’s layout. Meanwhile, they purvey a trial version and would likely charge more.
To sum up, these are some of the most popular choices to make your own site. They are suitable for different requirements. Choices are yours, make your choice.
Recently I have joined a IPhone Application development meet-up, which holds every two weeks on Sunday at UTS. If you have interest on it please no hesitate to contact me.
After I joined the meet-up, I start trying to build an IPhone app. As we know, IPhone apps are builded by using object c, which I am not that familiar with. Then I start searching internet, and found this awesome open source mobile framework – “Rhodes” – to build native mobile apps, which compatible for any smartphone. Rhodes 1.4 features built-in tools for test-driven development, and it allows developers to write executable specifications that test applications, said Blum.
On June 8th, 2010, Adam Blum (Rhomobile) present the topic “BUILDING NATIVE MOBILE APPS WITH RHODES”. He said “Rhodes is the only Ruby-based smartphone app framework for rapidly building native applications for all leading smartphones (iPhone, BlackBerry, Windows Mobile, Android, Symbian). During this session, attendees will learn how developers can leverage their web development skills to build cross-platform native applications that take full advantage of the device’s capabilities (contacts, camera, GPS) and eliminate the need to develop specific applications for each mobile OS.”
Ruby is a modern and productive language that enables Web developers to leverage their skills to write applications in a modern Model-View-Controller architecture, Blum said. “They don’t need to use a 30-year-old language like Objective C,” he added. Moreover, The framework constructs true native applications (not just web apps) and can maintain locally-stored data as well as use GPS, PIM functions, the camera and other specific features of the target hardware it runs on. (Worthington 2010)