Module: Cyberweb::Databases::Sqlite
- Defined in:
- lib/cyberweb/databases/sqlite.rb
Overview
Cyberweb::Databases::Sqlite
Class Method Summary collapse
-
.create_new_sqlite_database(name_of_the_database = 'database.sql') ⇒ Object
# === Cyberweb::Databases::Sqlite.create_new_sqlite_database.
-
.e(i = '') ⇒ Object
# === Cyberweb::Databases::Sqlite.e ========================================================================= #.
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 |