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_create_database(self):
pyp_database.create_database("imdb")
self.assertTrue(os.path.exists("imdb"))
pyp_database.delete_database("imdb", confirmation=False)
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)
