def save(self): if self._post_id: self.update(self) else: try: insert = InsertBuilder() insert.setStatement('insert into posts (user_id, post, lat, lng)') insert.setValues('values ("1", "' + self._post + '" , "44.34567", "-66.78945")') self._db.execute(insert); except: print "Could not insert record" self.notify()
def save(self): if self._comment_id: self.update(self) else: try: insert = InsertBuilder() insert.setStatement('insert into comments (user_id, post_id, comment)') insert.setValues('values ("' + self._user_id + '", "' + self._post_id + '" , "' + self._comment +'")') self._db.execute(insert); except: print "Could not insert record" self.notify()
d = Database('pannell', 'pannell', 'B00609201', 'db.cs.dal.ca') d.connect() print d.database_handle select = SelectBuilder() select.setStatement('select *') print select.getStatement() select.setTables('from users') print select.getTables() users = d.execute(select) while True: record = users.fetch_row() if not record: break print record insert = InsertBuilder() insert.setStatement('insert into users (user_name, password, role) values ("p2p2p2", "4321", "normal")') result = d.execute(insert)