xubuntu ruby on rails

---

Xubuntu 8.10 install.
$sudo aptitude install ruby
http://www.ruby-lang.org
http://rubyonrails.org
http://www.rubygems.org

---

$sudo aptitude install libyaml-ruby
$sudo aptitude install libzlib-ruby
$sudo aptitude install curl
$curl -O http://files.rubyforge.vm.bytemark.co.uk/rubygems/rubygems-1.3.1.tgz
$tar -xvzf rubygems-1.3.1.tgz
$sudo ruby setup.rb
$rm -r rubygems-1.3.1
$rm rubygems-1.3.1.tgz
( $gem
The program 'gem' can be found in the following packages:
* rubygems1.8
* rubygems1.9 )
$sudo ln -s /usr/bin/gem1.8 /usr/bin/gem
$gem --version
1.3.1
$sudo gem install rails

---

$sudo aptitude install mysql-server
$mysql -u root -p
mysql>create database stock_development;
mysql>create database stock_test;
mysql>create database stock_production;
mysql>grant all on stock_development.* to 'stock_user'@'localhost' identified by 'stock_user';
mysql>grant all on stock_test.* to 'stock_user'@'localhost' identified by 'stock_user';
mysql>grant all on stock_production.* to 'stock_user'@'localhost' identified by 'stock_user';
$sudo gem install mysql
no such file to load -- mkmf (LoadError)
$sudo aptitude install ruby1.8-dev
$sudo gem install mysql
/usr/bin/ruby1.8 extconf.rb install mysql
checking for mysql_query() in -lmysqlclient... no
checking for main() in -lm... yes
checking for mysql_query() in -lmysqlclient... no
checking for main() in -lz... no
checking for mysql_query() in -lmysqlclient... no
checking for main() in -lsocket... no
checking for mysql_query() in -lmysqlclient... no
checking for main() in -lnsl... yes
checking for mysql_query() in -lmysqlclient... no
*** extconf.rb failed ***
$sudo aptitude install libmysql-ruby

---

$mkdir src
$cd src
$rails stock
$cd stock
$script/console
(sh: irb: not found)
$sudo aptitude install irb1.8
$sudo ln -s /usr/bin/irb1.8 /usr/bin/irb
$script/console
no such file to load -- net/https
$sudo aptitude install libopenssl-ruby

---

$script/generate scaffold Provider name:string iva_type:integer
$rake db:migrate

---

$sudo aptitude install gedit

---

$sudo aptitude install git
$sudo aptitude install git-core
$git clone http://github.com/lguardiola/documentation_hacks
$cp -r documentation_hacks vendor/plugins
$rake doc:models:annotate

---

$script/plugin install git://github.com/technoweenie/restful-authentication.git
$script/generate authenticated user sessions
$script/plugin install git://github.com/timcharper/role_requirement.git
$script/generate roles Role User
No such file or directory - /home/maximilianou/src/stock1/app/controllers/application.rb
$cp app/controllers/application_controller.rb app/controllers/application.rb
$script/generate roles Role User
$mv app/controllers/application.rb app/controllers/application_controller.rb
$rake db:migrate

---

windows, ruby on rails, sqlite3

---

Download Ruby from:
http://www.ruby-lang.org/es/downloads/

binarios compilados
ftp://ftp.ruby-lang.org/pub/ruby/binaries/mswin32/ruby-1.8.6-i386-mswin32.zip

UnZip:
C:\ruby

PATH=%PATH%;C:\ruby\bin

Download RubyGems from:
http://rubygems.rubyforge.org

http://rubyforge.org/frs/download.php/45906/rubygems-1.3.1.zip

UnZip:
C:\rubygems-1.3.1

C:\rubygems-1.3.1>ruby setup.rb

C:\gem install rails --include-dependencies

Problemas No Encuentra Esto:
zlib.dll
SSLEAY32.dll

A otra cosa,

Eliminar
C:\ruby

Eliminar
C:\rubygems-1.3.1

---

Ahora con One-Click Installer:

http://rubyforge.org/frs/download.php/18566/ruby186-25.exe

C:>gem install rails --include-dependencies

---

C:>mkdir src
C:>cd src
C:\src>mkdir work
C:\src>cd work
C:\src\work>rails demo
C:\src\work>cd demo
C:\src\work\demo>ruby script\server

Rails requires RubyGems >= 1.1.1 (you have 0.9.2). Please `gem update --system`
and try again.

C:\src\work\demo>gem update --system

C:\src\work\demo>ruby script\server

http://localhost:3000/

---

no such file to load -- sqlite3

http://www.sqlite.org/download.html

UnZip and Copy:
C:\ruby\bin\sqlite3.exe

C:\>gem install sqlite3-ruby
checking for fdatasync() in rt.lib... no


from http://groups.google.com/group/comp.lang.ruby/browse_thread/thread/9d5c9ee6167dace4
http://www.sqlite.org/download.html

UnZip and Copy:
C:\ruby\bin\sqlite3.dll
C:\ruby\bin\sqlite3.def

C:\>gem install sqlite3-ruby
checking for fdatasync() in rt.lib... no

from http://www.nabble.com/Beginner-help:-Problem-installing-sqlite3-on-Windows-XP-td19200418.html
Jim Carter

C:\>gem install --version 1.2.3 sqlite3-ruby

http://localhost:3000/rails/info/properties
Perfecto!!!

---

debian, lenny, virtualbox, amd64

