Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

Appearance settings

sasie-sourcebits/active_sql

Open more actions menu

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

8 Commits
8 Commits
 
 
 
 
 
 

Repository files navigation

  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.

About

Connect mysql easily from ruby and rails applications.

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Contributors 2

  •  
  •  
Morty Proxy This is a proxified and sanitized view of the page, visit original site.