Meeting minutes

- Added headers to all the source files
- Create a skeleton for the report
- Create a list of evaluations we want to do
- Natasha will do evaluation GPS range while driving
- Anand will do evaluation of GPS range for walking
- Natasha will test BT scanning for different amount of bluetooth locations
- Evaluation of battery life
- with program running and with no reception
- with program running and no reception
- with no running program and reception
- with no running program and no reception

More status:
- added try/catch blocks for all select statements
- have been testing the whole application
- created dbSetup file so that we can run only one file instead of multiple ones for creating db and adding default locations


Before running LoCal.py run LoCalDbSetup.py

Status

- finished all methods for db
- finished testing db
- started combining db with everything else
- done with Tabs
- ui for alerts
- loCal alerts
- preferences are done


issues:
- still a timer problem with checkNow
- can't figure out how to use fonts

News

- The phone would not vibrate if it is plugged in to your computer
- Need to create a list of modules we need:
wlantools
xprofile
misty
appswitcher

http://cyke64.googlepages.com/

The wiki page

File Directory

We have a place to put all the source files now.

http://csgsc.cs.ucla.edu/~loCal/LoCal/

Updates

Db Interface:
- Updated that getLocations(int uid,char type) and getAllLocations(uid) will be returning LocationList object now
Output: LocationList
- Not sure how to handle updates?
- is there a way to do an exception handling?
- can we have getters and setters for location objects?
- how to access getType for subloc?



- Written methods:
+LocationList getLocations(uid,type)
+LocationList getAllLocations(uid)
+Location getLocation(lid,uid)
+- addLocation
+- addEvent
+- getEvent

some notes

Some things I learned:
- Python e32db auto incremented value starts with 0
- e23db doesn't support joins
- python doesn't support switch statement but it does have lambda like in scheme

supported sql on the phone (e32db)

# 'SELECT' is the most popular SQL
SELECT select-list FROM table-name [ WHERE search-condition ] [ ORDER BY sort-order ] 
# 3 search condition types: compare, like, null
# DML : INSERT, DELETE, UPDATE 
INSERT INTO table-name [ ( column-identifier,… ) ] VALUES ( column-value,… ) 
DELETE FROM table-name [ WHERE search-condition ] 
UPDATE table-name SET update-column,… [ WHERE search-condition ] 
# DDL : Work with the schema
CREATE TABLE table-name (column-definition,…) 
DROP TABLE table-name 
ALTER TABLE table-name { ADD add-column-set [ DROP drop-column-set ] | DROP drop-column-set } 
CREATE [ UNIQUE ] INDEX index-name ON table-name ( sort-specification,… ) 
DROP INDEX index-name FROM table-name 
Plus a few column types (not all of them)
['BIT', 'INTEGER', 'COUNTER', 'BIGINT', 'FLOAT',
 'TIMESTAMP', 'VARCHAR(n)', 'LONG VARCHAR']
# COUNTER is an auto-incremented unsigned integer

LoCal Tests and UI Coding

Today I hard coded a WiFi location and several GPS locations using the Location objects I created. As I walked to Ackerman for dinner, different locations were in range. So that test is confirm at least for WiFi and GPS. The GPS is a lot more accurate than I thought!

I also started messing around with UI coding. I created to Form objects that can handle adding of Locations. There are probably a few other ways we can handle this to, so this remains to be discussed. Code is too long to post here. Will post later.

Time for home.