Module: Cyberweb::Databases::Sqlite

Defined in:
lib/cyberweb/databases/sqlite.rb

Overview

Cyberweb::Databases::Sqlite

Class Method Summary collapse

Class Method Details

.create_new_sqlite_database(name_of_the_database = 'database.sql') ⇒ Object

#

Cyberweb::Databases::Sqlite.create_new_sqlite_database

This method can be used to create a new sqlite-database.

#


33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
 
# File 'lib/cyberweb/databases/sqlite.rb', line 33

def self.create_new_sqlite_database(
    name_of_the_database = 'database.sql'
  )
  database = Sequel.connect('sqlite://database.sql') # This will be class Sequel::SQLite::Database

  database.create_table(:webpage) {
    primary_key :id
    String :content
  }
  items = database[:webpage] # Create a dataset

  # ======================================================================= #
  # Populate the table:
  # ======================================================================= #
  items.insert(
    content: 'This is the content of this <b>webpage</b>.'
  )
end

.e(i = '') ⇒ Object

#

Cyberweb::Databases::Sqlite.e

#


24
25
26
 
# File 'lib/cyberweb/databases/sqlite.rb', line 24

def self.e(i = '')
  puts i
end