Software / code / prosody
Annotate
spec/scansion/uptime.scs @ 12723:4cfd09343947
mod_storage_sql: Strip timestamp precision in queries to fix error (thanks muppeth)
Fixes
Error in SQL transaction: Error executing statement parameters: ERROR: invalid input syntax for integer
This was handled for INSERT in 9524bb7f3944 but not SELECT.
| author | Kim Alvefur <zash@zash.se> |
|---|---|
| date | Wed, 07 Sep 2022 12:27:12 +0200 |
| parent | 10731:8e2f9d0fa72d |
| rev | line source |
|---|---|
|
10731
8e2f9d0fa72d
mod_uptime: Add scansion test coverage
Kim Alvefur <zash@zash.se>
parents:
diff
changeset
|
1 # XEP-0012: Last Activity / mod_uptime |
|
8e2f9d0fa72d
mod_uptime: Add scansion test coverage
Kim Alvefur <zash@zash.se>
parents:
diff
changeset
|
2 |
|
8e2f9d0fa72d
mod_uptime: Add scansion test coverage
Kim Alvefur <zash@zash.se>
parents:
diff
changeset
|
3 [Client] Romeo |
|
8e2f9d0fa72d
mod_uptime: Add scansion test coverage
Kim Alvefur <zash@zash.se>
parents:
diff
changeset
|
4 jid: romeo@localhost |
|
8e2f9d0fa72d
mod_uptime: Add scansion test coverage
Kim Alvefur <zash@zash.se>
parents:
diff
changeset
|
5 password: password |
|
8e2f9d0fa72d
mod_uptime: Add scansion test coverage
Kim Alvefur <zash@zash.se>
parents:
diff
changeset
|
6 |
|
8e2f9d0fa72d
mod_uptime: Add scansion test coverage
Kim Alvefur <zash@zash.se>
parents:
diff
changeset
|
7 ----- |
|
8e2f9d0fa72d
mod_uptime: Add scansion test coverage
Kim Alvefur <zash@zash.se>
parents:
diff
changeset
|
8 |
|
8e2f9d0fa72d
mod_uptime: Add scansion test coverage
Kim Alvefur <zash@zash.se>
parents:
diff
changeset
|
9 Romeo connects |
|
8e2f9d0fa72d
mod_uptime: Add scansion test coverage
Kim Alvefur <zash@zash.se>
parents:
diff
changeset
|
10 |
|
8e2f9d0fa72d
mod_uptime: Add scansion test coverage
Kim Alvefur <zash@zash.se>
parents:
diff
changeset
|
11 Romeo sends: |
|
8e2f9d0fa72d
mod_uptime: Add scansion test coverage
Kim Alvefur <zash@zash.se>
parents:
diff
changeset
|
12 <iq id='a' type='get' to='localhost'> |
|
8e2f9d0fa72d
mod_uptime: Add scansion test coverage
Kim Alvefur <zash@zash.se>
parents:
diff
changeset
|
13 <query xmlns='jabber:iq:last'/> |
|
8e2f9d0fa72d
mod_uptime: Add scansion test coverage
Kim Alvefur <zash@zash.se>
parents:
diff
changeset
|
14 </iq> |
|
8e2f9d0fa72d
mod_uptime: Add scansion test coverage
Kim Alvefur <zash@zash.se>
parents:
diff
changeset
|
15 |
|
8e2f9d0fa72d
mod_uptime: Add scansion test coverage
Kim Alvefur <zash@zash.se>
parents:
diff
changeset
|
16 Romeo receives: |
|
8e2f9d0fa72d
mod_uptime: Add scansion test coverage
Kim Alvefur <zash@zash.se>
parents:
diff
changeset
|
17 <iq type='result' id='a' from='localhost'> |
|
8e2f9d0fa72d
mod_uptime: Add scansion test coverage
Kim Alvefur <zash@zash.se>
parents:
diff
changeset
|
18 <query xmlns='jabber:iq:last' seconds='0'/> |
|
8e2f9d0fa72d
mod_uptime: Add scansion test coverage
Kim Alvefur <zash@zash.se>
parents:
diff
changeset
|
19 </iq> |
|
8e2f9d0fa72d
mod_uptime: Add scansion test coverage
Kim Alvefur <zash@zash.se>
parents:
diff
changeset
|
20 |
|
8e2f9d0fa72d
mod_uptime: Add scansion test coverage
Kim Alvefur <zash@zash.se>
parents:
diff
changeset
|
21 Romeo disconnects |
