Esempio n. 1
0
import db_code
from models import *
from datetime import *

db_code.setup_db()
db_session = db_code.get_db_session()


def p_db(name, num, email_id, phone_no):
      S = Person()
      S.id_number = num
      S.name = name
      S.email_id = email_id
      S.phone_no = phone_no
      db_session.add(S)
      db_session.commit()
      
r = db_session.query(Person).count() 
if (not r):
    (p_db('PersonA', 1, 'azx', '0989877123'))  
    (p_db('PersonB', 2, 'zxc', '03331233454'))
    (p_db('PersonC', 3, 'sdf', '03331233494'))
    (p_db('PersonD', 4, 'poi', '03331233474'))
    (p_db('PersonE', 5, 'rty', '03331233451'))
    (p_db('PersonF', 6, 'qwe', '03337233452'))
    (p_db('PersonG', 7, 'dfg', '03335213456'))
    (p_db('PersonH', 8, 'kjh', '03335933458'))
    (p_db('PersonI', 9, 'kjh', '03338233459'))
    (p_db('PersonJ', 10, 'lpo', '03337233452'))
    (p_db('PersonK', 11, 'kli', '03337233456'))
    (p_db('PersonL', 12, 'mnb', '03337233466'))
Esempio n. 2
0
File: imporT.py Progetto: Shazia/FYP
 def __init__(self):
     self.dbsession = get_db_session()
     db_code.setup_db()