1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950 |
- const schild = require('../schild')
- const connectionString = {
- testing: {
- client: 'mysql',
- useNullAsDefault: true,
- connection: {
- host: 'localhost',
- database: 'schild_berufskolleg',
- user: 'schild',
- password: 'schild',
- charset: 'utf8'
- }
- }
- }
- schild.connect(connectionString, 'testing')
- afterAll(() => {
- schild.disconnect()
- })
- describe('schild Methoden', () => {
- test('connection test', async () => {
- expect.assertions(1)
- expect(await schild.testConnection).toBeTruthy()
- })
- test('suche', async () => {
- expect.assertions(2)
- expect((await schild.suche('C1'))[0]).toHaveProperty('id')
- expect((await schild.suche('Denise'))[0]).toHaveProperty('id')
- })
- test('getSchueler', async () => {
- expect.assertions(2)
- expect(await schild.getSchueler(1942)).toHaveProperty('ID', 1942)
- expect((await schild.getSchueler(1623)).abschnitte).toHaveLength(4)
- })
- test('getKlasse', async () => {
- expect.assertions(2)
- expect((await schild.getKlasse('C16A2')).schueler).toHaveLength(27)
- expect((await schild.getKlasse('C16A2')).schueler[0]).toHaveProperty('ID', 1942)
- })
- test('getSchule', async () => {
- expect.assertions(1)
- expect(await schild.getSchule()).toHaveProperty('Ort', 'Bielefeld')
- })
- test('getSchuelerfoto', async () => {
- expect.assertions(1)
- expect(await schild.getSchuelerfoto(1234)).toContain('/9j/4')
- })
- })
|