For 2021 - online Python 3 training - see ((here)).
Our plans were to retire in summer 2020 and see the world, but Coronavirus has lead us into a lot of lockdown programming in Python 3 and PHP 7. We can now offer tailored online training - small groups, real tutors - works really well for groups of 4 to 14 delegates. Anywhere in the world; course language English.
Please ask about private 'maintenance' training for Python 2, Tcl, Perl, PHP, Lua, etc. |
MySQL database from Ruby - an example
Both MySQL and Ruby are huge subjects - the former being an excellent database engine and the latter a superb programming language. Yet although each individually is a huge subject, linking the two (i.e. accessing data stored in a MySQL database via a Ruby program) is so each that it's almost trivial.
Here's one way of doing it - my "Hello MySQL in Ruby" if you like.
1. Download the Ruby/MySQL module from http://www.tmtm.org/en/ruby/mysql/
2. Add the following lines (or equivalent) into your code:
require "mysql"
myconnect = Mysql::new("192.168.200.67", "trainee", "abc123", "forsale")
res = myconnect.query("select * from agents")
res.each do |row|
3. Enjoy!
The code loads in the module that you've downloaded ( require), connects to the database engine and database ( Mysql::new), runs the query (the query method on the connection object) and iterates through the result set.
The full source code of this example is here, and we cover the topic on our Ruby Programming course. (written 2008-11-16)
Associated topics are indexed as below, or enter http://melksh.am/nnnn for individual articles R119 - Ruby Miscellany [1181] Good Programming practise - where to initialise variables - (2007-05-09) [1586] Variable types in Ruby - (2008-03-21) [1720] Some Ruby lesser used functions - (2008-07-26) [1889] Ruby mixins, modules, require and include - (2008-11-16) [3155] Rake - a build system using code written in Ruby - (2011-02-03) [3428] How many days to Christmas? - (2011-09-09) [3622] Loading Ruby classes - where does Ruby look? - (2012-02-24) [3783] Load path, load and require in Ruby, and a change from 1.8 to 1.9 - (2012-06-24) [3799] Ruby Documentation through rdoc - (2012-07-07) R117 - Ruby GUIs, XML, SQL Database Connectivity [2714] A simple example - XML from a Ruby program - (2010-04-10) [4006] Ruby / SQLite3 example program, showing JOIN v LEFT JOIN - (2013-02-16) [4679] Reading in XML in Ruby with xmlsimple - (2016-05-18)
Some other Articles
Shopping in MelkshamSome Linux and Unix tipsMelksham Chamber of Commerce and IndustryRuby to access web servicesMySQL database from Ruby - an exampleFind the linkRuby Programming Course - Saturday and SundayKeys to friendless churchesHiding a MySQL database behind a web page
|
4759 posts, page by page
Link to page ... 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 95, 96 at 50 posts per page
This is a page archived from The Horse's Mouth at
http://www.wellho.net/horse/ -
the diary and writings of Graham Ellis.
Every attempt was made to provide current information at the time the
page was written, but things do move forward in our business - new software
releases, price changes, new techniques. Please check back via
our main site for current courses,
prices, versions, etc - any mention of a price in "The Horse's Mouth"
cannot be taken as an offer to supply at that price.
Link to Ezine home page (for reading).
Link to Blogging home page (to add comments).
|
|