---

from http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=502375
thanks to Daniel Baumann

#apt-get update

#apt-get upgrade

#apt-get install virtualbox

#vi /etc/group
...
vboxusers:x:114:maximilianou
...

#apt-get install virtualbox-ose-source

#m-a a-i virtualbox-ose

Restart the system

#modprobe vboxdrv

---

debian, lenny, amd64, mysql

---

Installing MySql Server and Client:

#apt-get install mysql-server

---

#netstat -tap |grep mysql

---

#mysqladmin -u root password xxxx

---

#mysql -u root -p
password:xxxx
mysql>quit

---

Creating a Database and User

MySql Information Schema
http://dev.mysql.com/doc/refman/5.0/en/information-schema.html
http://www.xcdsql.org/Misc/MySQL_INFORMATION_SCHEMA.html

#mysql -u root -p
password:xxxx
mysql>create database mvcdb;
mysql>grant all privileges on mvcdb.* to 'mvcuser'@'%' identified by 'mvcuser';
mysql>use mysql;
mysql>show tables;
mysql>select host, user, password from user where user like 'mvcuser%';
mysql>use information_schema;
mysql>show tables;
mysql>select * from user_privileges where grantee like "'mvcuser%'";

---

$mysql -u mvcuser, runs well
but i want
$mysql -u mvcuser -p, and this is not running well
now reading..

---

Reading Agile Web Development with Rails

---

Api installed documentation
use RubyGems to install rails.
$gem help server
$gem server
http://localhost:8808/

---

Agile Manifesto

Source: agilemanifesto.org

I have to remember this:

. Individuals and Interactions over processes and tools.
. Working Software over comprehensive documentation.
. Customer Collaboration over contract negotiation.
. Responding to Change over following a plan.

C#, Existent DataGridView, Add Column

---

Una vez que tenemos las rutas visibles en el DockPanel, y todo funciona perfectamente. Vamos a sumar el campo de Grupo a las rutas.
Pasos para recordar y en un futuro agregado no quedar en el camino.

---

1. Agragar la columna en la base:

ALTER TABLE RUTAS
ADD GRUPO_NOMBRE VARCHAR(50)

---

2. Re-Generar el DataSource en el "RUTASDS.xsd"
.Ir al Solution Explorer > LocalDatasets.DataSources.RUTASDS DobleClick
.Seleccionar el Query GetDataByRutasVisibles() ClickDerecho Properties
.Salvar en un NotePad el CommandText
.SELECT "ID_RUTA", "RUTA_NOMBRE", "RUTA_VISIBLE", "RUTA_COLOR", "GRUPO_NOMBRE" FROM "RUTAS" WHERE RUTA_VISIBLE = 1
.Ir al Solution Explorer > LocalDatasets.Datasources.RUTASDS BORRAR
.Ir al Panel DataSources > ClickDerecho > Add New DataSource
.Crear por default el DataSouces RUTASDS con la tabla Rutas > Finish
.RUTASDS.xsd > RUTASTableAdapter ClickDerecho > Add Query > Use SQL statements >
Select which returns rows > Pegar el Query
SELECT "ID_RUTA", "RUTA_NOMBRE", "RUTA_VISIBLE", "RUTA_COLOR", "GRUPO_NOMBRE" FROM "RUTAS" WHERE RUTA_VISIBLE = 1

---

3. Re-Generar el DataSource de "Object DataSource del DataGridView"
.Build Solution
.Select DockRutas.cs > DataGridView Click > ir al panel DataSources
> Expandir LocalDatasets > RUTASDS > Remove Object
.LocalDatasets > ClickDerecho > Add New DataSource > Object
> LocalDatasets.LocalDatasets.RUTASDS > Next > Finish
.Build Solution

---

4. Re-Generar el DataGridView
.ClickDerecho en el DataGridVew > Delete
.DataSources.LocalDatasets.RUTASDS.RUTAS > Arrastrar y pegar en el DockPanel
.Seleccionar el DataGridView > Panel Propiedades > Propiedad DataSource > Cambiar (rUTASBindingSource1) a rUTASBindingSource
.Eliminar del Panel Bajo del DataGridView > rUTASBindingSource1 y rUTASDS

---

5. Verificar los enganches del Codigo fuente.
.Verificar que seguimos teniendo en DockRutas.cs:

public DockRutas(FormCliente parentForm)
: base(parentForm)
{
InitializeComponent();
this.rUTASBindingSource.DataSource = RutasProcess.GetInstance().Rds;
}

private void DockRutas_Load(object sender, EventArgs e)
{
RutasProcess.GetInstance();
}

. y en RutasProcess.cs

protected RutasProcess()
{
_rutasTA = new RUTASTableAdapter();
_rutasDS = new RUTASDS();
_ruta_puntosTA = new RUTA_PUNTOSTableAdapter();
_ruta_puntosDS = new RUTA_PUNTOSDS();
_rutasTA.Fill(_rutasDS.RUTAS);
_ruta_puntosTA.Fill(_ruta_puntosDS.RUTA_PUNTOS);

}

---

6. Re-Generar el CheckBox del campo RUTA_VISIBLE
.DataGridView > ClickDerecho > Edit Columns > Seleccionar RUTA_VISIBLE
> ColumnType DataGridViewCheckBoxColumn
.Data > TrueValue 1 > FalseValue 0 > OK.

---

7. Correr y Verificar.

---