52 Commits

Author SHA1 Message Date
andronache
5cbd7e6e5c Default value for answer time is now null in cdrsql 2021-12-10 13:07:27 +01:00
Tripon Alexandru-Ionut
6a0377bbb8 Updated CGRID generation when empty.Fix#1552 2019-06-03 10:02:10 +02:00
DanB
b7e34f675a CDRs refactoring - removing old derived charging, APIs redesign 2019-02-17 20:37:07 +01:00
TeoV
6bfade03b0 Category field as 64 characters in storDb 2018-06-13 14:08:48 +02:00
DanB
78368d614d Increasing sessions_costs.origin_id to 128 chars 2018-02-19 19:38:45 +01:00
DanB
70539560fb Increase MySQL tables size in case of callcost logs 2018-02-19 19:27:09 +01:00
TeoV
976cd20713 SM_Cost -> SessionsCost and update FSEvent and KamEvent 2018-01-31 18:31:07 +01:00
paolovisintin
c0bdbd5925 Resize origin_id to 128 chars 2017-12-21 09:48:06 +01:00
TeoV
82be280d0a Removing Quotes from data/storage 2017-10-31 12:25:34 +01:00
TeoV
10a8d02d36 Update integration_tests 2017-10-31 12:00:28 +01:00
DanB
0da9a10de7 Removing Direction, PDD, DisconnectCause, Supplier from main fields of CDR; MySQL/Postgres storing nanoseconds instead of seconds for usage, tests update 2017-10-30 18:18:37 +01:00
alin104n
815d25959e RunID,OriginID SMCosts index 2017-03-15 00:42:27 +02:00
alin104n
22c47cf61b StorDB fixes and additions 2017-02-27 00:49:11 +02:00
DanB
fece61093e AccountSummary inside CDR object, decoupling it from CallCost for error cases 2016-08-29 14:28:14 +02:00
DanB
a307dc3ce0 Support for latest gorm 2016-04-04 13:02:06 +02:00
DanB
3ac526a05e CDRS forking rated CDRs depending on smg_costs, smg_costs indexing update to include origin_id also 2016-03-29 19:55:29 +02:00
DanB
608f430db7 Storage - SetSMCost and GetSMCost deprecating LogCallCost and GetLogCallCost, CDRS.StoreSMCost method, adding sm_costs indexes for cgrid+runid and originhost+originid in all dbs supported 2016-03-26 22:17:10 +01:00
Radu Ioan Fericean
4ff66e0883 populate cdr Usage 2016-03-24 17:39:47 +02:00
DanB
f58a07a029 Adding TBLSMCosts model 2015-12-27 11:38:59 +01:00
DanB
eb2e8f6876 Unified storage SetCdr and SetRatedCdr into SetCDR, engine/storage_cdrs_it_test should automate testing for the supported StoredDb drivers 2015-12-13 17:28:55 +01:00
DanB
35b6a5087c Engine tbl_cdrs refactoring, CDR.ReqType -> RequestType 2015-12-06 10:18:17 +01:00
Radu Ioan Fericean
189a893134 fixed mysql table name 2015-11-04 17:38:45 +02:00
Radu Ioan Fericean
21ac196222 tables unified, normal tests passing 2015-11-04 17:20:19 +02:00
DanB
05a522a64c Modified order of fields in stordb to include pdd after setuptime, small apier test fixes 2015-06-08 12:31:26 +02:00
DanB
b27daa074b Adding PDD to storDb, renaming CdrsFilter.FilterOnDerived -> CdrsFilter.FilterOnRated, added storDb store-restore CDR tests 2015-06-05 18:56:55 +02:00
DanB
3bc9f0e4cd DisconnecCause in StoredCdr and DerivedCharging 2015-05-13 23:42:29 +02:00
DanB
1ec59ad794 Adding supplier field in StoredCdr and related, rename IgnoreDerived-> FilterOnDerived in getCdrs function, fixed postgres load from tp_rates 2015-04-04 16:35:59 +02:00
DanB
6d4844afcf Fix ApierV1.LoadTariffPlanFromFolder on non-existent folder (thanks @catokx), increased category field to 32 char in SQL tables 2015-03-05 12:15:22 +01:00
DanB
95b1420bf8 Index answer_time and deleted_at columns for faster CDR queries/exports 2015-01-21 11:21:27 +01:00
DanB
cbd3e57397 Different GetCallCost for MySQL and Postgres 2014-11-13 12:01:42 +01:00
DanB
da21ffd32c CRUD Timestamps with no defaults 2014-11-12 10:58:30 +01:00
DanB
dd132805ec Adding automatic timestamp columns to SQL 2014-11-12 10:19:29 +01:00
DanB
d7dd56035f id->tag, tbid->id for more SQL best practices 2014-11-03 16:18:09 +01:00
DanB
5430490ec5 Adding RatedAccount and RatedSubject inside StoredCdr 2014-07-17 14:27:06 +02:00
DanB
62d1a31290 Removing unique key in cdrs_extra since it only slows down INSERTs 2014-07-16 11:50:43 +02:00
DanB
4f95f56284 Usage stored as decimal in MySQL, more tests and sample tariff plan data 2014-05-28 09:36:16 +02:00
DanB
ed3ef16c09 DBCdrs: duration -> usage to cope with the *sms and *data TORs 2014-05-08 20:08:11 +02:00
DanB
e893862f26 MySQL data structures refactoring, fixups rounding methods migration 2014-05-08 10:20:46 +02:00
DanB
f7abbacfe5 Refactoring CDRs to support RSRFields 2014-05-05 20:14:40 +02:00
DanB
5ae7a18283 Adding setupTime to CDRs for later stats calculation 2014-03-06 15:47:39 +01:00
DanB
670b748b01 Renaming tag->id and old id->tbid in mysql tables 2014-02-25 13:53:13 +01:00
DanB
7f8f981085 Small fixups 2013-12-27 11:48:17 +01:00
DanB
ca3b13651f Adding cdrc together with config dependencies and tests 2013-12-20 22:57:45 +01:00
DanB
2ba458524e CDRS with datetime instead of timestamp, adding run_ids in mediator config section 2013-12-19 20:01:19 +01:00
DanB
352540ab04 Adding local tests, available via flag -local 2013-11-18 16:29:25 +01:00
DanB
ec6de7e901 Implemented GetAllRatedCdr in store, renamed StorCDR into RatedCDR, changed time_answer into answer_timestamp in cdr_primary table for better go compatibility 2013-11-09 10:22:49 +01:00
DanB
edd2c704de TP APIs are now accepting string as time.Duration values, modified mysql table structures to increase *id fields to 64 2013-08-18 17:06:03 +02:00
DanB
a75c2e7324 Mediator refactoring to support CDR as imput instead of csv row - adding separation of names and indexes, StartTime->AnswerTime, adding reqtype=rated 2013-06-06 12:37:36 +02:00
DanB
c06b1e3c59 Adding renaming callcosts into transactions table 2013-05-30 13:00:24 +02:00
DanB
72e054a9b3 Adding tariffplan tables 2013-05-29 15:05:28 +02:00