Thu Apr 17 2025
1 : 28 : 59 PM

Khmer Web

Gateway to web application
Rental Bicycle App: Search Data Functionality
ថ្ងៃ ព្រហស្បតិ៍ ទី ២៤ កញ្ញា ២០២០
Edit

នៅ​ពេល​ដែល​ទិន្នន័យ​ត្រូវ​បាន​បញ្ចូល​កាន់​តែ​ច្រើន​ឡើង​ៗ ទៅ​ក្នុង​មូលដ្ឋាន​ទិន្នន័យ ដើម្បី​ស្រង់​យក​ទិន្នន័យ​ណា​មួយ​ យើង​ចាំបាច់​ត្រូវ​តែ​ស្វែង​រក​ទិន្នន័យ​នោះ ដោយ​វិធី «Search» ។ អាស្រ័យ​ហេតុ គ្រប់​កម្មវិធី​មូលដ្ឋាន​ទិន្នន័យ​ទាំងឡាយ ចាំបាច់​ត្រូវ​បំពាក់​ដោយ​មុខងារ​ search មួយ​ជា​ដ​រាប​។ ដោយឡែក ចំពោះ​កម្មវិធី Rental Bicycle App យើង​អាច​បំពាក់​មុខងារ​ Search អោយ​វា ដោយ​ធ្វើ​ដូច​ខាង​ក្រោម​នេះ៖

?
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
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
#\controllers\bikeform.py
import config, re, json
from bottle import template, route, request, redirect
from models import bicycledb
 
@route("/bikeform")
def renderForm():
  if 'rowedit' in config.kargs:
    del config.kargs['rowedit']
 
  return template('bikeform', data=config.kargs)
 
@route("/bikeform/edit/<id>")
def editForm(id):
  config.kargs['rowedit'] = bicycledb.edit(id)
  config.kargs['id'] = id
  return template('bikeform', data=config.kargs)
 
@route("/bikeform/delete/<id>")
def deleteForm(id):
  config.kargs['id'] = id
  bicycledb.delete(id)
  redirect('/')
 
@route("/bicycle/<brand>/<sortIndex>")
def sortBicycle(brand,sortIndex):
  config.kargs['bicycles'] = json.dumps(bicycledb.sort(brand))
  config.kargs['sortIndex'] = sortIndex
  return template('index', data=config.kargs)
 
@route("/search/bicycle/<query>")
def searchBicycle(query):
  config.kargs['bicycles'] = json.dumps(bicycledb.search(query))
  return template('index', data=config.kargs)
 
@route("/bikeform", method="POST")
def getFormData():
  brand = request.forms.get("fbrand")
  country = request.forms.get("fcountry")
  year = request.forms.get("fyear")
  amount = request.forms.get("famount")
  price = request.forms.get("fprice")
 
  if not re.findall("[a-zA-Z]", country):
    config.kargs['message'] = "Country name could contain only letter."
    return template('bikeform', data=config.kargs)
 
  elif not (re.findall("[0-9]", year) and re.findall("[0-9]", amount)):
    config.kargs['message'] = "Year and amount must be whole number."
    return template('bikeform', data=config.kargs)
 
  elif not (re.findall(r"[-+]?\d*\.\d+|\d+", price)):
    config.kargs['message'] = "Price must be a number."
    return template('bikeform', data=config.kargs)
 
  else:
    if 'rowedit' in config.kargs:
      bicycledb.update(brand, country, int(year), int(amount), float(price), config.kargs['id'])
      del config.kargs['rowedit']
      redirect('/')
 
    else:
      bicycledb.insert(brand, country, int(year), int(amount), float(price))
      return template('bikeform', data=config.kargs)
?
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
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
#\models\bicycledb.py
import sqlite3
 
def insert(*bicycle):
  conn = sqlite3.connect('sqlite.db')
  cursor = conn.cursor()
 
  sql ='''CREATE TABLE IF NOT EXISTS BICYCLE(
    BRAND TEXT,
    COUNTRY TEXT,
    YEAR INT,
    AMOUNT INT,
    PRICE FLOAT
  )
  '''
 
  cursor.execute(sql)
 
  cursor.execute("INSERT INTO BICYCLE VALUES (?, ?, ?, ?, ?)", bicycle)
   
  conn.commit()
  conn.close()
 
 
def select():
  conn = sqlite3.connect('sqlite.db')
  cursor = conn.cursor()
 
  sql ='''CREATE TABLE IF NOT EXISTS BICYCLE(
    BRAND TEXT,
    COUNTRY TEXT,
    YEAR INT,
    AMOUNT INT,
    PRICE FLOAT
  )
  '''
 
  cursor.execute(sql)
 
  cursor.execute("SELECT ROWID, * from BICYCLE")
 
  bicycles = cursor.fetchall()
   
  conn.commit()
  conn.close()
 
  return bicycles
 
def edit(id):
  conn = sqlite3.connect('sqlite.db')
  cursor = conn.cursor()
 
  cursor.execute("SELECT ROWID, * from BICYCLE WHERE ROWID = " + str(id))
 
  bicycle = cursor.fetchone()
   
  conn.commit()
  conn.close()
 
  return bicycle
 
 
def update(*args):
  conn = sqlite3.connect('sqlite.db')
  cursor = conn.cursor()
 
  sql = "UPDATE BICYCLE SET BRAND=?, COUNTRY=?, YEAR=?, AMOUNT=?, PRICE=? WHERE ROWID=?"
   
  cursor.execute(sql, args)
   
  conn.commit()
  conn.close()
 
def delete(id):
  conn = sqlite3.connect('sqlite.db')
  cursor = conn.cursor()
 
  cursor.execute("DELETE FROM BICYCLE WHERE ROWID=?", (id,))
 
  conn.commit()
  conn.close()
 
def sort(brand):
  conn = sqlite3.connect('sqlite.db')
  cursor = conn.cursor()
   
  cursor.execute("SELECT ROWID, * from BICYCLE ORDER BY " + brand)
  bicycles = cursor.fetchall()
 
  conn.commit()
  conn.close()
 
  return bicycles
 
def search(query):
  conn = sqlite3.connect('sqlite.db')
  cursor = conn.cursor()
   
  sql = "SELECT ROWID, * from BICYCLE WHERE BRAND LIKE '%"+query+"%'"
  sql += " OR COUNTRY LIKE '%"+query+"%'"
  sql += " OR YEAR LIKE '%"+query+"%'"
  sql += " OR AMOUNT LIKE '%"+query+"%'"
  sql += " OR PRICE LIKE '%"+query+"%'"
 
  cursor.execute(sql)
  bicycles = cursor.fetchall()
 
  conn.commit()
  conn.close()
 
  return bicycles

GitHub: https://github.com/Sokhavuth/Rental-Bicycle-App
Heroku: https://khmerweb-rba.herokuapp.com/