Eli Shkurkin shkurkin

## sqlite3_tips.md

      
              1 file
            
          
              0 forks
            
          
              0 comments
            
          
              0 stars
            
          
                shkurkin
                / sqlite3_tips.md
            
            
              Last active
              January 4, 2016 02:19
            
              
                SQLite 3 gem tips and tricks
              
          
    The setup

require 'sqlite3'

db = SQLite3::Database.new "data.db"

db.execute <<-SQL
  create table foobar (
    name varchar(30),
    val int


## jquery_example.html
<!DOCTYPE html>
<html>
<head>
  <title>DOM manipulation with jQuery</title>

  <script src="https://ajax.googleapis.com/ajax/libs/jquery/1.10.2/jquery.min.js"></script>

  <script type="text/javascript" src="jquery_example.js"></script>
</head>
<body>

## index.html
<!DOCTYPE html>
<html>
<head>
  <title>Basic HTML</title>
  <link rel="stylesheet" type="text/css" href="style.css">
</head>
<body>
  <div id="wrapper">
    <h1 class="sans">This is I</h1>
    <div class="center"><img src="img/me.jpg"></div>

## 0.2.1-boggle_class_from_methods.rb
class BoggleBoard

  def initialize(board)
    @board = board
  end

  def create_word(*coords)
    coords.map { |coord| @board[coord.first][coord.last]}.join("")
  end
	<!DOCTYPE html>
	<html>
	<head>
	<title>DOM manipulation with jQuery</title>

	<script src="https://ajax.googleapis.com/ajax/libs/jquery/1.10.2/jquery.min.js"></script>

	<script type="text/javascript" src="jquery_example.js"></script>
	</head>
	<body>
	class BoggleBoard

	def initialize(board)
	@board = board
	end

	def create_word(*coords)
	coords.map { \|coord\| @board[coord.first][coord.last]}.join("")
	end