Ejemplo n.º 1
0
def sample_data(engine):
    conn = engine.connect()
    conn.execute(
        question.insert(),
        [{
            "question_text": "What's new?",
            "pub_date": "2015-12-15 17:17:49.629+02"
        }],
    )
    conn.execute(
        choice.insert(),
        [
            {
                "choice_text": "Not much",
                "votes": 0,
                "question_id": 1
            },
            {
                "choice_text": "The sky",
                "votes": 0,
                "question_id": 1
            },
            {
                "choice_text": "Just hacking again",
                "votes": 0,
                "question_id": 1
            },
        ],
    )
    conn.close()
Ejemplo n.º 2
0
def sample_data(engine):
	conn = engine.connect()
	conn.execute(question.insert(), [
		{'question_text': 'Whats new?',
		 'pub_date': '15-12-15 17:17:49.629+02'}
	])
	conn.execute(choice.insert() [
		{'choice_text': 'Not much', 'votes': 0, 'question_id': 1},
		{'choice_text': 'The sky', 'votes': 0, 'question_id': 1},
		{'choice_text': 'Just hacking again', 'votes': 0, 'question_id': 1}
	])
	conn.close()
Ejemplo n.º 3
0
def sample_data(engine):
    conn = engine.connect()
    conn.execute(question.insert(), [
        {"question_text": "What\'s new?",
        "pub_date": "2019-04-20 17:15:30.629+02"}
    ])
    conn.execute(choice.insert(), [
        {'choice_text': 'Not much', 'votes': 0, 'question_id': 1},
        {'choice_text': 'The sky', 'votes': 0, 'question_id': 1},
        {'choice_text': 'Just hacking again', 'votes': 0, 'question_id': 1}
    ])
    conn.close()
Ejemplo n.º 4
0
def sample_data(engine=test_engine):
    conn = engine.connect()

    conn.execute(question.insert(), [{
        'id': 1,
        'question_text': 'Where are you from?',
        'pub_data': '2018-06-01 11:28:41.000602'
    }, {
        'id': 2,
        'question_text': 'Do you believe in any religion?',
        'pub_data': '2018-06-01 14:35:26.771179'
    }, {
        'id': 3,
        'question_text': 'What genre of film do you like?',
        'pub_data': '2018-06-01 14:50:01.000345'
    }])
    conn.execute(choice.insert(), [{
        'id': 1,
        'choice_text': 'Asia',
        'votes': 0,
        'question_id': 1
    }, {
        'id': 2,
        'choice_text': 'Europe',
        'votes': 0,
        'question_id': 1
    }, {
        'id': 3,
        'choice_text': 'USA',
        'votes': 0,
        'question_id': 1
    }, {
        'id': 4,
        'choice_text': 'Buddhism',
        'votes': 0,
        'question_id': 2
    }, {
        'id': 5,
        'choice_text': 'Christianity',
        'votes': 0,
        'question_id': 2
    }, {
        'id': 6,
        'choice_text': 'Islamism',
        'votes': 0,
        'question_id': 2
    }, {
        'id': 7,
        'choice_text': 'Action',
        'votes': 0,
        'question_id': 3
    }, {
        'id': 8,
        'choice_text': 'Emotion',
        'votes': 0,
        'question_id': 3
    }, {
        'id': 9,
        'choice_text': 'Sci_Fiction',
        'votes': 0,
        'question_id': 3
    }])

    conn.close()