training-python/test-sqlite.py at master · myamada9999/training-python · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
#! /usr/bin/python
# -*- coding: utf-8 -*-

import sqlite3

if __name__ == "__main__":

    print("insert test")
    connector = sqlite3.connect("sqlite_test.db")

    sql = "drop table test_table"
    connector.execute(sql)
    sql = "create table test_table(code, name)"
    connector.execute(sql)

    sql = "insert into test_table values('1','python')"
    connector.execute(sql)
    sql = "insert into test_table values('2','パイソン')"
    connector.execute(sql)
    sql = "insert into test_table values('3','ぱいそん')"
    connector.execute(sql)

    connector.commit()
    connector.close()

    print("select test")

    connector = sqlite3.connect("sqlite_test.db")
    cursor    = connector.cursor()
    cursor.execute("select * from test_table order by code")

    result = cursor.fetchall()

    for row in result:
        print "===== Hit! ====="
        print "code -- " + unicode(row[0])
        print "name -- " + unicode(row[1])

    cursor.close()
    connector.close()