English | Japanese
Copyright (c) 2011-2012 Yutaka Saito

### Database Access #### SQLite3 Database Operation The following code careates SQLite3 database and registers contents in a CSV file.
    import(csv)
    import(sqlite3)

    Person = struct(name:string, email:string,
                    gender:string, age:number, birthday:string, mobile:string)

    sqlite3.open('50records-en.sqlite3') {|db|
        db.exec('''\
            create table people (
                name     text,
                email    text,
                gender   text,
                age      integer,
                birthday text,
                mobile   text
            )
        ''')
        people = Person * csv.readlines(open('50records-en.csv'))
        db.transaction {
            for (person in people) {
                db.exec("insert into people values ('%s', '%s', '%s', %d, '%s', '%s')" % \
                        person.tolist())
            }
        }
    }
The code below extracts and prints information from a database that has been created by the program above.
    import(sqlite3)

    Person = struct(name:string, email:string,
                    gender:string, age:number, birthday:string, mobile:string)
    sqlite3.open('50records-en.sqlite3') {|db|
        people = Person * db.query('select * from people')
        println(people)
    }