def test_use_insert(self): pyp_database.create_database("imdb") db = pyp_database.use("imdb") db.create_table('actors', columns=['id', 'name', 'date_of_birth']) self.assertTrue(hasattr(db, "actors")) db.create_table('other_actors', columns=['id', 'name', 'date_of_birth']) self.assertTrue(hasattr(db, "other_actors")) db.actors.insert(1, 'Kevin Bacon', date(1958, 7, 8)) db.actors.show() db.other_actors.show() pyp_database.delete_database("imdb", confirmation=False)
import pyp_database from datetime import date pyp_database.create_database('imdb') db = pyp_database.use('imdb') db.create_table('actors', columns=['id', 'name', 'dob']) db.actors.insert(1, 'Kevin Bacon', date(1958, 7, 8)) print db.actors.query(name='Kevin Bacon') db.actors.insert(2, 'Kevin Bacon', date(1995, 5, 5)) print db.actors.query(name='Kevin Bacon') print db.actors.query(name='Kevin Bacon', id=1)
def test_database_creation(self): db_name = 'test-db' pyp_database.create_database(db_name) db = pyp_database.use(db_name) self.assertEquals(db.name, db_name)
def test_use_create(self): pyp_database.create_database("imdb") db = pyp_database.use("imdb") db.create_table('actors', columns=['id', 'name', 'date_of_birth']) self.assertTrue(os.path.exists("imdb/actors.table")) pyp_database.delete_database("imdb", confirmation=False)