Ir al contenido principal

Rails - Basic Steps II

Database

  • The scaffold generator create a database migration file in root_app/db/migrate
  • rake command execute the migration files
  • The DB to be used is specified in root_app/db/database.yml

Rails environment

  • Development - When the application is created is in this mode, all changes are reflected immediately
    • rails server - Deploy in development mode
    • Use SQLite as part of the development environment 
  • Test - To run the tests
  • Production - When the application is deployed
    • rails server -e production - Deploy in production mode 

Active Record

  • Is a design pattern
  • In Ruby is used as a mean of persisting data
  • Is used to access data stored in relational databases
  • Perform CRUD operations without worrying about the specific underlying database
  • Encapsulates that notion an object-relational mapping (ORM)

Active Record Module

This pattern is provided in a module called ActiveRecord
    • Establish a connection
      • ActiveRecord::Base.establish_connnection,  use the information from root_app/config/database.yml
    • Create database tables
    • Specify association between tables to Ruby classes
    • ActiveRecord::Migration - Incrementally evolve your DB overtime 
    • ActiveRecord::Schema.define - is created in file root_app/db/schema.rb, express its structure programmatically using a portable database-independent (DSL)

Interactive Ruby Shell (IRB)

Is an interpreter that allows real-time experimentation (like in python)

Command:  irb
Command:  quit - to exit

 To have the console in rails
Command:  rails console

 Create an object: p = Post.new(:title => "My post", :body => "Post content")
Save the object: p.save

Create Relationship between models

These are the relationship types:



To apply this relationship to our model:
  1. Go to  root_app/app/models
  2. Open the files *.rb
    • File with the primary key, add the line has_many an the entity with the foreign key in plural.  Ex: has_many :comments
    • File with the foreign key, add the line has_many an the entity with the foreign key in singular.  Ex: belongs_to :post
  3. To delete in cascade, in the entity  with the primary key
    • Add to the line dependent: destroy
    • Ex: has_many : comments, dependent: :destroy
  4. Open the rails console
    • Type p = Post.all and appear the comments related with a post and assigned to variable p.
    • Type p[1].destroy and the second comment will be destroyed with his comment

Create new Routes

  1. Go to  root_app/config
  2. Open the files routes.rb
  3. Add the line to the entity with the foreign key do resources:entity_primray_key
    • Ex: resources :posts do  resources :comments end
  4. Execute the command rake routes

Upload the changes to GIT

  1. git add .
  2. git commit -m "Added associations"
  3. git push origin master

Comentarios

Publicar un comentario

Entradas populares de este blog

Android - Basic Steps (Service)

Service Run in the main thread of the hosting application Android can kill the Service if need the resources Purpose Supporting inter-application method execution Performing background processing Start a Service Call Context.startService(Intent intent)\ To call from a Fragment use getActivity().getApplicationContext().startService( intentService); Executing the service After call startService(...)  In the Service is executed the method onStartCommand(...) If the method returns the constant START_NOT_STICKY then Android will not restart the service automatically if the the process is killedp Foreground To execute the service foreground call the method startForeground() Use this if the user is aware of the process Bind to a Service Call the method Context.bindService( Intent service ServiceConnection con int flags ) Send Toast from the Service On the method onStartCommand receive the message   ...
Publicar un comentario
Leer más

BI - SSIS ( Basics I )

SSIS - Basic Concepts Tasks Bulk Insert Task—Loads data into a table by using the BULK INSERT SQL command. Data Flow Task—This is the most important task that loads and transforms data into an OLE DB Destination. Execute Package Task—Enables you to execute a package from within a package, making your SSIS packages modular. Execute Process Task—Executes a program external to your package, like one to split your extract file into many files before processing the individual files. Execute SQL Task—Executes a SQL statement or stored procedure. File System Task—This task can handle directory operations like creating, renaming, or deleting a directory. It can also manage file operations like moving, copying, or deleting files. FTP Task—Sends or receives files from an FTP site. Script Task—Runs a set of VB.NET or C# coding inside a Visual Studio environment. Send Mail Task—Sends a mail message through SMTP. Analysis Services Processing Task—This task processes a SQL Server A...
Publicar un comentario
Leer más

TOGAF9

Kinds of Architectures Business Architecture / Business Process Architecture    Define the business strategy, governance, organization and key business processes Data Architecture    Describe the structure of an organization logical and physical data assets and data resources Application Architecture    Describe a blueprint for the individual application systems to be deploy, interactions and  their relationships to the core business processes of the organization Technology Architecture    Describe the logical software and hardware capabilities that are required to support the deployment of business data and application services. This includes middle-ware infrastructure, networks, communications, processing standards  Architecture Governance Increase transparency of accountability, and informed delegation of authority Controlled risk management Protection of the existing asset base through maximizing  re-us...
Publicar un comentario
Leer más