Project

active_sql

0.0
No commit activity in last 3 years
No release in over 3 years
Easy to work with mysql from ruby and rails
2005
2006
2007
2008
2009
2010
2011
2012
2013
2014
2015
2016
2017
2018
2019
2020
2021
2022
2023
2024
2025
2026
 Dependencies
 Project Readme
  ActiveSQL
  =========
  
  Get the super fast mysql query results from Ruby and Rails applications.
  
  Love to write queries. 
  
  Build queries on your own. 
 
  Get super fast results. 

  Keep everything in mysql.

  
  USAGE: 
  ======
   
    require 'active_sql' 
    
    ActiveSQL::Base.establish_connection(:host=> 'localhost',  :username=>'root', :password=> 'peep',  :socket=> '') => true 

    ActiveSQL::Base.connected? => true
  
    ActiveSQL::Base.insert_sql("insert into users values(1, 'user1@example.com', 12, 12.3)") => true

    ActiveSQL::Base.execute_sql("delete from roles") => true 
 
    ActiveSQL::Base.select_sql("select * from users") => [[1, 'user1@example.com', 12, 12.3]]

    ActiveSQL::Base.select_sql("select * from users").columns => ["id@users", "email@users", "rate@users", "points@users"]
   
    user = ActiveSQL::Base.select_sql("select id, rate as rank from users limit 1").first
       # Methods will be added by default.
       # Disabling methods possible.  
       user.id => 1
       user.rank => 12
  
    ActiveSQL::Base.my_char_set => "latin1"
   
    ActiveSQL::Base.my_char_set("utf8") => "utf8"

    ActiveSQL::Base.my_database("another_database") => true 
  
    # Append get methods to every row.
    ActiveSQL::Base.add_methods(true) => true 
     
    # Do not append methods:
    ActiveSQL::Base.add_methods(false) => true
       
    # Status of adding methods to the rows.
    ActiveSQL::Base.add_methods? => true 
    

  Note: 
    Tentative build compiled by ruby 1.8 - linux.